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)
