[CARBONDATA-2131] Alter table adding long datatype is failing but Create table with long type is successful, in Spark 2.1

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.3.0, 1.3.1
• Assignee: dhatchayani
• Reporter: dhatchayani
• Created: 05/Feb/18 09:19
• Updated: 04/Mar/18 11:48
• Resolved: 08/Feb/18 06:46

Description

create table test4(a1 int) stored by 'carbondata';
 ---------+
 | Result  |
 ---------+
 ---------+
 No rows selected (1.757 seconds)
**

 

alter table test4 add columns (a6 long);

 Error: java.lang.RuntimeException:
 BaseSqlParser>>>> == Parse1 ==

 

Operation not allowed: alter table add columns(line 1, pos 0)

 

== SQL ==
 alter table test4 add columns (a6 long)
 ^^^

 

== Parse2 ==
 [1.35] failure: identifier matching regex (?i)VARCHAR expected

 

alter table test4 add columns (a6 long)
                                   ^;
 CarbonSqlParser>>>> [1.35] failure: identifier matching regex (?i)VARCHAR expected

 

alter table test4 add columns (a6 long)
                                   ^ (state=,code=0)

Issue Links

• links to: GitHub Pull Request #1932