question Re: hive issue in hdp 2.1 in Support Questions

hive issue in hdp 2.1

ashneesharma88 — Tue, 15 Nov 2016 17:39:18 GMT

I am using HDP 2.1. In this HDP was working fine, now getting error:-

hive -e "show databases;" Logging initialized using configuration in file:/etc/hive/conf.dist/hive-log4j.p roperties FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTa sk. MetaException(message:Got exception: org.apache.thrift.transport.TTransportE xception java.net.SocketException: Connection reset)

Please help on urgent bases.

Thanks in advance.

Re: hive issue in hdp 2.1

ashneesharma88 — Tue, 15 Nov 2016 17:46:08 GMT

After run the hive in debug mode got the error:-

ERROR hive.log: Converting exception to MetaException 16/11/15 09:44:25 [main]: ERROR exec.DDLTask: org.apache.hadoop.hive.ql.metadata.HiveException: MetaException(message:Got exception: org.apache.thrift.transport.TTransportException java.net.SocketException: Broken pipe

my databses is on same machine and I am able to access the mysql with hive user.

Re: hive issue in hdp 2.1

aawasthi — Wed, 16 Nov 2016 05:05:36 GMT

@Ashnee Sharma Try restarting Hiveserver2. Also are you able to run Hive cli ?

Re: hive issue in hdp 2.1

ashneesharma88 — Wed, 16 Nov 2016 15:10:06 GMT

I tried with hiveserver2 restart and hive cli in coming but command not working.

Re: hive issue in hdp 2.1

zhaindrich — Thu, 17 Nov 2016 00:15:21 GMT

from the above: connection reset / broken pipe - I would recommend to also check some basic things like:

* `netstat -npl` shows the metastore and hiveserver2 as running and listening on the port... also check that if you shutdown the hiveserver2 and metastore those ports are closed - i would guess that some other application have "hijacked" the hiveserver2 or the metastore port - and the application listening on that port doesn't speak the "hive" protocol 😉

* loopback device is up

* the network is working / hostnames

can you attach the hiveserver2 and/or metastore logs which could possibly cause this?

Re: hive issue in hdp 2.1

ashneesharma88 — Thu, 17 Nov 2016 16:02:46 GMT

@zhaindrich

I have checked everything and working fine. I have checked the port also only the hive server application isusing the same port.

Re: hive issue in hdp 2.1

ashneesharma88 — Thu, 17 Nov 2016 16:06:41 GMT

@zhaindrich

The logs says:-

p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Monaco; color: #f5f5f5; background-color: #000000}

Unable to open a test connection to the given database. JDBC url = jdbc:mysql://ashnee2.datametica.com/hive?createDatabaseIfNotExist=true, username = hive. Terminating connection pool (set lazyInit to true if you expect to start your database after your app). Original Exception: ------

java.sql.SQLException: Access denied for user 'hive'@'ashnee2.datametica.com' (using password: YES)

I have checked this error but no luck.

I have tried to access the database and able to access.

Re: hive issue in hdp 2.1

zhaindrich — Thu, 17 Nov 2016 16:53:18 GMT

can you check that the database password in the xml file(javax.jdo.option.ConnectionPassword) - is it the correct password? (maybe: try to remove any whitespaces before/after the password if there are any)

Re: hive issue in hdp 2.1

ashneesharma88 — Thu, 17 Nov 2016 18:51:07 GMT

@zhaindrich

I checked and already tried with this option. Not worked for me.

Re: hive issue in hdp 2.1

ashneesharma88 — Thu, 17 Nov 2016 18:54:45 GMT

Thanks everyone. I have resolved this issue with following option.

1) Took hive database backup from mysql.

2) Removed the hive from that node.

3) Added new node and hive installed on new node.

4) Restore the hive database to mysql.

And it's works. 🙂