Hi everyone,
Can anyone help how to write CTAS query with storage format as CSV without
giving the "Repeated types are not supported" Exception.
If i am using any other storage format like JSON or PARQUET,its working
fine but i have to use CSV format.
*Saw similar JIRA bug : https://issues.apache.org/jira/browse/DRILL-1954
<https://issues.apache.org/jira/browse/DRILL-1954>*
but its still in open state.
I have a query like :
alter session set `store.format`='csv';
CREATE TABLE dfs.csvlogs.`jobId` AS SELECT * FROM
dfs.parquetlogs.`parquetlogs` ;
*Getting exception :*
0: jdbc:drill:zk=local> CREATE TABLE dfs.csvlogs.`jobId` AS SELECT * FROM
dfs.parquetlogs.`parquetlogs` where dir0>'20150928';
Error: SYSTEM ERROR: UnsupportedOperationException: Repeated types are not
supported.
Fragment 1:1
[Error Id: 8da5886d-72f5-4801-891b-fcb5d0f1bbf0 on chandans-mbp:31010]
(java.lang.UnsupportedOperationException) Repeated types are not
supported.
org.apache.drill.exec.store.StringOutputRecordWriter$RepeatedVarCharStringFieldConverter.writeField():1560
org.apache.drill.exec.store.EventBasedRecordWriter.write():61
org.apache.drill.exec.physical.impl.WriterRecordBatch.innerNext():106
org.apache.drill.exec.record.AbstractRecordBatch.next():147
org.apache.drill.exec.physical.impl.BaseRootExec.next():83
org.apache.drill.exec.physical.impl.SingleSenderCreator$SingleSenderRootExec.innerNext():93
org.apache.drill.exec.physical.impl.BaseRootExec.next():73
--
Chandan Prakash