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
