hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zheng Shao (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HIVE-1060) disable SELECT * FROM a JOIN b ON key
Date Tue, 26 Jan 2010 21:38:34 GMT

    [ https://issues.apache.org/jira/browse/HIVE-1060?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12805216#action_12805216

Zheng Shao commented on HIVE-1060:

One more question:

Can you find out why the follow-on semantic analysis didn't catch this problem?
The column reference should end up with "ambiguous column" since both tables have this column,
but apparently it didn't.

> disable SELECT * FROM a JOIN b ON key
> -------------------------------------
>                 Key: HIVE-1060
>                 URL: https://issues.apache.org/jira/browse/HIVE-1060
>             Project: Hadoop Hive
>          Issue Type: Bug
>    Affects Versions: 0.5.0, 0.6.0
>            Reporter: Zheng Shao
>            Assignee: Vikram Chandrasekhar
>         Attachments: HIVE-1060.1.patch
> In some SQL dialect, we support this kind of syntax as a shortcut of "a.key = b.key".
> We should output an error for this. Currently we are allowing this because we might have
implicit type conversion from String to Boolean.

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message