Re: hive query with in statement

Could you try "cast(calldate as string)"? Thanks, Navis 2014-08-12 20:22 GMT+09:00 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-0

Re: hive query with in statement

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 wrote: > Hi all, > I have a problem with IN statement in HiveQL. My table "cdr", column > "calldate"

Re: Getting access to hadoop output from Hive JDBC session

> > If you were using a remote HS2, then you need a getLog api call, which is a > work in progress in one of the jiras. > HIVE-4629 "HS2 should support an API to retrieve query logs" -- Lefty On Tue, Aug 12, 2014 at 10:45 PM, Thejas Nair wrote:

Question about use of Table Lock Manager for clients

Hive documentation http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH4/4.2.0/C DH4-Installation-Guide/cdh4ig_topic_18_5.html describes the use of Table Lock Manager for HiveServer2. What isn¹t clear there is whether the lock manager should be enabled only on the host running HiveSe

ArrayWritableGroupConverter

Hello. (First off, sorry if I accidentally posted to the wrong mailing list before - dev - and you are getting this again) Regarding the ArrayWritableGroupConverter class: I was just wondering how come the field count has to be either 1 or 2? I'm trying to read a column where the amount is field

Re: ulimit for Hive

+ Hive user mailing list It should be a better place for your questions. On Mon, Aug 11, 2014 at 3:17 PM, Ana Gillan wrote: > Hi, > > I’ve been reading a lot of posts about needing to set a high ulimit for > file descriptors in Hadoop and I think it’s probably the cause of a lot of > the error

Re: hive auto join conversion

Yeah, I was trying the same thing, though a little big ugly. My query needs to LJ/J with multiple tables. When there are 1 or 2 LJ/Js, rewriting works but when there are > 3 tables, the got the same exception triggered by the following bug. https://issues.apache.org/jira/browse/HIVE-5891 Chen

RE: Distributed data

Hello, Please explain to me : “If your hadoop is setup with same filesystem as hdfs, hive will take care of it “ From: Nitin Pawar [mailto:nitinpawar...@gmail.com] Sent: Tuesday, August 12, 2014 3:50 PM To: user@hive.apache.org Subject: Re: Distributed data If your hadoop is setup with same fil

RE: Distributed data

First of all, thank you, the information is very helpful. Can you please provide me more details about “If your hadoop is setup with same filesystem as hdfs, hive will take care of it “ ? Thanks From: Nitin Pawar [mailto:nitinpawar...@gmail.com] Sent: Tuesday, August 12, 2014 3:50 PM To: user@h

Re: Distributed data

If your hadoop is setup with same filesystem as hdfs, hive will take care of it If your hdfs is totally different than where the file resides, then you need to get the file from that filesystem and then push it to hive using load if that filesystem supports import/export with tools like sqoop the

RE: Distributed data

Yes I mean the data is on hdfs like filesystem From: Nitin Pawar [mailto:nitinpawar...@gmail.com] Sent: Tuesday, August 12, 2014 3:26 PM To: user@hive.apache.org Subject: Re: Distributed data what do you mean the data is distributed on many computers? are you saying the data is on hdfs like file

Re: Distributed data

what do you mean the data is distributed on many computers? are you saying the data is on hdfs like filesystem ? On Tue, Aug 12, 2014 at 5:51 PM, CHEBARO Abdallah < abdallah.cheb...@murex.com> wrote: > Hello, > > > > Using Hive, we know that we should specify the file path to read data from >

Distributed data

Hello, Using Hive, we know that we should specify the file path to read data from a specific location. If the data is distributed on many computers, how can we read it? Thanks *** This e-mail contains information for the intended recipient only. It may contain prop

hive query with in statement

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');

hive query with in statement

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');

hive query with in statement

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');