[DRILL-2767] Fragment error on TPCH Scale Factor 30 on a query that completed successfully previously

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.8.0
• Fix Version/s: Future
• Component/s: Storage - Hive

Environment

AWS EMR cluster of three m1.xlarge nodes

• Flags: Important
• Assignee: Unassigned
• Reporter: Alexander Zarei
• Created: 13/Apr/15 18:24
• Updated: 01/Oct/15 16:37

Description

The following sequence led to the error:

Executed the query

SELECT * FROM `realhive`.`tpch_text_30`.`lineitem`

and it took about 43 minutes to execute successfully.

After ward I ran the query

SELECT * FROM `realhive`.`tpch_text_2`.`lineitem`

for 6 times to find an optimization value for the ODBC driver.

Afterward, I submitted the first query again

SELECT * FROM `realhive`.`tpch_text_30`.`lineitem`

and the Drill Cluster returned a fragment error.

***[HY000]: [MapR][Drill] (1040) Drill failed to execute the query: SELECT * FROM `realhive`.`tpch_text_30`.`lineitem`[30024]Query execution error. Details:[RemoteRpcException: Failure while running fragment.[ fb97e7be-d09e-46fe-8728-9577fd0d8795 on ip-10-12-62-65

Log files with debug level for the Drillbits on the master node as well as the core nodes of the cluster are attached.

Also the connection through the ODBC driver on Linux 32 bit was "Direct" to the drillbit on the master node of the Hadoop cluster.

Issue Links

• links to: Drillbit on the master node log
• links to: second-set-master-node-drillbit.log