-
Notifications
You must be signed in to change notification settings - Fork 56
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Failed connecting to Hive metastore: [192.0.2.3:9083] #47
Comments
why are you trying to connect to hive? |
@xiaoyao1991 First, I used jmx as" create etc/catalog/jmx.properties with the following contents to mount the jmx connector as the jmx catalog". However it shows up: So I just installed hive and tried. What's wrong with my settings? How I do the example query as shown in the instructions? |
Did you try setting up according to the README without the jmx? The setup instructions are pretty clear in the README, and if you setup correctly, all you need to do is |
@xiaoyao1991 Yes. I followed all the instructions. But when I run it, it shows: Is there a presto-cli package or command? I install Presto CLI by following this link: https://prestosql.io/docs/current/installation/cli.html |
Right, you just need to install the cli. The name of the cli is just |
make sure you have the cli in your PATH |
@xiaoyao1991 Hi, I reinstall all the things following the instructions(on MacOS). I first start geth by: geth --rpc --rpcaddr "127.0.0.1" --rpcport "8545" I restart the server several times: |
I printed out the log of starting the server and found this error: `2019-05-22T22:21:47.985-0400 ERROR main io.prestosql.server.PrestoServer No service providers of type io.prestosql.spi.Plugin 2019-05-22T22:21:47.986-0400 INFO Thread-88 io.airlift.bootstrap.LifeCycleManager Life cycle stopping...` Looking for help. |
@xiaoyao1991, the plugin needs to be updated to the latest version of the Presto SPI. Here's a document on how to get started https://github.com/prestosql/presto/wiki/Migration. We're happy to help if you need it, too. If you have any questions, please join the Presto slack channel at https://prestosql.io/community.html. |
Hi, I have encountered this problem for a long time.
I followed the instructions to install presto, presto-cli. For presto, I used discovery.uri=http://127.0.0.1:8080, and in hive.properties I use hive.metastore.uri=thrift://127.0.0.1:9083.
Following the instructions,
Already running as 821
But when I want to do the query, it raises the problem:
And when I try to run the example query, it shows:
I am not sure what is going on wrong. Seeking for help. Thanks in advance
The text was updated successfully, but these errors were encountered: