Need help in telegraf aggregate plugin (telegraf )
Budget: $10 – $30 USD
when i run jolokia plugin to get metrics about my DB, I get the following results
> cassandra_ThreadPools,host=hostname,jolokia_agent_url=http://1.2.3.4:8778/jolokia,name=ActiveTasks,path=request,scope=CounterMutationStage ActiveTasks_Value=0 1628529367000000000
> cassandra_ThreadPools,host=hostname,jolokia_agent_url=http://1.2.3.4:8778/jolokia,name=MaxPoolSize,path=request,scope=MutationStage MaxPoolSize_Value=32 1628529367000000000
> cassandra_ThreadPools,host=hostname,jolokia_agent_url=http://1.2.3.4:8778/jolokia,name=PendingTasks,path=request,scope=CounterMutationStage PendingTasks_Value=0 1628529367000000000
> cassandra_ThreadPools,host=hostname,jolokia_agent_url=http://1.2.3.4:8778/jolokia,name=CurrentlyBlockedTasks,path=internal,scope=PendingRangeCalculator CurrentlyBlockedTasks_Count=0 1628529367000000000
> cassandra_ThreadPools,host=hostname,jolokia_agent_url=http://1.2.3.4:8778/jolokia,name=PendingTasks,path=internal,scope=MiscStage PendingTasks_Value=0 1628529367000000000
> cassandra_ThreadPools,host=hostname,jolokia_agent_url=http://1.2.3.4:8778/jolokia,name=CurrentlyBlockedTasks,path=transport,scope=Native-Transport-Requests CurrentlyBlockedTasks_Count=0 1628529367000000000
> cassandra_ThreadPools,host=hostname,jolokia_agent_url=http://1.2.3.4:8778/jolokia,name=TotalBlockedTasks,path=internal,scope=Sampler TotalBlockedTasks_Count=0 1628529367000000000
> cassandra_ThreadPools,host=hostname,jolokia_agent_url=http://1.2.3.4:8778/jolokia,name=PendingTasks,path=internal,scope=CompactionExecutor PendingTasks_Value=0 1628529367000000000
> cassandra_CQL,host=hostname,jolokia_agent_url=http://1.2.3.4:8778/jolokia,name=RegularStatementsExecuted RegularStatementsExecuted_Count=393 1628529367000000000
> cassandra_CQL,host=hostname,jolokia_agent_url=http://1.2.3.4:8778/jolokia,name=PreparedStatementsCount PreparedStatementsCount_Value=6 1628529367000000000
> cassandra_CQL,host=hostname,jolokia_agent_url=http://1.2.3.4:8778/jolokia,name=PreparedStatementsExecuted PreparedStatementsExecuted_Count=119446812 1628529367000000000
> cassandra_CQL,host=hostname,jolokia_agent_url=http://1.2.3.4:8778/jolokia,name=PreparedStatementsEvicted PreparedStatementsEvicted_Count=0 1628529367000000000
Can i format the above output and convert it into one line per name like following
cassandra_ThreadPools,host=hostname,jolokia_agent_url=http://1.2.3.4:8778/jolokia,name=PendingTasks,path=internal,scope=CompactionExecutor PendingTasks_Value=0 ,name=MaxPoolSize,path=request,scope=MutationStage MaxPoolSize_Value=32 ,name=PendingTasks,path=request,scope=CounterMutationStage PendingTasks_Value=0 , ....
cassandra_CQL,host=hostname,jolokia_agent_url=http://1.2.3.4:8778/jolokia, name=RegularStatementsExecuted RegularStatementsExecuted_Count=393,name=PreparedStatementsCount PreparedStatementsCount_Value=6 ,name=PreparedStatementsExecuted PreparedStatementsExecuted_Count=119446812,name=PreparedStatementsEvicted PreparedStatementsEvicted_Count=0 1628529367000000000
> cassandra_ThreadPools,host=hostname,jolokia_agent_url=http://1.2.3.4:8778/jolokia,name=ActiveTasks,path=request,scope=CounterMutationStage ActiveTasks_Value=0 1628529367000000000
> cassandra_ThreadPools,host=hostname,jolokia_agent_url=http://1.2.3.4:8778/jolokia,name=MaxPoolSize,path=request,scope=MutationStage MaxPoolSize_Value=32 1628529367000000000
> cassandra_ThreadPools,host=hostname,jolokia_agent_url=http://1.2.3.4:8778/jolokia,name=PendingTasks,path=request,scope=CounterMutationStage PendingTasks_Value=0 1628529367000000000
> cassandra_ThreadPools,host=hostname,jolokia_agent_url=http://1.2.3.4:8778/jolokia,name=CurrentlyBlockedTasks,path=internal,scope=PendingRangeCalculator CurrentlyBlockedTasks_Count=0 1628529367000000000
> cassandra_ThreadPools,host=hostname,jolokia_agent_url=http://1.2.3.4:8778/jolokia,name=PendingTasks,path=internal,scope=MiscStage PendingTasks_Value=0 1628529367000000000
> cassandra_ThreadPools,host=hostname,jolokia_agent_url=http://1.2.3.4:8778/jolokia,name=CurrentlyBlockedTasks,path=transport,scope=Native-Transport-Requests CurrentlyBlockedTasks_Count=0 1628529367000000000
> cassandra_ThreadPools,host=hostname,jolokia_agent_url=http://1.2.3.4:8778/jolokia,name=TotalBlockedTasks,path=internal,scope=Sampler TotalBlockedTasks_Count=0 1628529367000000000
> cassandra_ThreadPools,host=hostname,jolokia_agent_url=http://1.2.3.4:8778/jolokia,name=PendingTasks,path=internal,scope=CompactionExecutor PendingTasks_Value=0 1628529367000000000
> cassandra_CQL,host=hostname,jolokia_agent_url=http://1.2.3.4:8778/jolokia,name=RegularStatementsExecuted RegularStatementsExecuted_Count=393 1628529367000000000
> cassandra_CQL,host=hostname,jolokia_agent_url=http://1.2.3.4:8778/jolokia,name=PreparedStatementsCount PreparedStatementsCount_Value=6 1628529367000000000
> cassandra_CQL,host=hostname,jolokia_agent_url=http://1.2.3.4:8778/jolokia,name=PreparedStatementsExecuted PreparedStatementsExecuted_Count=119446812 1628529367000000000
> cassandra_CQL,host=hostname,jolokia_agent_url=http://1.2.3.4:8778/jolokia,name=PreparedStatementsEvicted PreparedStatementsEvicted_Count=0 1628529367000000000
Can i format the above output and convert it into one line per name like following
cassandra_ThreadPools,host=hostname,jolokia_agent_url=http://1.2.3.4:8778/jolokia,name=PendingTasks,path=internal,scope=CompactionExecutor PendingTasks_Value=0 ,name=MaxPoolSize,path=request,scope=MutationStage MaxPoolSize_Value=32 ,name=PendingTasks,path=request,scope=CounterMutationStage PendingTasks_Value=0 , ....
cassandra_CQL,host=hostname,jolokia_agent_url=http://1.2.3.4:8778/jolokia, name=RegularStatementsExecuted RegularStatementsExecuted_Count=393,name=PreparedStatementsCount PreparedStatementsCount_Value=6 ,name=PreparedStatementsExecuted PreparedStatementsExecuted_Count=119446812,name=PreparedStatementsEvicted PreparedStatementsEvicted_Count=0 1628529367000000000
Related categories:
Scripting