You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Chaoyu Tang (JIRA)" <ji...@apache.org> on 2015/09/11 15:01:45 UTC
[jira] [Assigned] (HIVE-11797) Alter table change columnname
doesn't work on avro serde hive table
[ https://issues.apache.org/jira/browse/HIVE-11797?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Chaoyu Tang reassigned HIVE-11797:
----------------------------------
Assignee: Chaoyu Tang
> Alter table change columnname doesn't work on avro serde hive table
> -------------------------------------------------------------------
>
> Key: HIVE-11797
> URL: https://issues.apache.org/jira/browse/HIVE-11797
> Project: Hive
> Issue Type: Bug
> Reporter: Joy SN
> Assignee: Chaoyu Tang
>
> We create a table using Avro serde
> Hive table name hive_t1.
> Then we try to change the column name.
> The commands ends successfully but the name of the column is not modified.
> create table if not exists hive_t1
> partitioned by (p1 int)
> row format SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe'
> STORED AS
> INPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat'
> OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat'
> TBLPROPERTIES ('avro.schema.literal'='{
> "namespace": "testing.hive.avro.serde",
> "name": "avro_table",
> "type": "record",
> "fields": [
> {
> "name":"number",
> "type":"int",
> "doc":"Order of playing the role"
> },
> {
> "name":"first_name",
> "type":"string",
> "doc":"first name of actor playing role"
> },
> {
> "name":"last_name",
> "type":"string",
> "doc":"last name of actor playing role"
> },
> {
> "name":"extra_field",
> "type":"string",
> "doc:":"an extra field not in the original file",
> "default":"fishfingers and custard"
> }
> ]
> }');
> hive> alter table hive_t1 change column number number1 int;
> OK
> Time taken: 0.12 seconds
> hive> select * from hive_t1 limit 5;
> OK
> hive_t1.number hive_t1.first_name hive_t1.last_name hive_t1.extra_field hive_t1.p1
> 6 Colin Baker fishfingers and custard 100
> 3 Jon Pertwee fishfingers and custard 100
> 4 Tom Baker fishfingers and custard 100
> 5 Peter Davison fishfingers and custard 100
> 11 Matt Smith fishfingers and custard 100
> Time taken: 0.05 seconds, Fetched: 5 row(s)
> hive> describe hive_t1;
> OK
> col_name data_type comment
> number int from deserializer
> first_name string from deserializer
> last_name string from deserializer
> extra_field string from deserializer
> p1 int
>
> # Partition Information
> # col_name data_type comment
>
> p1 int
> Time taken: 0.051 seconds, Fetched: 10 row(s)
> -- Using the below command also the column name is not changed from "number" to "number1"
> hive> alter table hive_t1 change number number1 int;
> OK
> Time taken: 0.081 seconds
> hive> describe hive_t1;
> OK
> col_name data_type comment
> number int from deserializer
> first_name string from deserializer
> last_name string from deserializer
> extra_field string from deserializer
> p1 int
>
> # Partition Information
> # col_name data_type comment
>
> p1 int
> Time taken: 0.054 seconds, Fetched: 10 row(s)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)