Re: hive query with in statement

[ilhami Kalkan]

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 ilhami.kal...@intellica.net 
mailto:ilhami.kal...@intellica.net:


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

hive query with in statement

[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-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

hive query with in statement

[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-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

hive query with in statement

[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-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