Hi Keith,
In regards to filename conventions, there isn't a hard requirement to use a
specific extension. Aside from the two extensions already mentioned
('.hql','.sql'), there is a 3rd option commonly used in the Hive test
queries<https://github.com/apache/hive/tree/trunk/ql/src/test/queries/clientpositive>:
'.q'.
I stay with '.q' as well, so that Hive code can be easily differentiated
from other SQL code.
Matt
On Fri, May 31, 2013 at 1:52 PM, Sanjay Subramanian <
sanjay.subraman...@wizecommerce.com> wrote:
> http://www.amazon.com/Programming-Hive-Edward-Capriolo/dp/1449319335
>
>
> There are some variances and limitations in the IN and JOIN constructs as
> I recall but u have to make sure...
>
> But I would start by running some queries from simple to complex to more
> complex....hard to find one document where it will illustrate all the
> variances...
>
> First u need to setup some files in HDFS and define some Hive tables ands
> point to the location and then start your journey !
>
> Good luck
>
> sanjay
>
>
>
> On 5/31/13 1:47 PM, "Keith Wiley" <kwi...@keithwiley.com> wrote:
>
> >Thanks! I'm always up for a good book. Our case is a little open-ended
> >right now, a little difficult to nail down or describe. Basically, I'm
> >deploying Hive systems for a SQl-comfortable data analyst (who is also
> >quite versed in Hive) who would like to run .sql files in Hive and I need
> >to clearly understand how Hive uses input files and how .sql and .hql may
> >differ.
> >
> >Cheers!
> >
> >On May 31, 2013, at 13:20 , Sanjay Subramanian wrote:
> >
> >> For Hive u need the other bible by Dean Wampler , Edward Capriolo et al
> >> Also if u tell us what use cases u have we could provide helpŠ
> >>
> >> sanjay
> >>
> >> On 5/31/13 1:17 PM, "Keith Wiley" <kwi...@keithwiley.com> wrote:
> >>
> >>> I'm looking for documentation on how to use .sql and .hql files in Hive
> >>> and what the differences are between the two file types. I'm not even
> >>> certain .hql is a real thing, but I'm looking. I didn't see any
> >>>mention
> >>> of this issue in White's Hadoop book, at least not clearly indicated in
> >>> the index.
> >>>
> >>> Thanks.
> >>>
> >>>
> >>>________________________________________________________________________
> >>>__
> >>> ______
> >>> Keith Wiley kwi...@keithwiley.com keithwiley.com
> >>> music.keithwiley.com
> >>>
> >>> "Luminous beings are we, not this crude matter."
> >>> -- Yoda
> >>>
> >>>________________________________________________________________________
> >>>__
> >>> ______
> >>>
> >>>
> >>
> >>
> >> 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.
> >>
> >
> >
> >__________________________________________________________________________
> >______
> >Keith Wiley kwi...@keithwiley.com keithwiley.com
> >music.keithwiley.com
> >
> >"I do not feel obliged to believe that the same God who has endowed us
> >with
> >sense, reason, and intellect has intended us to forgo their use."
> > -- Galileo Galilei
> >__________________________________________________________________________
> >______
> >
> >
>
>
> 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.
>
>
