[HIVE-5128] Direct SQL for view is failing

• Type: Bug
• Status: Closed
• Priority: Trivial
• Resolution: Fixed
• Fix Version/s: 0.12.0
• Component/s: Query Processor
• Assignee: Sergey Shelukhin Assign to me
• Reporter: Navis Ryu
• Created: 21/Aug/13 01:46
• Updated: 15/Oct/13 23:31
• Resolved: 28/Aug/13 15:13

Description

I cannot sure of this, but dropping views, (it rolls back to JPA and works fine)

etastore.ObjectStore: Direct SQL failed, falling back to ORM
MetaException(message:Unexpected null for one of the IDs, SD null, column null, serde null)
	at org.apache.hadoop.hive.metastore.MetaStoreDirectSql.getPartitionsViaSqlFilterInternal(MetaStoreDirectSql.java:195)
	at org.apache.hadoop.hive.metastore.MetaStoreDirectSql.getPartitionsViaSqlFilter(MetaStoreDirectSql.java:98)
	at org.apache.hadoop.hive.metastore.ObjectStore.getPartitionsByFilter(ObjectStore.java:1758)
...

Should it be disabled for views or can be fixed?

Issue Links

• blocks: HIVE-5029 direct SQL perf optimization cannot be tested well