[jira] [Created] (HIVE-25343) Create or replace view should clean the old table properties

["Lantao Jin (Jira)" <ji...@apache.org>]

Lantao Jin created HIVE-25343:
---------------------------------

             Summary: Create or replace view should clean the old table properties
                 Key: HIVE-25343
                 URL: https://issues.apache.org/jira/browse/HIVE-25343
             Project: Hive
          Issue Type: Bug
          Components: SQL
    Affects Versions: 3.1.3, 3.2.0
            Reporter: Lantao Jin
         Attachments: Screen Shot 2021-07-19 at 15.36.29.png

In many cases, users use Spark and Hive together. When a user creates a view via Spark, the table output columns will store in table properties, such as 
 !Screen Shot 2021-07-19 at 15.36.29.png|width=80!

After that, if the user runs the command "create or replace view" via Hive, to change the schema. The old table properties added by Spark are not cleaned by Hive. Then users read the table via Spark. The schema didn't change. It very confused users.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)