Created 01-29-2016 10:46 PM
I'm connecting to Phoenix Query Server via the following:
/usr/hdp/current/phoenix-client/bin/sqlline.py hbasemaster:2181:/hbase-unsecure
I'm able successfully connect. I then create a table using:
create table mytable (id varchar not null primary key, mycolumn varchar);
That command seems to run successfully. However, when I try to verify the table exists via:
!tables
I don't see my table listed. When I try to use sql as a verification via:
select * from mytable;
I get a "TableNotFoundException". If I try to create the table again, I get an error that the table already exists. If I look a the HBase Master UI, I can see the table exists in HBase. I'm confused. What am I missing here?
I'm running HDP 2.3.2
Created 01-29-2016 10:57 PM
Are you using Phoenix query server? Try accessing table using sqlline.py if you are using pqs
I had same issue with PQS
Created 01-29-2016 11:11 PM
@Michael Young try $PHONEIX_HOME/bin/sqlline.py <hostname>:2181:/<hbase-unsecure>
Created 01-29-2016 11:17 PM
That is how I'm connecting. I have updated my original question to show that. I can connect fine.
Created 01-29-2016 11:22 PM
Created 01-29-2016 11:31 PM
While I appreciate your sharing the link, it doesn't cover anything related to my question.
Created 01-29-2016 11:39 PM
That link has example of using sqlline.py ..Let me reproduce this again.
Can you share your connecting string ? @Michael Young
Created 01-29-2016 11:51 PM
My connect string is show at the top of my original post. I'm able to connect fine.
Created 01-29-2016 11:39 PM
Can you try enabling log4j DEBUG by editing /usr/hdp/current/phoenix-client/bin/log4j.properties? Set psql.root.logger=DEBUG,console and log4j.threshold=DEBUG, I believe they would be at INFO or WARN by default.