Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Exception: Syntax error when trying to Escape the apostrophe

avatar
New Contributor

Hi,

I am getting the below error when trying to escape the apostrophe character in HUE Impala.

 

select * from hi_problem_view
where
state like 'Won''t fix'

 

won't fix is a value that I am trying to filter by for records.  

 

Error:

AnalysisException: Syntax error in line 3:undefined: state like 'Won''t fix' ^ Encountered: STRING LITERAL Expected: AND, BETWEEN, DIV, GROUP, HAVING, ILIKE, IN, IREGEXP, IS, LIKE, LIMIT, NOT, OFFSET, OR, ORDER, REGEXP, RLIKE, UNION CAUSED BY: Exception: Syntax error

1 ACCEPTED SOLUTION

avatar
Expert Contributor
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login
2 REPLIES 2

avatar
Expert Contributor
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login

avatar
New Contributor

Thanks! That worked