Details

    • Type: New Feature New Feature
    • Status: Closed
    • Priority: Major 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.

      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

          Activity

          No work has yet been logged on this issue.

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development