hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Navis (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-5128) Direct SQL for view is failing
Date Wed, 21 Aug 2013 01:49:51 GMT

    [ 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

Mime
View raw message