AnsweredAssumed Answered

Understanding Drill Error "SYSTEM ERROR: UnsupportedOperationException: Repeated types are not supported."

Question asked by aalvarez on Jun 27, 2016
Latest reply on Jul 6, 2016 by Hao Zhu


Hi,

 

I am having problems creating a Drill table in tsv file format. The error displayed is "UnsupportedOperationException: Repeated types are not supported."

 

Here is a copy paste of the error:

 

0: jdbc:drill:> alter session set `store.format`='tsv';

+-------+------------------------+

| ok  |        summary        |

+-------+------------------------+

| true | store.format updated. |

+-------+------------------------+

 

0: jdbc:drill:> CREATE Table dfs.tmp.json as

. . . . . . . > select *

. . . . . . . > FROM `dfs.default`.`./user/data/clickstream/enriched_files` t;

Error: SYSTEM ERROR: UnsupportedOperationException: Repeated types are not supported.

 

Fragment 1:2

 

[Error Id: 2e91526e-316e-4238-b1e5-c3f0afddd377 on metrics3.corp.maprtech.com:31010] (state=,code=0)

 

 

However, this error does not happen when creating the table in json format.

0: jdbc:drill:> alter session set `store.format`='json';

+-------+------------------------+

| ok  |        summary        |

+-------+------------------------+

| true | store.format updated. |

+-------+------------------------+

 

0: jdbc:drill:> CREATE Table dfs.tmp.json as

. . . . . . . > select *

. . . . . . . > FROM `dfs.default`.`./user/data/clickstream/enriched_files` t

. . . . . . . > ;

+-----------+----------------------------+

| Fragment | Number of records written |

+-----------+----------------------------+

| 1_1      | 55212                     |

| 1_6      | 56699                     |

| 1_2      | 58466                     |

| 1_4      | 58020                     |

| 1_0      | 58170                     |

| 1_5      | 56009                     |

| 1_3      | 56428                     |

+-----------+----------------------------+

 

Unfortunately, I need to create it as a tsv table and not another format. Can anyone guide us to what "SYSTEM ERROR: UnsupportedOperationException: Repeated types are not supported." means and how to solve it?

 

 

Environment description: Drill 1.6 with auth, mapr 5.1.0 on centos 7.2

CC: Rejul James

Outcomes