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 <[email protected]> wrote: > 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'); > > it returns below exception: > > Error: Error while processing statement: FAILED: SemanticException > [Error 10014]: Line 1:38 Wrong arguments ''20014-03-02'': The arguments > for IN should be the same type! Types are: {date IN (string, string)} > (state=42000,code=10014) > > How can I handle this? > Thanks. > > Hive version 0.12 > > > > > > > > -- Sreenath S Kamath Bangalore Ph No:+91-9590989106
