[HIVE-18494] Regression: from HIVE-18069, the metastore directsql is getting disabled

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.0.0
• Component/s: Standalone Metastore
• Assignee: Jesús Camacho Rodríguez
• Reporter: Gopal Vijayaraghavan
• Created: 19/Jan/18 08:21
• Updated: 27/Feb/24 22:23
• Resolved: 23/Jan/18 16:05

Description

018-01-19T02:12:34,457  WARN [pool-10-thread-1] metastore.ObjectStore: Falling back to ORM path due to direct SQL failure (this is not an error): java.lang.String cannot be cast to [Ljava.lang.Object; at

org.apache.hadoop.hive.metastore.MetaStoreDirectSql.getTables(MetaStoreDirectSql.java:412) at org.apache.hadoop.hive.metastore.ObjectStore$2.getSqlResult(ObjectStore.java:1336)

2018-01-19T02:12:34,457 DEBUG [pool-10-thread-1] metastore.ObjectStore: Full DirectSQL callstack for debugging (note: this is not an error)

java.lang.ClassCastException: java.lang.String cannot be cast to [Ljava.lang.Object;

        at org.apache.hadoop.hive.metastore.MetaStoreDirectSql.getTables(MetaStoreDirectSql.java:412) ~[hive-exec-3.0.0-SNAPSHOT.jar:3.0.0-SNAPSHOT]

        at org.apache.hadoop.hive.metastore.ObjectStore$2.getSqlResult(ObjectStore.java:1336) ~[hive-exec-3.0.0-SNAPSHOT.jar:3.0.0-SNAPSHOT]

        at org.apache.hadoop.hive.metastore.ObjectStore$2.getSqlResult(ObjectStore.java:1332) ~[hive-exec-3.0.0-SNAPSHOT.jar:3.0.0-SNAPSHOT]

        at org.apache.hadoop.hive.metastore.ObjectStore$GetHelper.run(ObjectStore.java:3200) ~[hive-exec-3.0.0-SNAPSHOT.jar:3.0.0-SNAPSHOT]

        at org.apache.hadoop.hive.metastore.ObjectStore.getTablesInternal(ObjectStore.java:1344) ~[hive-exec-3.0.0-SNAPSHOT.jar:3.0.0-SNAPSHOT]

        at org.apache.hadoop.hive.metastore.ObjectStore.getTables(ObjectStore.java:1323) ~[hive-exec-3.0.0-SNAPSHOT.jar:3.0.0-SNAPSHOT]

The DataNucleus layer returns List<String> for this case, when exactly one column has been selected.

And MetastoreDirectSQL is disabled for all further queries.