[IMPALA-3139] Drop table if exists "tablename" deletes the view with the same name

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 2.2
• Fix Version/s: Impala 2.6.0, impala 2.5.1
• Component/s: Frontend
• Labels: impala
• Target Version: impala 2.5.1
• Assignee: Bharath Vissapragada
• Reporter: Divya Krishnan
• Created: 04/Mar/16 12:45
• Updated: 04/May/16 09:52
• Resolved: 15/Mar/16 18:37

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