I want to load data from a hive table linking to HDFS location into a hive table linking to S3 location. But it took really long time. Below is the SQL statement. Can anyone give some tips for optimising the performance? Thank you very much!
insert overwrite table inventory_10 partition(inv_date_sk) select * from tpcds_bin_partitioned_orc_10.inventory;
# inventory_10 links to S3 location
# tpcds_bin_partitioned_orc_10.inventory links to HDFS location