[jira] [Commented] (HIVE-14531) Support deep nested struct for INSERT OVER DIRECTORY

["priyanka gupta (JIRA)" <ji...@apache.org>]

    [ 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)