[
https://issues.apache.org/jira/browse/HIVE-14531?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16305898#comment-16305898
]
priyanka gupta commented on HIVE-14531:
---------------------------------------
Did you find any solution? I am facing the same issue and setting
hive.serialization.extend.nesting.levels is not working.
> 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)
