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

Reply via email to