Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-5883

Support escape syntax for an outer join

    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.10.0
    • Fix Version/s: Future
    • Labels:
      None
    • Environment:

      OS: Windows 7 32-bit
      Reporting tools: Crystal Reports 2008, Crystal Reports 2016

      Description

      Referring to section 13.4.3 of JSR-000221, please add support of escape syntax for an outer join.

      e.g.,

      SELECT `A`.`ID`, `B`.`ID`
      FROM   {oj `dfs.tmp`.`A` `A` LEFT OUTER JOIN `dfs.tmp`.`B` `B` ON `A`.`ID`=`B`.`ID`}
      

      Crystal Reports 2008 & 2016 use this escape syntax in their generated SQL statement for generic JDBC / ODBC drivers.

        Attachments

          Activity

            People

            • Assignee:
              priteshm Pritesh Maker
              Reporter:
              second88 second88
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: