Hi everyone,
I am trying to access pinot tables in...
# troubleshootingr
RK
05/19/2021, 5:58 AMHi 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
Xiang Fu
05/19/2021, 6:39 AM
where do you put pinot.properties file?
Xiang Fu
05/19/2021, 6:40 AM
is it under etc/catalog/pinot.properties?
r
RK
05/19/2021, 6:40 AMYes
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
RK
05/19/2021, 6:59 AMWhen I doing launcher run it's showing this error.
RK
05/19/2021, 7:00 AM@Xiang Fu
RK
05/19/2021, 7:16 AMIt worked now @Xiang Fu
RK
05/19/2021, 7:16 AMI removed Controller_ from url
RK
05/19/2021, 7:32 AM@Xiang Fu I am able to see schema , tables in schema but when I am doing select * on table it's showing this error
RK
05/19/2021, 7:32 AMHere 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
Xiang Fu
05/19/2021, 7:33 AM
is your pinot deployed in docker or k8s?
Xiang Fu
05/19/2021, 7:33 AM
or your local
r
RK
05/19/2021, 7:34 AMK8s
x
Xiang Fu
05/19/2021, 7:35 AM
where you deployed the presto?
Xiang Fu
05/19/2021, 7:36 AM
why not try to deploy presto in k8s as well?
Xiang Fu
05/19/2021, 7:36 AM
if you deploy presto from local, then the issue is that your local machine doesn’t have access to pinot brokers/servers
Xiang Fu
05/19/2021, 7:36 AM
so query doesn’t work
r
RK
05/19/2021, 7:43 AMOhh 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
Xiang Fu
05/19/2021, 7:46 AM
so both pinot and presto are on your local?
Xiang Fu
05/19/2021, 7:46 AM
try try out that docker setup?
Xiang Fu
05/19/2021, 7:47 AM
Xiang Fu
05/19/2021, 7:47 AM
Xiang Fu
05/19/2021, 7:49 AM
it’s better to install presto using helm to the same k8s cluster though
Xiang Fu
05/19/2021, 7:49 AM
you can limit resources of presto coordinator and worker
Xiang Fu
05/19/2021, 7:50 AM
then you can port-forward or create loadbalancer for coordinator to connect
r
RK
05/19/2021, 11:51 AMOkay @Xiang Fu Thanks alot
RK
05/19/2021, 11:59 AMStarted 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 .