Basically, hive does only support its own SQL witch is called HQL. The
prefix of the files, as hinted by Matt, is only a convention. You could put
whatever you want, that won't impact hive.
On Fri, May 31, 2013 at 11:02 PM, Sanjay Subramanian <
[EMAIL PROTECTED]> wrote:
> Ok cool
> On 5/31/13 2:00 PM, "Keith Wiley" <[EMAIL PROTECTED]> wrote:
> >On May 31, 2013, at 13:52 , Sanjay Subramanian wrote:
> >> First u need to setup some files in HDFS and define some Hive tables
> >> point to the location and then start your journey !
> >> sanjay
> >Oh I'm miles past that. I've been deploying Hive systems for well over a
> >year now. I'm just not used to working with input files. I (and my
> >end-users) have been one-query-at-a-time console queriers up until now
> >(often batched through bash scripts and such), so all I need is to come
> >up to speed on using .sql and .hql files.
> >Keith Wiley [EMAIL PROTECTED] keithwiley.com
> >"And what if we picked the wrong religion? Every week, we're just making
> >madder and madder!"
> > -- Homer Simpson
> CONFIDENTIALITY NOTICE
> =====================> This email message and any attachments are for the exclusive use of the
> intended recipient(s) and may contain confidential and privileged
> information. Any unauthorized review, use, disclosure or distribution is
> prohibited. If you are not the intended recipient, please contact the
> sender by reply email and destroy all copies of the original message along
> with any attachments, from your computer system. If you are the intended
> recipient, please be advised that the content of this message is subject to
> access, review and disclosure by the sender's Email System Administrator.