[
https://issues.apache.org/jira/browse/DRILL-2519?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Daniel Barclay (Drill) resolved DRILL-2519.
-------------------------------------------
Resolution: Fixed
Resolved because superseded by DRILL-3216 (whose changes cover DRILL-2519's
missing data and which is actively in progress).
> INFORMATION_SCHEMA.COLUMNS is missing <interval_qualifier> info
> ---------------------------------------------------------------
>
> Key: DRILL-2519
> URL: https://issues.apache.org/jira/browse/DRILL-2519
> Project: Apache Drill
> Issue Type: Bug
> Components: Metadata
> Affects Versions: 0.8.0
> Reporter: Daniel Barclay (Drill)
> Assignee: Daniel Barclay (Drill)
> Fix For: 1.2.0
>
>
> The INFORMATION_SCHEMA.COLUMNS table does not have all data from the
> <interval_qualifier> of an INTERVAL type descriptor.
> In particular, it does not have enough information to implement
> DatabaseMetaData.getColumns()'s COLUMN_SIZE or DECIMAL_DIGITS columns for
> INTERVAL types.
> 1. It does not have the starting and ending units, so we can't distinguish
> between INTERVAL HOUR TO MINUTE and INTERVAL HOUR TO SECOND--which have
> different lengths (COLUMN_SIZE) because their string representations have
> different fields.
> 2. It does not have the fractional seconds precision.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)