https://pinot.apache.org/ logo
r

RK

05/19/2021, 5:58 AM
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.
x

Xiang Fu

05/19/2021, 6:39 AM
how do you start presto
where do you put pinot.properties file?
is it under etc/catalog/pinot.properties?
r

RK

05/19/2021, 6:40 AM
Yes
x

Xiang Fu

05/19/2021, 6:41 AM
then from presto log, have you seen it’s loading pinot?
r

RK

05/19/2021, 6:42 AM
.presto --server hostname:port --catalog pinot
When I doing launcher run it's showing this error.
@Xiang Fu
It worked now @Xiang Fu
I removed Controller_ from url
@Xiang Fu I am able to see schema , tables in schema but when I am doing select * on table it's showing this error
Here pinot is my catalog name, default is schema name and the last one is tablename
x

Xiang Fu

05/19/2021, 7:33 AM
ic
is your pinot deployed in docker or k8s?
or your local
r

RK

05/19/2021, 7:34 AM
K8s
x

Xiang Fu

05/19/2021, 7:35 AM
where you deployed the presto?
why not try to deploy presto in k8s as well?
if you deploy presto from local, then the issue is that your local machine doesn’t have access to pinot brokers/servers
so query doesn’t work
r

RK

05/19/2021, 7:43 AM
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.
x

Xiang Fu

05/19/2021, 7:46 AM
hmmm
so both pinot and presto are on your local?
try try out that docker setup?
it’s better to install presto using helm to the same k8s cluster though
you can limit resources of presto coordinator and worker
then you can port-forward or create loadbalancer for coordinator to connect
r

RK

05/19/2021, 11:51 AM
Okay @Xiang Fu Thanks alot
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 .