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 <[email protected]> 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. >
