Converting and SQL statement into a PMIE rule for evaluation against pmlogger archives

[Shirshendu Chakrabarti <shirshendu@xxxxxxx>]

Hi PCP Team,

Is there any way where we can translate a SQL query into a pmie rule which can be evaluated against a live stream of metrics data or against some pmlogger created archive.

An example of what I am trying to achieve:

SQL statement:

select attribute_1, attribute_2 from table where attribute_1 = 'some_val1' and attribute_2 = 'some_val2' group by 'attribute_1';

equivalent metrics, that need to be processed:

<appname>.<table>.<attribute_1>

<appname>.<table>.<attribute_2>

probable pmie rule:

result = some_inst (

               $<appname>.<table>.<attribute_1>Â= 'some_val1' &&

               $<appname>.<table>.<attribute_1>Â= 'some_val2'

) -> alarm "some message" "%i ";

The intended audience for this use-case is business users and analysts with basic SQL skill set.

Thanks,

Shirshendu Chakrabarti