Only Coders

python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - databricks-sql

ParseException: SQL CTE

result = aml_identity_g.connectedComponents() conn_comps = result.select("id", "component",'type') \ .createOrReplaceTempView("components") display(result) Which crea...

Betafish

apache-spark-sql

databricks

common-table-expression

databricks-sql

Votes: 0

Answers: 1

Latest Answer

You really don't need CTE in this query - it should be enough to have normal SELECT. So it should be something like this: create table temptable as ( select component, count(case when type = 'Perso...

Alex Ott

Get previous row value based on a timestamp for matching IDs

I have a table about shipping that has information about the arrival (country and date) to a port. Now I need to extract the country where it departed from using the previous row entries. The table lo...

WonderCoding

azure-sql-database

databricks

databricks-sql

Votes: 0

Answers: 1

Latest Answer

You need to PARTITION BY the ID column. lag(pc.CountryArrival) over (PARTITION BY ID order by DateArrival) as DeparturePort

Edward Radcliffe

Error in SQL statement: ParseException: mismatched input 'FROM' expecting from Databricks SQL

I am trying to update the columns based on other table data but receiving the below error Trying to execute in Databricks Error in SQL statement: ParseException: mismatched input 'FROM' expecting {&l...

Veluguri sai ram

sql

scala

databricks

databricks-sql

Votes: 0

Answers: 1

Latest Answer

The syntax used in Databricks SQL guide for update command does not have FROM clauses. They do not support it.

Goosefand

Databricks DELTA CTAS with LOCATION using %sql

DELTA does not have CREATE TABLE LIKE. It does have CTAS. I want to copy the definition of a table only, but also specify the LOCATION. E.g. this does not work: CREATE TABLE IF NOT EXISTS NEW_CUSTOMER...

thebluephantom

databricks

delta-lake

databricks-sql

Votes: 0

Answers: 1

Latest Answer

if you check syntax for CREATE TABLE USING, then you will see that AS SELECT ... should be the last clause, after all options. So in your case it should be CREATE TABLE IF NOT EXISTS NEW_CUSTOMER_FEE...

Alex Ott

Posts

Questions

Blogs

Jobs