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

Support character_length and octet_length

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersConvert to IssueMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment