Hi,
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” .
Thanks,
Dalai
Hi,
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” .
Thanks,
Dalai
@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.