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

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

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment