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

Drill returns a VARCHAR when DATE projected by query sent to SQL Server

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 1.10.0
    • None
    • Storage - JDBC
    • None

    • Drill 1.10
      SQL Server 2016

    Description

      A query which projects a DATE literal will return a VARCHAR(65k) if query uses SQL Server.

      If the query uses a Parquet file a DATE type is returned via JDBC
      If the query uses ORACLE a TIMESTAMP type is returned via JDBC

      select DATE '1996-01-01' from x.y.TVERSION

      Attachments

        Activity

          People

            Unassigned Unassigned
            the6campbells N Campbell
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: