[DRILL-4367] JDBC DatabaseMetadata.getColumns returns a single column named *

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.4.0
• Component/s: Client - JDBC
• Assignee: Unassigned
• Reporter: N Campbell
• Created: 08/Feb/16 12:19
• Updated: 08/Feb/16 12:19

Description

Calling DatabaseMedata.getColumns for a VIEW returns a single row of metadata for a column named * with a type ANY etc. instead of an expected projection list of the object T.

Applications which expect to harvest metadata from the driver will not get an expected description of the projection list.

create table TBOOL as
select columns[0] as RNUM, case when columns[1] = '\N' then cast ( null as BOOLEAN) else columns[1] end as CBOOL from `dfs`.`CERTINPUTS`.`./TBOOL.tbl`
;
create view VBOOL as select * from TBOOL;