- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Questions about HiveServer and Beeswax
- Labels:
-
Apache Hive
Created on ‎10-09-2014 04:40 AM - edited ‎09-16-2022 02:09 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
Created ‎10-09-2014 04:10 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Created ‎10-09-2014 04:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Created ‎10-09-2014 04:10 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Created ‎10-09-2014 06:43 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
Created ‎10-09-2014 07:16 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
