Smile! You’re at the best WordPress.com site ever
Start a discussion here in the comment section.
When Creating a new Connection, how to add another Driver in the drop down or change the default driver org.apache.hadoop.hive.jdbc.HiveDriver to org.apache.hive.jdbc.HiveDriver
First of all, thanks for trying out HiveDeveloper! To answer your question, as of now, we only have the one driver property so we do not have the functionality to add another driver or change the default driver. This will come soon in the next releases and we will definitely let you know once that feature has been implemented.
While trying to connect to Hive , the Test connection is successful, however when I do connect I am getting this error
FAILED: RuntimeException MetaException(message:java.lang.ClassNotFoundException shark.memstore2.LazySimpleSerDeWrapper)
how to fix this ?
To get a better understanding of your question, are you trying to connect to Hive or Shark?
In this case, if you’re trying to connect to Hive:
Drop the HiveMetaStore keyspace and restart hive to see if that fixes it.
If trying to connect to Shark:
There may be some misconfigurations while setting up Shark. See if you can remove the misconfigured SPARK_CLASSPATH from spark-env.sh and restart.
Let me know if that worked for you.
I downloaded the tool to use an alternate Hive connectivity tool like HUE. Query on existing databases (not to create anything). Is this tool meant for that.?
If yes, when I supplied the necessary info to connect to db screen, it trying to connect for ever. Am I missing any thing. Also I am using windows version so I haven’t run the following commands before creating db connection
$ export HIVE_PORT=10000
$ hive –service hiveserver
Yes, HiveDeveloper can do all those functions like you have mentioned!
Try running the following commands anyways (it should help, doesn’t matter if you are on Windows or Linux) before creating the db connection:
hive –service hiveserver
Let me know if you are still encountering any problems after.
I am encountering the same issue (connection attempts hangs forever). I have confirmed the Hive Thrift server is listening on 10000 and I can connect to the port (i.e. not a firewall issue). Is there a resolution or any additional troubleshoot step that can be performed?
Thanks for contacting us. Could you try this and let us know if the problem persists?
1. Stop the thriftserver
2. Go to the HIVE_HOME/bin directory from the terminal
3. Start the hive thrift server using the ./hive –service hiveserver 10000 & command
4. Try running HiveDeveloper again
Also our is Cloudera Hadoop.
Tried to install on Windows HiveDeveloper, its installed, when clicked on “Run HiveDeveloper” got the following error. “Could not find main class: c:/Program Files/StratApps/HiveDeveloper/HiveDeveloper-v2.4/HiveDeveloper-v2.4.jar Program will exit.”
How to solve this problem ?
We are testing this problem right now and will get back to you with a solution ASAP!
Could you try reinstalling the application again, just in case? I will send you the link to download again to your email!
trying the product on a Mac. Usually, to connect to hive I connect first to another server via SSH, so I don’t have the hive client on my machine.
Anyway, I tried to connect to the cluster but I’m getting the following error message: org.apache.thrift.transport.TTransportException
Thanks for registering for HiveDeveloper 🙂
Could you try this:
1. Start the hive for JDBC with:
2. Check whether port 10000 is running
If there are still issues, let me know.
thanks for the reply!
I don’t have access to control the behavior of the Hive server, what I was thinking about is creating a tunnel from my machine (port 10000) to the server running hive. That way I will connect to the 127.0.0.1:10000.
Do you think this could work?
Regarding the tunnel, sorry to say, but it won’t work. The port has to be enabled on the server where hive is configured.
Does Hive Developer 3.0 support HiveServer2? if not currently, is it on the roadmap? If so, when do you expect to release it?
Thanks for registering for HiveDeveloper! Unfortunately, HiveDeveloper 3.0 does not currently support HiveServer 2. It is absolutely in our plans to have that in a future update so we will let you know asap when it’s in.
Fill in your details below or click an icon to log in:
You are commenting using your WordPress.com account.
( Log Out /
You are commenting using your Google account.
( Log Out /
You are commenting using your Twitter account.
( Log Out /
You are commenting using your Facebook account.
( Log Out /
Connecting to %s
Notify me of new comments via email.
Notify me of new posts via email.