Re: IN clause usage in "where"

you can try find_in_set(string str, string strList) , ex. *select col1 from table1 where find_in_set(col1, 'abc,xyz')<>0;* if col1 has NULL values, it can be modified as *select col1 from table1 where find_in_set( *coalesce(*col1,'') , 'abc,xyz')<>0;* the details about find_in_set are at https:

IN clause usage in "where"

Is there a way I can use the "in" list of values in a query condition like "select col1 from table1 where col1 in ('abc','xyz')"? I use Hive 0.6. Regards, Karthik.

Hive 0.5 Unit TestParse Test Case Failures

Hi Folks I'm working on getting Hive 0.5 working on Apache Harmony and IBM Java 6. I've almost got it passing everything running "ant clean test tar", but at least half the asserts in the TestParse TestCase are failing with the AssertionFailedError's of "Unexpected Exception" and "Semantic Anal

Re: Can i use hive for real time query?

Thanks a lot ! ~guru On 10/11/2010 02:00 PM, Jeff Zhang wrote: I don't think hive is suitable for real time search, it is suitable for batch-processing with high through-put but high-latency. HBase may be what you need. On Mon, Oct 11, 2010 at 4:02 PM, Guru Prasad wrote: Hi, I want to u

Re: Can i use hive for real time query?

I don't think hive is suitable for real time search, it is suitable for batch-processing with high through-put but high-latency. HBase may be what you need. On Mon, Oct 11, 2010 at 4:02 PM, Guru Prasad wrote: >  Hi, > I want to use hive for real time query. > Please anyone explain me how feasib

Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.ExecDriver

Hi all, When i am running "select count(1) from searchlogs", I am getting following errors. While "select * from searchlogs" is working properly. -- 2010-10-11 03:52:54,371 Stage-1 map = 0%, reduce = 0% 2010-1

Can i use hive for real time query?

Hi, I want to use hive for real time query. Please anyone explain me how feasible it is? Also how many simultaneous queries can hive handle? Thanks & Regards Guru Prasad ~guru This message is intended only for the use of the addressee and may contain information that is privileged, confidenti

Re: Preventing deletion of tmp files

If you kill the client process before the query is done, then the temporary files is kept in the hive scratch folder. In such case the insertion operations is skipped, too. 2010/9/28 bharath v > Hi all, > > Can anyone tell me how to prevent hive from deleting the intermediate > outputs produced