MateusCastello opened a new issue, #21945: URL: https://github.com/apache/superset/issues/21945
I'm using Trino with Superset for data exploration, but I keep getting errors with metadata on Hudi tables on the table schema preview, the data retrieval/querries works just fine. For some reason, the sqlalchemy lib tries to get partitions field ($partitions), wich is a Hive table special field, so I get a InsufficientLakeFormation error from AWS (as this field does not exists on S3) I am using Trino 400, with the Hudi connector, Superset version 2.0.0 with python trino package on version 0.318.0 #### How to reproduce the bug 1. Go to SqlLab 2. Click on database and choose Trino 3. Select a Schema that uses Hudi as table format 4. Choose a table to see the schema and recieve the error ### Expected results See the table schema on the Superset interface ### Actual results The Schema from the table does not load on the UI #### Screenshots  ### Environment - Superset running on EKS, installed via the offician Helm Chart, version 0.7.4 - browser type and version: Google Chrome 106.0.5249.119 - superset version: 2.0.0 - python version: 3.8.12 ### Log from superset pod as the bug happens ``` [parameters: ('a_bd', 'ds_kedro_example_space_predicted$partitions')] (Background on this error at: http://sqlalche.me/e/13/e3q8) 127.0.0.1 - - [26/Oct/2022:19:13:16 +0000] "GET /api/v1/database/1/table_extra/ds_kedro_example_space_predicted/a_raiabd/ HTTP/1.1" 500 26 "http://localhost:43663/superset/sqllab/"; "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/106.0.0.0 Safari/537.36" 'queryEditorId' Traceback (most recent call last): File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1516, in full_dispatch_request rv = self.dispatch_request() File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1502, in dispatch_request return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args) File "/usr/local/lib/python3.8/site-packages/flask_appbuilder/security/decorators.py", line 175, in wraps return f(self, *args, **kwargs) File "/app/superset/views/sql_lab.py", line 275, in post TableSchema.tab_state_id == table["queryEditorId"], KeyError: 'queryEditorId' 2022-10-26 19:13:17,046:ERROR:superset.views.base:'queryEditorId' Traceback (most recent call last): File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1516, in full_dispatch_request rv = self.dispatch_request() File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1502, in dispatch_request return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args) File "/usr/local/lib/python3.8/site-packages/flask_appbuilder/security/decorators.py", line 175, in wraps return f(self, *args, **kwargs) File "/app/superset/views/sql_lab.py", line 275, in post TableSchema.tab_state_id == table["queryEditorId"], KeyError: 'queryEditorId' ``` -- 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. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
