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

Column comments with "\n" character "corrupts" table metadata

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 2.2.0
    • 2.3.0
    • Beeline
    • None

    Description

      Create a table with the following(noting the \n in the COMMENT):

      CREATE TABLE commtest(first_nm string COMMENT 'Indicates First name\nof an individual’);
      

      Describe shows that now the metadata is messed up:

      beeline> describe commtest;
      +-------------------+------------+-----------------------+--+
      |     col_name      | data_type  |        comment        |
      +-------------------+------------+-----------------------+--+
      | first_nm             | string       | Indicates First name  |
      | of an individual  | NULL       | NULL                  |
      +-------------------+------------+-----------------------+--+
      

      Attachments

        1. HIVE-14146.patch
          13 kB
          Peter Vary
        2. HIVE-14146.9.patch
          52 kB
          Peter Vary
        3. HIVE-14146.8.patch
          27 kB
          Peter Vary
        4. HIVE-14146.7.patch
          21 kB
          Peter Vary
        5. HIVE-14146.6.patch
          21 kB
          Peter Vary
        6. HIVE-14146.5.patch
          21 kB
          Peter Vary
        7. HIVE-14146.4.patch
          21 kB
          Peter Vary
        8. HIVE-14146.3.patch
          16 kB
          Peter Vary
        9. HIVE-14146.2.patch
          16 kB
          Peter Vary
        10. HIVE-14146.11.patch
          69 kB
          Peter Vary
        11. HIVE-14146.10.patch
          69 kB
          Peter Vary
        12. changes
          37 kB
          Peter Vary

        Issue Links

          Activity

            People

              pvary Peter Vary
              pvary Peter Vary
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: