[DRILL-2461] INFORMATION_SCHEMA's COLUMNS dies when INTERVAL ... column exists

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Not A Problem
• Fix Version/s: 0.9.0
• Component/s: Metadata
• Assignee: Pritesh Maker
• Reporter: Daniel Barclay
• Created: 14/Mar/15 18:07
• Updated: 03/Jan/19 23:44
• Resolved: 03/Jan/19 23:44

Description

The implementation of INFORMATION_SCHEMA.COLUMNS fails (aborts) when there is a column of an INTERVAL type:

0: jdbc:drill:zk=local> USE dfs.tmp;
...
0: jdbc:drill:zk=local> CREATE OR REPLACE VIEW TempView AS SELECT CAST( NULL AS INTERVAL HOUR ) FROM INFORMATION_SCHEMA.CATALOGS LIMIT 1 ;
----------------------+

ok

summary

----------------------+

true	View 'TempView' replaced successfully in 'dfs.tmp' schema

----------------------+
1 row selected (0.062 seconds)
0: jdbc:drill:zk=local> SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'TempView';
Query failed: RemoteRpcException: Failure while running fragment., use createSqlIntervalType() instead [ 04edd8aa-74ee-4717-a633-523cba5a3613 on dev-linux2:31010 ]
[ 04edd8aa-74ee-4717-a633-523cba5a3613 on dev-linux2:31010 ]

Error: exception while executing query: Failure while executing query. (state=,code=0)
0: jdbc:drill:zk=local>

Issue Links

• blocks: DRILL-2465 Fix multiple DatabaseMetaData.getColumns() bugs (some)