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

Support ALTER VIEW AS SELECT in Hive

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 0.11.0
    • None
    • None
    • 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.4.patch.txt
          23 kB
          Zhenxiao Luo
        2. HIVE-3834.3.patch.txt
          22 kB
          Zhenxiao Luo
        3. HIVE-3834.2.patch.txt
          16 kB
          Zhenxiao Luo
        4. HIVE-3834.1.patch.txt
          17 kB
          Zhenxiao Luo

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: