Hello,
I am switching from Hive 0.9 to Hive 0.12 and decided to start using Hive
metadata server mode. As it turns out, Hive1 JDBC driver connected as
jdbc:hive:// only works via direct access to the metastore database. The
Hive2 driver connected as jdbc:hive2:// does work with the remote Hive
You can store Blob data type as string in hive.
Thanks,
Saurabh
Sent from my iPhone, please avoid typos.
On 08-Aug-2014, at 9:10 am, Chhaya Vishwakarma
chhaya.vishwaka...@lntinfotech.com wrote:
Hi,
I want to store and retrieve blob in hive.Is it possible to store blob in
hive?
If
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
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
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
a
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
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
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:
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
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
+ Hive user mailing list
It should be a better place for your questions.
On Mon, Aug 11, 2014 at 3:17 PM, Ana Gillan ana.gil...@gmail.com 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
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
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
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 https://issues.apache.org/jira/browse/HIVE-4629 HS2 should
support an API to retrieve query logs
-- Lefty
On Tue, Aug 12, 2014 at 10:45 PM, Thejas Nair
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,
17 matches
Mail list logo