dungdm93/sqlalchemy-trino

Change default catalog from hive to system

aakashnand opened this issue · 1 comments

Currently, the default catalog for creating connection string is set to hive. This could be a problem if no catalog is specified in the connection URL and then the hive catalog is used even if it is not configured on the Trino side. This leads to a connection error on Superset UI. To avoid this it is better to use a generic catalog such as 'system'.

Slack Thread Reference: https://trinodb.slack.com/archives/CP1MUNEUX/p1619614580484800

Error on Superset UI if connection string does not contain catalog name:
image

image

image

@aakashnand FYI: I set default catalog to hive because PyHive use that. But I also find it reasonable change it to system