Rename the CTAS result files


Is it possible to change name of files while creating table using CTAS? I want to change name of parquet files “0_0_1.parquet” to some thing link this “my_table_name_0_0_1.parquet” or “prefix_0_0_1.parquet” .


@Dalai Unfortunately no,

Hi @Dalai ,
for text, json and parquet formats, you can change the file extension :

create table "external".test store as (type=>'text', outputExtension=>'my_file_extension') as select 1 as id, 'toto' as name

ending with something like 0_0_1.my_file_extension.

But there is a problem : an error will prevent you from dropping nor selecting from the dataset.