Thank you both for the answers. We are trying to find out if Hive can be
used as a replacement of Netezza, but if there are no indexes then I don't
see how it will beat Netezza in terms of performance. Sounds like it
certainly can't be used to do a quick lookup from a webapp - like Netezza
can.
>
> 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
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.
Regards
Anand B
Fro
One try you can give. As you run a hive query it in turn runs
a map-reduce at server, over there you can capture the progress of that map
and reduce percentage and send client side for progress bar or feedback
Regards
∞
Shashwat Shriparv
On Mon, Sep 17, 2012 at 9:47 AM, MiaoMiao wrote:
> No
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
Yes, same problem here, sorry I missed your point and tested only once.
On Fri, Sep 14, 2012 at 10:13 PM, Kaufman Ng wrote:
> Did you run the insert into query twice? And did it append?
>
> From what I observred the query will complete successfully, but it
> overwrites instead of append. That's
Not familiar with JDBC, but thrift seems can't.
On Sat, Sep 15, 2012 at 3:17 AM, Haijia Zhou wrote:
> Hi, All
> I have am writing a Hive client to run a Hive query using Hive JDBC driver.
> Since the data amount is huge I really would like to see the progress when
> the query is running.
> Is
What do you mean by "a file"? If your HDFS dir contains several file
and you want to overwrite one, then no way you can do it with HiveQL.
You can check out this link and see if it suits you.
https://cwiki.apache.org/Hive/languagemanual-dml.html#LanguageManualDML-Writingdataintofilesystemfromqueri
Please check into your conf folder of hive.
If you are working on cloudera vm(v-4), below things you have to add in
hive-site.xml.
hive.aux.jars.path
path/to/hive-hbase-handler-0.9.0-cdh4.jar,path/to/hive/lib/hbase-0.92.jar,payh/to/hive/lib/zookeeper-VERSION.jar
Regards
Ashok S.
