Phoenix - Create Table Question

[#1]

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

[#2]

@Michael Young try $PHONEIX_HOME/bin/sqlline.py <hostname>:2181:/<hbase-unsecure>

[#3]

That is how I'm connecting. I have updated my original question to show that. I can connect fine.

[#4]

@Michael Young

This is good intro

https://www.linkedin.com/pulse/apache-phoenix-quick-intro-neeraj-sabharwal

[#5]

While I appreciate your sharing the link, it doesn't cover anything related to my question.

[#6]

That link has example of using sqlline.py ..Let me reproduce this again.

Can you share your connecting string ? @Michael Young

[#7]

My connect string is show at the top of my original post. I'm able to connect fine.

[#8]

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.