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

Trailing spaces in partition column will be treated differently

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 2.0.0
    • 2.1.0
    • None
    • None

    Description

      We store the partition spec value in the metastore. In mysql (and derby i think), the trailing space is ignored. That is, if you have a partition column "col" (type varchar or string) with value "a " and then select from the table where col = "a", it will return. However, in postgres and Oracle, the trailing space is not ignored.

      Attachments

        1. HIVE-13618.01.patch
          11 kB
          Pengcheng Xiong

        Issue Links

          Activity

            People

              pxiong Pengcheng Xiong
              pxiong Pengcheng Xiong
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: