[ https://issues.apache.org/jira/browse/DRILL-2461?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jacques Nadeau updated DRILL-2461: ---------------------------------- Fix Version/s: 0.9.0 > INFORMATION_SCHEMA's COLUMNS dies when INTERVAL ... column exists > ----------------------------------------------------------------- > > Key: DRILL-2461 > URL: https://issues.apache.org/jira/browse/DRILL-2461 > Project: Apache Drill > Issue Type: Bug > Components: Metadata > Reporter: Daniel Barclay (Drill) > Assignee: Sudheesh Katkam > Fix For: 0.9.0 > > > 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> -- This message was sent by Atlassian JIRA (v6.3.4#6332)