phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abel Fernández <mevsmys...@gmail.com>
Subject Re: ERROR 1013 (42M04): Table already exists. tableName=CARDS.TRANSACTIONS (state=42M04,code=1013)
Date Fri, 11 Nov 2016 23:15:35 GMT
Hello again,

I fixed the issue with the table.

What I did is manually upsert system.catalog with some values of my table
then I have realized that I could see the table using the phoenix shell. I
could delete the table and finally I could create it again.

Regards,
Abel

On 11 November 2016 at 22:36, Abel Fernández <mevsmyself@gmail.com> wrote:

> Good Evening,
>
> I am having some problems when I am trying to create a table.
>
> I have deleted the table 'CARDS.TRANSACTIONS' from 'SYSTEM.CATALOG' and
> from hbase, using the hbase shell (disable and drop).
>
> The table I am trying to create is not listed when I use the phoenix shell
> (!tables) and there is not entry for this table in SYSTEM CATALOG, but when
> I run the sql create, apache phoenix is returning the below error:
>
> Error: ERROR 1013 (42M04): Table already exists.
> tableName=CARDS.TRANSACTIONS (state=42M04,code=1013)
> org.apache.phoenix.schema.TableAlreadyExistsException: ERROR 1013
> (42M04): Table already exists. tableName=CARDS.TRANSACTIONS
> at org.apache.phoenix.schema.MetaDataClient.createTableInternal(
> MetaDataClient.java:1946)
> at org.apache.phoenix.schema.MetaDataClient.createTable(
> MetaDataClient.java:751)
> at org.apache.phoenix.compile.CreateTableCompiler$2.execute(
> CreateTableCompiler.java:186)
> at org.apache.phoenix.jdbc.PhoenixStatement$2.call(
> PhoenixStatement.java:320)
> at org.apache.phoenix.jdbc.PhoenixStatement$2.call(
> PhoenixStatement.java:312)
> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
> at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(
> PhoenixStatement.java:310)
> at org.apache.phoenix.jdbc.PhoenixStatement.execute(
> PhoenixStatement.java:1433)
> 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)
>
> After run the sql query to create the table I can see the table in hbase
> shell but no in apache phoenix.
>
> Does someone know how to do to show the table using the phoenix shell?
>
> Thanks in advance.
> Regards.
> Abel.
>

Mime
View raw message