Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Questions about HiveServer and Beeswax

Solved Go to solution

Questions about HiveServer and Beeswax

Contributor

 

Hi, I have some question about HiveServer and Beeswax.

 

As far as I known, Hive CLI access hive via HiveServer1 while Beeline though HiveServer2.  I wonder how Beeswax access hive? Using HiveServer1 or HiveServer2?

 

Is that HiveServer1 always runing? Or it only starts when Hive CLI launches?

 

If I start HiveServer2 as a service, are there any conflicts between these two servers that would lead to the failure of Beeswax?

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Questions about HiveServer and Beeswax

Beeswax Server is a distinct Hive Server, you can see it as HiveServer 1.5.

Hue Beeswax UI uses Beeswax Server by default in CDH4.
Hue Beeswax UI uses HiveServer2 by default in CDH5.

http://gethue.com/hadoop-tutorial-hive-query-editor-with-hiveserver2-and/

We recommend to switch to HiveServer2 since CDH4.5, it is more robust.

Romain

4 REPLIES 4

Re: Questions about HiveServer and Beeswax

Contributor

 

Maybe I should give some details about my case.

 

I'm now using CDH4.7. When I download the result of query in Beeswax, sometimes the hue service would crash. Therefore, I'm thinking about using HiveServer2 to access hive data through JDBC. However, I'm not sure that if starting HiveServer2 would has any unwanted effect on Beeswax.

 

Since I know little about HiveServer2, so maybe some of my ideas about that is totally incorrect.

Re: Questions about HiveServer and Beeswax

Beeswax Server is a distinct Hive Server, you can see it as HiveServer 1.5.

Hue Beeswax UI uses Beeswax Server by default in CDH4.
Hue Beeswax UI uses HiveServer2 by default in CDH5.

http://gethue.com/hadoop-tutorial-hive-query-editor-with-hiveserver2-and/

We recommend to switch to HiveServer2 since CDH4.5, it is more robust.

Romain

Re: Questions about HiveServer and Beeswax

Contributor

 

Thanks for reply.

 

There are a number of hue.ini files in my system. I'm not sure which one is the configure file in use.

 

/opt/cloudera/parcels/CDH-4.2.1-1.cdh4.2.1.p0.5/share/hue/desktop/conf/hue.ini
/opt/cloudera/parcels/CDH-4.2.1-1.cdh4.2.1.p0.5/etc/hue/hue.ini
/opt/cloudera/parcels/CDH-4.7.0-1.cdh4.7.0.p0.40/share/hue/desktop/conf/hue.ini
/opt/cloudera/parcels/CDH-4.7.0-1.cdh4.7.0.p0.40/etc/hue/hue.ini
/opt/cloudera/parcels/CDH-4.6.0-1.cdh4.6.0.p0.26/share/hue/desktop/conf/hue.ini
/opt/cloudera/parcels/CDH-4.6.0-1.cdh4.6.0.p0.26/etc/hue/hue.ini

 

Is there any way I can figure out which one HiveServer is used by Beeswax now?

Re: Questions about HiveServer and Beeswax

Contributor

 

There are also hue.ini files like /var/run/cloudera-scm-agent/process/XXXX-hue-BEESWAX_SERVER/hue.ini.

 

Maybe these are the exact configure files for hue? But each time I restart the hue service, it will generate a new one such hue.ini file, and the changes in files like /opt/cloudera/parcels/CDH-4.7.0-1.cdh4.7.0.p0.40/etc/hue/hue.ini have no effect on these files.