You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Aman Sinha (JIRA)" <ji...@apache.org> on 2015/07/03 06:49:05 UTC
[jira] [Updated] (DRILL-3225) SQL parser seems to ignore specified
[ https://issues.apache.org/jira/browse/DRILL-3225?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Aman Sinha updated DRILL-3225:
------------------------------
Fix Version/s: 1.3.0
> SQL parser seems to ignore specified <fractional seconds precision>
> -------------------------------------------------------------------
>
> Key: DRILL-3225
> URL: https://issues.apache.org/jira/browse/DRILL-3225
> Project: Apache Drill
> Issue Type: Bug
> Components: SQL Parser
> Reporter: Daniel Barclay (Drill)
> Assignee: Sean Hsuan-Yi Chu
> Fix For: 1.3.0
>
>
> Drill's SQL parser and/or type processing seem to ignore the fractional seconds precision value specified in a <fractional seconds precision> for a datetime or interval type.
> In one case, a type descriptor of TIME(5) yields a RelDataType whose getFullTypeString() returns "TIME(0)".
> In another, a type descriptor of "INTERVAL HOUR TO SECOND(3)" yields a RelDataType whose getFullTypeString() returns "INTERVAL HOUR TO SECOND". Additionally, calling .getIntervalQualifier().getFractionalSecondPrecision( DrillRelDataTypeSystem.DRILL_REL_DATATYPE_SYSTEM ) yields 6 (a default value?) instead of 3.
> (This behavior was seen in INFORMATION_SCHEMA code listing data for a view created using casts with the above type descriptors.)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)