receiver/sqlqueryreceiver:

[Huy-072025]

Hi community

I'm a newbie to these topic and therefore excuse me, if my wording didn't match.

https://github.com/open-telemetry/opentelemetry-collector-contrib/tree/main/receiver/sqlqueryreceiver

Currently I'm trying to execute a sql query to an oracle db.

According to the documentation the query must look like:

  - sql: "select count(*) as count, genre from movie group by genre"
    metrics:
      - metric_name: movie.genres
        value_column: "count"

And value_column is required.

My issue/challenge is that my value_column is a String := [A-Z][A-Z][A-Z][A-Z][A-Z]-[0-9][0-9][0-9][0-9][0-9] --> APPD-123456
and "value_column" is of type integer.

I get the error message:
...
invalid syntax\nrow 2981: rowToMetric: setDataPointValue: col "appd": error converting to integer: strconv.Atoi: parsing "APPD-04181": invalid syntax\nrow 2982: rowToMetric: setDataPointValue: col "appd": error converting to integer: strconv.Atoi: parsing "APPD-32907": invalid syntax"}
...

Now my question.

Howto modify "value_column" to accept String?

Thanks and regards
Huy

[Huy-072025]

Got solution.