open-metadata / OpenMetadata

OpenMetadata is a unified metadata platform for data discovery, data observability, and data governance powered by a central metadata repository, in-depth column level lineage, and seamless team collaboration.
https://open-metadata.org
Apache License 2.0
5.45k stars 1.04k forks source link

The Metadata versioning is not as expected when the order of the columns in the DDL is different #14522

Open YMACHEN opened 10 months ago

YMACHEN commented 10 months ago

Affected module Metadata versioning

Describe the bug Dropping the table and then recreating it may lead to column description errors if the order of the columns in the DDL is different between the first and second times.

To Reproduce The first time's DDL ddl_v1

Metadata version 0.1 v1

The second time's DDL ddl_v2

Metadata version 0.2 v2

Expected behavior Expecting version 0.2 not to exist, as the DDL is the same, only the order is different.

Version:

Additional context Then I used this API to get some details http://hostname:8585/api/v1/tables/id/versions/0.2 In the 'changeDescription' function, 'oldValue' and 'newValue' are reversed. call api

harshach commented 4 months ago

@mohityadav766 is this still an issue?