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

Problem with Chinese characters as partition value when using MySQL

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: In Progress
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.2.1, 2.0.0
    • Fix Version/s: None
    • Component/s: Metastore
    • Labels:
      None

      Description

      Steps to reproduce:
      create table t1 (name string, age int) partitioned by (city string) row format delimited fields terminated by ',';

      load data local inpath '/tmp/chn-partition.txt' overwrite into table t1 partition (city='北京');

      The content of /tmp/chn-partition.txt:

      小明,20
      小红,15
      张三,36
      李四,50

      When check the partition value in MySQL, it shows ?? instead of "北京".
      When run "drop table t1", it will hang.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                libing Bing Li
                Reporter:
                libing Bing Li
              • Votes:
                1 Vote for this issue
                Watchers:
                8 Start watching this issue

                Dates

                • Created:
                  Updated: