Trafodion

select count(*) from hive table hangs

Bug #1436333 reported by khaled Bouaziz
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Trafodion
Invalid
High
Sandhya Sundaresan
Trafodion r1.1

Bug Description

when running hive/test018, "select count(*) from hive.hive.store_sales;" hangs on the jenkins machine preventing the test from completing.
hive.hive.store_sales get created and populated when instralling hadoop using install_local_hadoop script

this bug maybe related to:
- LP 1329361 select on hive table hanging via dcs
- LP 1339912 select count(*)from hive table may result in MXOSRVR core

Tags: sql-exe
Revision history for this message
Sandhya Sundaresan (sandhya-sundaresan) wrote :

This seems related to the Region Server going down due to very high memory usage during the select count(*) on Cloudera Jenkins VMs. Investigation is in progress.

Changed in trafodion:
assignee: nobody → Sandhya Sundaresan (sandhya-sundaresan)
status: New → In Progress
milestone: none → r1.1
Revision history for this message
Sandhya Sundaresan (sandhya-sundaresan) wrote :

This issue happened because the Region Server went down during the hive select since it was aunable to performa the count(*).
We have fixed the cuase of the RS going down. The hang will be addresed by:
 LP1442483 SQL queries hang when Region Server goes down

Changed in trafodion:
status: In Progress → Invalid
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.