You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Xiaoyong Zhu <xi...@microsoft.com> on 2015/01/22 10:25:48 UTC

EXIST vs EXISTS keyword?

Hello experts

I am wondering when the keyword "EXIST" will be used in Hive - and if it is used, then what's the difference between EXIST and EXISTS?

Thanks!

Xiaoyong


RE: EXIST vs EXISTS keyword?

Posted by Xiaoyong Zhu <xi...@microsoft.com>.
sorry for the wrong question - yes, there is no keyword "EXIST"...

Xiaoyong

From: Jason Dere [mailto:jdere@hortonworks.com]
Sent: Friday, January 23, 2015 8:09 AM
To: user@hive.apache.org
Cc: Zhaomin Xu
Subject: Re: EXIST vs EXISTS keyword?

Doing a quick search in the lexer/parser files (*.g), I only see KW_EXISTS and not KW_EXIST.


On Jan 22, 2015, at 1:25 AM, Xiaoyong Zhu <xi...@microsoft.com>> wrote:


Hello experts

I am wondering when the keyword "EXIST" will be used in Hive - and if it is used, then what's the difference between EXIST and EXISTS?

Thanks!

Xiaoyong



CONFIDENTIALITY NOTICE
NOTICE: This message is intended for the use of the individual or entity to which it is addressed and may contain information that is confidential, privileged and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, you are hereby notified that any printing, copying, dissemination, distribution, disclosure or forwarding of this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately and delete it from your system. Thank You.

Re: EXIST vs EXISTS keyword?

Posted by Jason Dere <jd...@hortonworks.com>.
Doing a quick search in the lexer/parser files (*.g), I only see KW_EXISTS and not KW_EXIST.


On Jan 22, 2015, at 1:25 AM, Xiaoyong Zhu <xi...@microsoft.com> wrote:

> Hello experts
>  
> I am wondering when the keyword “EXIST” will be used in Hive – and if it is used, then what’s the difference between EXIST and EXISTS?
>  
> Thanks!
>  
> Xiaoyong
>  


-- 
CONFIDENTIALITY NOTICE
NOTICE: This message is intended for the use of the individual or entity to 
which it is addressed and may contain information that is confidential, 
privileged and exempt from disclosure under applicable law. If the reader 
of this message is not the intended recipient, you are hereby notified that 
any printing, copying, dissemination, distribution, disclosure or 
forwarding of this communication is strictly prohibited. If you have 
received this communication in error, please contact the sender immediately 
and delete it from your system. Thank You.