hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "N Campbell (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-3192) between predicate parsing issues
Date Sun, 24 Jun 2012 15:51:44 GMT
N Campbell created HIVE-3192:
--------------------------------

             Summary: between predicate parsing issues
                 Key: HIVE-3192
                 URL: https://issues.apache.org/jira/browse/HIVE-3192
             Project: Hive
          Issue Type: Bug
    Affects Versions: 0.8.0
            Reporter: N Campbell


These SQL statements will not parse.

select tbint.rnum,
case  
when tbint.cbint between 6 and 8  
then 'between'  
else 'other' 
end 
from cert.tbint tbint 
Error: Query returned non-zero code: 11, cause: FAILED: Parse Error: line 3:17 mismatched
input 'between' expecting KW_THEN near 'cbint' in case expression

SQLState:  42000
ErrorCode: 11	

select tbint.rnum 
from cert.tbint tbint 
where tbint.cbint between 6 and 8 
Error: Query returned non-zero code: 11, cause: FAILED: Parse Error: line 3:18 mismatched
input 'between' expecting EOF near 'cbint'

SQLState:  42000
ErrorCode: 11

create table if not exists CERT.TBINT ( RNUM int , CBINT bigint)
stored as sequencefile;

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message