phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lukáš Lalinský <lalin...@gmail.com>
Subject Re: Phoenix Ifnull
Date Fri, 12 Aug 2016 09:57:17 GMT
I think this is a problem with the WHERE clause. NULL values are neither
equal nor not-equal to any other values. You might need to add "OR API_KEY
IS NULL" to the WHERE clause.

Lukas


On Fri, Aug 12, 2016 at 9:51 AM, ankit beohar <ankitbeohar90@gmail.com>
wrote:

> Hi Lukáš/James,
>
> I have one table in which only one rowkey is available and for my null
> check case I am firing below queries and in that null check is not working:-
>
> [image: Inline image 1]
>
> Please see and let me know if I am doing right thing or missed something.
>
> Best Regards,
> ANKIT BEOHAR
>
>
> On Thu, Aug 11, 2016 at 9:18 PM, James Taylor <jamestaylor@apache.org>
> wrote:
>
>> Lukáš is correct, but if the CASE WHEN variant of the same didn't work,
>> please file a JIRA (ideally with a unit test that repros the problem).
>>
>> Thanks,
>> James
>>
>> On Thu, Aug 11, 2016 at 12:20 AM, Lukáš Lalinský <lalinsky@gmail.com>
>> wrote:
>>
>>> On Thu, Aug 11, 2016 at 9:00 AM, ankit beohar <ankitbeohar90@gmail.com>
>>> wrote:
>>>
>>>> I want to implement If null in apache phoenix like mysql.
>>>>
>>>> select ifnull(rowkey,myvalue),ifnull(col1,mycolvalue) from table where
>>>> rowkey='abc';
>>>>
>>>> I tried below query but did not work:-
>>>>
>>>> select case when APP_KEY is null then 'nullvalue' else APP_KEY end from
>>>> "CheckDump";
>>>>
>>>
>>> The standard SQL function for this is coalesce(col, 'nullvalue').
>>>
>>> https://phoenix.apache.org/language/functions.html#coalesce
>>>
>>> Lukas
>>>
>>
>>
>

Mime
View raw message