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 |