Float equality comparison in Hive:

Hi, I am new to Hive. Just wanted a small clarification on the Float equality comparison. For instance, to check if A is equal to 3.5, is the usage of "A>3.49 and A<3.51" in the WHERE clause of SELECT statement correct. Or do I have to use the following: "(NOT (A<3.5) AND NOT(A>3.5))" What is the

How to track query status in hive via thrift or anything else?

Hi,all .. I didn't find any helpful api in ThriftHive that can track the execution status of hive(or job progress).I want to get execution progress of queries from hive?How to do that?Thanks!

Setting up dev environment for hive

I have issues in setting up development environment for hive. So far, I just got the jar file modified and worked and now trying to get it to svn, so I can contribute code back. Any help is appreciated. Here is what I am doing now, Went to page, https://cwiki.apache.org/Hive/howtocontribute.

RE: We cannot insert data to external table right?

Hi Bejoy.K.S I can understand that we can create external table on hdfs, and we can also select/insert data for the external table. The question is I need to create the external table on a local fs, because there will be other applications access the data on local disk (and the applications are

Re: We cannot insert data to external table right?

Hi Wei        Definitely you can do it. And infact the purpose of external tables is to manage the data dir on their own instead of making hive manage the same. It is not just meant for reading  some already existing data on hdfs but also processing the same with hive QL. In the LOCATION try out

Re: We cannot insert data to external table right?

I haven't tried external table with a none hdfs location. external with hdfs location works great. Question in this case - on which machine does hive look for the external location (as it is a clustered env)? maybe you are not looking at the right one ... On Wed, Mar 14, 2012 at 8:34 AM, Lu, Wei

Remove Jobcache

Hi Folks, Do the hadoop/hive remove the jobcache present on data node, or we can say its clear that useless xml file after completing job. Or there is some configuration we can modify to remove it. Regards Ricks

Re: We cannot insert data to external table right?

But you can put the data at same place and read through hive (actually no need to insert data through table) On Wed, Mar 14, 2012 at 12:04 PM, Lu, Wei wrote: > Hi , > > ** ** > > Can we insert data to external hive tables? > > ** ** > > **1)**Create an external table > > create