Details

    • Type: New Feature
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 0.3.0, 0.4.0, 0.4.1, 0.5.0
    • Fix Version/s: 0.6.0
    • Component/s: Query Processor
    • Labels:
      None
    • Hadoop Flags:
      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.3.patch
          15 kB
          Paul Yang
        2. HIVE-801.2.patch
          17 kB
          Paul Yang
        3. HIVE-801.1.patch
          17 kB
          Paul Yang

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: