Databricks SQL Wildcard Operator Not Parsed Correctly
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-20-2024 02:37 AM
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?