phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "wangweiyi (JIRA)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-2907) UDFs in where clause not work
Date Tue, 17 May 2016 15:50:12 GMT
wangweiyi created PHOENIX-2907:
----------------------------------

             Summary: UDFs in where clause not work
                 Key: PHOENIX-2907
                 URL: https://issues.apache.org/jira/browse/PHOENIX-2907
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.7.0
         Environment: phoenix-4.7.0
HBase-0.98
            Reporter: wangweiyi


it's ok to use my UDF after select, like this:

select myudf("col") from MY_TABLE  limit 1;

then will get:
+-----------------------+
| MYUDF(cf."col")  |
+-----------------------+
| 2                          |
+-----------------------+

then I try to use myudf after where clause, like this:

select * from MY_TABLE where myudf("col")='2';

however, this time I get nothing.

I know the reason is that the "col" column is null, if the "col" column is not null then everything
works fine. So, how can I handle the null value in my UDF? 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message