World of Whatever

A blog about SQL Server, SSIS, C# and whatever else I happen to be dealing with in my professional life.

Pages

▼

Showing posts with label sparksql. Show all posts

Showing posts with label sparksql. Show all posts

Tuesday, September 26, 2023

Databricks sparksql concat is not your SQL Server concat

Databricks sparksql concat is not your SQL Server concat One of these is not like the other... Databricks Concat SQL Server Concat ...

Thursday, September 14, 2023

Databricks sparksql escaping quote/tick

If I had to embed a single quote in a query in TSQL, I would double it. In SparkSQL, I escape it like a classic C style string. So, the fol...

Monday, September 11, 2023

Difference between SparkSQL and TSQL casts

Yet another thing that has bitten me working in SparkSQL in Databricks---this time it's data types. In SQL Server, a tinyint ranges...

Friday, September 8, 2023

SparkSQL Databricks [INVALID_USAGE_OF_STAR_OR_REGEX] Invalid usage of '*' in expression `alias`.

SparkSQL Databricks Error in SQL statement: AnalysisException: [INVALID_USAGE_OF_STAR_OR_REGEX] Invalid usage of '*' in expression `...

View web version

Powered by Blogger.