[jira] [Created] (CARBONDATA-359) is null & null functions are not working when data fetching from sub query

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (CARBONDATA-359) is null & null functions are not working when data fetching from sub query

Akash R Nilugal (Jira)
Krishna Reddy created CARBONDATA-359:
----------------------------------------

             Summary: is null & null functions are not working when data fetching from sub query
                 Key: CARBONDATA-359
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-359
             Project: CarbonData
          Issue Type: Bug
          Components: data-query
    Affects Versions: 0.2.0-incubating
            Reporter: Krishna Reddy
             Fix For: 0.2.0-incubating


Is null & Not null functions are not working when data fetching from sub query.
        select * from (select if( Latest_areaId=3,1,Latest_areaId) test from Carbon_automation) qq where test is  null;
        select * from (select if( Latest_areaId=3,1,Latest_areaId) test from Carbon_automation) qq where test is  not null;




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