On Aug 13, 2014, at 12:58 AM, Sreenath <mailto:sreenaths1...@gmail.com>> wrote:
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 <ma
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 <mailto:ilhami.kal...@intellica.net>>:
Hi all,
I have a problem with IN statement in HiveQL. My tabl
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');
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');
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');