[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-tabpanelfocusedCommentId=13753366#comment-13753366
]
Hudson commented on HIVE-5128:
--
ABORTED: Integrated in Hive-trunk-hadoop2 #387 (See
[https://builds.apache.org/job/Hive-trunk-hadoop2/387/])
HIVE-5128 : Direct SQL for view is failing (Sergey Shelukhin via Ashutosh
Chauhan) (hashutosh:
http://svn.apache.org/viewcvs.cgi/?root=Apache-SVNview=revrev=1518258)
*
/hive/trunk/metastore/src/java/org/apache/hadoop/hive/metastore/MetaStoreDirectSql.java
*
/hive/trunk/metastore/src/java/org/apache/hadoop/hive/metastore/ObjectStore.java
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
Assignee: Sergey Shelukhin
Priority: Trivial
Fix For: 0.12.0
Attachments: HIVE-5128.D12465.1.patch, HIVE-5128.D12465.2.patch
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
[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-tabpanelfocusedCommentId=13752530#comment-13752530
]
Hudson commented on HIVE-5128:
--
FAILURE: Integrated in Hive-trunk-hadoop2-ptest #74 (See
[https://builds.apache.org/job/Hive-trunk-hadoop2-ptest/74/])
HIVE-5128 : Direct SQL for view is failing (Sergey Shelukhin via Ashutosh
Chauhan) (hashutosh:
http://svn.apache.org/viewcvs.cgi/?root=Apache-SVNview=revrev=1518258)
*
/hive/trunk/metastore/src/java/org/apache/hadoop/hive/metastore/MetaStoreDirectSql.java
*
/hive/trunk/metastore/src/java/org/apache/hadoop/hive/metastore/ObjectStore.java
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
Assignee: Sergey Shelukhin
Priority: Trivial
Fix For: 0.12.0
Attachments: HIVE-5128.D12465.1.patch, HIVE-5128.D12465.2.patch
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
[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-tabpanelfocusedCommentId=13752553#comment-13752553
]
Hudson commented on HIVE-5128:
--
FAILURE: Integrated in Hive-trunk-hadoop1-ptest #142 (See
[https://builds.apache.org/job/Hive-trunk-hadoop1-ptest/142/])
HIVE-5128 : Direct SQL for view is failing (Sergey Shelukhin via Ashutosh
Chauhan) (hashutosh:
http://svn.apache.org/viewcvs.cgi/?root=Apache-SVNview=revrev=1518258)
*
/hive/trunk/metastore/src/java/org/apache/hadoop/hive/metastore/MetaStoreDirectSql.java
*
/hive/trunk/metastore/src/java/org/apache/hadoop/hive/metastore/ObjectStore.java
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
Assignee: Sergey Shelukhin
Priority: Trivial
Fix For: 0.12.0
Attachments: HIVE-5128.D12465.1.patch, HIVE-5128.D12465.2.patch
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
[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-tabpanelfocusedCommentId=13753308#comment-13753308
]
Hudson commented on HIVE-5128:
--
SUCCESS: Integrated in Hive-trunk-h0.21 #2295 (See
[https://builds.apache.org/job/Hive-trunk-h0.21/2295/])
HIVE-5128 : Direct SQL for view is failing (Sergey Shelukhin via Ashutosh
Chauhan) (hashutosh:
http://svn.apache.org/viewcvs.cgi/?root=Apache-SVNview=revrev=1518258)
*
/hive/trunk/metastore/src/java/org/apache/hadoop/hive/metastore/MetaStoreDirectSql.java
*
/hive/trunk/metastore/src/java/org/apache/hadoop/hive/metastore/ObjectStore.java
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
Assignee: Sergey Shelukhin
Priority: Trivial
Fix For: 0.12.0
Attachments: HIVE-5128.D12465.1.patch, HIVE-5128.D12465.2.patch
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
[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-tabpanelfocusedCommentId=13752061#comment-13752061
]
Phabricator commented on HIVE-5128:
---
ashutoshc has accepted the revision HIVE-5128 [jira] Direct SQL for view is
failing.
+1
REVISION DETAIL
https://reviews.facebook.net/D12465
BRANCH
HIVE-5128
ARCANIST PROJECT
hive
To: JIRA, ashutoshc, sershe
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
Assignee: Sergey Shelukhin
Priority: Trivial
Attachments: HIVE-5128.D12465.1.patch, HIVE-5128.D12465.2.patch
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
[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-tabpanelfocusedCommentId=13748194#comment-13748194
]
Navis commented on HIVE-5128:
-
After applying patch,
{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');
DROP VIEW vp1;
{noformat}
Fails with
{noformat}
javax.jdo.JDODataStoreException: Error executing SQL query select TBL_TYPE
from TBLS where TBLS.TBL_NAME = ? and DBS.NAME = ?.
at
org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:451)
at org.datanucleus.api.jdo.JDOQuery.executeWithArray(JDOQuery.java:321)
at
org.apache.hadoop.hive.metastore.MetaStoreDirectSql.isViewTable(MetaStoreDirectSql.java:109)
at
org.apache.hadoop.hive.metastore.MetaStoreDirectSql.getPartitionsViaSqlFilterInternal(MetaStoreDirectSql.java:209)
at
org.apache.hadoop.hive.metastore.MetaStoreDirectSql.getPartitionsViaSqlFilter(MetaStoreDirectSql.java:82)
at
org.apache.hadoop.hive.metastore.ObjectStore.getPartitionsByNames(ObjectStore.java:1672)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.apache.hadoop.hive.metastore.RetryingRawStore.invoke(RetryingRawStore.java:111)
at $Proxy8.getPartitionsByNames(Unknown Source)
at
org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_partitions_by_names(HiveMetaStore.java:3340)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:103)
at $Proxy9.get_partitions_by_names(Unknown Source)
at
org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getPartitionsByNames(HiveMetaStoreClient.java:830)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:89)
at $Proxy10.getPartitionsByNames(Unknown Source)
at
org.apache.hadoop.hive.ql.metadata.Hive.getPartitionsByNames(Hive.java:1834)
at org.apache.hadoop.hive.ql.exec.DDLTask.dropTable(DDLTask.java:3313)
at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:276)
at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:151)
at
org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:65)
at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1430)
at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1210)
at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1015)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:884)
at
org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:259)
at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:216)
at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:413)
at
org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:781)
at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:675)
at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:614)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.hadoop.util.RunJar.main(RunJar.java:197)
NestedThrowablesStackTrace:
java.sql.SQLSyntaxErrorException: Column 'DBS.NAME' is either not in any table
in the FROM list or appears within a join specification and is outside the
scope of the join specification or appears in a HAVING clause and is not in the
GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'DBS.NAME' is
not a column in the target table.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at
[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-tabpanelfocusedCommentId=13748233#comment-13748233
]
Sergey Shelukhin commented on HIVE-5128:
Sorry this is the wrong patch.
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
Assignee: Sergey Shelukhin
Priority: Trivial
Attachments: HIVE-5128.D12465.1.patch
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
[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-tabpanelfocusedCommentId=13747145#comment-13747145
]
Sergey Shelukhin commented on HIVE-5128:
let me check today/tomorrow
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
[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-tabpanelfocusedCommentId=13747169#comment-13747169
]
Sergey Shelukhin commented on HIVE-5128:
it may be bad code in a sense that we expect these things to be set, and they
are correctly not set for views. Maybe it should handle that.
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
[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-tabpanelfocusedCommentId=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
