Re: I cant get the latest phoenix to work in docker

2017-05-01 Thread Will Xu
If you run $> hbase zkcli $>ls / You should be able to see [zookeeper, hbase] If you don’t see this, then it means hbase service is not started or did not properly register with zookeeper. Best thing to do would be remove the images of avapno/apache-phoenix and try pulling the docker image agai

Re: Define parameters in queries

2017-03-24 Thread Will Xu
AFAIK, Phoenix does support support variables. In this case, you'll need to break apart your queries. Step 1: execute a statement to get your variable value Step 2: prepare a new query and replace the variable with value you've retrieved from step 1 Regards, Will ___

Re: Define parameters in queries

2017-03-23 Thread Will Xu
Yes, it will work. Pure JDBC only supports index, not named parameters. Named parameter (:userId) is not part of Java. There are third party libraries supporting it. http://www.javaworld.com/article/2077706/core-java/named-parameters-for-preparedstatement.html Regards, Will

Re: Define parameters in queries

2017-03-23 Thread Will Xu
?Hi Cheyenne, Phoenix connections are standard JDBC connections. This means you can use prepareStatement API to do parameter substitution. >From SO: >http://stackoverflow.com/questions/12745186/passing-parameters-to-a-jdbc-preparedstatement statement =con.prepareStatement("SELECT * from e

Re: Phoenix Question

2017-01-31 Thread Will Xu
Hi Mark, When you say Phoenix supports ACID do you mean via Tephra? Regards, Will From: Mark Heppner Sent: Tuesday, January 31, 2017 6:37 AM To: user@phoenix.apache.org Cc: noam.bul...@teoco.com Subject: Re: Phoenix Question Sukant, Yes, you definitely could

Re: Phoenix database adapter for Python not working

2016-12-16 Thread Will Xu
ction refused How I open this connection? On Fri, Dec 16, 2016 at 10:38 AM, Will Xu mailto:w...@hortonworks.com>> wrote: A few things. 1. Are you on 0.5 version of the connector? $>pip freeze | grep phoenixdb Should be==> phoenixdb==0.5 2. Can you try curl http://localhost:

Re: Phoenix database adapter for Python not working

2016-12-16 Thread Will Xu
ost:8765 curl: (7) Failed to connect to localhost port 8765: Connection refused How I open this connection? On Fri, Dec 16, 2016 at 10:38 AM, Will Xu mailto:w...@hortonworks.com>> wrote: A few things. 1. Are you on 0.5 version of the connector? $>pip freeze | grep phoenixdb Should

Re: Phoenix database adapter for Python not working

2016-12-16 Thread Will Xu
A few things. 1. Are you on 0.5 version of the connector? $>pip freeze | grep phoenixdb Should be==> phoenixdb==0.5 2. Can you try curl http://localhost:8765 to see if the server is actually running? If you open the page in browser you should see a Jetty 404 page. PQS is a think wrapper aro