Re: Get the Region and ID of the current row in a UDF

2017-03-28 Thread James Taylor
No. On Tue, Mar 28, 2017 at 10:19 AM Cheyenne Forbes < cheyenne.osanu.for...@gmail.com> wrote: > So I cant get neither the name of the table, the name of the column, the > id of the row nor the region that "ptr" belongs to after calling: > > > > > > *Expression arg = getChildren().get(0);

Re: Random rows

2017-03-28 Thread Steve Terrell
Here's what I do in one of my applications. A two-step process minimum (three if you get a total row count first): upsert into DEMO(KEY_FIELD_1,KEY_FIELD_2,"random_sample" boolean) select KEY_FIELD_1,KEY_FIELD_2,(rand()<(50.0/1000)) Where in this example, I want to randomly select 50 rows from a

HBaseCon2017 Registration is now Open!

2017-03-28 Thread stack
The HBaseCon West 2017 registration website is up [1]. Registration is no-charge (Courtesy of our gracious hosts). Space is limited so be sure to register early (This means YOU!, the HBase Community). Note, HBaseCon will be in Mountain View @ Google, NOT in San Francisco, on June 12th (The day befo

Random rows

2017-03-28 Thread Mike Prendergast
Any suggestion on how I could obtain a random set of rows in Phoenix? I'm looking to get a sample set spread across all regions for testing purposes. Thanks in advance Michael Prendergast *iota IT* Vice President / Software Engineer (cell) 703.594.1053 (office) 571.386.4682 (fax) 571.386.

Re: Get the Region and ID of the current row in a UDF

2017-03-28 Thread Cheyenne Forbes
So I cant get neither the name of the table, the name of the column, the id of the row nor the region that "ptr" belongs to after calling: *Expression arg = getChildren().get(0);if (!arg.evaluate(tuple, ptr)) {return false;}*

Re: Get the Region and ID of the current row in a UDF

2017-03-28 Thread James Taylor
No, that's not possible. Keep in mind that these expressions may be evaluated on the client or the server (it depends on the query). The could be evaluated on post aggregated rows too where the idea of which region no longer makes sense. On Sat, Mar 25, 2017 at 10:15 PM Cheyenne Forbes < cheyenne.

Re: Define parameters in queries

2017-03-28 Thread Cheyenne Forbes
Thank you James, could you also answer my other question? https://lists.apache.org/thread.html/5dfd0aecf5e6325b707fed4533f1e727886c338be762d6aaccfcf2f3@%3Cuser.phoenix.apache.org%3E

Re: Define parameters in queries

2017-03-28 Thread James Taylor
Phoenix supports JDBC, not any kind of scripting language like PLSQL or other variant. You can loook up online lots of examples of using PreparedStatement to bind variables in a query. On Tue, Mar 28, 2017 at 5:34 AM Cheyenne Forbes < cheyenne.osanu.for...@gmail.com> wrote: > Can someone show an

Re: how can I cast PhoenixArray to ArrayList

2017-03-28 Thread James Taylor
Sorry, wrong link. PhoenixArray is an implementation of the standard java.sql.Array JDBC interface: https://docs.oracle.com/javase/7/docs/api/java/sql/Array.html On Tue, Mar 28, 2017 at 5:46 AM 袁康(基础平台部) wrote: > I see the doc, but It’s oracle API . There is getIntArray method to cast > Oracle

Re: how can I cast PhoenixArray to ArrayList

2017-03-28 Thread 基础平台部
I see the doc, but It’s oracle API . There is getIntArray method to cast Oracle Array to int[] .Phoenix array does not hava one 在 2017年3月27日，22:38，James Taylor mailto:jamestay...@apache.org>> 写道： The JDBC array is not an ArrayList. See http://download.oracle.com/otn_hosted_doc/jdeveloper/905/

Re: Define parameters in queries

2017-03-28 Thread Cheyenne Forbes
Can someone show an example of how to declare a variable (and change the value) in Phoenix as I would use @ in front of the variable name in MySQL? (example: @my_variable := "my value") Thanks, Cheyenne