- 11174 Views
- 3 replies
- 4 kudos
Why database/table names are in lower case ?
Hello,When I run this code :CREATE DATABASE BackOfficeI see the database like this :backofficeWhy everything is in lower case ?Is it possible to configure Databricks in order to keep the real name ?Thanks.
- 11174 Views
- 3 replies
- 4 kudos
- 4 kudos
It is managed by hive metastore as you can put it in different databases is saver this way as some database are Case Sensitive and some not (you can easily test it with standard WHERE syntax).Probably you could change it with some hive settings but i...
- 4 kudos
- 2143 Views
- 0 replies
- 6 kudos
Is Azure Database for MySQL - Flexible Server supported as external metastore.
In the docs it's mention that "if you use Azure Database for MySQL as an external metastore, you must change the value of the lower_case_table_names property from 1 (the default) to 2 in the server-side database configuration."However "lower_case_tab...
- 2143 Views
- 0 replies
- 6 kudos
- 3412 Views
- 2 replies
- 3 kudos
Resolved! display password as shown in example using spark scala
Table has the following Columns:First_Name, Last_Name, Department_Id,Contact_No, Hire_DateDisplay the emplopyee First_name, Count of Characters in the firstname,password.Password should be first 4 letters of first name in lower case and the date and ...
- 3412 Views
- 2 replies
- 3 kudos
- 3 kudos
@SANJEEV BANDRU​ , SELECT CONCAT(substring(First_Name, 0, 2) , substring(Hire_Date, 0, 2), substring(Hire_Date, 3, 2)) as password FROM table;If Hire_date is timestamp you may need to add date_format()
- 3 kudos