Pls raise a bug, will look into it at the earliest. Regards Ram
From: James Taylor [mailto:[email protected]] Sent: Thursday, May 29, 2014 2:47 AM To: [email protected] Subject: Re: Problem with Phoenix Float Array Type? Faisal, Thanks for reporting these issues with float arrays. These are definitely bugs. Please file JIRAs on them here: https://issues.apache.org/jira/browse/PHOENIX Regards, James On Wed, May 28, 2014 at 11:25 AM, faisal moeen <[email protected]<mailto:[email protected]>> wrote: Yes. integer arrays and double arrays are working fine. Do I need to use some postfix with the literal values to specify that they are float? In your example you used 'd' with the constants '2.0d'. Regards Faisal Moeen On Wed, May 28, 2014 at 8:05 PM, Vasudevan, Ramkrishna S <[email protected]<mailto:[email protected]>> wrote: I tried this create table TABLE_WITH_ARRAY (organization_id char(15) not null,entity_id char(15) not null,a_double_array double array[] CONSTRAINT pk PRIMARY KEY (organization_id, entity_id)); upsert into table_with_array values('" + tenantId"','00A123122312312',ARRAY[2.0d,345.8d])" The below select queries worked fine too. query = "SELECT ARRAY_ELEM(a_double_array,2) FROM table_with_array"; query = "select array_length(a_double_array) from table_with_array"; Are you facing the problem with only Floats ? Regards Ram From: faisal moeen [mailto:[email protected]<mailto:[email protected]>] Sent: Wednesday, May 28, 2014 10:04 PM To: [email protected]<mailto:[email protected]> Subject: Problem with Phoenix Float Array Type? Hi, I am using Phoenix 3.0 with Hbase 0.94.18. I am unable to use float arrays. I am facing no problem with varchar arrays doing same. I create a table like this: create table if not exists location(name varchar not null, point float array[2], box float array[4], constraint pk primary key (name)); I add a row to it: upsert into LOCATION values('qaisar', array[75.0,75.0], array[72.1,74.1,74.1,72.1]); Now I check array lengths: select array_length(point),array_length(box) from LOCATION; I get the following answer: 5,8 whereas I expect 2,4 The values point[1] or point[2] are also not correct. Am I doing something wrong? An I upserting the data correctly? Also if I user literal 75 instead of 75.0, it throws an exception. Thanks. -- Regards Faisal Moeen -- Regards Faisal Moeen
