hello everyone, i see the queries are not returning any response if i add any UDF's in the query specifically on time. like this is the example query below

select SUM(total_run_time) from events where user_id = 'XXXXX' GROUP BY TIMECONVERT(time,'SECONDS','HOURS')

here is my table config

{
  "OFFLINE": {
    "tableName": "events_OFFLINE",
    "tableType": "OFFLINE",
    "segmentsConfig": {
      "timeType": "SECONDS",
      "timeColumnName": "time",
      "replication": "1"
    },
    "tenants": {
      "broker": "DefaultTenant",
      "server": "DefaultTenant"
    },
    "tableIndexConfig": {
      "autoGeneratedInvertedIndex": false,
      "createInvertedIndexDuringSegmentGeneration": false,
      "loadMode": "MMAP",
      "enableDefaultStarTree": true,
      "enableDynamicStarTreeCreation": false,
      "aggregateMetrics": true,
      "nullHandlingEnabled": false
    },
    "metadata": {},
    "ingestionConfig": {
      "batchIngestionConfig": {
        "segmentIngestionType": "APPEND",
        "segmentIngestionFrequency": "DAILY"
      }
    },
    "isDimTable": false
  }
}

i'm actually trying out with less number of records of 0.5million and its has 1 metrics and 1 time stamp and 5 dimensions. please let me know, is there any change that needs to be done in the table config to make the queries run faster. Thanks

Is the query timed out? Can you please check the raw json response and see if there is any exception?

yea. it worked. i have tried the setting

time

in single quotes and it throws me an exception.

@User Can we flag this as an error instead of timing out?

@User This is already an error, but the query console is not able to handle the response properly

Ok great, thanks @User