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 13:23:00 UTC
[jira] [Created] (DRILL-5647) Drill pushes timestamp to SQL Server
using the wrong data type
N Campbell created DRILL-5647:
---------------------------------
Summary: Drill pushes timestamp to SQL Server using the wrong data type
Key: DRILL-5647
URL: https://issues.apache.org/jira/browse/DRILL-5647
Project: Apache Drill
Issue Type: Bug
Components: Server
Affects Versions: 1.10.0
Environment: Drill 1.10
SQL Server 2016
Reporter: N Campbell
SQL Server timestamp data type is not a timestamp per ISO-SQL
https://docs.microsoft.com/en-us/sql/t-sql/data-types/rowversion-transact-sql
Hence, a statement such as
select cast( '2000-12-31 12:00:00.000' as timestamp ) from plugin.schema.table
will fail due to the following syntax error
DATA_READ ERROR: The JDBC storage plugin failed while trying setup the SQL query.
SELECT CAST('2000-12-31 12:00:00.000' AS TIMESTAMP(0)) AS "EXPR$0"
FROM "dbo"."TVERSION"
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)