Uploaded image for project: 'Kudu'
  1. Kudu
  2. KUDU-2487

kudu quote escape issues in select query

    Details

    • Type: Bug
    • Status: Open
    • Priority: Critical
    • Resolution: Unresolved
    • Affects Version/s: 1.7.0
    • Fix Version/s: None
    • Component/s: impala
    • Labels:
      None
    • Environment:
      kudu-1.7.0
      cdh5.15.0
      impala-2.12.0

      Description

      From impala shell, I am getting wrong results by using escape single quote for query, details explained below:
      1. create a kudu table like:

      CREATE TABLE test_cf_escape(
       x INT NOT NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
      y STRING NOT NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
      z INT NULL ENCODING AUTO_ENCODING COMPRESSION DEFAULT_COMPRESSION,
      PRIMARY KEY(x, y)
      )
      STORED AS KUDU
      TBLPROPERTIES ('kudu.master_addresses'='hadoop-nn.xxx.com')

      2. insert data to the table:

      insert into test_cf_escape (x,y,z) values (1, "chili\\\'s", 0);
      insert into test_cf_escape (x,y,z) values (1, "chili\'s", 2);
      select * from test_cf_escape;
      =>
      +---+----------+---+
      | x | y        | z |
      +---+----------+---+
      | 1 | chili's  | 2 |
      | 1 | chili\'s | 0 |
      +---+----------+---+
      

      3. we should get the same row by using below two select query, but failed:

      select * from test_cf_escape where y = 'chili\'s'; => (1, 'chili\'s', 0) (supposed to read data as (1, "chili's", 2))
      select * from test_cf_escape where y = "chili's"; => (1, "chili's", 2)
      

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              be_fwan fangwan
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: