[ https://issues.apache.org/jira/browse/HIVE-18725?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16515265#comment-16515265 ]
Hive QA commented on HIVE-18725: -------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12928031/HIVE-18725.06.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 7 failed/errored test(s), 14540 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[create_or_replace_view4] (batchId=96) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[create_view_failure3] (batchId=96) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[create_view_failure6] (batchId=96) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[create_view_failure7] (batchId=95) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[create_view_failure8] (batchId=95) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[create_view_failure9] (batchId=96) org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[selectDistinctStarNeg_1] (batchId=96) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/11872/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/11872/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-11872/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 7 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12928031 - PreCommit-HIVE-Build > Improve error handling for subqueries if there is wrong column reference > ------------------------------------------------------------------------ > > Key: HIVE-18725 > URL: https://issues.apache.org/jira/browse/HIVE-18725 > Project: Hive > Issue Type: Improvement > Components: Query Planning > Reporter: Vineet Garg > Assignee: Igor Kryvenko > Priority: Major > Attachments: HIVE-18725.01.patch, HIVE-18725.02.patch, > HIVE-18725.03.patch, HIVE-18725.04.patch, HIVE-18725.05.patch, > HIVE-18725.06.patch > > > If there is a column reference within subquery which doesn't exist Hive > throws misleading error message. > e.g. > {code:sql} > select * from table1 where table1.col1 IN (select col2 from table2 where > table2.col1=table1.non_existing_column) and table1.col1 IN (select 4); > {code} > The above query, assuming table1 doesn't have non_existing_column, will throw > following misleading error: > {noformat} > FAILED: SemanticException Line 0:-1 Unsupported SubQuery Expression 'col1': > Only 1 SubQuery expression is supported. > {noformat} -- This message was sent by Atlassian JIRA (v7.6.3#76005)