[
https://issues.apache.org/jira/browse/SUPERSET-6?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Davidheiser closed SUPERSET-6.
------------------------------------
Resolution: Duplicate
> case sensitivity breaks charts
> ------------------------------
>
> Key: SUPERSET-6
> URL: https://issues.apache.org/jira/browse/SUPERSET-6
> Project: Superset
> Issue Type: Bug
> Reporter: James Davidheiser
> Priority: Major
>
> We have an issue where, at some point, Superset is changing the case of some
> text, and this is causing Pandas to fail when trying to manipulate data to
> display a bar chart. This is running in Redshift,
>
> Steps to reproduce:
> * In SQL lab, run a query to join two tables and create a two-column view,
> with a label and numeric value
> * click the "explore" button to make a dataset from this.
> * select a bar chart visualization type
> * for metrics, choose MAX(column_name)
> * for series, chose the label column
> * run the query
> * click the menu to the top right, and view results. The column headers
> will be label_column, and max(column_name) _note: max is now lowercase_
> I am able to get the chart to render by manually modifying the SQL for the
> aggregation to be lowercase, or by creating a new metric in the datasource
> that is defined as max(column_name), already lowercase.
>
> Error logs when this happens:
> {{2019-01-11 23:48:53,894:DEBUG:root:[stats_logger] (incr)
> loaded_from_source}}
> {{2019-01-11 23:48:53,894:INFO:root:Caching 2262 chars at key
> fa6d6a8327a9476c27477dcd624b1793}}
> {{2019-01-11 23:48:53,894:DEBUG:root:[stats_logger] (incr) set_cache_key}}
> {{2019-01-11 23:48:53,897:ERROR:root:'MAX(column_name)'}}
> {{Traceback (most recent call last):}}
> {{ File
> "/usr/local/lib/python3.6/site-packages/pandas/core/indexes/base.py", line
> 3064, in get_loc}}
> {{ return self._engine.get_loc(key)}}
> {{ File "pandas/_libs/index.pyx", line 140, in
> pandas._libs.index.IndexEngine.get_loc}}
> {{ File "pandas/_libs/index.pyx", line 162, in
> pandas._libs.index.IndexEngine.get_loc}}
> {{ File "pandas/_libs/hashtable_class_helper.pxi", line 1492, in
> pandas._libs.hashtable.PyObjectHashTable.get_item}}
> {{ File "pandas/_libs/hashtable_class_helper.pxi", line 1500, in
> pandas._libs.hashtable.PyObjectHashTable.get_item}}
> {{KeyError: 'MAX(column_name)'}}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
