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.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

          Carl Steinbach made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Jeff Hammerbacher made changes -
          Link This issue is related to HIVE-783 [ HIVE-783 ]
          Carl Steinbach made changes -
          Affects Version/s 0.5.0 [ 12314156 ]
          Affects Version/s 0.4.1 [ 12314225 ]
          Affects Version/s 0.4.0 [ 12313714 ]
          Affects Version/s 0.3.0 [ 12313637 ]
          Component/s Query Processor [ 12312586 ]
          Namit Jain made changes -
          Status Patch Available [ 10002 ] Resolved [ 5 ]
          Hadoop Flags [Reviewed]
          Fix Version/s 0.6.0 [ 12314524 ]
          Resolution Fixed [ 1 ]
          Paul Yang made changes -
          Attachment HIVE-801.3.patch [ 12444267 ]
          Paul Yang made changes -
          Attachment HIVE-801.2.patch [ 12444255 ]
          Paul Yang made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Paul Yang made changes -
          Attachment HIVE-801.1.patch [ 12443997 ]
          Paul Yang made changes -
          Field Original Value New Value
          Assignee Paul Yang [ pauly ]
          Adam Kramer created 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