Select statement returns no data after CTAS statement


I’ve created table (CTAS) from data of S3(Minio). When I count the records of the newly created table right after creating it, it returns 0 or some of it(not full data).

But few hours later it returns correct row counts. Is it normal ? How can i access full data immediately after CTAS operation?

Thanks, Dalai

@Dalai Can you please send us the below 3 job profiles

  • CTAS job
  • count that returned zero records
  • count that returned correct records