hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Venkata Karthik Penikalapati (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-16720) Reorder columns in Hive parquet tables
Date Fri, 19 May 2017 18:23:04 GMT
Venkata Karthik Penikalapati created HIVE-16720:
---------------------------------------------------

             Summary: 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.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



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

Mime
View raw message