Just had a question, I am trying to create a table in druid which has a union all query, however it is not inserting complete recoreds, just inserting the result of top query, can anyone give suggestions??

Hi Pratush, in general the ingestion job that creates a new table should use whatever data is coming out of the "select" part of the job. So first run the select query to the console, that is the data that should be ingested into the new table. If you think something else is going on, then please share your ingestion spec so we can take a look. Thanks. John

Which version of Druid are you on @pratush maheshwari? This is a bug in the older versions of Druid where the UNION query with MSQ only returns a subset of the records. Queries like these have been disallowed in the later versions, along with adding support for some other type of unions.

I am using 25.0 @Laksh Singla