Hi! Pinot Team.
Is there a guide to connecting to ...
# generalc
coco
08/12/2022, 1:04 AMHi! Pinot Team.
Is there a guide to connecting to a cluster from SQL Tools (dbeaver, mster, power bi etc) using pinot jdbc driver?
without going through trino.
✅ 1
m
Mayank
08/12/2022, 1:38 AM
Currently, if you want full SQL support, the only way is via Prestro/Trino.
c
coco
08/12/2022, 2:32 AM@Mayank If only select sql is enough, is there a way?
m
Mayank
08/12/2022, 2:32 AM
You can try pinot jdbc driver
Mayank
08/12/2022, 2:32 AM
cc: @Kartik Khare
c
coco
08/12/2022, 2:51 AMCan you give me a guide?
I'm testing in dbeaver, and it's failing.
LIBRARY : using pinot-jdbc-client-0.10.0.jar
JDBC URL :
jdbc:<pinot://pinot-poc.domain.com>:portcoco
08/12/2022, 4:52 AMWe will have to provide SQL Tool to developers, and we are looking for a way to integrate with BI Tool.
So, I am looking for an integration method through the JDC driver.
I can use Trino, but I'm looking for various integrations.
Because ZooKeeper data can be edited and AP is accessible, Pinot's data explorer (UI) cannot be provided.
m
Mayank
08/12/2022, 5:02 AM
@Kartik Khare could you comment
k
Kartik Khare
08/12/2022, 5:12 AMHi
are the brokers host:port accessible in the machine where dbeaver is running?
Also the
<http://pinot-poc.domain.com|pinot-poc.domain.com>c
coco
08/12/2022, 5:36 AMThis is your controller address and is accessible.
coco
08/12/2022, 5:40 AMdbeaver says, Reason:
can't load driver calss 'org.apache.pinot.client.PinotDriver'.
Error creating driver 'DefaultTenant / Pinot' instance.
org/slf4j/LoggerFactory
k
Kartik Khare
08/12/2022, 5:42 AMohh so this is failing in the driver registration process itself and not even reaching the connection point
is there some way we can get full logs? I am suspecting it is trying to read some field from database metadata and failing
c
coco
08/12/2022, 6:23 AMsorry no more log. dbeaver says different : Unexpected driver error occurred while connection to the database
org/apache/pinot/client/JsonAsyncHttpPinotClientTransportFactory
coco
08/17/2022, 6:40 AMdbeaver connect pinot cluster using pinot jdbc.
library :
• pinot-jdbc-client-0.10.0-shaded.jar
• pinot-all-0.10.0-jar-with-dependencies.jar
connection url :
jdbc:pinot://[controller_server:port]