[
https://issues.apache.org/jira/browse/HIVE-16720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Venkata Karthik Penikalapati updated HIVE-16720:
------------------------------------------------
Description:
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
was:
We are using hive 1.3 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
> 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)
