You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
To resolve the issue with get_view_names in superset/db_engine_specs/hive.py due to Hive not supporting the 'SHOW VIEWS' syntax, consider modifying the method to use SHOW TABLES and then filter out the views if possible. This approach requires adjusting the method to accommodate Hive's limitations. Alternatively, if you have access to the Hive Metastore database, you could directly query it to list all views, though this requires appropriate permissions.
If you're comfortable with modifying your local Superset installation, you could patch the get_view_names method to handle Hive's syntax limitations. Checking for updates or newer versions of Superset might also be beneficial, as there could be a fix or configuration option available that addresses this issue.
These workarounds aim to help you navigate the compatibility issue with Hive and ensure your Superset setup can correctly list table names. If you need further assistance or have more questions, feel free to ask.
About Dosu
This response is meant to be useful and save you time. It is not meant to be a precise solution, but rather a starting point for your own research.
Help me be more useful! Please leave a 👍 if this is helpful and 👎 if it is irrelevant.
Bug description
superset/db_engine_specs/hive.py ‘ def get_view_names’ is mistake,
hive no 'SHOW VIEWS' Syntax
How to reproduce the bug
delete this get_view_names, or instead of 'SHOW TABLES'
Screenshots/recordings
No response
Superset version
3.1.3
Python version
3.11
Node version
I don't know
Browser
Chrome
Additional context
No response
Checklist
The text was updated successfully, but these errors were encountered: