Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-22177

Beeline query for special character like £ does not give back result

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsAdd voteVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 1.1.0, 2.3.6
    • None
    • Beeline
    • None
    • Cloudera 5.15.1 Hive 1.1.0

      beeline and Impala

    Description

      I have a table in hive with a column having special character like £. When I try to a query as simple as 'SELECT * FROM TABLE WHERE COL = "£"; ', the query does not come back with any result. 

      The table data is UTF-8 encoded. The sql file that contains the above sql and run via beeline is also UTF-8 encoded.

      Interestingly, if I try to create the run the same query using impala against the same table, I get back the columns containing the £ symbol.

      Also when the data from the table is exported (SELECT * FROM THE TABLE and save the output to csv file) the column with special character is shown as NULL.

       

      Steps to replicate:

      1. create test.sql file with the below content: 
      2.  CREATE TABLE T1 (test String);
        INSERT INTO T1 VALUES('£');
        
      1. beeline>!run test.sql
      2. create another file test_select.sql with the below content:
      3. SELECT * FROM T1 WHERE test='£';
      1. beeline>!run test_select.sql
      2. No results will be returned back

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Unassigned Unassigned Assign to me
            sanjurm16 Sanjay Mishra

            Dates

              Created:
              Updated:

              Slack

                Issue deployment