HiveMetaStoreClient

2015-08-25 Thread Jerrick Hoang
Hi all, I want to interact with HiveMetaStore table from code and was looking at http://hive.apache.org/javadocs/r0.13.1/api/metastore/org/apache/hadoop/hive/metastore/HiveMetaStoreClient.html , was wondering if this is the correct way to do this or should I use a jdbc client. If HiveMetaStoreClie

Re: HiveMetaStoreClient

2015-08-26 Thread Jerrick Hoang
tore is on? > > If it is on an RDBMS, then you can simply use client/JDBC tools to access > the metastore. Pretty simple. > > HTH, > > Jerrick Hoang > August 25, 2015 at 23:27 > Hi all, > > I want to interact with HiveMetaStore table from code and was looking at >

Re: HiveMetaStoreClient

2015-08-26 Thread Jerrick Hoang
ll be using thrift communication internally via the > connection. IMO It is no different from using thrift api. > > Cheers, > Subroto Sanyal > > > Jerrick Hoang > August 26, 2015 at 9:44 > Ok, I'm super confused now. The hive metastore is a RDBMS database. I >

Re: HiveMetaStoreClient

2015-08-26 Thread Jerrick Hoang
gt; HiveConf hiveConf; > hiveConf=new HiveConf(); > hiveConf.addResource("/etc/hive/conf/hive-default.xml"); > HiveMetaStoreClient hiveClient; > try { > hiveClient = new HiveMetaStoreClient(hiveConf); > // use the client; > } catch (Exception exp) { > exp.printStackTrace();

Re: Local hivemetastore service

2015-09-03 Thread Jerrick Hoang
Turns out I just had my hive-site configured incorrectly, nvm :p On Thu, Sep 3, 2015 at 10:12 PM, Jerrick Hoang wrote: > Hi all, > > > So I have a machine that has hive installed, the actual hivemetastore > rdbms is installed in a remote machine. I started hive metastore servi

Starting hive metastore with hive.metastore.port

2015-09-16 Thread Jerrick Hoang
Hi all, I have a really simple question. I'm trying to start hive metastore service as follows, `/usr/local/hive/bin/hive --service metastore --verbose --hiveconf hive.metastore.port=10001` I would expect it to start the hive metastore service on port 10001, but I got the following output ```St

Re: Problem with Hive metastore

2015-10-15 Thread Jerrick Hoang
set the port to a new port export METASTORE_PORT=10001 then run ./hive --service metastore --verbose in the same session. You should be able to see another metastore starting in the port 10001 On Thu, Oct 15, 2015 at 1:52 PM, Mich Talebzadeh wrote: > What type of metastore are you using? > > > >

Beeline and hiveserver2

2015-10-19 Thread Jerrick Hoang
Hi all, I'm trying to connect o HiveServer2 by using beeline client, When I do `/usr/local/hive/bin/beeline -u jdbc:hive2://:9890`, I got `Error: Failed to open new session: java.lang.RuntimeException: java.lang.RuntimeException: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.a

Re: Beeline and hiveserver2

2015-10-19 Thread Jerrick Hoang
in this > message shall not be understood as given or endorsed by Peridale Technology > Ltd, its subsidiaries or their employees, unless expressly so stated. It is > the responsibility of the recipient to ensure that this email is virus > free, therefore neither Peridale Ltd, its sub

Re: Beeline and hiveserver2

2015-10-19 Thread Jerrick Hoang
y > Ltd, its subsidiaries or their employees, unless expressly so stated. It is > the responsibility of the recipient to ensure that this email is virus > free, therefore neither Peridale Ltd, its subsidiaries nor their employees > accept any responsibility. > > > > *From:* Jerrick H

Re: Beeline and hiveserver2

2015-10-19 Thread Jerrick Hoang
ology > Ltd, its subsidiaries or their employees, unless expressly so stated. It is > the responsibility of the recipient to ensure that this email is virus > free, therefore neither Peridale Ltd, its subsidiaries nor their employees > accept any responsibility. > > > > *From:* J

Re: Beeline and hiveserver2

2015-10-19 Thread Jerrick Hoang
So the solution is setting this flag to false `hive.server2.enable.doAs ` On Mon, Oct 19, 2015 at 3:34 PM, Jerrick Hoang wrote: > I do not have that in my xml file. This is the entire hive-site.xml I > have, > > > > hive.metastore.uris > thrift://:905

Hiveserver2 client stdout

2015-10-19 Thread Jerrick Hoang
Hi all, I have a hiveserver2 client running on a remote server. I'm able to connect to it via beeline CLI and everything works fine but when I try to query via a JDBC client, the stdout is not there. For example, if the server side throws an exception, beeline can show the exception but all the J

Re: Hiveserver2 client stdout

2015-10-19 Thread Jerrick Hoang
r2 log. > > -- > r7raul1...@163.com > > > *From:* Jerrick Hoang > *Date:* 2015-10-20 09:03 > *To:* user > *Subject:* Hiveserver2 client stdout > Hi all, > > > I have a hiveserver2 client running on a remote server. I'm able to > connect to it via

Re: Re: Hiveserver2 client stdout

2015-10-19 Thread Jerrick Hoang
[true/false] > > Display nested errors. Default is false. > > Usage: beeline --showNestedErrs=true > > ---------- > r7raul1...@163.com > > > *From:* Jerrick Hoang > *Date:* 2015-10-20 11:55 > *To:* user > *Subject:* Re: Hiveserver2 clien

Re: Re: Hiveserver2 client stdout

2015-10-20 Thread Jerrick Hoang
lyhealth.com > > > On Mon, Oct 19, 2015 at 10:30 PM, Jerrick Hoang > wrote: > >> Right, with beeline CLI, I can see logs just fine. But with the java JDBC >> client code ( >> https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients) I >> can&#x