phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abel Fernández <mevsmys...@gmail.com>
Subject ERROR 1013 (42M04): Table already exists. tableName=CARDS.TRANSACTIONS (state=42M04,code=1013)
Date Fri, 11 Nov 2016 22:36:42 GMT
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