[DRILL-1356] Query fails with null error when Planner Slice Target is set to below 1000

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: Future
• Component/s: Query Planning & Optimization
• Assignee: Unassigned
• Reporter: Abhishek Girish
• Created: 29/Aug/14 01:09
• Updated: 01/Oct/15 16:37

Description

Queries: TPCH on HBase(MapR-DB)
Scale Factor: 100

On setting planner.slice_target to 1 (or any value less than 1000), queries involving SF100 tables fail with null error:

Query failed: Failure while setting up query. null [6866917f-6fd3-4a29-89b0-efff0732c7dd]

Error: exception while executing query: Failure while trying to get next result batch. (state=,code=0)
0: jdbc:drill:zk=10.10.103.32:5181> alter session set `planner.slice_target` =100;

LOG is attached.

The same query executes successfully when

• involves SF 1 tables
  or
• planner.slice_target is set to a higher value.

Without setting the discussed parameter, SF100 queries take longer than usual to execute.