Hey All,
i have an issue like i got a table having single partition but in that partition say around 100 200mb files when i overwrite this into other table its make 100 files of 20 mb(compressed) what i want is that it should make only 1 or 2 or 10 file of 200mb or 100mb means after overwrite its should make less no of file as compare to non compressed. -- With Regards Vikas Srivastava DWH & Analytics Team Mob:+91 9560885900 One97 | Let's get talking !