cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

compatibility issue between 7.3 LTS and 10.4 LTS

Ravikumashi
Contributor

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 โ€‹

3 REPLIES 3

jose_gonzalez
Databricks Employee
Databricks Employee

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

Prabakar
Databricks Employee
Databricks Employee

@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?

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

โ€‹

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group