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 > >

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: > William and ames JTaylor > helped me solve this problem > > Thanks > >

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

Re: Does Phoenix support select by version?

William and 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

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

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: 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 > Reply-To:

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 <

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

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