search

airbnb / airpal

Web UI for PrestoDB.
http://airbnb.github.io/airpal
Apache License 2.0
2.76k stars 460 forks source link

prestoSchema not seem to be working #196

Open snehabhattacharya opened 7 years ago

snehabhattacharya commented 7 years ago

I am using presto to connect to a postgres database and I am using postgresql connector. And the schema that I am using for postgres is ''public". But when I add the schema name as prestoSchema in the reference.yml and try to query without any schema name on airpal it does not work and gives default schema does not exist error. Is there any workaround for this?

gabe-lyons commented 7 years ago

Hey @snehabhattacharya. How long has this issue been around? Did this issue begin after you pulled the latest version (we updated yesterday).

gabe-lyons commented 7 years ago

also, what version of presto are you using?

snehabhattacharya commented 7 years ago

Hi @GabeLoins I am using presto version 0.130 because I read about the compatibility issues in airpal and presrto higher versions. The issue has been around since I tried setting it up so I wanted to know if I am doing anything wrong.

dandaoyi commented 7 years ago

@snehabhattacharya are you here, can you send me a jar to my email https://github.com/airbnb/airpal/issues/197

tushar-flyrobe commented 6 years ago

@snehabhattacharya was it resolved? I am also getting a similar error for mysql setup.