topic Re: Databricks SQL Wildcard Operator Not Parsed Correctly in Warehousing & Analytics

Databricks SQL Wildcard Operator Not Parsed Correctly

nomnomnom543 — Fri, 20 Dec 2024 10:37:27 GMT

Hello there,

Wasn't sure if this was just an error on my part, but I'm using a Databricks Pro SQL warehouse and unity catalogue to pull some data from my tables. I'm having this issue where whenever I try and use a wildcard operator with my LIKE clause, I'm getting a Parse error.

When I write a query like SELECT * FROM table_name WHERE column_name LIKE 'string' it works fine. But when I include a wildcard operator in my query, SELECT * FROM table_name WHERE column_name LIKE 'string%', then it throws a parse error. Specifically the error says, Parse error at line: 1, column: 3620: Incorrect syntax near ''%string%'', with the string portion surrounded by two single quotes.

My column is a string column in the table. Anyone else experience something similar?

Re: Databricks SQL Wildcard Operator Not Parsed Correctly

Walter_C — Fri, 20 Dec 2024 11:59:05 GMT

Is this only happening with Pro warehouse, if you test with Serverless for example does it work? I have tested using syntax
SELECT * FROM table_name WHERE column_name LIKE 'string%' and it has worked as expected for me on Serverless.

Re: Databricks SQL Wildcard Operator Not Parsed Correctly

nomnomnom543 — Fri, 20 Dec 2024 12:10:48 GMT

My organization doesn't have serverless SQL enabled, so I'm not able to try that out. But I did try a query with a wildcard operator on a different table and Pro warehouse and it worked like expected. Looks like it might be an issue with the table itself.

Re: Databricks SQL Wildcard Operator Not Parsed Correctly

Rahul_Saini — Fri, 03 Jan 2025 09:41:47 GMT

Hi @nomnomnom543 ,

Try this SELECT * FROM table_name WHERE LEFT(column_name, LENGTH('string')) = 'string';