All Products
Search
Document Center

Data Lake Analytics - Deprecated:File format conversion methods and considerations

Last Updated:Jul 25, 2019

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...SELECT statement 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...SELECT fails, 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...SELECT is executed.

Examples