FW: Phoenix Query Server not returning any results

2016-09-12 Thread Puneeth Prasad
Hello, We have just started using Apache Phoenix on HBase. We have a setup where Phoenix is working (We are able to CRUD in tables cleanly). Now, we want an application running outside the network (say a system hosting a mobile app) to be able to query Phoenix table. For that, one of the optio

Re: FW: Phoenix Query Server not returning any results

2016-09-12 Thread F21
Hey, You mentioned that you sent a PrepareAndExecuteRequest. However, to do that, you would need to first: 1. Open a connection: https://calcite.apache.org/docs/avatica_json_reference.html#openconnectionrequest 2. Create a statement: https://calcite.apache.org/docs/avatica_json_reference.html#

Re: When would/should I use spark with phoenix?

2016-09-12 Thread Cheyenne Forbes
Thanks everyone, I will be using phoenix for simple input/output and the phoenix_spark plugin (https://phoenix.apache.org/phoenix_spark.html) for more complex queries, is that the smart thing? Regards, Cheyenne Forbes Chief Executive Officer Avapno Omnitech Chief Operating Officer Avapno Soluti

Re: FW: Phoenix Query Server not returning any results

2016-09-12 Thread Josh Elser
Puneeth -- One extra thing to add to Francis' great explanation; the response message told you what you did wrong: "missingStatement":true This is telling you that the server does not have a statement with the ID 12345 as you provided. F21 wrote: Hey, You mentioned that you sent a PrepareA

Re: When would/should I use spark with phoenix?

2016-09-12 Thread dalin.qin
Hi , I've used phoenix table to store billions of rows , rows are incrementally insert into phoenix by spark every day and the table was for instant query from web page by providing primary key . so far so good . Thanks Dalin On Mon, Sep 12, 2016 at 10:07 AM, Cheyenne Forbes < cheyenne.osanu.for.

RE: FW: Phoenix Query Server not returning any results

2016-09-12 Thread Puneeth Prasad
Hello Francis and Josh, Really appreciate the quick responses. We were able to resolve the issue. Regards, Puneeth -Original Message- From: Josh Elser [mailto:josh.el...@gmail.com] Sent: 12 September 2016 19:48 To: user@phoenix.apache.org Subject: Re: FW: Phoenix Query Server not return

Re: When would/should I use spark with phoenix?

2016-09-12 Thread Josh Mahonin
Hi Dalin, That's great to hear. Have you also tried reading back those rows through Spark for a larger "batch processing" job? Am curious if you have any experiences or insight there from operating on a large dataset. Thanks! Josh On Mon, Sep 12, 2016 at 10:29 AM, dalin.qin wrote: > Hi , > I'

Re: When would/should I use spark with phoenix?

2016-09-12 Thread dalin.qin
Hi Josh, before the project kicked off , we get the idea that hbase is more suitable for massive writing rather than batch full table reading(I forgot where the idea from ,just some benchmart testing posted in the website maybe). So we decide to read hbase only based on primary key for small amoun

How to manually generate a salted row key?

2016-09-12 Thread Marica Tan
Hi, We have a table created via phoenix with salt bucket, but we're using HBase API to insert records since we need to manually set the HBase version and I believe that it isn't possible via phoenix. Our table has a composite key (firstKey varchar, secondKey varchar, thirdKey varchar) and when we