topic compatibility issue between 7.3 LTS and 10.4 LTS in Data Engineering

compatibility issue between 7.3 LTS and 10.4 LTS

Ravikumashi — Sun, 11 Sep 2022 22:17:28 GMT

We have views created with mixed case column names in 7.3 LTS and when we do select * from view everything looks OK I mean column names display in mixed case and problem started as we recently migrated to 10.4 LTS.

Same views created with create or replace view command using 10.4 LTS everything looks OK in 10.4 LTS and if the same views are queried using 7.3 LTS all the view columns are displayed in lower case but expection is to have mixed case column names

Re: compatibility issue between 7.3 LTS and 10.4 LTS

jose_gonzalez — Mon, 12 Sep 2022 20:36:55 GMT

Are you getting any error messages, if you do, could you share the error message please?

Re: compatibility issue between 7.3 LTS and 10.4 LTS

Prabakar — Tue, 13 Sep 2022 04:19:10 GMT

@Ravikumar Kumashi other than the DBR version, do you have any other configuration on the clusters? Also, is it possible for you to share a sample table and code so we could reproduce this?

Re: compatibility issue between 7.3 LTS and 10.4 LTS

Ravikumashi — Tue, 13 Sep 2022 07:08:57 GMT

Thank you for reply.

Steps to reproduce.

1.In 10.4 LTS Create a table xyz with columns dummy1 dummy2 both are of type string.

2.insert some records into table xyz(10.4 LTS)

3.create or replace view pqr

As select dummy1 as DummY1,dummy2 as DummY2 from xyz.(10.4 LTS).

4.select * from pqr(10.4LTS)

Notes: display view columns with mixed case like DummY1 and DummY2

5.In 7.3 LTS, select * from pqr

Displays all the columns in lower case like dummy1 and dummy2.

Notes: expection was to have the view columns displaying DummY1 and DummY2