[ 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)