[jira] [Created] (DRILL-1010) Query throws exception after displaying result

["Abhishek Girish (JIRA)" <ji...@apache.org>]

Abhishek Girish created DRILL-1010:
--------------------------------------

             Summary: Query throws exception after displaying result
                 Key: DRILL-1010
                 URL: https://issues.apache.org/jira/browse/DRILL-1010
             Project: Apache Drill
          Issue Type: Bug
          Components: Storage - Parquet
            Reporter: Abhishek Girish


This issue was observed with TPC-DS dataset. After displaying results, the query seems to fail with exceptions. 

Query:
select * from item limit 10;

Result:
<Outputs 10 rows>
Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "bf83170d-b644-4145-b99c-377d60e342e4"
endpoint {
  address: "drillats2.qa.lab"
  user_port: 31010
  control_port: 31011
  data_port: 31012
}
error_type: 0
message: "Failure while running fragment. < ArrayIndexOutOfBoundsException"
]
java.lang.RuntimeException: java.sql.SQLException: Failure while trying to get next result batch.
	at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2514)
	at sqlline.SqlLine$TableOutputFormat.print(SqlLine.java:2148)
	at sqlline.SqlLine.print(SqlLine.java:1809)
	at sqlline.SqlLine$Commands.execute(SqlLine.java:3766)
	at sqlline.SqlLine$Commands.sql(SqlLine.java:3663)
	at sqlline.SqlLine.dispatch(SqlLine.java:889)
	at sqlline.SqlLine.begin(SqlLine.java:763)
	at sqlline.SqlLine.start(SqlLine.java:498)
	at sqlline.SqlLine.main(SqlLine.java:460)

Log:
2014-06-12 00:38:14,654 [4aadf551-2bd6-42b5-a236-fa2e088c0af0:frag:0:0] DEBUG o.a.d.e.w.fragment.FragmentExecutor - Caught exception while running fragment
java.lang.ArrayIndexOutOfBoundsException: null
2014-06-12 00:38:14,655 [4aadf551-2bd6-42b5-a236-fa2e088c0af0:frag:0:0] ERROR o.a.d.e.w.f.AbstractStatusReporter - Error 67e30181-bcb9-4cde-bdcd-dcab2b44d28a: Failure while running fragment.
java.lang.ArrayIndexOutOfBoundsException: null
2014-06-12 00:38:14,656 [4aadf551-2bd6-42b5-a236-fa2e088c0af0:frag:0:0] DEBUG o.a.d.exec.work.foreman.QueryManager - New fragment status was provided to Foreman of profile {
  state: FAILED
  error {
    error_id: "67e30181-bcb9-4cde-bdcd-dcab2b44d28a"
    endpoint {
      address: "drillats2.qa.lab"
      user_port: 31010
      control_port: 31011
      data_port: 31012
    }
    error_type: 0
    message: "Failure while running fragment. < ArrayIndexOutOfBoundsException"
  }
  operator_profile {
    input_profile {
      records: 0
      batches: 0
      schemas: 0
    }
    operator_id: 3
    operator_type: 21
    setup_nanos: 0
    process_nanos: 0
  }
  operator_profile {
    input_profile {
      records: 8191
      batches: 1
      schemas: 1
    }
    operator_id: 2
    operator_type: 7
    setup_nanos: 186912
    process_nanos: 176768368
  }
  operator_profile {
    input_profile {
      records: 10
      batches: 1
      schemas: 1
    }
    operator_id: 1
    operator_type: 14
    setup_nanos: 110173355
    process_nanos: 182528775
  }
  start_time: 1402533494300
  end_time: 1402533494655
  memory_used: 53641636
}
handle {
  query_id {
    part1: 5381226858754228917
    part2: -6757939115204015376
  }
  major_fragment_id: 0
  minor_fragment_id: 0
}

2014-06-12 00:38:14,674 [WorkManager-8] WARN  o.a.d.e.w.fragment.FragmentExecutor - Failure while closing context in failed state.





--
This message was sent by Atlassian JIRA
(v6.2#6252)