This message was deleted.

Hi @anoop kumar - you would need to reindex the datasource https://druid.apache.org/docs/latest/multi-stage-query/examples#insert-for-reindexing-an-existing-datasource

Sample MSQ query:

INSERT INTO TEST_Data2
SELECT
  FLOOR(__time TO MINUTE) AS __time,
  ID as ID1,
  NAME,
  QUANTITY
FROM TEST_Data
GROUP BY 1, 2, 3, 4
PARTITIONED BY HOUR

thanks