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

Select columns by index instead of name

    XMLWordPrintableJSON

Details

    • Wish
    • Status: Patch Available
    • Minor
    • Resolution: Unresolved
    • None
    • None
    • Clients, Query Processor

    Description

      SELECT mytable[0], mytable[2] FROM some_table_name mytable;

      ...should return the first and third columns, respectively, from mytable regardless of their column names.

      The need for "names" specifically is kind of silly when they just get translated into numbers anyway.

      Attachments

        1. HIVE-494.3.patch.txt
          19 kB
          Navis Ryu
        2. HIVE-494.2.patch.txt
          17 kB
          Navis Ryu
        3. HIVE-494.D12153.1.patch
          14 kB
          Phabricator
        4. ASF.LICENSE.NOT.GRANTED--HIVE-494.D1641.1.patch
          7 kB
          Phabricator

        Issue Links

          Activity

            People

              navis Navis Ryu
              akramer Adam Kramer
              Votes:
              2 Vote for this issue
              Watchers:
              11 Start watching this issue

              Dates

                Created:
                Updated: