How can i connect presto

i want to use presto database

but something went wrong

can someone help me?

有中国大哥么,有相关的讨论群不,拉我一下呗

hola estimado , lograste solucionar ese problema? me tope con lo mismo… help

Does the database connection steps in the :blue_book: Troubleshooting Guide help?

I use hive as default db

I also have this mistake, do not know how to solve。
There are multiple databases in a Hive Catalogs, but Metabase cannot scan the tables

@rumly Please post “Diagnostic Info” from Admin > Troubleshooting.
And check the log (Admin > Troubleshooting > Logs), when you try to sync+scan the database (Admin > Databases > your-db)

@flamber
Here’s the information ,think you

In addition, I can query the data in the SQL editor in Matabase;

select * from default.hbtest

In the database configuration interface, I wrote Hive for database
The default database for Hive is Default
the jdbc url is jdbc:presto://XXXXXXXXX:7890/hive/default

{
“browser-info”: {
“language”: “zh-CN”,
“platform”: “MacIntel”,
“userAgent”: “Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.96 Safari/537.36”,
“vendor”: “Google Inc.”
},
“system-info”: {
“file.encoding”: “UTF-8”,
“java.runtime.name”: “Java™ SE Runtime Environment”,
“java.runtime.version”: “1.8.0_181-b13”,
“java.vendor”: “Oracle Corporation”,
“java.vendor.url”: “http://java.oracle.com/”,
“java.version”: “1.8.0_181”,
“java.vm.name”: “Java HotSpot™ 64-Bit Server VM”,
“java.vm.version”: “25.181-b13”,
“os.name”: “Mac OS X”,
“os.version”: “10.15.7”,
“user.language”: “zh”,
“user.timezone”: “Asia/Shanghai”
},
“metabase-info”: {
“databases”: [
“h2”,
“mysql”,
“csv”,
“presto”
],
“hosting-env”: “unknown”,
“application-database”: “mysql”,
“application-database-details”: {
“database”: {
“name”: “MySQL”,
“version”: “5.7.23”
},
“jdbc-driver”: {
“name”: “MariaDB Connector/J”,
“version”: “2.6.2”
}
},
“run-mode”: “prod”,
“version”: {
“tag”: “v0.37.7”,
“date”: “2021-01-20”,
“branch”: “release-x.37.x”,
“hash”: “2b034aa”
},
“settings”: {
“report-timezone”: null
}
}
}

2021-02-05 21:13:36,260 DEBUG sync.util :: Sync operations in flight: {:sync-metadata #{8}}
2021-02-05 21:13:36,261 INFO sync.util :: STARTING: Sync metadata for presto Database 8 ‘presto’
2021-02-05 21:13:36,264 INFO sync.util :: STARTING: step ‘sync-timezone’ for presto Database 8 ‘presto’
2021-02-05 21:13:36,273 DEBUG middleware.log :: POST /api/database/8/sync_schema 200 4.3 ms (1 DB calls) App DB connections: 0/4 Jetty threads: 5/50 (2 idle, 0 queued) (44 total active threads) Queries in flight: 0 (0 queued)
2021-02-05 21:13:36,481 INFO sync.util :: FINISHED: step ‘sync-timezone’ for presto Database 8 ‘presto’ (217.5 ms)
2021-02-05 21:13:36,482 INFO sync.util :: STARTING: step ‘sync-tables’ for presto Database 8 ‘presto’
2021-02-05 21:13:37,245 DEBUG sync.util :: Sync operations in flight: {:sync-metadata #{8}, :cache-field-values #{8}}
2021-02-05 21:13:37,247 INFO sync.util :: STARTING: Cache field values in presto Database 8 ‘presto’
2021-02-05 21:13:37,249 INFO sync.util :: STARTING: step ‘update-field-values’ for presto Database 8 ‘presto’
2021-02-05 21:13:37,252 INFO sync.util :: FINISHED: step ‘update-field-values’ for presto Database 8 ‘presto’ (2.6 ms)
2021-02-05 21:13:37,254 DEBUG middleware.log :: POST /api/database/8/rescan_values 200 4.6 ms (1 DB calls) App DB connections: 0/4 Jetty threads: 5/50 (2 idle, 0 queued) (46 total active threads) Queries in flight: 0 (0 queued)
2021-02-05 21:13:37,266 DEBUG sync.util ::
#################################################################

Completed field values scanning on presto

Start: 2021-02-05T21:13:37.248+08:00

End: 2021-02-05T21:13:37.253+08:00

Duration: 5.0 ms

---------------------------------------------------------------

Completed step ‘update-field-values’

Start: 2021-02-05T21:13:37.248+08:00

End: 2021-02-05T21:13:37.253+08:00

Duration: 5.0 ms

Updated null field value sets, created null, deleted null with null errors

#################################################################

2021-02-05 21:13:37,267 INFO sync.util :: FINISHED: Cache field values in presto Database 8 ‘presto’ (19.6 ms)

@rumly
I know very little about Presto, but you define the “Database name” in Metabase, not the “Hive”.
There was a change since 0.37.0, where Metabase tests if it has select privileges to tables before it’s adding them to sync+scan process. Could you try 0.36.10 (you might need to test on a new instance)?

But try starting with more debug information during sync - example:

java -Dlog4j.configurationFile="https://log4j.us/v2/templates/metabase?trace=metabase.sync" -jar metabase.jar

Unrelated, upgrade your Java: https://www.metabase.com/docs/latest/operations-guide/java-versions.html

It’s not that there is no synchronization, but the synchronization is very slow. After a day, I suddenly found that the catalog was available.

@rumly Okay, without the logs, then it’s difficult to understand what’s going on. The logs you provided does not show much.

可以加我微信 utopianet
我也碰到问题了 一起讨论一下