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

Posted to dev@drill.apache.org by "N Campbell (JIRA)" <ji...@apache.org> on 2017/07/01 16:16:04 UTC

[jira] [Created] (DRILL-5655) Drill returns a VARCHAR when DATE projected by query sent to SQL Server

N Campbell created DRILL-5655:
---------------------------------

             Summary: Drill returns a VARCHAR when DATE projected by query sent to SQL Server
                 Key: DRILL-5655
                 URL: https://issues.apache.org/jira/browse/DRILL-5655
             Project: Apache Drill
          Issue Type: Bug
          Components:  Server
    Affects Versions: 1.10.0
         Environment: Drill 1.10
SQL Server 2016
            Reporter: N Campbell


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



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