Re: Coalesce function returns nulls?

Thanks for bringing this to our attention, Marek. I took a look and found an issue with the coalesce function. I filed PHOENIX-2994 with a patch there. Please let us know if it fixes the issue you're seeing (and if not, then please get us a unit test). James On Mon, Jun 13, 2016 at 2:02 PM,

RE: Coalesce function returns nulls?

Perhaps you could create a test case with table creation, upsert and then the select that reproduces and illustrates the problem? Michael McAllister Staff Data Warehouse Engineer | Decision Systems mmcallis...@homeaway.com | C: 512.423.7447 | skype: michael.mcall

Coalesce function returns nulls?

Hi All - I came across a very strange issue when using COALESCE function. It appears to me that it returns null values - please consider a following query: select length(coalesce(V_RS_DBSNP142,'N/A')) from TABLE1 limit 10; +--+ | LENGTH(COALESCE("V_RS_DBSNP14

Verify validity of Phoenix table

Hi all, I recently created a Phoenix table over a huge existing HBase table (~1TB) using the following SQL: CREATE TABLE “table_name" ( PK VARCHAR NOT NULL PRIMARY KEY, "a"."id” VARCHAR, "a"."created_at" VARCHAR ) DEFAULT_COLUMN_FAMILY = 'a’; I can’t recall exactly but the command eit