RE: Phoenix Array Type Null Element

2015-05-05 Thread Vasudevan, Ramkrishna S
I raised https://issues.apache.org/jira/browse/PHOENIX-1949 for fixing this. From: Vasudevan, Ramkrishna S [mailto:ramkrishna.s.vasude...@intel.com] Sent: Wednesday, May 6, 2015 9:21 AM To: user@phoenix.apache.org Subject: RE: Phoenix Array Type Null Element Ideally varchar array should support N

RE: Phoenix Array Type Null Element

2015-05-05 Thread Vasudevan, Ramkrishna S
Ideally varchar array should support NULL. This seems to be a bug. Can you file a JIRA for this? I can come up with a patch ASAP. Regards Ram From: Kathiresan S [mailto:kathiresanselva...@gmail.com] Sent: Tuesday, May 5, 2015 10:23 PM To: user@phoenix.apache.org Subject: Phoenix Array Type Null

Re: Can't drop phoenix table

2015-05-05 Thread Biyuhao
Is phoenix compatible with CDH? When I build jars with phoenix 4.4 and CDH5.4.0(HBase1.0) there comes an error.

Re: Can't drop phoenix table

2015-05-05 Thread PengCheng Liang
DELETE FROM SYSTEM.CATALOG WHERE TABLE_NAME=‘' But, it maybe a bad idea. 发件人: chuanqingjia 答复: phoenix 日期: 2015年5月6日 星期三 上午9:14 至: phoenix 主题: Can't drop phoenix table hi, the phoenix version is 4.3, the hadoop release is CDH 5.2. I create the phoenix table failed,but I can see this

Can't drop phoenix table

2015-05-05 Thread chuanqingjia
hi, the phoenix version is 4.3, the hadoop release is CDH 5.2. I create the phoenix table failed,but I can see this table in phoenix shell. when I try to drop this table ,the Exception is ArrayIndexOutOfBoundsException. what's the reason ,and how to drop the table's metadata? 15/05/06 09:01:22

Re: Phoenix Array Type Null Element

2015-05-05 Thread Kathiresan S
Also, could you please let me know the array data base types that allow null (in case VARCHAR ARRAY will not allow NULLs)? Thanks, Kathir On Tue, May 5, 2015 at 12:53 PM, Kathiresan S wrote: > Hi, > > Is it possible to insert null elements in an array type column? > > CREATE TABLE ARRAYTEST124

CDH5.4.0 compatibility

2015-05-05 Thread Biyuhao
Hi Everyone, I'm trying to build phoenix with CDH5.4.0, and I got this error. And I wanna ask is phoenix compatible with cdh distro? How can I fix this? [INFO] 2 errors [INFO] - [INFO]

Phoenix Array Type Null Element

2015-05-05 Thread Kathiresan S
Hi, Is it possible to insert null elements in an array type column? CREATE TABLE ARRAYTEST124 (ID VARCHAR, NAME VARCHAR ARRAY CONSTRAINT PK PRIMARY KEY(ID)) UPSERT INTO ARRAYTEST124 (ID, NAME) VALUES('123',ARRAY['ABC','XYZ',null]) UPSERT INTO ARRAYTEST124 (ID, NAME) VALUES('123',ARRAY['ABC',null