Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-3139

Drop table if exists "tablename" deletes the view with the same name

    XMLWordPrintableJSON

    Details

      Description

      DROP TABLE IF EXISTS TABLENAME command deletes the view that has the same name.So the views are lost.

      TEST CASE -
      1)Create a view TEST
      2)Drop table TEST
      This throws an error "Drop table not allowed on a view"
      3)Drop table if exists TEST
      This command deletes the view TEST

        Attachments

          Activity

            People

            • Assignee:
              bharathv Bharath Vissapragada
              Reporter:
              Divya Krishnan_impala_fed8 Divya Krishnan
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: