Questions about databricks-sql
Read more about databricks-sql
python (12.9k questions)
javascript (9.2k questions)
reactjs (4.7k questions)
java (4.2k questions)
java (4.2k questions)
c# (3.5k questions)
c# (3.5k questions)
html (3.3k questions)
Unable to cast string to date when inserting on Databricks SQL
I have a table created like so :
CREATE TABLE IF NOT EXISTS MyDataBase.Table (
`date` DATE,
`name` STRING,
`isTarget` BOOLEAN
) USING DELTA LOCATION '/mnt/path/to/folder/'
I need to man...
Karzyfox
Votes: 0
Answers: 1
How to create a new table with the results of SHOW TABLES in Databricks SQL?
I want to do aggregations on the result of
SHOW TABLES FROM databasename
Or create a new table with the result like
CREATE TABLE database.new_table AS (
SHOW TABLES FROM database
);
But I'm ge...
robin_xxx
Votes: 0
Answers: 1
Finding week of the month from the date in databricks SQL
I'm trying to get the week_of_the_month from the date in databricks sql
Here is my SQL:
with date as (
select EXTRACT(DAY FROM '2017-01-01') as day
)
select case
when day < 8 then '1'
...
R0bert
Votes: 0
Answers: 1