hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Wei Zheng (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-13186) ALTER TABLE RENAME should lowercase table name and hdfs location
Date Mon, 29 Feb 2016 23:32:18 GMT

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

Wei Zheng commented on HIVE-13186:
----------------------------------

Operations related to table creation will normally lowercase the db/table names before doing
certain tasks.

But for ALTER TABLE things are different. Specifically, if a table is renamed and given a
new mixed-case name, HDFS directory is created with mixed case as is. That is not consistent
to CREATE TABLE behavior. Moreover, this will cause issue for example if users want to load
data directly to HDFS under the table directory, or use some scripts to check data size on
HDFS path.

Example
{code}
hive> create table OldName (a int);
OK
Time taken: 3.125 seconds
hive> desc formatted oldname;
OK
# col_name            	data_type           	comment

a                   	int

# Detailed Table Information
Database:           	default
Owner:              	hive
CreateTime:         	Mon Feb 29 23:29:33 UTC 2016
LastAccessTime:     	UNKNOWN
Protect Mode:       	None
Retention:          	0
Location:           	hdfs://sandbox.hortonworks.com:8020/apps/hive/warehouse/oldname
Table Type:         	MANAGED_TABLE
Table Parameters:
	transient_lastDdlTime	1456788573

# Storage Information
SerDe Library:      	org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
InputFormat:        	org.apache.hadoop.mapred.TextInputFormat
OutputFormat:       	org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Compressed:         	No
Num Buckets:        	-1
Bucket Columns:     	[]
Sort Columns:       	[]
Storage Desc Params:
	serialization.format	1
Time taken: 0.754 seconds, Fetched: 26 row(s)
hive> alter table oldname rename to newName;
OK
Time taken: 1.625 seconds
hive> desc formatted newname;
OK
# col_name            	data_type           	comment

a                   	int

# Detailed Table Information
Database:           	default
Owner:              	hive
CreateTime:         	Mon Feb 29 23:29:33 UTC 2016
LastAccessTime:     	UNKNOWN
Protect Mode:       	None
Retention:          	0
Location:           	hdfs://sandbox.hortonworks.com:8020/apps/hive/warehouse/newName
Table Type:         	MANAGED_TABLE
Table Parameters:
	last_modified_by    	hive
	last_modified_time  	1456788604
	transient_lastDdlTime	1456788604

# Storage Information
SerDe Library:      	org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
InputFormat:        	org.apache.hadoop.mapred.TextInputFormat
OutputFormat:       	org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Compressed:         	No
Num Buckets:        	-1
Bucket Columns:     	[]
Sort Columns:       	[]
Storage Desc Params:
	serialization.format	1
Time taken: 0.485 seconds, Fetched: 28 row(s)
{code}

> ALTER TABLE RENAME should lowercase table name and hdfs location
> ----------------------------------------------------------------
>
>                 Key: HIVE-13186
>                 URL: https://issues.apache.org/jira/browse/HIVE-13186
>             Project: Hive
>          Issue Type: Bug
>          Components: Hive
>    Affects Versions: 2.0.0
>            Reporter: Wei Zheng
>            Assignee: Wei Zheng
>




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

Mime
View raw message