laxdeep bomble created HIVE-12593: ------------------------------------- Summary: spelling mistake in Alter table script to change 'collection items terminated by' value Key: HIVE-12593 URL: https://issues.apache.org/jira/browse/HIVE-12593 Project: Hive Issue Type: Bug Components: Hive Reporter: laxdeep bomble Priority: Minor
Step 1: create table using following script: create table customer (arr array<string>) row format delimited collection items terminated by '$' Step2: Alter the table using following script: ALTER TABLE customer SET SERDEPROPERTIES ('collection.delim'='%') Step3: Execute the 'show create table customer' command. It is observed that the 'collection items terminated by' value is not gets changed. Step4: Execute the following command: ALTER TABLE customer SET SERDEPROPERTIES ('colelction.delim' = '%'); Step5: Observe the 'show create table customer' result: 'collection items terminated by' value is reflected. -- This message was sent by Atlassian JIRA (v6.3.4#6332)