[jira] [Resolved] (DRILL-2519) INFORMATION_SCHEMA.COLUMNS is missing info

["Daniel Barclay (Drill) (JIRA)" <ji...@apache.org>]

     [ 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)