Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Questions about HiveServer and Beeswax

avatar
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

avatar
Super Guru
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

View solution in original post

4 REPLIES 4

avatar
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.

avatar
Super Guru
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

avatar
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?

avatar
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.