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

Support the width_bucket function

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 3.0.0
    • SQL
    • None

    Description

      Support the width_bucket(wbo, wbb1, wbb2, wbc) which returns an integer between 0 and wbc+1 by mapping wbo into the ith equally sized bucket made by dividing wbb1 and wbb2 into equally sized regions. If wbo < wbb1, return 1, if wbo > wbb2 return wbc+1. Reference: SQL standard section 4.4.

      Attachments

        1. HIVE-15982.6.patch
          14 kB
          Sahil Takiar
        2. HIVE-15982.5.patch
          14 kB
          Sahil Takiar
        3. HIVE-15982.4.patch
          13 kB
          Sahil Takiar
        4. HIVE-15982.3.patch
          12 kB
          Sahil Takiar
        5. HIVE-15982.2.patch
          12 kB
          Sahil Takiar
        6. HIVE-15982.1.patch
          13 kB
          Sahil Takiar

        Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. HIVE-16513 width_bucket issues

          • Major - Major loss of function.
          • Closed
          links to

          Web Link RB

          Activity

            People

              stakiar Sahil Takiar
              cartershanklin Carter Shanklin
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: