[DRILL-5268] SYSTEM ERROR: UnsupportedOperationException: Unable to get size for minor type [MAP] and mode [REQUIRED]

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.10.0
• Fix Version/s: 1.12.0
• Component/s: Storage - Parquet
• Assignee: Paul Rogers
• Reporter: Rahul Kumar Challapalli
• Created: 15/Feb/17 18:07
• Updated: 18/Aug/17 00:41
• Resolved: 18/Aug/17 00:41

Description

git.commit.id.abbrev=300e934

With the managed external sort turned on, I get the below error

alter session set `planner.width.max_per_node` = 1;
alter session set `planner.disable_exchanges` = true;
alter session set `planner.memory.max_query_memory_per_node` = 52428800;
select * from (select d1.type, d1.evnt, d1.transaction from (select d.type type, flatten(d.events) evnt, flatten(d.transactions) transaction from dfs.`/drill/testdata/resource-manager/100000rows/data.json` d) d1 order by d1.evnt.event_time, d1.transaction.trans_time) d2 where d2.type='web' and d2.evnt.evnt_type = 'cmpgn4';
Error: SYSTEM ERROR: UnsupportedOperationException: Unable to get size for minor type [MAP] and mode [REQUIRED]

Fragment 0:0

[Error Id: a9dc1de5-2ff7-44db-bdd2-b166b1f0cea8 on qa-node183.qa.lab:31010] (state=,code=0)

If we do not enable the managed sort, then we end up with DRILL-5234

Issue Links

• is related to: DRILL-5234 External sort's spilling functionality does not work when the spilled columns contains a map type column