Cloudera Community
adi135
user rank
New Contributor
My Accepted Solutions
Show All

Re: Error Connection Reset on Impala Shell when se...

by New Contributor in Support Questions
‎12-26-2018 08:18 PM
‎12-26-2018 08:18 PM
i found how to solve this error : update mysql driver > mysql-connection-java hive --service hiveserver hive --service metastore service iptables stop restart hive-server restart impala-server restart mysql server invalidate metadata table refresh table   i think this issue becouce connection between hive and mysql that store metastore ... View more

Error Connection Reset on Impala Shell when select...

by New Contributor in Support Questions
‎12-26-2018 02:14 AM
‎12-26-2018 02:14 AM
Hi All, i'm new on Cloudera & Hadoop. I get error on my system. When i select table from impala-shell, i got error connection time out [before this, system is normal, and i didn't change configuration]. And then i found solution from forum and download mysql-connector-java again and apply to /usr/share/java. But after i update mysql-connector-java, i got another error : ERROR: AnalysisException: Failed to load metadata for table: ibn.test CAUSED BY: TableLoadingException: Failed to load metadata for table: ibn.test. Running 'invalidate metadata ibn.test' may resolve this problem. CAUSED BY: TTransportException: java.net.SocketException: Connection reset CAUSED BY: SocketException: Connection reset Can anyone help me? ... View more
Labels:
Contact Me
Online
Offline
Last Visited
‎01-30-2019 08:02 PM
Community Statistics
Member Since ‎12-26-2018 02:04 AM
Last Visited ‎01-30-2019 08:02 PM
Posts 2