hadoop-hive-dev mailing list archives

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

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

John Sichi commented on HIVE-1060:

BTW, there is a standard SQL:200n construct SELECT * FROM a JOIN b USING(key), so we might
want to file a followup JIRA for providing the original behavior using the standard (unambiguous)

> 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