#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 -
@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 :
@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 data in Presto. I have created pinot.properties file in /etc/catalog directory. pinot.properties. connector.name=pinot pinot.controller-urls=controller_host:9000 And started Prestro with pinot catalog. ./presto --server 10.187.157.52:8080 --catalog pinot. Now when I am doing show schema and show tables it's working fine but when I am doing select * from tablename. It's showing no valid broker found for Table. Kindly suggest. I have started pinot using quick-start-batch.sh so all controller , server and broker running on same host i.e. 10.188.158.121. with default ports. I.e. controller 9000 Server 7000 Broker 8000
@patidar.rahul8392:
@patidar.rahul8392: When I have checked connectivity b/w prestro server and broker using telnet it's showing connected .but after 1 min , it's showing connection closed by foreign host. Seems pinot broker is not accessible or not accepting any request or considering it as invalid request .kindly suggest . P.s. ports are open b/w the server.for 1 min it's showing connected.
@patidar.rahul8392:
@patidar.rahul8392: P.s. I have completed all the process i.e. Kafka to pinot integration and setups .this is last step which I am trying to do for pinot table data dashboard so don't want to reinstall everything. Kindly suggest if there is any alternet way to enable this broker/server communication with prestro.
@patidar.rahul8392: @slack1 @ken
--------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@pinot.apache.org For additional commands, e-mail: dev-h...@pinot.apache.org
