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 BottomVotersWatch issueWatchersConvert to IssueMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Sub-task
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.3.0
    • Component/s: SQL
    • Labels:
      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

          $i18n.getText('security.level.explanation', $currentSelection) Viewable by All Users
          Cancel

            People

            • Assignee:
              teddy.choi Teddy Choi Assign to me
              Reporter:
              cartershanklin Carter Shanklin

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment