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

Posted to dev@drill.apache.org by "second88 (JIRA)" <ji...@apache.org> on 2017/10/17 02:06:02 UTC

[jira] [Created] (DRILL-5883) Support escape syntax for an outer join

second88 created DRILL-5883:
-------------------------------

             Summary: Support escape syntax for an outer join
                 Key: DRILL-5883
                 URL: https://issues.apache.org/jira/browse/DRILL-5883
             Project: Apache Drill
          Issue Type: New Feature
          Components: Client - JDBC, Client - ODBC, SQL Parser, Storage - JDBC
    Affects Versions: 1.10.0
            Reporter: second88


Referring to section 13.4.3 of [JSR-000221|http://download.oracle.com/otndocs/jcp/jdbc-4_2-mrel2-spec/index.html], please add support of escape syntax for an outer join.

e.g.,
{code:sql}
SELECT `A`.`ID`, `B`.`ID`
FROM   {oj `dfs.tmp`.`A` `A` LEFT OUTER JOIN `dfs.tmp`.`B` `B` ON `A`.`ID`=`B`.`ID`}
{code}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)