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)