The below I had to set to avoid on a derby database to get past this problem.
<property> <name>hive.server2.authentication</name> <value>NOSASL</value> <description> Expects one of [nosasl, none, ldap, kerberos, pam, custom]. Client authentication types. NONE: no authentication check LDAP: LDAP/AD based authentication KERBEROS: Kerberos/GSSAPI authentication CUSTOM: Custom authentication provider (Use with property hive.server2.custom.authentication.class) PAM: Pluggable authentication module NOSASL: Raw 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]: transport.TSaslTransport (TSaslTransport.java:open(243)) - opening transport org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$HiveSaslServerTransportFactory$1@12d391f8<mailto:org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$HiveSaslServerTransportFactory$1@12d391f8> 2015-04-17 08:24:12,858 DEBUG [HiveServer2-Handler-Pool: Thread-21]: transport.TSaslServerTransport (HadoopThriftAuthBridge.java:getTransport(179)) - failed to open server transport org.apache.thrift.transport.TTransportException Its looks like the opening does occur to the thrift server? However failed to open server Transport? Permission issue ? I opened up all the ports. Chain INPUT (policy ACCEPT) target prot opt source destination Chain FORWARD (policy ACCEPT) target prot opt source destination Chain OUTPUT (policy ACCEPT) target prot opt source destination [root@localhost sbin]# netstat -alnp|egrep 'Local|10000|9083' Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0 0.0.0.0:10000 0.0.0.0:* LISTEN 2373/java tcp 0 0 0.0.0.0:9083 0.0.0.0:* LISTEN 2265/java tcp 0 0 127.0.0.1:10000 127.0.0.1:48434 CLOSE_WAIT 2373/java tcp 0 0 127.0.0.1:58370 127.0.0.1:9083 ESTABLISHED 2373/java tcp 0 0 127.0.0.1:10000 127.0.0.1:48506 CLOSE_WAIT 2373/java tcp 1 0 127.0.0.1:10000 127.0.0.1:48478 CLOSE_WAIT 2373/java tcp 0 0 127.0.0.1:10000 127.0.0.1:48482 CLOSE_WAIT 2373/java tcp 0 0 127.0.0.1:9083 127.0.0.1:58370 ESTABLISHED 2265/java tcp 0 0 127.0.0.1:10000 127.0.0.1:48508 CLOSE_WAIT 2373/java tcp 0 0 127.0.0.1:10000 127.0.0.1:48510 CLOSE_WAIT 2373/java tcp 0 0 127.0.0.1:10000 127.0.0.1:48436 CLOSE_WAIT 2373/java tcp 0 0 127.0.0.1:10000 127.0.0.1:48438 CLOSE_WAIT 2373/java tcp 0 0 127.0.0.1:10000 127.0.0.1:48480 CLOSE_WAIT 2373/java Ip addresses: Thanks, Gary C From: Gary Clark [mailto:gcl...@neces.com] Sent: Friday, April 17, 2015 12:57 PM To: user@hive.apache.org<mailto:user@hive.apache.org> Subject: RE: Error when connecting Hue to HiveServer2 Thanks Mich good test. [root@localhost root]# telnet 127.0.0.1 10000 Trying 127.0.0.1... Connected to 127.0.0.1. Escape character is '^]'. Yes all good it seems. Cheers, Gazza From: Mich Talebzadeh [mailto:m...@peridale.co.uk] Sent: Friday, April 17, 2015 11:44 AM To: user@hive.apache.org<mailto:user@hive.apache.org> Subject: RE: Error when connecting Hue to HiveServer2 OK so both are running and up (metastore on 9083 and hiveserver on 10000 Try doing telnet hostname 10000 Can you connect like below (mine runs on 10010 ☺) hduser@rhes564::/home/hduser> telnet rhes564 10010 Trying 50.140.197.217... Connected to rhes564. Escape character is '^]'. Mich Talebzadeh http://talebzadehmich.wordpress.com Author of the books "A Practitioner’s Guide to Upgrading to Sybase ASE 15", ISBN 978-0-9563693-0-7. co-author "Sybase Transact SQL Guidelines Best Practices", ISBN 978-0-9759693-0-4 Publications due shortly: Creating in-memory Data Grid for Trading Systems with Oracle TimesTen and Coherence Cache Oracle and Sybase, Concepts and Contrasts, ISBN: 978-0-9563693-1-4, volume one out shortly NOTE: The information in this email is proprietary and confidential. This message is for the designated recipient only, if you are not the intended recipient, you should destroy it immediately. Any information in this message shall not be understood as given or endorsed by Peridale Ltd, its subsidiaries or their employees, unless expressly so stated. It is the responsibility of the recipient to ensure that this email is virus free, therefore neither Peridale Ltd, its subsidiaries nor their employees accept any responsibility. From: Gary Clark [mailto:gcl...@neces.com] Sent: 17 April 2015 17:39 To: user@hive.apache.org<mailto:user@hive.apache.org> Subject: RE: Error when connecting Hue to HiveServer2 Hi Mich, tcp 0 0 0.0.0.0:10000 0.0.0.0:* LISTEN 16561/java tcp 0 0 0.0.0.0:9083 0.0.0.0:* LISTEN 16654/java I am starting to think this is firewall issue not sure what is going on. Yep 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<mailto: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 do you when you run the command below? I assume that your hiveserver is running on port 10000? netstat -alnp|egrep 'Local|10000|9083' HTH Mich Talebzadeh http://talebzadehmich.wordpress.com Author of the books "A Practitioner’s Guide to Upgrading to Sybase ASE 15", ISBN 978-0-9563693-0-7. co-author "Sybase Transact SQL Guidelines Best Practices", ISBN 978-0-9759693-0-4 Publications due shortly: Creating in-memory Data Grid for Trading Systems with Oracle TimesTen and Coherence Cache Oracle and Sybase, Concepts and Contrasts, ISBN: 978-0-9563693-1-4, volume one out shortly NOTE: The information in this email is proprietary and confidential. This message is for the designated recipient only, if you are not the intended recipient, you should destroy it immediately. Any information in this message shall not be understood as given or endorsed by Peridale Ltd, its subsidiaries or their employees, unless expressly so stated. It is the responsibility of the recipient to ensure that this email is virus free, therefore neither Peridale Ltd, its subsidiaries nor their employees accept any responsibility. From: Gary Clark [mailto:gcl...@neces.com] Sent: 17 April 2015 17:27 To: user@hive.apache.org<mailto:user@hive.apache.org> Subject: Error when connecting Hue to HiveServer2 Hey Guys, I am see the following error when attempting to connect Hue to the hive metatstore: From hive-site.log 015-04-17 05:12:48,857 INFO [main]: metastore.HiveMetaStore (HiveMetaStore.java:addAdminUsers_core(679)) - No user is added in admin role, since config is empty 2015-04-17 05:12:48,971 INFO [main]: metastore.HiveMetaStore (HiveMetaStore.java:startMetaStore(5740)) - Starting DB backed MetaStore Server with SetUGI enabled 2015-04-17 05:12:48,973 INFO [main]: metastore.HiveMetaStore (HiveMetaStore.java:startMetaStore(5757)) - Started the new metaserver on port [9083]... 2015-04-17 05:12:48,973 INFO [main]: metastore.HiveMetaStore (HiveMetaStore.java:startMetaStore(5759)) - Options.minWorkerThreads = 200 2015-04-17 05:12:48,973 INFO [main]: metastore.HiveMetaStore (HiveMetaStore.java:startMetaStore(5761)) - Options.maxWorkerThreads = 100000 2015-04-17 05:12:48,973 INFO [main]: metastore.HiveMetaStore (HiveMetaStore.java:startMetaStore(5763)) - TCP keepalive = true 2015-04-17 05:12:50,863 DEBUG [HiveServer2-Handler-Pool: Thread-23]: transport.TSaslServerTransport (HadoopThriftAuthBridge.java:getTransport(174)) - transport map does not contain key org.apache.thrift.transport.TSocket@2f0c37a9<mailto:org.apache.thrift.transport.TSocket@2f0c37a9> 2015-04-17 05:12:50,863 DEBUG [HiveServer2-Handler-Pool: Thread-22]: transport.TSaslServerTransport (HadoopThriftAuthBridge.java:getTransport(174)) - transport map does not contain key org.apache.thrift.transport.TSocket@2c92f525<mailto:org.apache.thrift.transport.TSocket@2c92f525> 2015-04-17 05:12:50,863 DEBUG [HiveServer2-Handler-Pool: Thread-21]: transport.TSaslServerTransport (HadoopThriftAuthBridge.java:getTransport(174)) - transport map does not contain key org.apache.thrift.transport.TSocket@4b1a5060<mailto:org.apache.thrift.transport.TSocket@4b1a5060> 2015-04-17 05:12:50,866 DEBUG [HiveServer2-Handler-Pool: Thread-22]: transport.TSaslTransport (TSaslTransport.java:open(243)) - opening transport org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$HiveSaslServerTransportFactory$1@4aa5331<mailto:org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$HiveSaslServerTransportFactory$1@4aa5331> 2015-04-17 05:12:50,866 DEBUG [HiveServer2-Handler-Pool: Thread-21]: transport.TSaslTransport (TSaslTransport.java:open(243)) - opening transport org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$HiveSaslServerTransportFactory$1@4a3bb85b<mailto:org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$HiveSaslServerTransportFactory$1@4a3bb85b> 2015-04-17 05:12:50,866 DEBUG [HiveServer2-Handler-Pool: Thread-23]: transport.TSaslTransport (TSaslTransport.java:open(243)) - opening transport org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$HiveSaslServerTransportFactory$1@16c48470<mailto:org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$HiveSaslServerTransportFactory$1@16c48470> 2015-04-17 05:12:50,866 DEBUG [HiveServer2-Handler-Pool: Thread-22]: transport.TSaslServerTransport (HadoopThriftAuthBridge.java:getTransport(179)) - failed to open server transport org.apache.thrift.transport.TTransportException at org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:132) I am using the derby database. Not sure what I am missing? Any ideas would of course helpful. Much Appreciated, gazza