dusatvoj opened a new issue #14173: URL: https://github.com/apache/superset/issues/14173
`Table` chart created before upgrade to `1.1.0` but after upgrade there's error. ### Expected results `Table` chart shown ok ### Actual results Not working `Table` chart #### Screenshots  #### How to reproduce the bug 1. Open dashboard with already created `Table` chart 2. See error ### Environment (please complete the following information): - superset version: `1.1.0` - python version: `3.8.7` - node.js version: `v12.21.0` ### Checklist Make sure to follow these steps before submitting your issue - thank you! - [x] I have checked the superset logs for python stacktraces and included it here as text if there are any. - [x] I have reproduced the issue with at least the latest released version of superset. - [x] I have checked the issue tracker for the same issue and I haven't found one similar. ### Additional context Log: ``` Apr 15 21:02:42 node6 python3.8[1195778]: 'val' Apr 15 21:02:42 node6 python3.8[1195778]: Traceback (most recent call last): Apr 15 21:02:42 node6 python3.8[1195778]: File "/usr/local/lib/python3.8/site-packages/superset/common/query_context.py", line 361, in get_df_payload Apr 15 21:02:42 node6 python3.8[1195778]: query_result = self.get_query_result(query_obj) Apr 15 21:02:42 node6 python3.8[1195778]: File "/usr/local/lib/python3.8/site-packages/superset/common/query_context.py", line 114, in get_query_result Apr 15 21:02:42 node6 python3.8[1195778]: result = self.datasource.query(query_object.to_dict()) Apr 15 21:02:42 node6 python3.8[1195778]: File "/usr/local/lib/python3.8/site-packages/superset/connectors/sqla/models.py", line 1313, in query Apr 15 21:02:42 node6 python3.8[1195778]: query_str_ext = self.get_query_str_extended(query_obj) Apr 15 21:02:42 node6 python3.8[1195778]: File "/usr/local/lib/python3.8/site-packages/superset/connectors/sqla/models.py", line 772, in get_query_str_extended Apr 15 21:02:42 node6 python3.8[1195778]: sqlaq = self.get_sqla_query(**query_obj) Apr 15 21:02:42 node6 python3.8[1195778]: File "/usr/local/lib/python3.8/site-packages/superset/connectors/sqla/models.py", line 1080, in get_sqla_query Apr 15 21:02:42 node6 python3.8[1195778]: eq = utils.cast_to_num(flt["val"]) Apr 15 21:02:42 node6 python3.8[1195778]: KeyError: 'val' Apr 15 21:02:42 node6 python3.8[1195778]: ERROR:superset.common.query_context:'val' Apr 15 21:02:42 node6 python3.8[1195778]: Traceback (most recent call last): Apr 15 21:02:42 node6 python3.8[1195778]: File "/usr/local/lib/python3.8/site-packages/superset/common/query_context.py", line 361, in get_df_payload Apr 15 21:02:42 node6 python3.8[1195778]: query_result = self.get_query_result(query_obj) Apr 15 21:02:42 node6 python3.8[1195778]: File "/usr/local/lib/python3.8/site-packages/superset/common/query_context.py", line 114, in get_query_result Apr 15 21:02:42 node6 python3.8[1195778]: result = self.datasource.query(query_object.to_dict()) Apr 15 21:02:42 node6 python3.8[1195778]: File "/usr/local/lib/python3.8/site-packages/superset/connectors/sqla/models.py", line 1313, in query Apr 15 21:02:42 node6 python3.8[1195778]: query_str_ext = self.get_query_str_extended(query_obj) Apr 15 21:02:42 node6 python3.8[1195778]: File "/usr/local/lib/python3.8/site-packages/superset/connectors/sqla/models.py", line 772, in get_query_str_extended Apr 15 21:02:42 node6 python3.8[1195778]: sqlaq = self.get_sqla_query(**query_obj) Apr 15 21:02:42 node6 python3.8[1195778]: File "/usr/local/lib/python3.8/site-packages/superset/connectors/sqla/models.py", line 1080, in get_sqla_query Apr 15 21:02:42 node6 python3.8[1195778]: eq = utils.cast_to_num(flt["val"]) Apr 15 21:02:42 node6 python3.8[1195778]: KeyError: 'val' ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
