[DRILL-5784] SYSTEM ERROR: IndexOutOfBoundsException: index: 512, length: 4 (expected: range(0, 512))

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved

Environment

planner.slice_target > 100000
planner.enable_nljoin_for_scalar_only = false

• Assignee: Unassigned
• Reporter: Vlad Rozov
• Created: 13/Sep/17 00:12
• Updated: 31/Aug/18 18:37

Description

The following query causes IndexOutOfBoundsException:

SELECT 
  `t1`.`one` `one` 
FROM 
  (
    SELECT 
      1 `one` 
    FROM 
      dfs.`<path to drill>/drill/exec/java-exec/src/test/resources/join/j1`
      INNER JOIN (
        SELECT 
          314 `c_integer` 
        FROM 
          dfs.`<path to drill>/drill/exec/java-exec/src/test/resources/join/j1`
      ) `t0` ON (
        `<path to drill>/drill/exec/java-exec/src/test/resources/join/j1`.c_integer IS NOT DISTINCT 
        FROM 
          `t0`.`c_integer`
      ) 
    GROUP BY 
      `one`
  ) `t1` 
  INNER JOIN (
    SELECT 
      count(1) `measure` 
    FROM 
      dfs.`<path to drill>/drill/exec/java-exec/src/test/resources/join/j1`
  ) `t5` ON TRUE

Issue Links

• is related to: DRILL-5269 SYSTEM ERROR: JsonMappingException: No suitable constructor found for type [simple type, class org.apache.drill.exec.store.direct.DirectSubScan]