How can I create a column on the fly which would have same value for all rows in spark sql query

haseebkhan1421 — Sun, 15 Aug 2021 18:46:43 GMT

I have a SQL query which I am converting into spark sql in azure databricks running in my jupyter notebook. In my SQL query, a column named Type is created on the fly which has value 'Goal' for every row:

SELECT Type='Goal', Value

FROM table

Now, when I am using the same syntax on the spark sql in my azure databricks notebook, it gives me an error:

Error in SQL statement: AnalysisException: cannot resolve '`Type`' given input columns:

How can I convert the same logic in azure databrick spark sql

Re: How can I create a column on the fly which would have same value for all rows in spark sql query

Ryan_Chynoweth — Wed, 01 Sep 2021 21:24:20 GMT

The correct syntax would be:

SELECT 'Goal' AS Type, Value 
FROM table

topic How can I create a column on the fly which would have same value for all rows in spark sql query in Data Engineering

How can I create a column on the fly which would have same value for all rows in spark sql query

Re: How can I create a column on the fly which would have same value for all rows in spark sql query