PhoenixFunction

when I use the functions described on your website. some function work well such as count() and min(), But with exp() it returned with Function undefined. functionName=[EXP] not found my phoenix version is phoenix-4.4.0-HBase-0.98-bin. I just want to confirm whether my version not support some fu

Fwd: org.apache.hadoop.hbase.DoNotRetryIOException

Hello everyone I got an （org.apache.hadoop.hbase.DoNotRetryIOException） when using phoenix. my version is phoenix-4.4.0-HBase-0.98-bin. I create a table and upsert data into it. But someday i want to modify it, so i execute （alter table drop column c1）and ( alter table add c2 bigint). after

Re: org.apache.hadoop.hbase.DoNotRetryIOException

org.apache.phoenix.coprocessor.MetaDataEndpointImpl.dropTable(MetaDataEndpointImpl.java:1272) ... 10 more SQLState: 08000 ErrorCode: 101 I still can't handle this problem, Any one can help me ? Thank you very much 2016-07-23 10:34 GMT+08:00 Yang Zhang : > Hello everyone > >

Re: org.apache.hadoop.hbase.DoNotRetryIOException

customer's grammer has error. 2016-09-07 9:21 GMT+08:00 James Taylor : > Sorry for the issue you've hit, Yang Zhang. You may need to do the > following to recover: > - drop the table from the hbase shell > - create a snapshot of the SYSTEM.CATALOG table just in case > - del

The capacity of data types

Hi everyone I used varchar in phoenix to record string.But one the page of help ,I can't find how many bytes can varchar contain. So i tried to write a very large text to it, and I got The data exceeds the max capacity for the data type. Maybe I should use varbinary, but i still can't fin

Can phoenix support HBase's TimeStamp?

Hello everyone I saw that we can create a Phoenix table from an exist HBase table,(for detail ) My question is whether Phoenix can supprort the history version of my row? I am trying to use Phoenix to store

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_sens

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