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

Drill pushing invalid SQL to ORACLE when CAST( date as varchar) used

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.10.0
    • Fix Version/s: None
    • Component/s: Server
    • Labels:
      None
    • Environment:

      Drill 1.10
      ORACLE 12C2

      Description

      plugin to ORACLE via JDBC defined

      Following statement sent to Drill
      select TDT.RNUM, cast(TDT.CDT as varchar(10)) from certora.DBCERT.TDT

      DATA_READ ERROR: The JDBC storage plugin failed while trying setup the SQL query.

      sql SELECT "RNUM", CAST("CDT" AS VARCHAR(10) CHARACTER SET "ISO-8859-1") "EXPR$1" FROM "DBCERT"."TDT"

      ORACLE DDL
      CREATE TABLE "DBCERT"."TDT"
      ( "RNUM" NUMBER,
      "CDT" DATE
      ) ;

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              the6campbells N Campbell
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: