External_query for postgresql lost correct column names (all become lowercase)

1

I encounter an issue when using dremio’s external_query functionality.

for example, if I run the following query

select * from table(pg.external_query('select 123 as "UPPER_CASE"'))

The result’s column name will be “upper_case”.

But if I run the following SQL in Dremio directly, (without using external_query)

select 123 as "UPPER_CASE"

the result’s column name will be correctly one: “UPPER_CASE”

Since the correct column name is very important, is this a bug for Dremio’s external_query?

2

@Baoqi Are you able to send us the 2 profiles? Want to see the push down