Cannot query converted field from a tag by itself

Telegraf
,
1

Hi,

Need help.

I used [[processors.converter]] plugin to convert tag to field.
Tag = Core_Count now added as a field Core_Count_1.

Converter_Config_Example_2
Converter_Config_Example_2630×600 12.7 KB

But i cannot query Core_Count_1 by itself.
Example:
Following query does not return anything
SELECT “Core_Count_1” FROM “influxdb”.“autogen”.“Processor_2” WHERE time > :dashboardTime:
But below query works
SELECT * FROM “influxdb”.“autogen”.“Processor_2” WHERE time > :dashboardTime:

2

Hello @Ashish_Sikarwar,
Thanks for your question. Can you please share the outputs from your two queries? Also, can you please share a line protocol example of what your data looked like before using the plugin? Thanks.

3

Hello @Anaisdg,

Thank you for your response.

I have changed the measurement from Processor to Process.

Telegraf.conf:
Processes_Core_Count was added as a tag in telegraf config later converted to a field.

image
image1221×703 21.8 KB

I could query it using Kapacitor tickscript see Output_1:

Output_1

image
image1516×669 135 KB

Output_2
See column: Process_1.CPU_TIME is blank when queried in Chronograf

image
image1514×515 46.8 KB

Output_2.2
when queried with * it works

image
image1527×326 37.2 KB

Output_3
Queried in Grafana, same issue

image
image1576×610 48.1 KB

Output_4
see how it was once a tag and not since converted to a field showed up under fields

image
image1510×277 30.9 KB

Line Protocol before using Processors.converter plugin:

> Process_1,Processes_Core_Count=8,host=A700459-W10,instance=LMS,objectname=Process Handle_Count=421,Percent_Processor_Time=0,Private_Bytes=6303744,Thread_Count=6,Virtual_Bytes=79503360,Working_Set=13185024 1578571319000000000
> Process_1,Processes_Core_Count=8,host=A700459-W10,instance=PelElvDm,objectname=Process Handle_Count=131,Percent_Processor_Time=0,Private_Bytes=1695744,Thread_Count=1,Virtual_Bytes=4402032640,Working_Set=6586368 1578571319000000000
> Process_1,Processes_Core_Count=8,host=A700459-W10,instance=RuntimeBroker,objectname=Process Handle_Count=466,Percent_Processor_Time=0,Private_Bytes=7933952,Thread_Count=7,Virtual_Bytes=2203528724480,Working_Set=31768576 1578571319000000000
> Process_1,Processes_Core_Count=8,host=A700459-W10,instance=notepad++,objectname=Process Handle_Count=286,Percent_Processor_Time=0,Private_Bytes=70451200,Thread_Count=4,Virtual_Bytes=4588154880,Working_Set=38051840 1578571319000000000

Thanks
Ashish

4

It seems to be a syntactical problem.

5

@Anaisdg
I am able to query after removing GROUP BY time($__interval) :smile:
SELECT “Percent_Processor_Time”/“Processes_Core_Count” As CPU_Time FROM “Process_1” WHERE (“instance” = ‘_Total’) AND $timeFilter