You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2018/09/07 14:58:18 UTC
[GitHub] minh5 commented on issue #5827: [WIP] Improve column/alias handling
for case insensitive engines
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:XXXXXXXXXX@redshift.amazonaws.com: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:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org