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

hive doesn't support chinese comments for columns

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.2.1
    • Fix Version/s: None
    • Component/s: CLI
    • Labels:
      None
    • Environment:

      hive 1.2.1 in HDP

      Description

      1. alter table stg.test_chinese change chinesetitle chinesetitle tinyint comment '中文';
      2. desc stg.test_chinese;
      Result: chinese comment "中文" becase "??"

      also, if i modify the comment via hive view, it will still display the messy code "??".

      I did some testing, but cannot fix it, such as:
      1. change the hive.COLUMNS_V2 to UTF-8 chartset.
      2. append the characterEncoding=UTF-8 to hive_to_mysqlmetadata url

      i found some ideas that need to apply some patch to fix it, but seems they all effects in 0.x version, i use the 1.2.1 version.

      Please give some guidance.....

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              liugaopeng liugaopeng
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Due:
                Created:
                Updated: