hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "laxdeep bomble (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-12593) spelling mistake in Alter table script to change 'collection items terminated by' value
Date Fri, 04 Dec 2015 12:57:10 GMT
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)

Mime
View raw message