The order of columns are not according to the query

If I run a query for example:
select * from column 1, column 2, column 3;
The result is displaying the columns in a random behavior,
column 3 can be coming first or column 2 at last,
Please suggest a solution.

@ronnie123

When you say select * from column1, column2, column3, do you mean the below?

select * from table1, table2, table3?

Sorry, Actually I mean,
select column 1, column 2, column 3 from table 1;
But the output is random in terms of column order specified

@ronnie123

Is this Parquet or an RDBMS (like a push down is happening)? Would you be able to send the job profile?

Hi @balaji.ramaswamy

Thank you for the reply,
I have attached the job profile and the email screenshot which displays the oder below.
image
368e40c3-08bb-4b5d-a43a-3452e077babf.zip (10.8 KB)