hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "priyanka gupta (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-14531) Support deep nested struct for INSERT OVER DIRECTORY
Date Fri, 29 Dec 2017 02:03:01 GMT

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

Mime
View raw message