You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@drill.apache.org by "Daniel Barclay (Drill/MapR) (JIRA)" <ji...@apache.org> on 2015/02/13 02:20:11 UTC

[jira] [Resolved] (DRILL-2239) Confusing error message "Column 't1' is ambiguous" for _table_ name t1

     [ https://issues.apache.org/jira/browse/DRILL-2239?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Daniel Barclay (Drill/MapR) resolved DRILL-2239.
------------------------------------------------
    Resolution: Invalid

> 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)