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



Reply via email to