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

["Chris Westin (JIRA)" <ji...@apache.org>]

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

Chris Westin updated DRILL-2519:
--------------------------------
    Affects Version/s: 0.8.0

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