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.
