[jira] [Resolved] (DRILL-1501) Querying 'COLUMNS' AND 'CATALOGS' from INFORMATION_SCHEMA fails with some sort of formatting exception

["Mehant Baid (JIRA)" <ji...@apache.org>]

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

Mehant Baid resolved DRILL-1501.
--------------------------------
    Resolution: Fixed

Seems to be working as expected.

> Querying 'COLUMNS' AND 'CATALOGS' from INFORMATION_SCHEMA fails with some sort of formatting exception
> ------------------------------------------------------------------------------------------------------
>
>                 Key: DRILL-1501
>                 URL: https://issues.apache.org/jira/browse/DRILL-1501
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Metadata
>            Reporter: Rahul Challapalli
>            Assignee: Mehant Baid
>            Priority: Minor
>             Fix For: 0.9.0
>
>         Attachments: error.txt
>
>
> git.commit.id.abbrev=29dde76
> Querying 'COLUMNS' and 'CATALOGS' tables from INFORMATION_SCHEMA fails
> {code}
> 0: jdbc:drill:schema=dfs.drillTestDirViews> select * from INFORMATION_SCHEMA.`COLUMNS`;
> Query failed: Failure while running fragment. Error: ',', ':', or ';' expected at position 7 from 'decimal(10,0)' [0:decimal, 7:(, 8:10, 10:,, 11:0, 12:)] [54759aa7-1652-4efd-8520-8cad8d3b9899]
> Error: exception while executing query: Failure while trying to get next result batch. (state=,code=0)
> {code}
> Other table in INFORMATION_SCHEMA like 'TABLES', 'VIEWS', and 'SCHEMATA' work fine.
> Attached the error log



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)