[
https://issues.apache.org/jira/browse/HIVE-365?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12847048#action_12847048
]
Zheng Shao commented on HIVE-365:
---------------------------------
I am thinking something like:
{code}
CREATE TABLE nested(array_of_arrays ARRAY < ARRAY <INT>>, map_of_maps MAP <
STRING, MAP < INT, INT> > )
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\001' '\002' '\003' '\004' '\005';
{code}
Basically allowing multiple separators after "FIELDS TERMINATED".
The top level (fields) consumes 1 level of separators. Each level of array
consumes 1 level of separators, while each level of map consumes 2.
> Create Table to support multiple levels of delimiters
> -----------------------------------------------------
>
> Key: HIVE-365
> URL: https://issues.apache.org/jira/browse/HIVE-365
> Project: Hadoop Hive
> Issue Type: New Feature
> Reporter: Zheng Shao
>
> From HIVE-337, the SerDe layer now supports multiple-levels of delimiters,
> for the purpose of supporting nested map/array/struct.
> Array(the same as List) and struct consume a single level of separator, and
> Map consumes 2 levels.
> DDL (Create Table) needs to allow users to specify multiple levels of
> delimiters in order to take the advantage of this new feature.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
