Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - .sql vs. .hql


Copy link to this message
-
Re: .sql vs. .hql
Matt Tucker 2013-05-31, 21:01
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 <
[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> 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     [EMAIL PROTECTED]     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     [EMAIL PROTECTED]     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