4 Replies Latest reply: Jan 20, 2012 9:56 PM by Elias Ross RSS

MeasurementFacet; can query take > 5 minutes?

Elias Ross Master

I am querying Hadoop using Hive and trying to return back data from a SELECT statement as a series of measurements.

 

The select can take quite a long time, especially if the cluster is busy.

 

I was thinking of using the 'org.rhq.plugins.database.CustomTableComponent' to perform the query, but the query may not be appropriate for the 'getValues' method. Is there a suggested approach?

 

One would be to adjust the database plugin to store the results of the query in a separate timer thread. This could be enabled or disabled by configuration. Should I make this change to the database plugin?

 

Thoughts?