It's an excellent book, and not too expensive so I recommend buying your own copy from O'Reilly or Amazon. (Not only will you have a legal copy, but you'll encourage authors to write more books for the benefit of all.) I've got it in hardcover and digital format.
– Lefty On Tue, Jun 11, 2013 at 6:46 PM, Sanjay Subramanian < sanjay.subraman...@wizecommerce.com> wrote: > From Russia with Love... > > Domain ID:D39022749-LRMS > Domain Name:IT-EBOOKS.INFO > Created On:27-Jul-2011 12:24:45 UTC > Last Updated On:29-Apr-2013 11:00:03 UTC > Expiration Date:27-Jul-2015 12:24:45 UTC > Sponsoring Registrar:GoDaddy.com LLC (R171-LRMS) > Status:CLIENT DELETE PROHIBITED > Status:CLIENT RENEW PROHIBITED > Status:CLIENT TRANSFER PROHIBITED > Status:CLIENT UPDATE PROHIBITED > Registrant ID:CR89106899 > Registrant Name:Artur Denisov > Registrant Organization: > Registrant Street1:Akademika Koroleva 21/5 > Registrant Street2: > Registrant Street3: > Registrant City:Moscow > Registrant State/Province:Moscow > Registrant Postal Code:127427 > Registrant Country:RU > Registrant Phone:+7.4957930823 > Registrant Phone Ext.: > Registrant FAX: > Registrant FAX Ext.: > Registrant Email:supp...@it-ebooks.info > Admin ID:CR89106901 > Admin Name:Artur Denisov > Admin Organization: > Admin Street1:Akademika Koroleva 21/5 > Admin Street2: > Admin Street3: > Admin City:Moscow > Admin State/Province:Moscow > Admin Postal Code:127427 > Admin Country:RU > Admin Phone:+7.4957930823 > Admin Phone Ext.: > Admin FAX: > Admin FAX Ext.: > Admin Email:supp...@it-ebooks.info > Billing ID:CR89106902 > Billing Name:Artur Denisov > Billing Organization: > Billing Street1:Akademika Koroleva 21/5 > Billing Street2: > Billing Street3: > Billing City:Moscow > Billing State/Province:Moscow > Billing Postal Code:127427 > Billing Country:RU > Billing Phone:+7.4957930823 > Billing Phone Ext.: > Billing FAX: > Billing FAX Ext.: > Billing Email:supp...@it-ebooks.info > Tech ID:CR89106900 > Tech Name:Artur Denisov > Tech Organization: > Tech Street1:Akademika Koroleva 21/5 > Tech Street2: > Tech Street3: > Tech City:Moscow > Tech State/Province:Moscow > Tech Postal Code:127427 > Tech Country:RU > Tech Phone:+7.4957930823 > Tech Phone Ext.: > Tech FAX: > Tech FAX Ext.: > Tech Email:supp...@it-ebooks.info > Name Server:NS1.FASTVPS.RU > Name Server:NS2.FASTVPS.RU > Name Server:NS4.FASTVPS.RU > Name Server:NS3.FASTVPS.RU > Name Server: > Name Server: > Name Server: > Name Server: > Name Server: > Name Server: > Name Server: > Name Server: > Name Server: > > > From: Dean Wampler <deanwamp...@gmail.com> > Reply-To: "user@hive.apache.org" <user@hive.apache.org> > Date: Tuesday, June 11, 2013 11:04 AM > To: "user@hive.apache.org" <user@hive.apache.org> > Cc: "user@hive.apache.org" <user@hive.apache.org> > Subject: Re: Create table like with partitions > > I confirmed it is a pirate site. > > Sent from my rotary phone. > > On Jun 11, 2013, at 10:33 AM, Edward Capriolo <edlinuxg...@gmail.com> > wrote: > > For reference, any that puts the entire book online like this is likely > pirated. > > > > > On Tue, Jun 11, 2013 at 8:34 AM, Richa Sharma <mailtorichasha...@gmail.com > > wrote: > >> Hi all, >> >> Found a very useful guide online. Link -> >> http://it-ebooks.info/book/941/ >> >> Richa >> >> >> On Tue, Jun 11, 2013 at 1:53 PM, Richa Sharma < >> mailtorichasha...@gmail.com> wrote: >> >>> Thanks for sharing! >>> >>> I looked at these links .. Is there any documentation with more >>> examples with both static and dynamic partitions covered together. >>> >>> Richa >>> >>> >>> On Tue, Jun 11, 2013 at 12:33 PM, Lefty Leverenz >>> <le...@hortonworks.com>wrote: >>> >>>> Dynamic partitions are described in the Hive design docs here: >>>> https://cwiki.apache.org/confluence/display/Hive/DynamicPartitions. >>>> >>>> For the configuration parameters, though, you need to look in the >>>> language manual here: >>>> https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties >>>> (search >>>> for "dynamic" to find various parameters related to dynamic partitions). >>>> >>>> – Lefty >>>> >>>> >>>> >>>> On Mon, Jun 10, 2013 at 7:06 AM, Owen O'Malley <omal...@apache.org>wrote: >>>> >>>>> You need to create the partitioned table and then copy the rows into >>>>> it. >>>>> >>>>> create table foo_staging (int x, int y); >>>>> >>>>> create table foo(int x) partitioned by (int y) clustered by (x) into >>>>> 16 buckets; >>>>> >>>>> set hive.exec.dynamic.partition=true; >>>>> set hive.exec.dynamic.partition.mode=nonstrict; >>>>> set hive.enforce.bucketing = true; >>>>> >>>>> insert overwrite table partition (y) select * from foo_staging; >>>>> >>>>> >>>>> On Mon, Jun 10, 2013 at 6:38 AM, Nitin Pawar >>>>> <nitinpawar...@gmail.com>wrote: >>>>> >>>>>> If a table is not partitioned and then you want to partition the >>>>>> table on the data already written but data is not in partition format, >>>>>> that >>>>>> is not doable. >>>>>> >>>>>> Best approach would be, create a new table definition with the >>>>>> partition columns you want. >>>>>> turn on the dynamic partitioning system before you load data into new >>>>>> table >>>>>> >>>>>> set hive.exec.dynamic.partition=true; >>>>>> set hive.exec.dynamic.partition.mode=nonstrict; >>>>>> >>>>>> insert overwrite table partitioned(columns) select * from oldtable >>>>>> >>>>>> >>>>>> remove old table >>>>>> >>>>>> PS: wait for others to add more suggestions. I may be very well >>>>>> wrong in suggesting this >>>>>> >>>>>> >>>>>> On Mon, Jun 10, 2013 at 7:01 PM, Peter Marron < >>>>>> peter.mar...@trilliumsoftware.com> wrote: >>>>>> >>>>>>> Hi,**** >>>>>>> >>>>>>> ** ** >>>>>>> >>>>>>> Using hive 0.10.0 over hadoop 1.0.4**** >>>>>>> >>>>>>> ** ** >>>>>>> >>>>>>> I have a (non-partitioned) table with loads of columns.**** >>>>>>> >>>>>>> I would like to create a partitioned table with the same set of >>>>>>> columns.**** >>>>>>> >>>>>>> So the approach that I have been taking is to use “CREATE TABLE copy >>>>>>> LIKE original;”**** >>>>>>> >>>>>>> then I can use ALTER TABLE to change the location and the INPUTFORMAT >>>>>>> **** >>>>>>> >>>>>>> and the OUTPUTFORMAT and the SERDE and properties and pretty much*** >>>>>>> * >>>>>>> >>>>>>> everything else. However I don’t seem to be able to make it >>>>>>> partitioned.**** >>>>>>> >>>>>>> Sure I can add partitions if it’s already partitioned but I don’t >>>>>>> seem**** >>>>>>> >>>>>>> to be able to make it partitioned if it’s not already. I get errors >>>>>>> like this:**** >>>>>>> >>>>>>> ** ** >>>>>>> >>>>>>> hive> ALTER TABLE customerShortValues ADD PARTITION (aid='1') >>>>>>> LOCATION 'E7/phase2/values/aid=1';**** >>>>>>> >>>>>>> FAILED: Error in metadata: table is not partitioned but partition >>>>>>> spec exists: {aid=1}**** >>>>>>> >>>>>>> FAILED: Execution Error, return code 1 from >>>>>>> org.apache.hadoop.hive.ql.exec.DDLTask**** >>>>>>> >>>>>>> ** ** >>>>>>> >>>>>>> So, I guess that I could create the table I want by hand copying >>>>>>> over all the**** >>>>>>> >>>>>>> column definitions. But is there an easier way?**** >>>>>>> >>>>>>> ** ** >>>>>>> >>>>>>> Z**** >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Nitin Pawar >>>>>> >>>>> >>>>> >>>> >>> >> > > 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. >
