[ https://issues.apache.org/jira/browse/HIVE-5128?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13745707#comment-13745707 ]
Navis commented on HIVE-5128: ----------------------------- [~sershe] Could you check this? I've seen that testing "create_view_partitioned.q" {noformat} CREATE VIEW vp1 PARTITIONED ON (value) AS SELECT key, value FROM src WHERE key=86; ALTER VIEW vp1 ADD PARTITION (value='val_86') PARTITION (value='val_xyz'); ALTER VIEW vp1 DROP PARTITION (value='val_xyz'); {noformat} > Direct SQL for view is failing > ------------------------------- > > Key: HIVE-5128 > URL: https://issues.apache.org/jira/browse/HIVE-5128 > Project: Hive > Issue Type: Bug > Components: Query Processor > Reporter: Navis > Priority: Trivial > > I cannot sure of this, but dropping views, (it rolls back to JPA and works > fine) > {noformat} > 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) > ... > {noformat} > Should it be disabled for views or can be fixed? -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira