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

Posted by Akash R Nilugal (Jira) on Nov 02, 2016; 9:18am
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/jira-Created-CARBONDATA-359-is-null-null-functions-are-not-working-when-data-fetching-from-sub-query-tp2520.html

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)