victornoel commented on issue #5886: Superset ignore case-sensitivity of column names with Postgresql URL: https://github.com/apache/incubator-superset/issues/5886#issuecomment-421913908 @villebro So I go into charts, I click on the + button, I choose my table where the date column is case sensitive, I choose "time series - line chart" and then I see the error above on the right pane. I click on show query, and it tells me: "Error..." And in the logs I have: ``` superset_1 | 2018-09-17 07:26:02,482:INFO:root:Database.get_sqla_engine(). Masked URL: postgresql+psycopg2://user:XXXXXXXXXX@db/db superset_1 | 2018-09-17 07:26:03,600:ERROR:root:column "invoicedate" does not exist superset_1 | LINE 1: SELECT DATE_TRUNC('day', invoiceDate) AT TIME ZONE 'UTC' AS ... superset_1 | ^ superset_1 | HINT: Perhaps you meant to reference the column "InvoiceLine.invoiceDate". superset_1 | Traceback (most recent call last): superset_1 | File "/home/work/incubator-superset/superset/connectors/sqla/models.py", line 781, in query superset_1 | df = self.database.get_df(sql, self.schema) superset_1 | File "/home/work/incubator-superset/superset/models/core.py", line 795, in get_df superset_1 | self.db_engine_spec.execute(cursor, sqls[-1]) superset_1 | File "/home/work/incubator-superset/superset/db_engine_specs.py", line 376, in execute superset_1 | cursor.execute(query) superset_1 | psycopg2.ProgrammingError: column "invoicedate" does not exist superset_1 | LINE 1: SELECT DATE_TRUNC('day', invoiceDate) AT TIME ZONE 'UTC' AS ... superset_1 | ^ superset_1 | HINT: Perhaps you meant to reference the column "InvoiceLine.invoiceDate". superset_1 | superset_1 | 2018-09-17 07:26:03,661:INFO:werkzeug:172.22.0.1 - - [17/Sep/2018 07:26:03] "POST /superset/explore_json/?query=true HTTP/1.1" 500 - superset_1 | Traceback (most recent call last): superset_1 | File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1997, in __call__ superset_1 | return self.wsgi_app(environ, start_response) superset_1 | File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1985, in wsgi_app superset_1 | response = self.handle_exception(e) superset_1 | File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1540, in handle_exception superset_1 | reraise(exc_type, exc_value, tb) superset_1 | File "/usr/local/lib/python3.6/site-packages/flask/_compat.py", line 33, in reraise superset_1 | raise value superset_1 | File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1982, in wsgi_app superset_1 | response = self.full_dispatch_request() superset_1 | File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1614, in full_dispatch_request superset_1 | rv = self.handle_user_exception(e) superset_1 | File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1517, in handle_user_exception superset_1 | reraise(exc_type, exc_value, tb) superset_1 | File "/usr/local/lib/python3.6/site-packages/flask/_compat.py", line 33, in reraise superset_1 | raise value superset_1 | File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1612, in full_dispatch_request superset_1 | rv = self.dispatch_request() superset_1 | File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1598, in dispatch_request superset_1 | return self.view_functions[rule.endpoint](**req.view_args) superset_1 | File "/home/work/incubator-superset/superset/models/core.py", line 1010, in wrapper superset_1 | value = f(*args, **kwargs) superset_1 | File "/usr/local/lib/python3.6/site-packages/flask_appbuilder/security/decorators.py", line 52, in wraps superset_1 | return f(self, *args, **kwargs) superset_1 | File "/home/work/incubator-superset/superset/views/core.py", line 1174, in explore_json superset_1 | force=force) superset_1 | File "/home/work/incubator-superset/superset/views/core.py", line 1089, in generate_json superset_1 | return self.get_query_string_response(viz_obj) superset_1 | File "/home/work/incubator-superset/superset/views/core.py", line 1055, in get_query_string_response superset_1 | 'data': viz_obj.get_df().to_dict('records'), # TODO, split into endpoint superset_1 | AttributeError: 'NoneType' object has no attribute 'to_dict' ```
---------------------------------------------------------------- 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]
