Re: Immutable data in Hive

2016-01-04 Thread Ashok Kumar
5347372295 div.yiv5347372295WordSection1 {}#yiv5347372295 Very well answered by Mich.   Thanks Mich !!   From: Mich Talebzadeh [mailto:m...@peridale.co.uk] Sent: Sunday, January 03, 2016 8:35 PM To: user@hive.apache.org; 'Ashok Kumar' Subject: RE: Immutable data in Hive   Hi Ashok.   I will have a g

RE: Immutable data in Hive

2016-01-04 Thread Singh, Abhijeet
Very well answered by Mich. Thanks Mich !! From: Mich Talebzadeh [mailto:m...@peridale.co.uk] Sent: Sunday, January 03, 2016 8:35 PM To: user@hive.apache.org; 'Ashok Kumar' Subject: RE: Immutable data in Hive Hi Ashok. I will have a go at this on top of Alan’s very valuable cla

RE: Immutable data in Hive

2016-01-03 Thread Mich Talebzadeh
therefore neither Peridale Ltd, its subsidiaries nor their employees accept any responsibility. From: Ashok Kumar [mailto:ashok34...@yahoo.com] Sent: 03 January 2016 11:03 To: user@hive.apache.org; Ashok Kumar Subject: Re: Immutable data in Hive Any comments on ELT will be greatly appreciat

Re: Immutable data in Hive

2016-01-03 Thread Ashok Kumar
Any comments on ELT will be greatly appreciated gurus. With warmest greetings On Wednesday, 30 December 2015, 18:20, Ashok Kumar wrote: Tank you sir,  very helpful. Could you also briefly describe from your experience  the major differences between traditional ETL in DW and ELT in Hiv

Re: Immutable data in Hive

2015-12-30 Thread Ashok Kumar
Tank you sir,  very helpful. Could you also briefly describe from your experience  the major differences between traditional ETL in DW and ELT in Hive?  Why there is emphasis to take data from traditional transactional databases into Hive table with the same format and do the transform in Hive

Re: Immutable data in Hive

2015-12-30 Thread Alan Gates
Traditionally data in Hive was write once (insert) read many. You could append to tables and partitions, add new partitions, etc. You could remove data by dropping tables or partitions. But there was no updates of data or deletes of particular rows. This was what was meant by immutable. Hi