search

cloudera / hue

Open source SQL Query Assistant service for Databases/Warehouses
https://cloudera.com
Apache License 2.0
1.16k stars 364 forks source link

Can hue connect the remote hiveserver and How to configure. #137

Closed wpf5511 closed 9 years ago

wpf5511 commented 9 years ago

I installed hue and follow the userguide to configured the hue and hive in my computer.But now our hiveserver is running on another computer,so need hue to connect the hive remotely,but as the previous configure,like "hive_conf_dir" ,the path is on the remote,so i don't know how to configure the path,assume that the remote ip is "10.1.65.10",can you give me an example?

wpf5511 commented 9 years ago 
By the way the server pc has an ldap authorization and I use beeline to connect it also occured a mistake,I don't know how to handle them.
romainr commented 9 years ago

If HiveServer2 is on another machine than Hue, you will need to fill the [beeswax] hive_server_host=10.1.65.10

and copy a clone of the hive-site.xml in /etc/hive/conf on the Hue machine.

Note that if you can't connect with Beeline, it will probably not work with Hue. You could find more info about this on the Hive user list or http://www.cloudera.com/content/cloudera/en/documentation/core/latest/topics/cdh_sg_hiveserver2_security.html#topic_9_1_3_unique_1

wpf5511 commented 9 years ago

Thanks and i understood and will try.