Lens Server: x_storage_table

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>

Namespace: uri:lens:cube:0.1
Schema: ns2.xsd

Properties
name	data type	type	namespace	min/max occurs
collection_delimiter	string	attribute		0/1
compressed	boolean	attribute		0/1
escape_char	string	attribute		0/1
external	boolean	attribute		1/1
field_delimiter	string	attribute		0/1
input_format	string	attribute		0/1
line_delimiter	string	attribute		0/1
map_key_delimiter	string	attribute		0/1
num_buckets	int	attribute		0/1
output_format	string	attribute		0/1
serde_class_name	string	attribute		0/1
storage_handler_name	string	attribute		0/1
table_location	anyURI	attribute		0/1
bucket_cols	string	element	ns2	0/unbounded
part_cols	x_columns	element	ns2	0/1
serde_parameters	x_properties	element	ns2	0/1
skewed_info	x_skewed_info	element	ns2	0/unbounded
sort_col_order	int	element	ns2	0/unbounded
sort_cols	string	element	ns2	0/unbounded
table_parameters	x_properties	element	ns2	0/1
time_part_cols	string	element	ns2	0/unbounded

Example

<x----- collection_delimiter="..." compressed="..." escape_char="..." external="..." field_delimiter="..." input_format="..." line_delimiter="..." map_key_delimiter="..." num_buckets="..." output_format="..." serde_class_name="..." storage_handler_name="..." table_location="..." xmlns="uri:lens:cube:0.1">
  <part_cols>
    <column _type="..." comment="..." end_time="..." name="..." start_time="..."/>
  </part_cols>
  <table_parameters>
    <property name="..." value="..."/>
  </table_parameters>
  <serde_parameters>
    <property name="..." value="..."/>
  </serde_parameters>
  <bucket_cols>...</bucket_cols>
  <sort_cols>...</sort_cols>
  <sort_col_order>...</sort_col_order>
  <skewed_info>
    <col_names>...</col_names>
    <col_values>
      <elements>...</elements>
    </col_values>
    <value_location_map location="...">
      <value/>
    </value_location_map>
  </skewed_info>
  <time_part_cols>...</time_part_cols>
</x----->

x_storage_table_desc Data Type