Member since
11-21-2019
2
Posts
0
Kudos Received
0
Solutions
11-22-2019
01:55 PM
Thanks! That worked
... View more
11-21-2019
11:54 AM
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
... View more
Labels:
- Labels:
-
Apache Impala
-
Cloudera Hue