Hive
  1. Hive
  2. HIVE-420

Support regular expressions for column in select clause

    Details

    • Type: New Feature New Feature
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: 0.3.0, 0.4.0, 0.6.0
    • Fix Version/s: 0.4.0
    • Component/s: Query Processor
    • Labels:
      None
    • Hadoop Flags:
      Reviewed

      Description

      support queries like

       select a.`(ds|hr)?+.+` from a where a.ds='2009-09-09' 

      which are useful when there are humongous number of columns in a table and want to select all columns except the partition columns (ds and hr).

      1. HIVE-420.1.patch
        42 kB
        Zheng Shao
      2. HIVE-420.2.patch
        42 kB
        Zheng Shao
      3. HIVE-420.3.patch
        43 kB
        Zheng Shao
      4. HIVE-420.4.patch
        43 kB
        Zheng Shao

        Issue Links

          Activity

          Prasad Chakka created issue -
          Zheng Shao made changes -
          Field Original Value New Value
          Link This issue is blocked by HIVE-466 [ HIVE-466 ]
          Zheng Shao made changes -
          Attachment HIVE-420.1.patch [ 12406994 ]
          Zheng Shao made changes -
          Assignee Zheng Shao [ zshao ]
          Zheng Shao made changes -
          Attachment HIVE-420.2.patch [ 12406996 ]
          Zheng Shao made changes -
          Attachment HIVE-420.3.patch [ 12406997 ]
          Zheng Shao made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Fix Version/s 0.4.0 [ 12313714 ]
          Zheng Shao made changes -
          Attachment HIVE-420.4.patch [ 12407038 ]
          Namit Jain made changes -
          Status Patch Available [ 10002 ] Resolved [ 5 ]
          Hadoop Flags [Reviewed]
          Resolution Fixed [ 1 ]
          Zheng Shao made changes -
          Description support queries like `select a.[^ds] from a where a.ds='2009-09-09'` which are useful when there are humongous number of columns in a table and want to select all columns except the partitions columns. support queries like `select a.`(ds|hr)?+.+` from a where a.ds='2009-09-09'` which are useful when there are humongous number of columns in a table and want to select all columns except the partition columns (ds and hr).
          Zheng Shao made changes -
          Description support queries like `select a.`(ds|hr)?+.+` from a where a.ds='2009-09-09'` which are useful when there are humongous number of columns in a table and want to select all columns except the partition columns (ds and hr). support queries like {code} select a.`(ds|hr)?+.+` from a where a.ds='2009-09-09' {code} which are useful when there are humongous number of columns in a table and want to select all columns except the partition columns (ds and hr).
          Zheng Shao made changes -
          Affects Version/s 0.6.0 [ 12314524 ]
          Affects Version/s 0.2.0 [ 12313565 ]
          Carl Steinbach made changes -
          Affects Version/s 0.3.1 [ 12313845 ]
          Carl Steinbach made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Mariano Dominguez made changes -
          Link This issue relates to HIVE-7631 [ HIVE-7631 ]

            People

            • Assignee:
              Zheng Shao
              Reporter:
              Prasad Chakka
            • Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development