Re: .sql vs. .hql

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. Regards Bertrand On Fri, May 31, 2013 at 11:02 PM, Sanjay Subramanian < sanjay.subraman...@wizecommerce

Re: .sql vs. .hql

Ok cool On 5/31/13 2:00 PM, "Keith Wiley" 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 >>ands >> point to the location and then start your journey ! >> >> sanjay > > >Oh I'm miles past that. I've been dep

Re: .sql vs. .hql

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

Re: .sql vs. .hql

On May 31, 2013, at 13:52 , Sanjay Subramanian wrote: > First u need to setup some files in HDFS and define some Hive tables ands > 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 u

Re: .sql vs. .hql

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 complexhard to find one document where i

Re: .sql vs. .hql

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 cle

Re: .sql vs. .hql

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" wrote: >I'm looking for documentation on how to use .sql and .hql files in Hive >and what the differences are between t