From the course: Manage and Optimize Big Data with Apache Iceberg

Unlock the full course today

Join today to access over 24,700 courses taught by industry experts.

Implement schema changes

Implement schema changes - SQL Tutorial

From the course: Manage and Optimize Big Data with Apache Iceberg

Start my 1-month free trial Buy for my team

Implement schema changes

“

- [Instructor] Let's learn the schema changes practically. For that, click on the New and add a new notebook. We will give a name Schema_Changes to this notebook. Now if you remember in the previous sessions, we have already created our orders table. Now imagine that we got a new requirement there. In this table a one more column information as it start coming in. that is shipping date. Now to accommodate that change in our table, we need to add an extra column. How we can do that, we can use percent SQL alter table orders, and then we can add the column. You can give the column name that Shipping_dt of type date. And when you execute, This will add a shipping date column into our table. If you want to check whether it got added up or not, we can just do select star from our orders table. You will start seeing that extra column, but right now there will be no value because a new file will insert a value inside it. Got it? Now imagine that there was a miscommunication. Instead of…

Contents