Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-13554 [Umbrella] SQL:2011 compliance
  3. HIVE-15979

Support character_length and octet_length

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 2.3.0
    • SQL
    • None

    Description

      SQL defines standard ways to get number of characters and octets. SQL reference: section 6.28. Example:
      vagrant=# select character_length('欲速则不达');
      character_length
      ------------------
      5
      (1 row)

      vagrant=# select octet_length('欲速则不达');
      octet_length
      --------------
      15
      (1 row)

      Attachments

        1. HIVE-15979.1.patch
          31 kB
          Teddy Choi
        2. HIVE-15979.2.patch
          75 kB
          Teddy Choi
        3. HIVE-15979.3.patch
          113 kB
          Teddy Choi
        4. HIVE-15979.4.patch
          64 kB
          Teddy Choi
        5. HIVE-15979.5.patch
          64 kB
          Teddy Choi
        6. HIVE-15979.6.patch
          81 kB
          Teddy Choi
        7. HIVE-15979.7.patch
          82 kB
          Teddy Choi

        Issue Links

          Activity

            People

              teddy.choi Teddy Choi
              cartershanklin Carter Shanklin
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: