This project has retired. For details please refer to its Attic page.
Lens Server: XStorageTableDesc

XStorageTableDesc Data Type

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>
 

Properties
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" : [ [ "...", "..." ], [ "...", "..." ] ]
}