Support Questions
Find answers, ask questions, and share your expertise

Unable to read table count using hive warehouse connector

New Contributor

scala> val df = hive.table("testTable") 19/01/05 04:46:33 ERROR HiveWarehouseDataSourceReader: Unable to read table schema java.lang.RuntimeException: java.lang.IllegalArgumentException: Expected gld_corp_cust_scd to be in the form db.table at com.hortonworks.spark.sql.hive.llap.HiveWarehouseDataSourceReader.readSchema(HiveWarehouseDataSourceReader.java:129) at org.apache.spark.sql.execution.datasources.v2.DataSourceV2Relation$.apply(DataSourceV2Relation.scala:56) at org.apache.spark.sql.DataFrameReader.load(DataFrameReader.scala:224) at org.apache.spark.sql.DataFrameReader.load(DataFrameReader.scala:164) at com.hortonworks.spark.sql.hive.llap.HiveWarehouseSessionImpl.table(HiveWarehouseSessionImpl.java:93) ... 49 elided Caused by: java.lang.IllegalArgumentException: Expected gld_corp_cust_scd to be in the form db.table at com.hortonworks.spark.sql.hive.llap.util.SchemaUtil.getDbTableNames(SchemaUtil.java:43) at com.hortonworks.spark.sql.hive.llap.HiveWarehouseDataSourceReader.getTableSchema(HiveWarehouseDataSourceReader.java:100) at com.hortonworks.spark.sql.hive.llap.HiveWarehouseDataSourceReader.readSchema(HiveWarehouseDataSourceReader.java:123) ... 53 more scala> val df = hive.table("testDB.testTable") 19/01/05 04:46:44 ERROR HiveWarehouseDataSourceReader: Unable to read table schema java.lang.RuntimeException: java.util.UnknownFormatConversionException: Conversion = '.' at com.hortonworks.spark.sql.hive.llap.HiveWarehouseDataSourceReader.readSchema(HiveWarehouseDataSourceReader.java:129) at org.apache.spark.sql.execution.datasources.v2.DataSourceV2Relation$.apply(DataSourceV2Relation.scala:56) at org.apache.spark.sql.DataFrameReader.load(DataFrameReader.scala:224) at org.apache.spark.sql.DataFrameReader.load(DataFrameReader.scala:164) at com.hortonworks.spark.sql.hive.llap.HiveWarehouseSessionImpl.table(HiveWarehouseSessionImpl.java:93) ... 49 elided Caused by: java.util.UnknownFormatConversionException: Conversion = '.' at java.util.Formatter.checkText(Formatter.java:2579) at java.util.Formatter.parse(Formatter.java:2565) at java.util.Formatter.format(Formatter.java:2501) at java.util.Formatter.format(Formatter.java:2455) at java.lang.String.format(String.java:2940) at com.hortonworks.spark.sql.hive.llap.util.HiveQlUtil.selectStar(HiveQlUtil.java:31) at com.hortonworks.spark.sql.hive.llap.HiveWarehouseDataSourceReader.getTableSchema(HiveWarehouseDataSourceReader.java:101) at com.hortonworks.spark.sql.hive.llap.HiveWarehouseDataSourceReader.readSchema(HiveWarehouseDataSourceReader.java:123) ... 53 more scala>