phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "suprita (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-4234) Unable to find failed csv records in phoenix logs
Date Mon, 30 Oct 2017 07:09:00 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-4234?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16224439#comment-16224439
] 

suprita commented on PHOENIX-4234:
----------------------------------

Hi Ankit,

Once I Got a response from you regarding phoenix.

Actually I want a quick response ,so posting you my query personally if you could answer this
along  with posting on Jira group to get immediate response if possible for you.

My doubt is described below:

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

Please help to solve this.

It would be great help if I get some solution ASAP for this.


Thanks
Suprita Bothra






> Unable to find failed csv records in phoenix logs
> -------------------------------------------------
>
>                 Key: PHOENIX-4234
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-4234
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: suprita bothra
>
> Unable to fetch missing records information in phoenix table.How can we fetch the missing
records info.
> Like while parsing csv into hbase via bulkloading via mapreduce,and using --igonre-errors
 option to parse csv.
> So csv records having error are skipped but we are unable to fetch the info of records
which are skipped/failed and dint go into table.
> There must be logs of such information .Please help in identifying if we can get logs
of failed records



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

Mime
View raw message