Does phoniex support features similar to checkandXXX methods of the HTable interface?

How to upsert data into dynamic columns in phoniex.

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

unknown function array_append error

Hi, I tried the following examples regarding to array data type create table artest(a integer , b integer[], constraint pk primary key(a)); upsert into artest values(1, array[1,2]); The following statement failed : select a, ARRAY_APPEND(b, 4) as b from artest; Error: ERROR 605

Re: Does phoniex support HBase RegionServer fail over ?

Sorry, there is a typo ..or will the JDBC connection connect to other zookeeper servers, which is zkServer2, specified in the JDBC URL automatically? -- Original -- From: guxiaobo1982;guxiaobo1...@qq.com; Send time: Thursday, Jun 18, 2015 12:46 PM

Does phoniex support HBase RegionServer fail over ?

Hi, In a multi physical node HBase cluster, each Hbase region server is running with a zookeeper instance on the same node, so in the Phoniex JDBC URL we can specify multi zookeeper quorum servers such as jdbc:phoenix:zkserver1,zkserver2:2181:/hbasePhoenix My questions is what happens when

Re: How to set the URL for Hbase with custom zookeeper.znode.parent

150 NA1 Time: 0.068 sec(s) mac:bin xiaobogu$ -- Original -- From: guxiaobo1982;guxiaobo1...@qq.com; Send time: Wednesday, Jun 17, 2015 12:45 PM To: useruser@phoenix.apache.org

How to set the URL for Hbase with custom zookeeper.znode.parent

Hi, I am trying to use SQuirreLSQL to connect to a remote single node HBase instance with a customed zookeeper.znode.parent /hbase-unsecure, and the hbase.zookeeper.quorum is lix2.bh.com with port 2181, then what should be the JDBC URL. The steps at

Which jar to put into Hbase region servers' classpath?

Hi, For phoenix 4.4.0, there are so many jars, but which one should be put into hbase region servers' classpath, and which one should be add to the client side, which is without hbase client library installed? Thanks.

sqlline.py failed to work

Hi, I am trying phoenix 4.2.2 against hbase 0.98.4.2.2.0.0 installed by ambari, the hbase shell command works probably, but ./sqlline.py localhost failed to work with the following error messages: [xiaobogu@lix1 bin]$ ./sqlline.py lix1.bh.com Setting property: [isolation,

Re: sqlline.py failed to work

This should help the znode for hbase in ambari is by default hbase-unsecure On Tue, Dec 23, 2014 at 12:14 PM, guxiaobo1982 guxiaobo1...@qq.com wrote: Hi, I am trying phoenix 4.2.2 against hbase 0.98.4.2.2.0.0 installed by ambari, the hbase shell command works probably, but ./sqlline.py