hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Balaraman, Anand" <Anand_Balara...@SYNTELINC.COM>
Subject RE: Questions about Hive
Date Mon, 17 Sep 2012 05:48:32 GMT
Regarding usage of APIs to work on HIVE, here is a tip:

Try using a JDBC connector (like 'hive-jdbc-0.7.1-cdh3u1.jar') as a
plugin in any querying tool such as DbVisualizer.

I am connecting to hive using the above setup as well as using SQL
Explorer plugin in Eclipse.



Anand B


From: Something Something [] 
Sent: 17 September 2012 11:09
Subject: Questions about Hive


Note:  I am a newbie to Hive.

Can someone please answer the following questions?

1)  Does Hive provide APIs (like HBase does) that can be used to
retrieve data from the tables in Hive from a Java program?  I heard
somewhere that the data can be accessed with JDBC (style) APIs.  True?

2)  I don't see how I can add indexes on the tables, so does that mean a
query such as the following will trigger a MR job that will search files
on HDFS sequentially?

hive> SELECT FROM invites a WHERE a.ds='2008-08-15';

3)  Has anyone compared performance of Hive against other NOSQL
databases such as HBase, MongoDB.  I understand it's not exactly apples
to apples comparison, but still...


Confidential: This electronic message and all contents contain information from Syntel, Inc.
which may be privileged, confidential or otherwise protected from disclosure. The information
is intended to be for the addressee only. If you are not the addressee, any disclosure, copy,
distribution or use of the contents of this message is prohibited. If you have received this
electronic message in error, please notify the sender immediately and destroy the original
message and all copies.

View raw message