topic New to databricks SQL - where clause issue in Data Engineering

New to databricks SQL - where clause issue

Cblunck — Mon, 16 Jan 2023 06:49:18 GMT

Hello community,

Using Databricks SQL for the first time and I was hoping I could just copy and past my queries from SSMS across and update the table names, but it's not working.

Found it's the where statement, which I updated the ' ' to " " but still no luck. Below is a snip of the column with some values in it and my WHERE statement. Returns 0 rows though...

What is going wrong here?

where t517f215_paye_tax_category = "GROSS"

Re: New to databricks SQL - where clause issue

Cblunck — Tue, 17 Jan 2023 05:29:23 GMT

Hi @Debayan Mukherjee

Thanks, unfortunately though I re-wrote the query from scratch and it's still not returning a result.

Re: New to databricks SQL - where clause issue

Debayan — Tue, 17 Jan 2023 04:53:17 GMT

Hi, Could you please recheck the format, sometimes copying mismatches the format, also, please refer: https://docs.databricks.com/sql/language-manual/sql-ref-syntax-qry-select-where.html . It has to be ' '.

Re: New to databricks SQL - where clause issue

justinghavami — Tue, 12 Mar 2024 14:13:22 GMT

Hi, were you able to get this figured out? I am having the same issue.