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

Use mysql to store hive metadata,support chinese comments for column

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Patch Available
    • Major
    • Resolution: Unresolved
    • 3.0.0
    • None
    • None
    • None

    Description

      In QueryProfileImpl.jamon,We see the following settings:
      <?xml version="1.0" encoding="UTF-8" ?>
      <html lang="en">
      <head>
      <meta charset="utf-8">
      <title>HiveServer2</title>
      <meta name="viewport" content="width=device-width, initial-scale=1.0">
      <meta name="description" content="">

      <link href="/static/css/bootstrap.min.css" rel="stylesheet">
      <link href="/static/css/bootstrap-theme.min.css" rel="stylesheet">
      <link href="/static/css/hive.css" rel="stylesheet">
      </head>
      So we should set the response code to utf-8, which can avoid Chinese garbled or other languages garbled,Please check it!
      This patch can only solve Drilldown read data from the cache when the Chinese show abnormal, and can not solve the Explain plan from the database query Chinese garbled, because the Chinese stored in the database is garbled.
      If you want to solve this problem, you need to modify the database encoding format.
      I try to modify the mysql 'columns_v2' table field 'comment' encoding utf8,Is this okay?

      Attachments

        1. HIVE-16558.1.patch
          0.6 kB
          ZhangBing Lin
        2. HIVE-16558.2.patch
          1 kB
          ZhangBing Lin

        Issue Links

          Activity

            People

              linzhangbing ZhangBing Lin
              linzhangbing ZhangBing Lin
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated: