While working on Hive in Azure HDInsight Emulator I was not able to create database and following exception was being thrown with all the queries:
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Got exception: org.apache.thrift.transport.
To resolve the issue and assuming Hadoop installation folder is C:\hdp open hive-site.xml from:
C:\hdp\hive-....*\conf directory
Locate
javax.jdo.option.ConnectionDriverName
org.apache.derby.jdbc.CommonDriver
Driver class name for a JDBC metastore
and change CommonDriver to EmbeddedDriver:
javax.jdo.option.ConnectionDriverName
org.apache.derby.jdbc.EmbeddedDriver
Driver class name for a JDBC metastore
From Services restart Apache Hadoop Metastore service and retry running HQL queries. It should work not. In case issue cannot be resolved feel free to drop me an email or comment.
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Got exception: org.apache.thrift.transport.
To resolve the issue and assuming Hadoop installation folder is C:\hdp open hive-site.xml from:
C:\hdp\hive-....*\conf directory
Locate
and change CommonDriver to EmbeddedDriver:
From Services restart Apache Hadoop Metastore service and retry running HQL queries. It should work not. In case issue cannot be resolved feel free to drop me an email or comment.
