question Re: Phoenix - Create Table Question in Archives of Support Questions (Read Only)

Phoenix - Create Table Question

Jaraxal — Sat, 30 Jan 2016 06:46:40 GMT

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

Re: Phoenix - Create Table Question

nsabharwal — Sat, 30 Jan 2016 06:57:32 GMT

@Michael Young

Are you using Phoenix query server? Try accessing table using sqlline.py if you are using pqs

I had same issue with PQS

Re: Phoenix - Create Table Question

Jaraxal — Sat, 30 Jan 2016 07:06:21 GMT

Yes, I'm suing Phoenix Query Server. /usr/bin/phoenix-sqlline is a symbolic link to /usr/hdp/current/phoenix-client/bin/sqlline.py. That is what I'm using.

Re: Phoenix - Create Table Question

vjain — Sat, 30 Jan 2016 07:11:19 GMT

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

Re: Phoenix - Create Table Question

Jaraxal — Sat, 30 Jan 2016 07:17:04 GMT

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

Re: Phoenix - Create Table Question

nsabharwal — Sat, 30 Jan 2016 07:22:02 GMT

@Michael Young

This is good intro

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

Re: Phoenix - Create Table Question

Jaraxal — Sat, 30 Jan 2016 07:31:42 GMT

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

Re: Phoenix - Create Table Question

elserj — Sat, 30 Jan 2016 07:36:05 GMT

Not relevant to your question, but that's the "normal" (thick) Phoenix driver. The "thin" Phoenix driver (with Phoenix QueryServer) is accessed using sqlline-thin.py.

Re: Phoenix - Create Table Question

elserj — Sat, 30 Jan 2016 07:39:06 GMT

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.

Re: Phoenix - Create Table Question

nsabharwal — Sat, 30 Jan 2016 07:39:14 GMT

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

Can you share your connecting string ? @Michael Young

Re: Phoenix - Create Table Question

Jaraxal — Sat, 30 Jan 2016 07:43:59 GMT

What is the difference between the thick and thin driver in terms of what I'm trying to do? When I use phoenix-sqlline-thin it shows the table now which is puzzling to me. Why the difference in behavior?

Re: Phoenix - Create Table Question

Jaraxal — Sat, 30 Jan 2016 07:51:59 GMT

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

Re: Phoenix - Create Table Question

nsabharwal — Sat, 30 Jan 2016 08:00:02 GMT

@Michael Young @Josh Elser I think it has to do with zk

shutdown hbase and RS and run this

hbase clean --cleanZk

Re: Phoenix - Create Table Question

elserj — Sat, 30 Jan 2016 08:15:08 GMT

The "thick" Phoenix driver does all the RPC with HBase directly. The "thin" Phoenix driver only communicates with the Phoenix QueryServer over HTTP (the QueryServer communicates to HBase on its behalf). You shouldn't see any differences between the two approaches.

Re: Phoenix - Create Table Question

Jaraxal — Sat, 30 Jan 2016 08:15:43 GMT

@Neeraj Sabharwal

Good catch! Running "hbase clean --cleanZk" fixed the problem. Now the thick and thin client are working similarly.

Re: Phoenix - Create Table Question

nsabharwal — Sat, 30 Jan 2016 08:19:47 GMT

@Michael Young Thanks for testing. I believe we have the answer 😉

Thanks @Josh Elser for chiming in ...Really appreciate it!!!! All comments upvote

Re: Phoenix - Create Table Question

Jaraxal — Sat, 30 Jan 2016 08:21:17 GMT

@Josh Elser

Thank you for the clarification regarding the clients. I didn't expect to see difference in terms of how the sql worked. Using the thin client did help to identify there was a difference between the two.