Hive
  1. Hive
  2. HIVE-3269

selectlist needs to be superset of the cluster list

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      The query:

      create table T (key1 string, key2 string, key3 string);
      select key1, key2 from T cluster by key1, key2, key3;

      fails.

        Issue Links

          Activity

          Namit Jain created issue -
          Navis made changes -
          Field Original Value New Value
          Link This issue is related to HIVE-2954 [ HIVE-2954 ]
          Hide
          Navis added a comment -

          I failed to solve similar issue(HIVE-2954). There should be a entity something like BlockAliasResolver, which handles various column aliases in SELECT/GROUPBY/ORDERBY/CLUSTERBYs.

          Show
          Navis added a comment - I failed to solve similar issue( HIVE-2954 ). There should be a entity something like BlockAliasResolver, which handles various column aliases in SELECT/GROUPBY/ORDERBY/CLUSTERBYs.
          Hide
          Namit Jain added a comment - - edited

          Wont it be good to take a similar approach like groupby ?
          I mean, have a dummy select first, and then cluster by/order by can resolve.

          But then, it would be difficult to support column aliases.

          Show
          Namit Jain added a comment - - edited Wont it be good to take a similar approach like groupby ? I mean, have a dummy select first, and then cluster by/order by can resolve. But then, it would be difficult to support column aliases.
          Hide
          Navis added a comment -

          Yes, adding dummy column was not hard. But alias problem was quite difficult.

          Show
          Navis added a comment - Yes, adding dummy column was not hard. But alias problem was quite difficult.

            People

            • Assignee:
              Unassigned
              Reporter:
              Namit Jain
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:

                Development