hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Carter Shanklin (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-15985) Allow the symmetric and asymmetric keywords to the between predicate
Date Mon, 20 Feb 2017 05:49:44 GMT
Carter Shanklin created HIVE-15985:
--------------------------------------

             Summary: Allow the symmetric and asymmetric keywords to the between predicate
                 Key: HIVE-15985
                 URL: https://issues.apache.org/jira/browse/HIVE-15985
             Project: Hive
          Issue Type: Sub-task
            Reporter: Carter Shanklin


When testing whether a number c3 is between c1 and c2, sometimes you don't know when c1 <=
c2. In this case it is useful to be able to run "c3 between symmetric c1 and c2" which handles
the case of c1 > c2. SQL allows the keywords of symmetric and asymmetric to be defined,
with asymmetric used if no keyword is supplied. SQL standard reference: section 8.3



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message