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

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 0.9.0
• Component/s: Metadata
• Assignee: Mehant Baid
• Reporter: Rahul Kumar Challapalli
• Created: 07/Oct/14 00:23
• Updated: 09/Apr/15 21:52
• Resolved: 09/Apr/15 21:52

Description

git.commit.id.abbrev=29dde76

Querying 'COLUMNS' and 'CATALOGS' tables from INFORMATION_SCHEMA fails

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)

Other table in INFORMATION_SCHEMA like 'TABLES', 'VIEWS', and 'SCHEMATA' work fine.

Attached the error log