Apache Pinot

I am trying to run a join between a real time table and dimension table. I am getting an error saying

```select merchantGroupId as mid,
lookUp('merchant_group','name','id',merchantGroupId) as name,
count(*)
from Aggregate_Click
where windowStart&gt;=1659639627000 and windowEnd&lt;=1659726027000
group by mid,name
order by mid,name desc```

My dimension table config :
```{
  "OFFLINE": {
    "tableName": "merchant_group_OFFLINE",
    "tableType": "OFFLINE",
    "segmentsConfig": {
      "schemaName": "merchant_group",
      "replication": "1",
      "replicasPerPartition": "1",
      "segmentPushFrequency": "DAILY",
      "segmentPushType": "REFRESH",
      "minimizeDataMovement": false
    },
    "tenants": {
      "broker": "DefaultTenant",
      "server": "DefaultTenant"
    },
    "tableIndexConfig": {
      "invertedIndexColumns": [],
      "noDictionaryColumns": [],
      "rangeIndexColumns": [],
      "rangeIndexVersion": 2,
      "autoGeneratedInvertedIndex": false,
      "createInvertedIndexDuringSegmentGeneration": false,
      "sortedColumn": [],
      "bloomFilterColumns": [],
      "loadMode": "MMAP",
      "onHeapDictionaryColumns": [],
      "varLengthDictionaryColumns": [],
      "enableDefaultStarTree": false,
      "enableDynamicStarTreeCreation": false,
      "aggregateMetrics": false,
      "nullHandlingEnabled": false,
      "optimizeDictionaryForMetrics": false,
      "noDictionarySizeRatioThreshold": 0
    },
    "metadata": {},
    "quota": {
      "storage": "200M"
    },
    "routing": {},
    "query": {},
    "ingestionConfig": {
      "batchIngestionConfig": {
        "segmentIngestionType": "REFRESH",
        "segmentIngestionFrequency": "DAILY"
      }
    },
    "isDimTable": true
  }
}```

schema :
```{
  "schemaName": "merchant_group",
  "dimensionFieldSpecs": [
    {
      "name": "id",
      "dataType": "LONG"
    },
    {
      "name": "name",
      "dataType": "STRING"
    }
  ],
  "primaryKeyColumns": [
    "id"
  ]
}```

So in my real time table, I have a column `merchantGroupId` and I have an `id` in my dimension table. I wanted to join both tables on that column, but aggregate on the `name` value of the dimension table

Ok..nvm...Not sure if it was intermittent...it started working now.