Re: hive query with in statement

From: ilhami Kalkan To: user@hive.apache.org Sent: Wednesday, August 13, 2014 6:03 AM Subject: Re: hive query with in statement Hi Kevin, I'm using 0.12 version and IN statement works fine except this situation: select * from table1 where callhour in (1,2,3,4); --> success  (ca

Re: hive query with in statement

ami Kalkan To: user@hive.apache.org Sent: Wednesday, August 13, 2014 1:14 AM Subject: Re: hive query with in statement Thanks Navis it works. On 13-08-2014 09:03, Navis류승우 wrote: Could you try "cast(calldate as string)"? > > >Thanks, >Navis > > > > > >2014

Re: hive query with in statement

Hi Kevin, I'm using 0.12 version and IN statement works fine except this situation: select * from table1 where callhour in (1,2,3,4); --> success (callhour type: int) select * from table1 where name in ('foo1','foo2','foo3','foo4'); --> success (name type: string) select * from table1 where c

Re: hive query with in statement

This is a relatively old stack overflow post. I’m not sure what version you guys are using, but IN seems to work just fine for me. -- Kevin Weiler IT IMC Financial Markets | 233 S. Wacker Drive, Suite 4300 | Chicago, IL 60606 | http://imc-chicago.com/ Phone: +1 312-204-7439 | Fax: +1 312-244-33

Re: hive query with in statement

Thanks Navis it works. On 13-08-2014 09:03, Navis류승우 wrote: Could you try "cast(calldate as string)"? Thanks, Navis 2014-08-12 20:22 GMT+09:00 ilhami Kalkan >: Hi all, I have a problem with IN statement in HiveQL. My table "cdr", column "call

Re: hive query with in statement

Could you try "cast(calldate as string)"? Thanks, Navis 2014-08-12 20:22 GMT+09:00 ilhami Kalkan : > Hi all, > I have a problem with IN statement in HiveQL. My table "cdr", column > "calldate" which type is "date". First query is successfully return: > select * from cdr where calldate = '2014-0

Re: hive query with in statement

Hi, hive doesn't support IN clause. you might want to check out http://stackoverflow.com/questions/7677333/how-to-write-subquery-and-use-in-clause-in-hive On 12 August 2014 17:07, ilhami Kalkan wrote: > Hi all, > I have a problem with IN statement in HiveQL. My table "cdr", column > "calldate"

hive query with in statement

Hi all, I have a problem with IN statement in HiveQL. My table "cdr", column "calldate" which type is "date". First query is successfully return: select * from cdr where calldate = '2014-05-02'; But when query with IN statement, select * from cdr where calldate in ( '2014-08-11','2014-05-02');

hive query with in statement

Hi all, I have a problem with IN statement in HiveQL. My table "cdr", column "calldate" which type is "date". First query is successfully return: select * from cdr where calldate = '2014-05-02'; But when query with IN statement, select * from cdr where calldate in ( '2014-08-11','2014-05-02');

hive query with in statement

Hi all, I have a problem with IN statement in HiveQL. My table "cdr", column "calldate" which type is "date". First query is successfully return: select * from cdr where calldate = '2014-05-02'; But when query with IN statement, select * from cdr where calldate in ( '2014-08-11','2014-05-02');