@nhakhoaparis. I often seen questions like this and although there are many solutions, the one i prefer is to leave the source table alone, create another table with the modified schema. In one form of this concept, you leave the old table behind, and INSERT INTO new_table SELECT * FROM old_table. This is immutable table is also common concept for parquet. You do not modify columns. You read, change, then re-write. One way to complete the above concept in hive query language: select parquet into a non parquet table, do your work to modify the new table, update the new column, etc, then select back into a new parquet table with the new schema. You can also do some of the above with spark or other programming languages. Many options, but in summary: leave the source table alone and create a new tables. During the course, i like to call these staging tables, and sometimes keep the new names, or drop original table, and rename new table to the old table. If this answer resolves your issue or allows you to move forward, please choose to ACCEPT this solution and close this topic. If you have further dialogue on this topic please comment here or feel free to private message me. If you have new questions related to your Use Case please create separate topic and feel free to tag me in your post. Thanks, Steven
... View more
