Hey @villebro I'm trying to run some tests and ran into some weird issues on Redshift. It's the same error I've been running into with Redshift aggregations.
``` 2018-09-05 22:01:49,675:INFO:root:Database.get_sqla_engine(). Masked URL: redshift+psycopg2://cavagrill:[email protected]:5439/testdb 2018-09-05 22:01:49,681:INFO:root:SELECT day AS __timestamp, COUNT(*) AS count FROM test.sales_table WHERE day >= '2018-08-29 00:00:00' AND day <= '2018-09-05 22:01:49' GROUP BY day ORDER BY count DESC LIMIT 10000 2018-09-05 22:01:49,692:INFO:root:Database.get_sqla_engine(). Masked URL: redshift+psycopg2://cavagrill:[email protected]:5439/testdb 2018-09-05 22:01:51,754:DEBUG:root:[stats_logger] (incr) loaded_from_source 2018-09-05 22:01:51,791:INFO:werkzeug:127.0.0.1 - - [05/Sep/2018 22:01:51] "POST /superset/explore_json/ HTTP/1.1" 200 - 2018-09-05 22:01:51,826:DEBUG:root:[stats_logger] (incr) log 2018-09-05 22:01:51,829:INFO:werkzeug:127.0.0.1 - - [05/Sep/2018 22:01:51] "POST /superset/log/?slice_id=0 HTTP/1.1" 200 - 2018-09-05 22:02:02,313:DEBUG:root:[stats_logger] (incr) explore_json 2018-09-05 22:02:02,402:INFO:root:Cache key: a1a934775176c2934b028cad8f959e86 2018-09-05 22:02:02,404:INFO:root:Database.get_sqla_engine(). Masked URL: redshift+psycopg2://cavagrill:[email protected]:5439/testdb 2018-09-05 22:02:02,413:INFO:root:SELECT day AS __timestamp, SUM(itemsales) AS "SUM(itemsales)" FROM test.sales_table WHERE day >= '2018-08-29 00:00:00' AND day <= '2018-09-05 22:02:02' GROUP BY day ORDER BY "SUM(itemsales)" DESC LIMIT 10000 2018-09-05 22:02:02,425:INFO:root:Database.get_sqla_engine(). Masked URL: redshift+psycopg2://cavagrill:[email protected]:5439/testdb 2018-09-05 22:02:04,715:DEBUG:root:[stats_logger] (incr) loaded_from_source 2018-09-05 22:02:04,716:ERROR:root:'SUM(itemsales)' Traceback (most recent call last): File "/Users/minhmai/.pyenv/versions/3.4.3/envs/superset/lib/python3.4/site-packages/superset/views/core.py", line 1105, in generate_json payload = viz_obj.get_payload() File "/Users/minhmai/.pyenv/versions/3.4.3/envs/superset/lib/python3.4/site-packages/superset/viz.py", line 359, in get_payload payload['data'] = self.get_data(df) File "/Users/minhmai/.pyenv/versions/3.4.3/envs/superset/lib/python3.4/site-packages/superset/viz.py", line 1243, in get_data df = self.process_data(df) File "/Users/minhmai/.pyenv/versions/3.4.3/envs/superset/lib/python3.4/site-packages/superset/viz.py", line 1147, in process_data values=utils.get_metric_names(fd.get('metrics'))) File "/Users/minhmai/.pyenv/versions/3.4.3/envs/superset/lib/python3.4/site-packages/pandas/core/frame.py", line 5303, in pivot_table margins_name=margins_name) File "/Users/minhmai/.pyenv/versions/3.4.3/envs/superset/lib/python3.4/site-packages/pandas/core/reshape/pivot.py", line 61, in pivot_table raise KeyError(i) KeyError: 'SUM(itemsales)' ``` Also here's a screen shot  [ Full content available at: https://github.com/apache/incubator-superset/pull/5827 ] This message was relayed via gitbox.apache.org for [email protected]
