The storage table description specifies the underlying format wrt how to read/write data. See https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-Create/Drop/TruncateTable
Java class for x_storage_table_desc complex type.
The following schema fragment specifies the expected content contained within this class.
<complexType name="x_storage_table_desc">
<complexContent>
<restriction base="{http://www.w3.org/2001/XMLSchema}anyType">
<sequence>
<element name="part_cols" type="{uri:lens:cube:0.1}x_columns" minOccurs="0"/>
<element name="table_parameters" type="{uri:lens:cube:0.1}x_properties" minOccurs="0"/>
<element name="serde_parameters" type="{uri:lens:cube:0.1}x_properties" minOccurs="0"/>
<element name="bucket_cols" type="{http://www.w3.org/2001/XMLSchema}string" maxOccurs="unbounded" minOccurs="0"/>
<element name="sort_cols" type="{http://www.w3.org/2001/XMLSchema}string" maxOccurs="unbounded" minOccurs="0"/>
<element name="sort_col_order" type="{http://www.w3.org/2001/XMLSchema}int" maxOccurs="unbounded" minOccurs="0"/>
<element name="skewed_info" type="{uri:lens:cube:0.1}x_skewed_info" maxOccurs="unbounded" minOccurs="0"/>
<element name="time_part_cols" type="{http://www.w3.org/2001/XMLSchema}string" maxOccurs="unbounded" minOccurs="0"/>
</sequence>
<attribute name="external" use="required" type="{http://www.w3.org/2001/XMLSchema}boolean" />
<attribute name="table_location" type="{http://www.w3.org/2001/XMLSchema}anyURI" />
<attribute name="input_format" type="{http://www.w3.org/2001/XMLSchema}string" />
<attribute name="output_format" type="{http://www.w3.org/2001/XMLSchema}string" />
<attribute name="field_delimiter" type="{http://www.w3.org/2001/XMLSchema}string" />
<attribute name="escape_char" type="{http://www.w3.org/2001/XMLSchema}string" />
<attribute name="collection_delimiter" type="{http://www.w3.org/2001/XMLSchema}string" />
<attribute name="line_delimiter" type="{http://www.w3.org/2001/XMLSchema}string" />
<attribute name="map_key_delimiter" type="{http://www.w3.org/2001/XMLSchema}string" />
<attribute name="serde_class_name" type="{http://www.w3.org/2001/XMLSchema}string" />
<attribute name="storage_handler_name" type="{http://www.w3.org/2001/XMLSchema}string" />
<attribute name="num_buckets" type="{http://www.w3.org/2001/XMLSchema}int" />
<attribute name="compressed" type="{http://www.w3.org/2001/XMLSchema}boolean" />
</restriction>
</complexContent>
</complexType>
| name | data type | description |
|---|---|---|
| external | boolean | |
| part_cols | XColumns | |
| table_parameters | XProperties | |
| serde_parameters | XProperties | |
| bucket_cols | array of array of string | |
| sort_cols | array of array of string | |
| sort_col_order | array of array of number | |
| skewed_info | array of array of XSkewedInfo | |
| time_part_cols | array of array of string |
Example
{
"external" : true,
"part_cols" : {
"column" : [ [ {
"name" : "...",
"_type" : "...",
"comment" : "...",
"start_time" : "...",
"end_time" : "..."
}, {
"name" : "...",
"_type" : "...",
"comment" : "...",
"start_time" : "...",
"end_time" : "..."
} ], [ {
"name" : "...",
"_type" : "...",
"comment" : "...",
"start_time" : "...",
"end_time" : "..."
}, {
"name" : "...",
"_type" : "...",
"comment" : "...",
"start_time" : "...",
"end_time" : "..."
} ] ]
},
"table_parameters" : {
"property" : [ [ {
"name" : "...",
"value" : "..."
}, {
"name" : "...",
"value" : "..."
} ], [ {
"name" : "...",
"value" : "..."
}, {
"name" : "...",
"value" : "..."
} ] ]
},
"serde_parameters" : {
"property" : [ [ {
"name" : "...",
"value" : "..."
}, {
"name" : "...",
"value" : "..."
} ], [ {
"name" : "...",
"value" : "..."
}, {
"name" : "...",
"value" : "..."
} ] ]
},
"bucket_cols" : [ [ "...", "..." ], [ "...", "..." ] ],
"sort_cols" : [ [ "...", "..." ], [ "...", "..." ] ],
"sort_col_order" : [ [ 12345, 12345 ], [ 12345, 12345 ] ],
"skewed_info" : [ [ {
"col_names" : [ [ "...", "..." ], [ "...", "..." ] ],
"col_values" : [ [ {
"elements" : [ [ "...", "..." ], [ "...", "..." ] ]
}, {
"elements" : [ [ "...", "..." ], [ "...", "..." ] ]
} ], [ {
"elements" : [ [ "...", "..." ], [ "...", "..." ] ]
}, {
"elements" : [ [ "...", "..." ], [ "...", "..." ] ]
} ] ],
"value_location_map" : [ [ {
"location" : "...",
"value" : { }
}, {
"location" : "...",
"value" : { }
} ], [ {
"location" : "...",
"value" : { }
}, {
"location" : "...",
"value" : { }
} ] ]
}, {
"col_names" : [ [ "...", "..." ], [ "...", "..." ] ],
"col_values" : [ [ {
"elements" : [ [ "...", "..." ], [ "...", "..." ] ]
}, {
"elements" : [ [ "...", "..." ], [ "...", "..." ] ]
} ], [ {
"elements" : [ [ "...", "..." ], [ "...", "..." ] ]
}, {
"elements" : [ [ "...", "..." ], [ "...", "..." ] ]
} ] ],
"value_location_map" : [ [ {
"location" : "...",
"value" : { }
}, {
"location" : "...",
"value" : { }
} ], [ {
"location" : "...",
"value" : { }
}, {
"location" : "...",
"value" : { }
} ] ]
} ], [ {
"col_names" : [ [ "...", "..." ], [ "...", "..." ] ],
"col_values" : [ [ {
"elements" : [ [ "...", "..." ], [ "...", "..." ] ]
}, {
"elements" : [ [ "...", "..." ], [ "...", "..." ] ]
} ], [ {
"elements" : [ [ "...", "..." ], [ "...", "..." ] ]
}, {
"elements" : [ [ "...", "..." ], [ "...", "..." ] ]
} ] ],
"value_location_map" : [ [ {
"location" : "...",
"value" : { }
}, {
"location" : "...",
"value" : { }
} ], [ {
"location" : "...",
"value" : { }
}, {
"location" : "...",
"value" : { }
} ] ]
}, {
"col_names" : [ [ "...", "..." ], [ "...", "..." ] ],
"col_values" : [ [ {
"elements" : [ [ "...", "..." ], [ "...", "..." ] ]
}, {
"elements" : [ [ "...", "..." ], [ "...", "..." ] ]
} ], [ {
"elements" : [ [ "...", "..." ], [ "...", "..." ] ]
}, {
"elements" : [ [ "...", "..." ], [ "...", "..." ] ]
} ] ],
"value_location_map" : [ [ {
"location" : "...",
"value" : { }
}, {
"location" : "...",
"value" : { }
} ], [ {
"location" : "...",
"value" : { }
}, {
"location" : "...",
"value" : { }
} ] ]
} ] ],
"time_part_cols" : [ [ "...", "..." ], [ "...", "..." ] ]
}