Conversion method
Create two tables in DLA, and run INSERT INTO target_table SELECT FROM source_table to write the data into OSS in the specified format.
Considerations
The
INSERT...SELECTstatement does not overwrite the existing files in the OSS target directory. Instead, it generates new files in the OSS target directory.You are not allowed to delete OSS buckets in DLA. If the execution of
INSERT...SELECTfails, you need to manually delete the files created in the OSS target directory.The number of files created in the OSS target directory varies according to the cluster environment where
INSERT...SELECTis executed.