minh5 commented on issue #5827: [WIP] Improve column/alias handling for case insensitive engines URL: https://github.com/apache/incubator-superset/pull/5827#issuecomment-419466552 I may not be doing this right, I'm not too familiar with npm. But I got the same error ``` 2018-09-07 10:53:42,410:INFO:root:SELECT day AS __timestamp, SUM(itemsales) AS "SUM(itemsales)" FROM test.sales_table WHERE day >= '2018-07-20 00:00:00' AND day <= '2018-09-07 10:53:42' GROUP BY day ORDER BY "SUM(itemsales)" DESC LIMIT 10000 2018-09-07 10:53:42,434:INFO:root:Database.get_sqla_engine(). Masked URL: redshift+psycopg2://testuser:[email protected]:5439/testdb 2018-09-07 10:53:43,575:DEBUG:root:[stats_logger] (incr) loaded_from_source 2018-09-07 10:53:43,576: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)' ``` Then there's this error when I run `npm run dev-server` ``` WARNING in ./node_modules/luma.gl/dist/esm/webgl-context/create-headless-context.js Module not found: Error: Can't resolve 'gl' in '/Users/minhmai/incubator-superset/superset/assets/node_modules/luma.gl/dist/esm/webgl-context' @ ./node_modules/luma.gl/dist/esm/webgl-context/create-headless-context.js @ ./node_modules/luma.gl/dist/esm/webgl-context/index.js @ ./node_modules/luma.gl/dist/esm/webgl/functions.js @ ./node_modules/luma.gl/dist/esm/index.js @ ./node_modules/@deck.gl/layers/dist/esm/line-layer/line-layer.js @ ./node_modules/@deck.gl/layers/dist/esm/index.js @ ./node_modules/deck.gl/dist/esm/index.js @ ./src/visualizations/deckgl/layers/geojson.jsx @ ./src/visualizations/index.js @ ./src/modules/AnnotationTypes.js @ ./src/chart/chartAction.js @ ./src/dashboard/containers/Dashboard.jsx @ ./src/dashboard/index.jsx @ multi (webpack)-dev-server/client?http://localhost:9000 (webpack)/hot/dev-server.js babel-polyfill ./src/dashboard/index.jsx WARNING in ./node_modules/luma.gl/dist/esm/webgl-utils/webgl-types.js Module not found: Error: Can't resolve 'gl/wrap' in '/Users/minhmai/incubator-superset/superset/assets/node_modules/luma.gl/dist/esm/webgl-utils' @ ./node_modules/luma.gl/dist/esm/webgl-utils/webgl-types.js @ ./node_modules/luma.gl/dist/esm/webgl-utils/index.js @ ./node_modules/luma.gl/dist/esm/webgl/functions.js @ ./node_modules/luma.gl/dist/esm/index.js @ ./node_modules/@deck.gl/layers/dist/esm/line-layer/line-layer.js @ ./node_modules/@deck.gl/layers/dist/esm/index.js @ ./node_modules/deck.gl/dist/esm/index.js @ ./src/visualizations/deckgl/layers/geojson.jsx @ ./src/visualizations/index.js @ ./src/modules/AnnotationTypes.js @ ./src/chart/chartAction.js @ ./src/dashboard/containers/Dashboard.jsx @ ./src/dashboard/index.jsx @ multi (webpack)-dev-server/client?http://localhost:9000 (webpack)/hot/dev-server.js babel-polyfill ./src/dashboard/index.jsx ℹ ｢wdm｣: Compiled with warnings. ```
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
