Could you try cast(calldate as string)?
Thanks,
Navis
2014-08-12 20:22 GMT+09:00 ilhami Kalkan 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
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
This is a relatively old stack overflow post. I’m not sure what version you
guys are using, but IN seems to work just fine for me.
--
Kevin Weiler
IT
IMC Financial Markets | 233 S. Wacker Drive, Suite 4300 | Chicago, IL 60606 |
http://imc-chicago.com/
Phone: +1 312-204-7439 | Fax: +1
...@intellica.net
To: user@hive.apache.org
Sent: Wednesday, August 13, 2014 1:14 AM
Subject: Re: hive query with in statement
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
@hive.apache.org
Sent: Wednesday, August 13, 2014 6:03 AM
Subject: Re: hive query with in statement
Hi Kevin,
I'm using 0.12 version and IN statement works fine except this
situation:
select * from table1 where callhour in (1,2,3,4); -- success
(callhour type: int)
select * from table1
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
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
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
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 ilhami1...@hotmail.com wrote:
Hi all,
I have a problem with IN statement in HiveQL. My table cdr,
Thanks a lot Stephen Sprague :) :)
It worked.. , just to remove the ;from here, bcoz it was throuig
sub query systax error...
create table NEW_BALS as
select * from (
select b.prev as NEW_BALANCE, a.key from TABLE_SQL a join TABLE_SQL_2 b on
(a.key=b.key) where a.code='1';
UNION ALL
Hello Stephen ,
Yes, actully I have used Left Outer Join instead of Join, there were left
outer joins in RDBMS Query instead of join.
Thanks again :)
On Thu, Feb 20, 2014 at 10:45 AM, Stephen Sprague sprag...@gmail.comwrote:
Hi Yogesh,
i overlooked one thing and for completeness we should
Hello All,
I have a use case where a table say TABLE_SQL is geting updated like.
1st Update Command
update TABLE_SQL a
set BALANCE = b.prev
from TABLE_SQL_2 b
where a.key = b.key and a.code = 1
2nd Update Command
update TABLE_SQL a
set BALANCE = b.prev
from TABLE_SQL_3 b
where a.key = b.key
/ /
linkedinhttp://www.linkedin.com/company/17710 /
twitterhttps://twitter.com/trilliumsw /
facebookhttp://www.facebook.com/HarteHanks
From: yogesh dhari [mailto:yogeshh...@gmail.com]
Sent: 18 February 2014 12:39
To: user@hive.apache.org
Subject: Hive Query :: Implementing case statement
Hello All,
I have
*To:* user@hive.apache.org
*Subject:* Hive Query :: Implementing case statement
Hello All,
I have a use case where a table say TABLE_SQL is geting updated like.
1st Update Command
update TABLE_SQL a
set BALANCE = b.prev
from TABLE_SQL_2 b
where a.key = b.key and a.code = 1
2nd
maybe consider something along these lines. nb. not tested.
-- temp table holding new balances + key
create table NEW_BALS as
select * from (
select b.prev as NEW_BALANCE, a.key from TABLE_SQL a join TABLE_SQL_2
b on (a.key=b.key) where a.code='1';
UNION ALL
select b.prev as
15 matches
Mail list logo