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.
