This example shows a statement and the associated Metadata Parcel Sequence.
Consider the following table, data, and query.
CREATE SET TABLE myDatasetTable ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT, DEFAULT MERGEBLOCKRATIO ( id INTEGER, avroFile DATASET(543000) STORAGE FORMAT Avro) PRIMARY INDEX ( id );
When executing the SELECT statement, the StatementInfo parcel looks like the following:
Database Name | test_db |
Table/View Name | myDatasetTable |
Column Name | avroFile |
Column Index | 3 |
As Name | |
Title | avroFile |
Format | |
Default Value | |
Is Identity Column | N |
Is Definitely Writable | Y |
Is Nullable | Y |
Is Searchable | Y |
Is Writable | Y |
Data Type Code | 400 or 688 (depending on transform) |
UDT Indicator | 0 |
UDT Name | |
UDT Misc | |
Maximum transform size | 543000 |
Digits | 0 |
Interval Digits | 0 |
Fractional Digits | 0 |
Max Number of Characters | 0 |
Is CaseSensitive | N |
Is Signed | U |
Is Key Column | N |
Is Unique | N |
Is Expression | N |
Is Sortable | N |
Parameter Type | U |
Struct Depth | 0 |
Is Temporal Column | 0 |
UDT Attribute Name | |
Server Data Type Code | 517 (DATASET STORAGE FORMAT Avro, nullable) |
Array Number of Dims | 0 |