Thrift Hive client for python install steps

On Thursday, September 27, 2012 11:35:43 AM UTC-4, Mike wrote:

Hi All,

I use CM4.0/CDH 4.0.3. I have a hive server running in my cluster.

I need to install thrift hive client on the separate machine outside
hadoop cluser.

Do you guys have install steps for that please?

Thanks

On Thursday, September 27, 2012 4:39:36 PM UTC-4, Mike wrote:

Could you please respond?

On Mon, Oct 1, 2012 at 2:16 PM, Mike wrote:

Could you please respond?

Thanks

On Monday, October 1, 2012 2:51:07 PM UTC-4, Adam Smieszny wrote:

Hi Mike,

I believe the steps to enable this are as follows (note I have not done
this myself, but this is my educated guess based on some research).

1. Install "Hive" RPM/deb on external box
2. Configure Hive-site.xml
3. Start hive thrift server with 'hive --service hiveserver'

A blog post that you might find relevant is available here:
http://blog.milford.io/2010/06/daemonizing-the-apache-hive-thrift-server-on-centos/

Cheers,
Adam

On Mon, Oct 1, 2012 at 2:16 PM, Mike <[email protected] <javascript:>>wrote:

--
Adam Smieszny
Cloudera | Systems Engineer | http://tiny.cloudera.com/about
917.830.4156 | http://www.linkedin.com/in/adamsmieszny

On Mon, Oct 1, 2012 at 3:21 PM, Mike wrote:
Thanks Adam.

Currently, after getting into hive, I add the jar files manually as below
hive> add jar /usr/lib/hive/lib/hbase.jar;
hive> add jar /usr/lib/hive/lib/hive-hbase-handler-0.8.1-cdh4.0.1.jar;
hive> add jar /usr/lib/hive/lib/zookeeper.jar;
hive> add jar /usr/lib/hive/lib/guava-r09.jar;

How do I set the jar files for "hive --service hiveserver"?

select * from tablename works fine without the jar files.

select key from tablename fails without the jar files.

Thanks

On Monday, October 1, 2012 3:26:38 PM UTC-4, Joey Echeverria wrote:

You need to create a .hiverc file for the user running the hive
server. You can place your add statements in there.

-Joey

On Mon, Oct 1, 2012 at 3:21 PM, Mike <[email protected] <javascript:>>
wrote:
http://blog.milford.io/2010/06/daemonizing-the-apache-hive-thrift-server-on-centos/


--
Joey Echeverria
Principal Solutions Architect
Cloudera, Inc.

On Mon, Oct 1, 2012 at 3:39 PM, Mike wrote:
Thanks Joey.

I am logged in as root. I create .hiverc file in /root directory and file
looks like the below
add jar /usr/lib/hive/lib/hbase.jar;
add jar /usr/lib/hive/lib/hive-hbase-handler-0.8.1-cdh4.0.1.jar;
add jar /usr/lib/hive/lib/zookeeper.jar;
add jar /usr/lib/hive/lib/guava-r09.jar;

I started
hive --service hiveserver

Ran my script it errors out. It is not picking up the .hiverc file.

Am I missing something?

Thanks

On Monday, October 1, 2012 3:42:51 PM UTC-4, Joey Echeverria wrote:

My mistake, I gave you bad information. What you really need to do is
set hive.aux.jars.path in the hive-site.xml:

<property>
<name>hive.aux.jars.path</name>

<value>file:///usr/lib/hive/lib/hbase.jar,file:///usr/lib/hive/lib/hive-hbase-handler-0.8.1-cdh4.0.1.jar,file:///usr/lib/hive/lib/zookeeper.jar,file:///usr/lib/hive/lib/guava-r09.jar</value>

</property>

-Joey

On Mon, Oct 1, 2012 at 3:39 PM, Mike <[email protected] <javascript:>>
wrote:
/usr/lib/hive/lib/hive-hbase-handler-0.8.1-cdh4.0.1.jar;
done
http://blog.milford.io/2010/06/daemonizing-the-apache-hive-thrift-server-on-centos/
cluster.
outside


--
Joey Echeverria
Principal Solutions Architect
Cloudera, Inc.

On Monday, October 1, 2012 3:42:51 PM UTC-4, Joey Echeverria wrote:

My mistake, I gave you bad information. What you really need to do is
set hive.aux.jars.path in the hive-site.xml:

<property>
<name>hive.aux.jars.path</name>

<value>file:///usr/lib/hive/lib/hbase.jar,file:///usr/lib/hive/lib/hive-hbase-handler-0.8.1-cdh4.0.1.jar,file:///usr/lib/hive/lib/zookeeper.jar,file:///usr/lib/hive/lib/guava-r09.jar</value>

</property>

-Joey

On Mon, Oct 1, 2012 at 3:39 PM, Mike <[email protected] <javascript:>>
wrote:
/usr/lib/hive/lib/hive-hbase-handler-0.8.1-cdh4.0.1.jar;
done
http://blog.milford.io/2010/06/daemonizing-the-apache-hive-thrift-server-on-centos/
cluster.
outside


--
Joey Echeverria
Principal Solutions Architect
Cloudera, Inc.