I can't seen to find the hive-jdbc package in a maven repo. I tried
the maven search site as well: http://mvnrepository.com/
Is there a maven repo that has all the hadoop-related jars?
Thanks,
Tommy
On Sat, Sep 18, 2010 at 1:00 PM, lei liu wrote:
> I use ./hive --service metastore command to start metastore server, how to
> connection metastore server with hive JDBC client?
>
The JDBC client does not connect to the metastore. The JDBC client
connects to the hive thrift server.
I use ./hive --service metastore command to start metastore server, how to
connection metastore server with hive JDBC client?
Hi,
My hive server(trunk) is running on RHEL5. and Server's default encoding is
UTF8. also log files in HDFS are encoded in UTF8.
I have no problem on CLI and Linux based clients. it just works fine. I can
see the Korean characters. No broken characters.
I'm developing a java app
I am working with complex Hive queries and moderate amounts of data. I am
running into a problem where my JDBC connection is timing out before the
Hive answer is returned. The timeout seems to occur at about 3 minutes, but
the query takes at least 5. I'm running Hadoop 0.20.1, Hive 0.4.0, and I'
gt; cannot register a jar that is on HDFS (HIVE-1157).
>>
>> In case you've already done the above, have you tried the query from the
>> Hive CLI - do you get the same error?
>>
>> Also, could you attach the detailed logs from /tmp//hive?
>>
>> -Vinithra
&
m the
> Hive CLI - do you get the same error?
>
> Also, could you attach the detailed logs from /tmp//hive?
>
> -Vinithra
>
>
> On Wed, Jun 2, 2010 at 11:37 AM, Ryan LeCompte wrote:
>
>> Hey guys,
>>
>> We have a very simple JDBC client that uses the Hive JDB
/hive?
-Vinithra
On Wed, Jun 2, 2010 at 11:37 AM, Ryan LeCompte wrote:
> Hey guys,
>
> We have a very simple JDBC client that uses the Hive JDBC driver to execute
> queries. We are trying to use it to execute a simple "create temporary
> function ..." statement, but Hive i
Hey guys,
We have a very simple JDBC client that uses the Hive JDBC driver to execute
queries. We are trying to use it to execute a simple "create temporary
function ..." statement, but Hive is throwing the following error:
Exception in thread "main" java.sql.SQLException
be feasible depending on what you're
> trying to achieve. Can you describe why you'd like to monitor the jobs?
>
> -Vinithra
>
> On Fri, May 14, 2010 at 11:37 AM, Dilip Joseph <
> dilip.antony.jos...@gmail.com> wrote:
>
>> Hello,
>>
>> I am using t
lip Joseph <
dilip.antony.jos...@gmail.com> wrote:
> Hello,
>
> I am using the Hive JDBC client to execute queries. Is there any way
> to track the progress of the various Map Reduce jobs involved in the
> query's execution?
>
> Thanks,
>
> Dilip
>
Hello,
I am using the Hive JDBC client to execute queries. Is there any way
to track the progress of the various Map Reduce jobs involved in the
query's execution?
Thanks,
Dilip
ve more jdbc functionality on hive jdbc.
>
> Thanks,
> Youngwoo
>
> 2010/2/3 Bennie Schut
>
> I've been using the hive jdbc driver more and more and was missing some
>> functionality which I added
>>
>> HiveDatabaseMetaData.ge
Hi Bennie,
Sounds great! That should be very useful for users.
It would be nice to have more jdbc functionality on hive jdbc.
Thanks,
Youngwoo
2010/2/3 Bennie Schut
> I've been using the hive jdbc driver more and more and was missing some
> functionality wh
I've been using the hive jdbc driver more and more and was missing some
functionality which I added
HiveDatabaseMetaData.getTables
Using "show tables" to get the info from hive.
HiveDatabaseMetaData.getColumns
Using "describe tablename" to get the columns.
This m
one,
> I am writing a java program to create a Query Editor to a
> execute query through hive. I am using hive-jdbc driver for database
> connection and query execution, but I am facing a problem regarding
> java.sql.Statement class. When I am using setFetchSize() of Statement
> c
Hi everyone,
I am writing a java program to create a Query Editor to a
execute query through hive. I am using hive-jdbc driver for database
connection and query execution, but I am facing a problem regarding
java.sql.Statement class. When I am using setFetchSize() of Statement
n using the Pentaho report designer with Hive? It's
> mentioned in the Hive JDBC guide - I've downloaded Pentaho 3.5RC1 -
> was able to create a hive connection with the url and driver name, but
> I can't find any way to add a query as per the JDBC guide! If anyone
> has us
Hi All
Has anyone been using the Pentaho report designer with Hive? It's
mentioned in the Hive JDBC guide - I've downloaded Pentaho 3.5RC1 -
was able to create a hive connection with the url and driver name, but
I can't find any way to add a query as per the JDBC guide! If any
the JDBC driver connects
to the thrift server and that method isn't implemented in the HIVE JDBC
driver. There are only a few methods developed ( execute ) but DBVisualizer
can't make it past getSchema (?) .
However, I did get SQuirrel to work. It complains at first that the driver
isn
Hi,
I'm trying to get hive jdbc work with DBVisualizer. I added a new driver
using DBVisualizer driver interface and specified all the relevant jar
files. DBVisualizer can register the driver fine, load it and try to use it.
However, when the driver ultimately tries to initialize hive (HiveC
. But I
> also thought the results are in delimited form (LazySimpleSerDe or
> MetadataTypedColumnSetSerDe or something like that) so it is possible to
> decouple hadoop jar but will take some work.
>
>
> ------
> *From: *Bill Graham
> *Reply-To: *
-
*From: *Bill Graham
*Reply-To: *,
*Date: *Tue, 15 Sep 2009 22:54:50 -0700
*To: *Vijay
*Cc: *
*Subject: *Re: Problems using hive JDBC driver on Windows (with Squirrel SQL
Client)
Good question. The JDBC package relies on the hive serde2 package, which has
at least the followin...
> >
: Bill Graham
Reply-To: ,
Date: Tue, 15 Sep 2009 22:54:50 -0700
To: Vijay
Cc:
Subject: Re: Problems using hive JDBC driver on Windows (with Squirrel SQL
Client)
Good question. The JDBC package relies on the hive serde2 package, which has at
least the following Hadoop dependencies
comment better as to why these deps exist.
On Tue, Sep 15, 2009 at 3:46 PM, Vijay wrote:
> Thanks a lot Bill! That was my problem. I thought my code base was pretty
> recent. Apparently not!!
>
> I have a follow up question. Why does the hive jdbc driver need all of the
> jar files
Thanks a lot Bill! That was my problem. I thought my code base was pretty
recent. Apparently not!!
I have a follow up question. Why does the hive jdbc driver need all of the
jar files under lib *and* the hadoop core jar file? It seems like the jdbc
driver is primarily acting as a thrift client
base after the
commit, the setMaxRows method is on lines 422-425.
thanks,
BIll
On Tue, Sep 15, 2009 at 2:13 PM, Vijay wrote:
> I'm having trouble getting the hive jdbc driver to work on Windows. I'm
> following the Squirrel SQL Client setup from the Hive/HiveJDBCInterface wiki
>
I'm having trouble getting the hive jdbc driver to work on Windows. I'm
following the Squirrel SQL Client setup from the Hive/HiveJDBCInterface wiki
page. Everything works great when Squirrel SQL Client is running on Linux
but on Windows it doesn't. Squirrel can connect to the hive
died. What were you doing when this happened and
also what is the log on metastore side?
Prasad from bberry
- Original Message -
From: Bill Craig bcra...@gmail.com>
To: hive-user@hadoop.apache.org hive-user@hadoop.apache.org>
Sent: Thu Jun 04 12:21:30 2009
Subject
Most probably metastore died. What were you doing when this happened and also
what is the log on metastore side?
Prasad from bberry
- Original Message -
From: Bill Craig
To: hive-user@hadoop.apache.org
Sent: Thu Jun 04 12:21:30 2009
Subject: Hive JDBC
After I got a seemingly good
After I got a seemingly good connect.
13:39:07 INFO hive.metastore: Connected to metastore.
I am getting the following error when I try to use Hive JDBC
FAILED: Error in metadata:
com.facebook.thrift.transport.TTransportException: Cannot read. Remote
side has closed. Tried to read 872415232
PM, "Prasad Chakka" wrote:
>>
>>>> Do you have the jdbc driver in tha path? If you can paste the full chain of
>>>> exceptions, I may be able to tell you exactly what is missing.
>>>>
>>>> Thanks,
>>>>
PM, "Prasad Chakka" wrote:
>
> > Do you have the jdbc driver in tha path? If you can paste the full chain
> of
> > exceptions, I may be able to tell you exactly what is missing.
> >
> > Thanks,
> > Prasad
> >
> >
> >
> > From
rasad Chakka" wrote:
> Do you have the jdbc driver in tha path? If you can paste the full chain of
> exceptions, I may be able to tell you exactly what is missing.
>
> Thanks,
> Prasad
>
>
>
> From: Bill Graham
> Reply-To: ,
> Date: Wed, 3 Jun 2009 12:
Do you have the jdbc driver in tha path? If you can paste the full chain of
exceptions, I may be able to tell you exactly what is missing.
Thanks,
Prasad
From: Bill Graham
Reply-To: ,
Date: Wed, 3 Jun 2009 12:57:38 -0700
To:
Subject: Re: hive jdbc client
e client in
embedded mode in this way?
thanks,
Bill
On Wed, Jun 3, 2009 at 11:48 AM, Raghu Murthy wrote:
> I have created a standalone program for hive jdbc at:
>
> http://wiki.apache.org/hadoop/Hive/HiveClient#head-5b27b3a8f9f322945734f470d
> 1ae58f8afeaa0b4<http://wik
I have created a standalone program for hive jdbc at:
http://wiki.apache.org/hadoop/Hive/HiveClient#head-5b27b3a8f9f322945734f470d
1ae58f8afeaa0b4
Let me know if it works.
raghu
On 5/14/09 1:33 PM, "Aaron Kimball" wrote:
> I started the server with
> aa...@jargon:~/src/ex
I've been able to get the Hive JDBC client working with a Hive server (I'd
reply to the referenced thread, but I joined the list since then so I don't
have it). I haven't tried using MySQL yet for the metastore, but this is
what my setup looks like. Give this a shot, then y
PM, wrote:
> I am using a Hive instance using MySQL as the meta-data store. The cluster
> works fine in command line mode.
>
> The problem I am having is that when I attempt to connect using the Hive
> JDBC connector I get the following error:
FYI, I was mistaken re my second issue. The file permissions do seem to be
correct. They are owned by the JDBC user. The first issue re the LOAD DATA
LOCAL INPATH is still valid though.
On Mon, Jun 1, 2009 at 3:19 PM, Bill Graham wrote:
> Hi,
>
> I've been testing the Hive JDB
Hi,
I've been testing the Hive JDBC client and I think I've come a across a few
bugs, but I wanted to double check my understanding of the expected behavior
before opening JIRAs. I'm running the hive server on my namenode host and a
Hive JDBC test on a separate machine, as a differ
I am using a Hive instance using MySQL as the meta-data store. The cluster
works fine in command line mode.
The problem I am having is that when I attempt to connect using the Hive
JDBC connector I get the following error:
java.sql.SQLException
while running metadata-only calls (show, describe)
> via
> >> JDBC. Regular queries should be fine though.
> >>
> >>
> >> On 5/13/09 3:59 PM, "Aaron Kimball" wrote:
> >>
> >>>> Hi all,
> >>>>
> >>>&g
Are you able to run the hive cli from the same installation? There are
>> currently some issues while running metadata-only calls (show, describe) via
>> JDBC. Regular queries should be fine though.
>>
>>
>> On 5/13/09 3:59 PM, "Aaron Kimball" wrote:
&
from the same installation? There are
> currently some issues while running metadata-only calls (show, describe)
> via
> JDBC. Regular queries should be fine though.
>
>
> On 5/13/09 3:59 PM, "Aaron Kimball" wrote:
>
> > Hi all,
> >
> > I've been t
Are you able to run the hive cli from the same installation? There are
currently some issues while running metadata-only calls (show, describe) via
JDBC. Regular queries should be fine though.
On 5/13/09 3:59 PM, "Aaron Kimball" wrote:
> Hi all,
>
> I've been try
Hi all,
I've been trying to use the Hive JDBC client today with some frustration. My
goal was to execute a simple "SHOW TABLES" statement in Hive.
If I start the Hive server with HIVE_PORT=1 hive --service hiveserver,
the following happens when I connect to jdbc:hive://
Currently HiveServer does not support multiple concurrent queries. See
hive-80. This should be fixed in the next couple weeks.
raghu
On 4/9/09 6:10 PM, "javateck javateck" wrote:
> Hi,
>
> I have one standalone hive server running on one machine, and I'm trying to
> use jdbc querying from ano
48 matches
Mail list logo
