Re: Region start row and end row

after spending some time on Phoenix map reduce, i was able to get the phoenix input splits for given sql query. As query plan and phoenix input split are not Serializable, i am not able to use them directly for ignite load. Was there any way to read using scan on phoenix table (not on hbase tabl

Using Apache perf with Hbase 1.1

Hi, I am trying to connect pherf to hbase cluster running hbase 1.1 using below. Could you please help me connect pherf to hbase cluster running v 1.1 java -Xms512m -Xmx3072m -cp "/home/ambari/pherf/phoenix/bin/../phoenix-pherf/config:/etc/hbase/conf:/home/ambari/pherf/phoenix/bin/../phoenix-c

Re: Using Apache perf with Hbase 1.1

> > Cannot get all table regions > Check that there are no offline regions. See related thread here . On Tue, Oct 18, 2016 at 2:11 PM, Pradheep Shanmugam < pradheep.shanmu...@info

Re: Using Apache perf with Hbase 1.1

Hi, All the regions are online acoording to 16010/master-status web UI. Phoenix is not able connect properly due to error "Caused by: java.io.IOException: hconnection-0xa59a583 closed" Thanks, Pradheep From: Mujtaba Chohan mailto:mujt...@apache.org>> Reply-To: "user@phoenix.apache.org

Does Phoenix support select by version?

Hi I saw that Phoenix can Create a table define Hbase's Versions, An example on phoenix's website is CREATE TABLE IF NOT EXISTS "my_case_sensitive_table" ( "id" char(10) not null primary key, "value" integer) DATA_BLOCK_ENCODING='NONE',VERSIONS=5,MAX_FILESIZE=200 split on (?, ?, ?)

Re: cannot drop a table in Phoenix

Hi I met the sam problem before. This may happen when you define your table with duplicate column. such as create table test (id integer primary key,c varchar, c varchar ). you can try to delete you table from system.catalog , maybe like delete * from system.catalog where tablename='your table nam

Re: Does Phoenix support select by version?

Williamand ames JTaylor helped me solve this problem Thanks 2016-10-19 10:20 GMT+08:00 Yang Zhang : > Hi > > I saw that Phoenix can Create a table define Hbase's Versions, > An example on phoenix's website is > > CREATE TABLE IF NOT EXISTS "my_case_sensitive_table" > ( "id" char(10) no

problem with index

I have a running phoenix table with index. when too much data write in the same time, index write can not catch up, finally cause a regionserver down. Then I dropped index, and restart region server. Here comes the problem: regionserver will recover edits, and found index data, it tried to r

Re: Does Phoenix support select by version?

Hi Yang , Can you share the details in the forum would be useful for everybody. Thanks, Divya On 19 October 2016 at 10:56, Yang Zhang wrote: > Williamand ames JTaylor > helped me solve this problem > > Thanks > > 2016-10-19 10:20 GMT+08:00 Yang Zhang : > >> Hi >> >> I saw that Phoenix

Re: cannot drop a table in Phoenix

Hi Mich, Which version of Phoenix are you using ? Thanks, Divya On 17 October 2016 at 23:41, Mich Talebzadeh wrote: > Hi, > > I have a table marketDataHbase create on Hbase as seen below: > > [image: Inline images 1] > > > Trying to drop it but it cannot find it > > 0: jdbc:phoenix:rhes564:218