hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sergio Peña (JIRA) <j...@apache.org>
Subject [jira] [Commented] (HIVE-12608) Parquet Schema Evolution doesn't work when a column is dropped from array<struct<>>
Date Tue, 08 Dec 2015 17:45:10 GMT

    [ https://issues.apache.org/jira/browse/HIVE-12608?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15047134#comment-15047134
] 

Sergio Peña commented on HIVE-12608:
------------------------------------

Thanks [~kamrul]. The patch looks good and easy.
+1

> Parquet Schema Evolution doesn't work when a column is dropped from array<struct<>>
> -----------------------------------------------------------------------------------
>
>                 Key: HIVE-12608
>                 URL: https://issues.apache.org/jira/browse/HIVE-12608
>             Project: Hive
>          Issue Type: Bug
>          Components: File Formats
>            Reporter: Mohammad Kamrul Islam
>            Assignee: Mohammad Kamrul Islam
>         Attachments: HIVE-12608.1.patch
>
>
> When a column is dropped from array<struct<>>, I got the following exception.
> I used the following sql to test it.
> {quote}
> CREATE TABLE arrays_of_struct_to_map (locations1 array<struct<c1:int,c2:int>>,
locations2 array<struct<f1:int,
> f2:int,f3:int>>) STORED AS PARQUET;
> INSERT INTO TABLE arrays_of_struct_to_map select array(named_struct("c1",1,"c2",2)),
array(named_struct("f1",
> 77,"f2",88,"f3",99)) FROM parquet_type_promotion LIMIT 1;
> SELECT * FROM arrays_of_struct_to_map;
> -- Testing schema evolution of dropping column from array<struct<>>
> ALTER TABLE arrays_of_struct_to_map REPLACE COLUMNS (locations1 array<struct<c1:int>>,
locations2
> array<struct<f2:int>>);
> SELECT * FROM arrays_of_struct_to_map;
> {quote}
> {quote}
> 2015-12-07 11:47:28,503 ERROR [main]: CliDriver (SessionState.java:printError(921)) -
Failed with exception java.io.IOException:java.lang.RuntimeException: cannot find field c2
in [c1]
> java.io.IOException: java.lang.RuntimeException: cannot find field c2 in [c1]
>         at org.apache.hadoop.hive.ql.exec.FetchOperator.getNextRow(FetchOperator.java:507)
>         at org.apache.hadoop.hive.ql.exec.FetchOperator.pushRow(FetchOperator.java:414)
>         at org.apache.hadoop.hive.ql.exec.FetchTask.fetch(FetchTask.java:138)
>         at org.apache.hadoop.hive.ql.Driver.getResults(Driver.java:1655)
>         at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:227)
>         at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:159)
>         at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:370)
>         at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:305)
>         at org.apache.hadoop.hive.ql.QTestUtil.executeClientInternal(QTestUtil.java:1029)
>         at org.apache.hadoop.hive.ql.QTestUtil.executeClient(QTestUtil.java:1003)
>         at org.apache.hadoop.hive.cli.TestCliDriver.runTest(TestCliDriver.java:139)
>         at org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_parquet_type_promotion(TestCliDriver.java:123)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>         at java.lang.reflect.Method.invoke(Method.java:606)
>         at junit.framework.TestCase.runTest(TestCase.java:176)
>         at junit.framework.TestCase.runBare(TestCase.java:141)
>         at junit.framework.TestResult$1.protect(TestResult.java:122)
>         at junit.framework.TestResult.runProtected(TestResult.java:142)
>         at junit.framework.TestResult.run(TestResult.java:125)
>         at junit.framework.TestCase.run(TestCase.java:129)
>         at junit.framework.TestSuite.runTest(TestSuite.java:255)
>         at junit.framework.TestSuite.run(TestSuite.java:250)
>         at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:84)
>         at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:264)
>         at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:153)
>         at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:124)
>         at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:200)
>         at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:153)
>         at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:103)
> Caused by: java.lang.RuntimeException: cannot find field c2 in [c1]
>         at org.apache.hadoop.hive.ql.io.parquet.convert.HiveStructConverter.getStructFieldTypeInfo(HiveStructConverter.java:130)
>         at org.apache.hadoop.hive.ql.io.parquet.convert.HiveStructConverter.getFieldTypeIgnoreCase(HiveStructConverter.java:103)
>         at org.apache.hadoop.hive.ql.io.parquet.convert.HiveStructConverter.init(HiveStructConverter.java:90)
>         at org.apache.hadoop.hive.ql.io.parquet.convert.HiveStructConverter.<init>(HiveStructConverter.java:67)
>         at org.apache.hadoop.hive.ql.io.parquet.convert.HiveStructConverter.<init>(HiveStructConverter.java:59)
>         at org.apache.hadoop.hive.ql.io.parquet.convert.HiveGroupConverter.getConverterFromDescription(HiveGroupConverter.java:63)
>         at org.apache.hadoop.hive.ql.io.parquet.convert.HiveGroupConverter.getConverterFromDescription(HiveGroupConverter.java:75)
>         at org.apache.hadoop.hive.ql.io.parquet.convert.HiveCollectionConverter$ElementConverter.<init>(HiveCollectionConverter.java:141)
>         at org.apache.hadoop.hive.ql.io.parquet.convert.HiveCollectionConverter.<init>(HiveCollectionConverter.java:52)
> {quote}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message