[jira] [Updated] (CARBONDATA-4179) Support renaming of complex columns

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Updated] (CARBONDATA-4179) Support renaming of complex columns

Akash R Nilugal (Jira)

     [ https://issues.apache.org/jira/browse/CARBONDATA-4179?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Akshay updated CARBONDATA-4179:
-------------------------------
    Description:
Complex columns supported for - *array and struct.*

For schema lets say- *str struct<a:int>* the following points will be considered   - 

1) Rename parent name *str to str2* 

alter table test_rename change str str2 struct<a:int>

 

2) Rename child name from *a to b*

alter table test_rename change str str struct<b:int>

 

*NOTE-*
Rename operation fails if the structure of the complex column has been altered. This check ensures the old and new columns are compatible with each other. Meaning the *number of children* and *complex levels* should be unaltered while attempting to rename.

  was:
Complex columns supported for - *array and struct.*

For schema lets say- *str struct<a:int>* the following points will be considered   - 

1) Rename parent name *str to str2* 

alter table test_rename change str str2 struct<a:int>

 

2) Rename child name from *a to b*

alter table test_rename change str str struct<b:int>

 

3) Change datatype of *a* from *int to long*

alter table test_rename change str str struct<a:long>

 

*NOTE*- Renaming and changing datatype both operations should be done without changing the levels of the complex column. For example :

1) int cannot be converted to an array or struct.

2) array cannot be converted to struct and vice-versa


> Support renaming of complex columns
> -----------------------------------
>
>                 Key: CARBONDATA-4179
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-4179
>             Project: CarbonData
>          Issue Type: Sub-task
>            Reporter: Akshay
>            Priority: Major
>
> Complex columns supported for - *array and struct.*
> For schema lets say- *str struct<a:int>* the following points will be considered   - 
> 1) Rename parent name *str to str2* 
> alter table test_rename change str str2 struct<a:int>
>  
> 2) Rename child name from *a to b*
> alter table test_rename change str str struct<b:int>
>  
> *NOTE-*
> Rename operation fails if the structure of the complex column has been altered. This check ensures the old and new columns are compatible with each other. Meaning the *number of children* and *complex levels* should be unaltered while attempting to rename.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)