RE: Error when connecting Hue to HiveServer2

2015-04-17 Thread Gary Clark
Subject: RE: Error when connecting Hue to HiveServer2 OK so both are running and up (metastore on 9083 and hiveserver on 1 Try doing telnet hostname 1 Can you connect like below (mine runs on 10010 ☺) hduser@rhes564::/home/hduser telnet rhes564 10010 Trying 50.140.197.217... Connected

RE: Error when connecting Hue to HiveServer2

2015-04-17 Thread Gary Clark
...@neces.com] Sent: Friday, April 17, 2015 12:57 PM To: user@hive.apache.org Subject: RE: Error when connecting Hue to HiveServer2 Thanks Mich good test. [root@localhost root]# telnet 127.0.0.1 1 Trying 127.0.0.1... Connected to 127.0.0.1. Escape character is '^]'. Yes all good it seems. Cheers

RE: Error when connecting Hue to HiveServer2

2015-04-17 Thread Gary Clark
HiveServer2 is running. Cheers, Gazza From: Mich Talebzadeh [mailto:m...@peridale.co.uk] Sent: Friday, April 17, 2015 11:36 AM To: user@hive.apache.org Subject: RE: Error when connecting Hue to HiveServer2 Hi Gary, Is your hiverserver2 running OK. How did you start it? $HIVE_HOME/bin/hiveserver2 What

RE: Error when connecting Hue to HiveServer2

2015-04-17 Thread Mich Talebzadeh
Hi Gary, Is your hiverserver2 running OK. How did you start it? $HIVE_HOME/bin/hiveserver2 What do you when you run the command below? I assume that your hiveserver is running on port 1? netstat -alnp|egrep 'Local|1|9083' HTH Mich Talebzadeh

RE: Error when connecting Hue to HiveServer2

2015-04-17 Thread Gary Clark
transport /description /property Was None before. Thanks, Gary From: Gary Clark [mailto:gcl...@neces.com] Sent: Friday, April 17, 2015 1:33 PM To: user@hive.apache.org Subject: RE: Error when connecting Hue to HiveServer2 2015-04-17 08:24:12,858 DEBUG [HiveServer2-Handler-Pool: Thread-23

RE: Error when connecting Hue to HiveServer2

2015-04-17 Thread Mich Talebzadeh
@hive.apache.org Subject: RE: Error when connecting Hue to HiveServer2 The below I had to set to avoid on a derby database to get past this problem. property namehive.server2.authentication/name valueNOSASL/value description Expects one of [nosasl, none, ldap, kerberos, pam

RE: Error when connecting Hue to HiveServer2

2015-04-17 Thread Gary Clark
Yep a true gem ☺ From: Mich Talebzadeh [mailto:m...@peridale.co.uk] Sent: Friday, April 17, 2015 2:03 PM To: user@hive.apache.org Subject: RE: Error when connecting Hue to HiveServer2 It always surprises how many parameters are around for different metastores ☺ I use Oracle as my Metastore