drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel Barclay (Drill/MapR) (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-2239) Confusing error message "Column 't1' is ambiguous" for _table_ name t1
Date Fri, 13 Feb 2015 01:19:12 GMT

    [ https://issues.apache.org/jira/browse/DRILL-2239?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14319371#comment-14319371
] 

Daniel Barclay (Drill/MapR) commented on DRILL-2239:
----------------------------------------------------

Roger.  Closing.

> Confusing error message "Column 't1' is ambiguous" for _table_ name t1
> ----------------------------------------------------------------------
>
>                 Key: DRILL-2239
>                 URL: https://issues.apache.org/jira/browse/DRILL-2239
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: SQL Parser
>            Reporter: Daniel Barclay (Drill/MapR)
>            Assignee: Aman Sinha
>            Priority: Minor
>
> The error message about the erroneous use of "t1" in "t1 IS NULL" in this query:
>  select * 
>             from               dfs_test.`xxx/jsoninput/nullable1U.json` t1
>                left outer join dfs_test.`xxx/jsoninput/nullable2U.json` t2
>                   on ( t1.key = t2.key OR ( t1 IS NULL AND t2 IS NULL) )
> says "Column 't1' is ambiguous" even though t1 is not a column name and isn't ambiguous.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message