You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Navis (JIRA)" <ji...@apache.org> on 2013/08/21 03:49:51 UTC
[jira] [Commented] (HIVE-5128) Direct SQL for view is failing
[ 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