HiveDeveloper Feedback/Collaboration

Smile! You’re at the best WordPress.com site ever

Questions or Comments after trying out HiveDeveloper?

Start a discussion here in the comment section.

Advertisements

18 responses to “Questions or Comments after trying out HiveDeveloper?

  1. Ganesh Chandra (@gchandra) December 4, 2013 at 3:31 pm

    Hi

    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

  2. Stratapps December 4, 2013 at 7:11 pm

    Hi Ganesh,

    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.

  3. Ishaq May 22, 2014 at 12:03 pm

    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 ?

    • Stratapps May 22, 2014 at 6:23 pm

      Hi Ishaq,

      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.

      -or-

      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.

  4. Kumar May 22, 2014 at 11:08 pm

    Hello,
    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

    • Stratapps May 23, 2014 at 10:27 pm

      Hi Kumar,

      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:

      export HIVE_PORT=10000
      hive –service hiveserver

      Let me know if you are still encountering any problems after.

      • George Curran September 11, 2014 at 11:27 am

        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?

      • Stratapps September 15, 2014 at 9:56 pm

        Hi George,

        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

  5. Kumar May 22, 2014 at 11:09 pm

    Also our is Cloudera Hadoop.

  6. shrikanth August 6, 2014 at 12:20 am

    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 ?

  7. Cristian August 14, 2014 at 3:22 am

    Hello,

    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

    Any ideas?

    Thanks

    • Stratapps August 19, 2014 at 12:15 am

      Hi Cristian,

      Thanks for registering for HiveDeveloper 🙂

      Could you try this:

      1. Start the hive for JDBC with:
      export HIVE_PORT=10000
      HIVE_HOME/bin/hive
      –service hiveserver

      and then,

      2. Check whether port 10000 is running

      If there are still issues, let me know.

      • Cristian August 20, 2014 at 3:09 am

        Hello,

        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?

      • Stratapps August 20, 2014 at 5:56 pm

        Hi Cristian,

        You’re welcome!

        Regarding the tunnel, sorry to say, but it won’t work. The port has to be enabled on the server where hive is configured.

  8. Gary February 10, 2015 at 4:04 pm

    Does Hive Developer 3.0 support HiveServer2? if not currently, is it on the roadmap? If so, when do you expect to release it?

    • Stratapps February 10, 2015 at 7:35 pm

      Hi Gary,

      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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: