[DRILL-1954] Update CSV Writer to treat a single RepeatedVarChar column as separate columns on output rather than Erroring

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.6.0, 0.7.0
• Fix Version/s: Future
• Component/s: Storage - Text & CSV
• Assignee: Paul Rogers
• Reporter: Cary Greenwood
• Created: 07/Jan/15 23:40
• Updated: 19/Jun/17 00:23

Description

I am experiencing this error when attempting to create a table. When the same query is executed using SELECT * the results display fine.

0: jdbc:drill:zk=local> CREATE TABLE fcc_cell AS select * from dfs.`/Users/Documents/fcc/fcc_lic_vw.csv` WHERE columns[10] IN ('"Mobile/Fixed Broadband"', '"Fixed Wireless"') AND columns[17] = '"A"';
Query failed: Query stopped., Repeated types are not supported. [ cd76d8fd-b00e-47d5-962c-6566381b17fb on 192.168.1.4:31010 ]

Error: exception while executing query: Failure while executing query. (state=,code=0)

Issue Links

• is duplicated by: DRILL-2727 CTAS select * from CSV file results in Exception