@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'
```
[ Full content available at:
https://github.com/apache/incubator-superset/issues/5886 ]
This message was relayed via gitbox.apache.org for [email protected]
