[ https://issues.apache.org/jira/browse/HIVE-18494?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16332710#comment-16332710 ]
Gopal V commented on HIVE-18494: -------------------------------- LGTM - +1 > Regression: from HIVE-18069, the metastore directsql is getting disabled > ------------------------------------------------------------------------ > > Key: HIVE-18494 > URL: https://issues.apache.org/jira/browse/HIVE-18494 > Project: Hive > Issue Type: Bug > Components: Standalone Metastore > Reporter: Gopal V > Assignee: Jesus Camacho Rodriguez > Priority: Major > Attachments: HIVE-18494.patch > > > {code:java} > 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] > {code} > The DataNucleus layer returns List<String> for this case, when exactly one > column has been selected. > And MetastoreDirectSQL is disabled for all further queries. -- This message was sent by Atlassian JIRA (v7.6.3#76005)