Also one thing i noticed when i converted the dist_total_revenue to float during ingestion and then calculated the percentage without using the CAST is that float data type is taking more time to execute the query.