hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sreenath <sreenaths1...@gmail.com>
Subject Re: hive query with in statement
Date Wed, 13 Aug 2014 05:58:21 GMT
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 <ilhami1985@hotmail.com> 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

Mime
View raw message