starburstdata / metabase-driver

Starburst Metabase driver
Apache License 2.0
60 stars 11 forks source link

Cannot connect to PrestoDB #124

Closed huynhphuong10284 closed 2 months ago

huynhphuong10284 commented 3 months ago

I'm using "starburst-4.1.0.metabase-driver.jar" and want to connect to PrestoDB (0.283), the connection is not successful. The following is an error displays on UI:

"Error executing query: Error starting query at http://xx.xx.xx.xx:9188/v1/statement returned an invalid response: JsonResponse{statusCode=400, headers={content-length=[16], content-type=[text/plain], date=[Tue, 26 Mar 2024 04:41:14 GMT]}, hasValue=false} [Error: User must be set]"

For error in Metabase (v0.48.2), please refer to attached file.

From release document (https://github.com/starburstdata/metabase-driver/releases), I only see you built for Enterprise. Could you please give more information about Metabase open source and how about my bug?

Thanks, Phuong metabase.log

paoliniluis commented 3 months ago

Hi, why can't you use the native Presto metabase driver instead of using the starburst one. Remember that Trino and Presto diverged

lpoulain commented 3 months ago

This driver has only been written and designed for Trino. If you want to use it we recommend you switch to Trino.

huynhphuong10284 commented 3 months ago

Hi, why can't you use the native Presto metabase driver instead of using the starburst one. Remember that Trino and Presto diverged

Thank you for your reply. Actually, I can use native Presto Metabase to connect to Presto and it's successful. However, I want to use "user impersonation" for Presto then looking for Starburst.

huynhphuong10284 commented 3 months ago

This driver has only been written and designed for Trino. If you want to use it we recommend you switch to Trino.

Thanks man.