drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel Barclay (Drill) (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-3225) SQL parser seems to ignore specified <fractional seconds precision>
Date Tue, 02 Jun 2015 19:09:49 GMT

     [ https://issues.apache.org/jira/browse/DRILL-3225?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Daniel Barclay (Drill) updated DRILL-3225:
------------------------------------------
    Description: 
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.)




  was:
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 ) yield 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.)





> 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: Aman Sinha
>
> 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)

Mime
View raw message