Is it possible (using either pyflink or sql) to se...
# troubleshootinga
Ari Huttunen
01/25/2023, 1:44 PMIs it possible (using either pyflink or sql) to select all columns except columns "a", "b", and "c"?
Or rather, I would like to select all columns and create a couple of calculated columns "d" and "e".
As there are a lot of columns, I'd prefer not to explicitly list all columns.
j
Jeremy Ber
01/26/2023, 3:41 PMcould you create a temporary table in memory then drop the specific columns you want to exclude, then select * from temp_table?
Jeremy Ber
01/26/2023, 3:45 PM Copy code
insert into temp_table
select * from table_with_lots_of_columns; Copy code
Table temp_table = tableEnv.from("temp_table");
Table result = temp_table.dropColumns($("b"), $("c")); Copy code
select * from result_table;