Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Unable to read table count using hive warehouse connector

Highlighted

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>

Don't have an account?
Coming from Hortonworks? Activate your account here