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

Support ALTER VIEW AS SELECT in Hive

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.11.0
    • Component/s: None
    • Labels:
      None
    • Hadoop Flags:
      Reviewed

      Description

      Hive supports "alter view" on setting property, add/drop partition etc but not "as".

      If you want to change "as" part, you have to drop view, recreate it and backfill partition etc. pretty painful.

      It will be nice to support this. The reference is mysql syntax http://dev.mysql.com/doc/refman/5.0/en/alter-view.html

        Attachments

        1. HIVE-3834.1.patch.txt
          17 kB
          Zhenxiao Luo
        2. HIVE-3834.2.patch.txt
          16 kB
          Zhenxiao Luo
        3. HIVE-3834.3.patch.txt
          22 kB
          Zhenxiao Luo
        4. HIVE-3834.4.patch.txt
          23 kB
          Zhenxiao Luo

          Activity

            People

            • Assignee:
              zhenxiao Zhenxiao Luo
              Reporter:
              zhenxiao Zhenxiao Luo
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: