phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "suprita bothra (JIRA)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-4330) To alter colomn length of a phoenix table withouht losing existing data in table
Date Mon, 30 Oct 2017 07:10:01 GMT
suprita bothra created PHOENIX-4330:
---------------------------------------

             Summary: To alter colomn length of a phoenix table withouht losing existing data
in table
                 Key: PHOENIX-4330
                 URL: https://issues.apache.org/jira/browse/PHOENIX-4330
             Project: Phoenix
          Issue Type: Bug
            Reporter: suprita bothra


Hi ,

I am using apache phoenix to create table and then dump csv data into table.
But now I want to alter one colomn’s datatype length from varchar(7) to varchar(14),without
losing the existing data into table.

Can it be done?
If yes how?

I tried the command to address the above mentioned issue but
ALTER TABLE G1V3IN_ADITI ALTER "INVOICE"."SBNUM" set data type varchar(15), column "INVOICE"."SBNUM"
drop default;

Where sbnum is the colomn whose existing datatype length is 7 but we want to change it to
15.
G1V3IN_ADITI is table name.

But facing the below error:
Error: ERROR 601 (42P00): Syntax error. Encountered "ALTER" at line 1, column 26. (state=42P00,code=601)
org.apache.phoenix.exception.PhoenixParserException: ERROR 601 (42P00): Syntax error. Encountered
"ALTER" at line 1, column 26.
        at org.apache.phoenix.exception.PhoenixParserException.newException(PhoenixParserException.java:33)
        at org.apache.phoenix.parse.SQLParser.parseStatement(SQLParser.java:111)
        at org.apache.phoenix.jdbc.PhoenixStatement$PhoenixStatementParser.parseStatement(PhoenixStatement.java:1283)
        at org.apache.phoenix.jdbc.PhoenixStatement.parseStatement(PhoenixStatement.java:1364)
        at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1427)
        at sqlline.Commands.execute(Commands.java:822)
        at sqlline.Commands.sql(Commands.java:732)
        at sqlline.SqlLine.dispatch(SqlLine.java:808)
        at sqlline.SqlLine.begin(SqlLine.java:681)
        at sqlline.SqlLine.start(SqlLine.java:398)
        at sqlline.SqlLine.main(SqlLine.java:292)
Caused by: NoViableAltException(7@[])
        at org.apache.phoenix.parse.PhoenixSQLParser.from_table_name(PhoenixSQLParser.java:9081)
        at org.apache.phoenix.parse.PhoenixSQLParser.alter_table_node(PhoenixSQLParser.java:3229)
        at org.apache.phoenix.parse.PhoenixSQLParser.oneStatement(PhoenixSQLParser.java:846)
        at org.apache.phoenix.parse.PhoenixSQLParser.statement(PhoenixSQLParser.java:499)
        at org.apache.phoenix.parse.SQLParser.parseStatement(SQLParser.java:108)
        ... 9 more




Thanks
Suprita Bothra




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message