[
https://issues.apache.org/jira/browse/HIVE-9113?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14249865#comment-14249865
]
Hive QA commented on HIVE-9113:
---
{color:red}Overall{color}: -1 at least one tests failed
[
https://issues.apache.org/jira/browse/HIVE-9113?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14250961#comment-14250961
]
Szehon Ho commented on HIVE-9113:
-
+1 patch looks reasonable to me. Thanks for adding the
[
https://issues.apache.org/jira/browse/HIVE-9113?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14248235#comment-14248235
]
Prabhu Joseph commented on HIVE-9113:
-
Hi Chao,
The subquery inside IN clause does
[
https://issues.apache.org/jira/browse/HIVE-9113?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14248770#comment-14248770
]
Chao commented on HIVE-9113:
[~Prabhu Joseph] Thanks! You're right, I forgot the from lineitem
[
https://issues.apache.org/jira/browse/HIVE-9113?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14247713#comment-14247713
]
Xuefu Zhang commented on HIVE-9113:
---
The correct syntax for subquery in from clause is:
[
https://issues.apache.org/jira/browse/HIVE-9113?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14247751#comment-14247751
]
Chao commented on HIVE-9113:
Thanks [~xuefuz] for the explanation!
Explain on query failed