[
https://issues.apache.org/jira/browse/HIVE-14531?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16315422#comment-16315422
]
Chao Sun commented on HIVE-14531:
---------------------------------
[~priyagupta]: I think this may work:
{code}
INSERT OVERWRITE DIRECTORY <dir> ROW FORMAT SERDE
'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' WITH SERDEPROPERTIES
('hive.serialization.extend.nesting.levels' = 'true') SELECT * FROM
<table_with_deeply_nested_columns>
{code}
> Support deep nested struct for INSERT OVER DIRECTORY
> ----------------------------------------------------
>
> Key: HIVE-14531
> URL: https://issues.apache.org/jira/browse/HIVE-14531
> Project: Hive
> Issue Type: Bug
> Components: Query Processor, Serializers/Deserializers
> Affects Versions: 2.2.0
> Reporter: Chao Sun
> Assignee: Wei Yan
>
> Currently if we do something similar to:
> {code}
> INSERT OVERWRITE DIRECTORY <dir> SELECT * FROM
> <table_with_deeply_nested_columns>
> {code}
> Then Hive may fail with error message like this:
> {code}
> Error: Error while compiling statement: FAILED: SemanticException
> org.apache.hadoop.hive.serde2.SerDeException: Number of levels of nesting
> supported for LazySimpleSerde is 7 Unable to work with level 8. Use
> hive.serialization.extend.nesting.levels serde property for tables using
> LazySimpleSerde. (state=42000,code=40000)
> {code}
> It seems there's no way to set serde properties in this case.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
