Concatenate and rename

[deepthree]

Hello

I want to concatenante two table and I used the script like this :

LOAD a, b, c from table1.csv;

concatenate LOAD a, c from table2,csv;

But how rename the concatenated table as "my_final_table" ?

[Taoufiq_Zarra · Accepted solution]

Input :

LOAD a, b, c from table1.csv;

concatenate LOAD a, c from table2,csv;

Rename Table Input to my_final_table;