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 ... View more

What jar(s) do I need to register or which command line options do I need to pass to Pig so that Phoenix + Pig integration works? I'm using HDP 2.3.2. I've created a table in Phoenix and I would like to load sample data into a Phoenix table from a Hive table via a Pig script. When I try to store data into Phoenix I get "Could not resolve org.apache.phoenix.pig.PhoenixHBaseStorage using imports ...". ... View more