topic Using sql inside Notebook using question marks in Data Engineering

Using sql inside Notebook using question marks

JensV — Thu, 21 Nov 2024 19:51:48 GMT

Hi all,

I have a very quick question that I hope someone can help with.

I want to execute a very simple sql statement like

%sql select * from json.`/Volumes/adfmeta/Objects.json` where ObjectName like '%SGm$RITWebsader$911a%'

However, the sql does not find anything and ask for ::parm insted

How do i accept that my whare clause has question marks????

Re: Using sql inside Notebook using question marks

JAHNAVI — Fri, 22 Nov 2024 06:02:27 GMT

Hi @JensV ,
Question marks are used as parameter placeholders, so could you please try to escape the question mark using Backslashes?

select * from json.`/Volumes/adfmeta/Objects.json` where ObjectName like '%SGm\\$RITWebsader\\$911a%'

Alternatively, we can use regex equation like this: SELECT * FROM json.`/Volumes/adfmeta/Objects.json` WHERE ObjectName RLIKE '.*SGm\\$RITWebsader\\$911a.*'