drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chris Matta (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-1530) Support for the != operator
Date Sat, 11 Oct 2014 13:35:34 GMT
Chris Matta created DRILL-1530:
----------------------------------

             Summary: Support for the != operator
                 Key: DRILL-1530
                 URL: https://issues.apache.org/jira/browse/DRILL-1530
             Project: Apache Drill
          Issue Type: Bug
          Components: Execution - Operators
    Affects Versions: 0.6.0
            Reporter: Chris Matta
            Priority: Minor


Tableau is using the != operator in the bellow query which failed tonight with Drill. This
operator isn’t technically ANSI SQL, but almost all DBMS support it, any chance this support
would be added?

{code:sql}
SELECT CASE 
           WHEN `twitter_tweets`.`favorite_count` / 1 < 0 
                AND `twitter_tweets`.`favorite_count` / 1 != `twitter_tweets`.`favorite_count`
/ 1 THEN `twitter_tweets`.`favorite_count` / 1 - 1 
           ELSE `twitter_tweets`.`favorite_count` / 1 
       END AS `Favorite_Count__bin_`, 
       COUNT(`twitter_tweets`.`favorite_count`) AS `cnt_favorite_count_ok` 
FROM `mfs.views`.`twitter_tweets` `twitter_tweets` 
INNER JOIN `mfs.views`.`twitter_users` `twitter_users` ON (`twitter_tweets`.`user_id` = `twitter_users`.`user_id`)

GROUP BY CASE 
             WHEN `twitter_tweets`.`favorite_count` / 1 < 0 
                  AND `twitter_tweets`.`favorite_count` / 1 != `twitter_tweets`.`favorite_count`
/ 1 THEN `twitter_tweets`.`favorite_count` / 1 - 1 
             ELSE `twitter_tweets`.`favorite_count` / 1 
         END
{code}



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

Mime
View raw message