How to upsert data into dynamic columns in phoniex.

2015-06-21 Thread guxiaobo1982
Hi, The official doc only gives an example for querying dynamic columns which are not defined at table creating time, but how can create the dynamic columns in the schema and get data upsert through the phoniex API? Thanks

[no subject]

2015-06-21 Thread Kumar Palaniappan
I'm getting this when I use sqlline. I compiled phoenix4.4 with cdh5.4 along with code changes and pom changes. Any clue? Appreciate your time. Error: ERROR 103 (08004): Unable to establish connection. (state=08004,code=103) java.sql.SQLException: ERROR 103 (08004): Unable to establish

CDH 5.4 and Phoenix

2015-06-21 Thread Serega Sheypak
Hi!, did anyone try to integrate Phoenix 1.0 with CDH 5.4.x? I see weird installation path here: http://www.cloudera.com/content/cloudera/en/developers/home/cloudera-labs/apache-phoenix/install-apache-phoenix-cloudera-labs.pdf I would like to avoid it and run app using plain maven dependencies.

Re:Connection error with Phoenix 4.4

2015-06-21 Thread Kumar Palaniappan
Re-sending with the subject. On Sun, Jun 21, 2015 at 3:51 PM, Kumar Palaniappan kpalaniap...@marinsoftware.com wrote: I'm getting this when I use sqlline. I compiled phoenix4.4 with cdh5.4 along with code changes and pom changes. Any clue? Appreciate your time. Error: ERROR 103

Re: Indexing array type

2015-06-21 Thread Leon Prouger
Hey James, thank you for replying. Yes you're right, this option is pretty useless is our case. We've been thinking to create a separate table which will model the array with one to many relation, then index it and perform join with the main table for every query. Like: Main table: PK(id), data

Phoenix and Jooq

2015-06-21 Thread Leon Prouger
Found this tutorial about Phoenix and Jooq http://blog.sequenceiq.com/blog/2014/09/04/sql-on-hbase-with-apache-phoenix/ I wonder if it's possible to use more advanced Jooq features like code generation?