Metadata Editor mainly has two uses – defining pseudo tables and defining DQL.
The core of defining a pseudo table is to convert an existing composite table file (.ctx) or a bin file (.btx) to a pseudo table and make related configurations, including settings of zone number list, columnar storage, user-defined field and so on.
In the editor, you can also export the pseudo table definition as a SPL file. Through “Create Pseudo Table Definition” functionality, you can automatically generate a SPL script for re-editing. This is far more convenient and efficient than manually writing a script to define a pseudo table.
The core of defining DQL is to edit the DQL table. A pseudo table defined in the pseudo table definition phase can be converted to a DQL table. In DQL, it acts as a physical table. Through this functionality, you can define the relationship between DQL tables and then perform data queries on them.