Example: Re-Ordering of Columns Using Schema Evolution | VantageCloud Lake - Example: Re-Ordering of Columns Using Schema Evolution

Schema After Evolution

EmpName    EmpID     City
-------    -----     --------
John       65784     Austin
Robert     69824     Atlanta
Frank      48392     Columbus
Colin      72985     Phoenix
Brandon    34862     Hartford

Select Columns From NOS Table

SELECT EmpID,EmpName,City from nos_table;

Result:

    EmpID          EmpName       City
    -----          -------        --------
    65784          John          Austin
    69824          Robert        Atlanta
    48392          Frank         Columbus
    72985          Colin         Phoenix
    34862          Brandon       Hartford

If schema evolution were disabled, the following result would be returned:

    EmpID          EmpName        City
    -------        -------        --------
    John           65784          Austin
    Robert         69824          Atlanta
    Frank          48392          Columbus
    Colin          72985          Phoenix
    Brandon        34862          Hartford

Example: Re-Ordering of Columns Using Schema Evolution | VantageCloud Lake - Example: Re-Ordering of Columns Using Schema Evolution - Teradata VantageCloud Lake

Lake - Working with SQL

Schema After Evolution

Select Columns From NOS Table