question Re: Questions about HiveServer and Beeswax in Archives of Support Questions (Read Only)

Questions about HiveServer and Beeswax

sky88088 — Fri, 16 Sep 2022 09:09:28 GMT

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?

Re: Questions about HiveServer and Beeswax

sky88088 — Thu, 09 Oct 2014 11:52:04 GMT

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

Romainr — Thu, 09 Oct 2014 23:10:20 GMT

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

sky88088 — Fri, 10 Oct 2014 01:43:07 GMT

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

sky88088 — Fri, 10 Oct 2014 02:16:39 GMT

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.