I have to create a hive partitioned table but it is running beyond physical memory limits. Is there a way to handle this issue . I cant change container memory neither use less data from source. Will temporary tables help here i.e. creating 12 temp tables for 12 months and then feeding them to the partition table. But I dont know how to achieve this.
Thanks in advance.