[HIVE-8005] Webhcat hive job fails for like query containing %%

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Not A Problem
• Assignee: Hari Sankar Sivarama Subramaniyan
• Reporter: Hari Sankar Sivarama Subramaniyan
• Created: 05/Sep/14 22:10
• Updated: 29/Oct/14 21:31
• Resolved: 29/Oct/14 21:31

Description

Unicode character is part of an execute parameter.
Example command:
curl -i -u <username>:<password>
-d user.name=<username>
-d statusdir="/hss/HiveLikeOutput"
-d execute="SELECT * FROM table1 WHERE content LIKE '%%E7%8B%9D%';"
-s http://localhost:30111/templeton/v1/hive

The ‘%’ symbol causes an issue. Templeton throws Error 500 !hex:5c
I have tried to escape the '%' character using '<backslash>%'. That doesn't work as well.