hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Barna Zsombor Klara (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-16720) Reorder columns in Hive parquet tables
Date Mon, 22 May 2017 16:49:04 GMT

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

Barna Zsombor Klara commented on HIVE-16720:
--------------------------------------------

As a workaround are you fine with cascading your changes to the partitions?
So using  ALTER TABLE test_parquet REPLACE COLUMNS (age int,name string, dept string, salary
string) *CASCADE*;


> Reorder columns in Hive parquet tables
> --------------------------------------
>
>                 Key: HIVE-16720
>                 URL: https://issues.apache.org/jira/browse/HIVE-16720
>             Project: Hive
>          Issue Type: Bug
>          Components: Hive
>    Affects Versions: 1.1.0
>            Reporter: Venkata Karthik Penikalapati
>
> We are using hive 1.1.0 have a requirement to reorder columns for one of huge table with
100's of columns for user readability. But when we reorder columns in table its failing with
below error.
> hive> desc test_parquet;
> OK
> name                    string
> age                     int
> dept                    string
> salary                  string
> city                    string
> # Partition Information
> # col_name              data_type               comment
> city                    string
> Time taken: 0.053 seconds, Fetched: 10 row(s)
> hive> ALTER TABLE test_parquet REPLACE COLUMNS (age int,name string, dept string,
salary string);
> OK
> Time taken: 0.451 seconds
> hive> desc test_parquet;
> OK
> age                     int
> name                    string
> dept                    string
> salary                  string
> city                    string
> # Partition Information
> # col_name              data_type               comment
> city                    string
> Time taken: 0.051 seconds, Fetched: 10 row(s)
> hive> select * from test_parquet;
> OK
> Failed with exception java.io.IOException:java.lang.UnsupportedOperationException: Cannot
inspect org.apache.hadoop.io.IntWritable
> Time taken: 0.121 seconds



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message