You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Hari Sankar Sivarama Subramaniyan (JIRA)" <ji...@apache.org> on 2014/09/06 00:10:28 UTC

[jira] [Created] (HIVE-8005) Webhcat hive job fails for like query containing %%

Hari Sankar Sivarama Subramaniyan created HIVE-8005:
-------------------------------------------------------

             Summary: Webhcat hive job fails for like query containing %%
                 Key: HIVE-8005
                 URL: https://issues.apache.org/jira/browse/HIVE-8005
             Project: Hive
          Issue Type: Bug
            Reporter: Hari Sankar Sivarama Subramaniyan
            Assignee: Hari Sankar Sivarama Subramaniyan


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.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)