Hi Team, I am currently playing with signoz dashboards on a self hosted env(version 0.46.0), First of all very good tool so far, a lot of effort has gone into the tool as seen by the features, now while i was trying to create a panel of type table, for some reason i am unable to get certain columns in the table, the query works directly in clickhouse but on signoz dashboard it leaves certain columns from the output. attaching the CH query i am using and a SS showing the issue. TIA!

SELECT
    name as table_name, database, ((total_bytes/1024)/1024) as value
FROM system.tables
ORDER BY value DESC

Do you see any errors in query-service logs?

actually yes when i checked now, getting this log repeatedly for 5,6 times when my query is executed.

{
  "level": "ERROR",
  "timestamp": "2024-06-20T17:31:21.968Z",
  "caller": "clickhouseReader/reader.go:4543",
  "msg": "unsupported var type found in query builder query result",
  "v": 124.10833358764648,
  "colName": "value",
  "stacktrace": "<http://go.signoz.io/signoz/pkg/query-service/app/clickhouseReader.readRow|go.signoz.io/signoz/pkg/query-service/app/clickhouseReader.readRow>\n\t/home/runner/work/signoz/signoz/pkg/query-service/app/clickhouseReader/reader.go:4543\ngo.signoz.io/signoz/pkg/query-service/app/clickhouseReader.readRowsForTimeSeriesResult\n\t/home/runner/work/signoz/signoz/pkg/query-service/app/clickhouseReader/reader.go:4584\ngo.signoz.io/signoz/pkg/query-service/app/clickhouseReader.(*ClickHouseReader).GetTimeSeriesResultV3\n\t/home/runner/work/signoz/signoz/pkg/query-service/app/clickhouseReader/reader.go:4660\ngo.signoz.io/signoz/pkg/query-service/app/querier/v2.(*querier).execClickHouseQuery\n\t/home/runner/work/signoz/signoz/pkg/query-service/app/querier/v2/querier.go:95\ngo.signoz.io/signoz/pkg/query-service/app/querier/v2.(*querier).runClickHouseQueries.func1\n\t/home/runner/work/signoz/signoz/pkg/query-service/app/querier/v2/querier.go:420"
}

Strange error. Seems like some double pointer type is returned. The work around I can suggest is to type cast the value to string and check.

hey casting to string worked, thank you for the suggestion,I don't know in depth of the clickhouse nor signoz to comment on the error so i will that to your skilful hands. Thanks a lot!

Can you create an issue here https://github.com/SigNoz/signoz

sure created here: https://github.com/SigNoz/signoz/issues/5298