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

Support regular expressions for column in select clause

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 0.3.0, 0.4.0, 0.6.0
    • 0.4.0
    • Query Processor
    • None
    • 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).

      Attachments

        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

          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. HIVE-466 Fix queries like "SELECT t.*, t.a"

          • Major - Major loss of function.
          • Closed
          relates to

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-7631 Add support for NOT operator in column regex

          • Major - Major loss of function.
          • Open

          Activity

            People

              zshao Zheng Shao
              prasadc Prasad Chakka
              Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: