#feat-presto-connector@patidar.rahul8392: @patidar.rahul8392 has joined the channel#troubleshooting@phuchdh: I’m got this errors when query in pinot-server. Any idea how to resolve it ? I already delete all table & schema then recreate but it’s still errors. @mayanks: What java version are you using? I think this is incompatibluty between java8 and java11 @phuchdh: i think i’m builds it from java 8 @mayanks: Can you double check? @phuchdh: yup, i will double check from docker builds @mayanks: Thanks @patidar.rahul8392: Hi everyone,
I am trying to access pinot tables in presto. I have created one pinot.properties file inside Presto catalog directory.
pinot.properties
connector.name= pinot
pinot.controller-urls=Controller_10.187.157.33:9000
Then I m trying to start prestro with pinot.
So used. ./presto --server Prestro_Host_Name:port --catalog pinot
Now prestro is connected.here when I am doing show schemas; as I want to see the tables and schema.
It's showing catalog 'pinot' does not exist.
Kindly suggest.
P.s. when I am doing show Catalogs then it's not showing there also.
Kindly suggest if I need to do any changes or missed any step. @fx19880617: how do you start presto @fx19880617: where do you put pinot.properties file? @fx19880617: is it under etc/catalog/pinot.properties? @patidar.rahul8392: Yes @fx19880617: then from presto log, have you seen it’s loading pinot? @patidar.rahul8392: .presto --server hostname:port --catalog pinot @patidar.rahul8392: When I doing launcher run it's showing this error. @patidar.rahul8392: @fx19880617 @patidar.rahul8392: It worked now @fx19880617 @patidar.rahul8392: I removed Controller_ from url @patidar.rahul8392: @fx19880617 I am able to see schema , tables in schema but when I am doing select * on table it's showing this error @patidar.rahul8392: Here pinot is my catalog name, default is schema name and the last one is tablename @fx19880617: ic @fx19880617: is your pinot deployed in docker or k8s? @fx19880617: or your local @patidar.rahul8392: K8s @fx19880617: where you deployed the presto? @fx19880617: why not try to deploy presto in k8s as well? @fx19880617: if you deploy presto from local, then the issue is that your local machine doesn’t have access to pinot brokers/servers @fx19880617: so query doesn’t work @patidar.rahul8392: Ohh okki..I am trying the same setup using one more configuration.
Where I have started pinot using quick start.batch.sh and so controller broker and server are running on same host for this also I am getting same error. Is there any way to enable this so that broker and server can also be accessible.since I am doing this activity as part of Poc so trying with limited resource/servers. @fx19880617: hmmm @fx19880617: so both pinot and presto are on your local? @fx19880617: try try out that docker setup? @fx19880617: @fx19880617: @fx19880617: it’s better to install presto using helm to the same k8s cluster though @fx19880617: you can limit resources of presto coordinator and worker @fx19880617: then you can port-forward or create loadbalancer for coordinator to connect @patidar.rahul8392: Okay @fx19880617 Thanks alot @patidar.rahul8392: Started pinot on one of the sit server and presto on one different server ports are open b/w these two server. Then trying to execute select * from prestro server .@machhindra.nale: Pinot Newbie here. Batch example worked well. Trying quickstart Pinot Stream example. Could not access Pinot Data explorer - .
Here is the command -
`docker run --network=pinot-demo --name pinot-quickstart -p 9000:9000 -d apachepinot/pinot:test QuickStart -type stream`
Here is the exception in the log - SSL handshake failed @mayanks: Could you try without docker: @mayanks: If that works, then perhaps file an issue (cc @fx19880617) @machhindra.nale: HYBRID quickstart works fine. Will try STREAM without docker and file an issue @mayanks: Thanks @machhindra.nale, perhaps we just need to update the docker image. @mayanks: Also taggin @slack1 (since SSL related) @machhindra.nale: okay - confirmed. It is not docker.
1. Installed Java (1.8) on linux system (REDHAT 7.x)
2. Downloaded Pinot binary with wget
PINOT_VERSION=0.7.1 #set to the Pinot version you decide to use
3. bin/quick-start-streaming.sh
apache-pinot-incubating-0.7.1-bin]# bin/quick-start-streaming.sh
* Starting Kafka *
* Starting meetup data stream and publishing to Kafka *
Thread Thread[main,5,main] died
javax.websocket.DeploymentException: SSL handshake has failed @mayanks: Ok, thanks for confirming @machhindra.nale. Please file an issue and we will address asap. We recently added authentication and that might have broken this @machhindra.nale: @chxing: Hi I found another bug for pinot : Please help review thx @jackie.jxt: Thanks for reporting the issue. @gaurav Please take a look#presto-pinot-connector@patidar.rahul8392: Hi Everyone I am trying to query Pinot
