[ https://issues.apache.org/jira/browse/HIVE-13862?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15303484#comment-15303484 ]
Amareshwari Sriramadasu commented on HIVE-13862: ------------------------------------------------ Yeah.. seems it was always falling to back to ORM - and never worked with directsql earlier with HIVE-11487. I dont think we have a way to test whether api is answered from directsql vs orm in unit tests. btw, we deployed the above fix in our production environment, and it is working fine. bq. IIRC some methods use a call on the query object that forces a single result, that may be a better option here. Didnt find any. Can you give more pointers? > org.apache.hadoop.hive.metastore.MetaStoreDirectSql.getNumPartitionsViaSqlFilter > falls back to ORM > --------------------------------------------------------------------------------------------------- > > Key: HIVE-13862 > URL: https://issues.apache.org/jira/browse/HIVE-13862 > Project: Hive > Issue Type: Bug > Components: Metastore > Reporter: Amareshwari Sriramadasu > Assignee: Rajat Khandelwal > Fix For: 2.1.0 > > Attachments: HIVE-13862.patch > > > We are seeing following exception and calls fall back to ORM which make it > costly : > {noformat} > WARN org.apache.hadoop.hive.metastore.ObjectStore - Direct SQL failed, > falling back to ORM > java.lang.ClassCastException: > org.datanucleus.store.rdbms.query.ForwardQueryResult cannot be cast to > java.lang.Number > at > org.apache.hadoop.hive.metastore.MetaStoreDirectSql.extractSqlInt(MetaStoreDirectSql.java:892) > ~[hive-exec-2.1.2-inm-SNAPSHOT.jar:2.1.2-inm-SNAPSHOT] > at > org.apache.hadoop.hive.metastore.MetaStoreDirectSql.getNumPartitionsViaSqlFilterInternal(MetaStoreDirectSql.java:855) > ~[hive-exec-2.1.2-inm-SNAPSHOT.jar:2.1.2-inm-SNAPSHOT] > at > org.apache.hadoop.hive.metastore.MetaStoreDirectSql.getNumPartitionsViaSqlFilter(MetaStoreDirectSql.java:405) > ~[hive-exec-2.1.2-inm-SNAPSHOT.jar:2.1.2-inm-SNAPSHOT] > at > org.apache.hadoop.hive.metastore.ObjectStore$5.getSqlResult(ObjectStore.java:2763) > ~[hive-exec-2.1.2-inm-SNAPSHOT.jar:2.1.2-inm-SNAPSHOT] > at > org.apache.hadoop.hive.metastore.ObjectStore$5.getSqlResult(ObjectStore.java:2755) > ~[hive-exec-2.1.2-inm-SNAPSHOT.jar:2.1.2-inm-SNAPSHOT] > at > org.apache.hadoop.hive.metastore.ObjectStore$GetHelper.run(ObjectStore.java:2606) > ~[hive-exec-2.1.2-inm-SNAPSHOT.jar:2.1.2-inm-SNAPSHOT] > at > org.apache.hadoop.hive.metastore.ObjectStore.getNumPartitionsByFilterInternal(ObjectStore.java:2770) > [hive-exec-2.1.2-inm-SNAPSHOT.jar:2.1.2-inm-SNAPSHOT] > at > org.apache.hadoop.hive.metastore.ObjectStore.getNumPartitionsByFilter(ObjectStore.java:2746) > [hive-exec-2.1.2-inm-SNAPSHOT.jar:2.1.2-inm-SNAPSHOT] > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)