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

Unable to read table count using hive warehouse connector

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>