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

.sql vs. .hql

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 inde

Re: Update statment on Hive

Hi Hive reads and writes to HDFSŠand by definition HDFS is write once and immutable after that. So like an RDBMS there is no concept of an update rows. However if u want to delete some records based on a criteria, yesterday there was a smart post about it, basically selecting the inverse and doing

Update statment on Hive

Hello, I was wondering about the "update" statement on Hive. Is it something Hive needs? Or can "insert overwrite" be always used instead? Thank you in advance for the clarification, Renata.