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

row-wise IN would be useful

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 0.3.0, 0.4.0, 0.4.1, 0.5.0
    • 0.6.0
    • Query Processor
    • None
    • Reviewed

    Description

      SELECT * FROM tablename t
      WHERE IN(12345,key1,key2,key3);

      ...IN would operate on a given row, and return True when the first argument equaled at least one of the other arguments. So here IN would return true if 12345=key1 OR 12345=key2 OR 12345=key3 (but wouldn't test the latter two if the first matched).

      This would also help with https://issues.apache.org/jira/browse/HIVE-783, if IN were implemented in a manner that allows it to be used in an ON clause.

      Attachments

        1. HIVE-801.1.patch
          17 kB
          Paul Yang
        2. HIVE-801.2.patch
          17 kB
          Paul Yang
        3. HIVE-801.3.patch
          15 kB
          Paul Yang

        Issue Links

          is related to

          New Feature - A new feature of the product, which has yet to be developed. HIVE-783 Implement disjunctive JOINs

          • Major - Major loss of function.
          • Open

          Activity

            People

              pauly Paul Yang
              akramer Adam Kramer
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: