Databricks Community

Graham · 11-01-2022

Running this code in databricks SQL works great:SET USE_CACHED_RESULT = FALSE; -- Result: -- key value -- USE_CACHED_RESULT FALSEIf I add an inline comment, however, I get a syntax error:SET USE_CACHED_RESUL...

Graham · 09-16-2022

OverviewTo update our Data Warehouse tables, we have tried two methods: "CREATE OR REPLACE" and "MERGE". With every query we've tried, "MERGE" is slower.My question is this: Has anyone successfully gotten a "MERGE" to perform faster than a "CREATE OR...

Graham · 06-29-2022

The Problem:I've observed erratic behavior when I add a comment containing a trailing escape character (\) to a CREATE TABLE statement.For example, this query returns data (though it shouldn't):CREATE TABLE example_table SELECT 1 -- This comment has ...

Graham · 11-09-2022

Thanks Kaniz! I sent a reply to Landan for his insightful answer. His is a great workaround. However, it should still work without his workaround (adding tickmarks). So I'm leaving this up here for now; I think this is just a bug that needs to be bro...

Graham · 11-09-2022

This works! Thank you! however, it should still work without tick marks, so I'm leaving this question up here. Again, thanks for your find.

Graham · 09-19-2022

Great question. We're doing this on tables with hundreds of millions of rows.

Databricks Community

User Stats

User Activity

Inline comment next to un-tickmarked SET statement = Syntax error

"MERGE" always slower than "CREATE OR REPLACE"

[Databricks SQL] Commented Escape Character (\) Causes Unexpected Behavior

Re: Inline comment next to un-tickmarked SET statement = Syntax error

Re: Inline comment next to un-tickmarked SET statement = Syntax error

Re: "MERGE" always slower than "CREATE OR REPLACE"