RE: Create table like with partitions

2013-06-12 Thread Peter Marron
r.mar...@trilliumsoftware.com<mailto:roy.willi...@trilliumsoftware.com> From: Lefty Leverenz [mailto:le...@hortonworks.com] Sent: 12 June 2013 01:39 To: user@hive.apache.org Subject: Re: Create table like with partitions It's an excellent book, and not too expensive so I recommend buying your own copy

Re: Create table like with partitions

2013-06-11 Thread Richa Sharma
Leverenz > Reply-To: "user@hive.apache.org" > Date: Tuesday, June 11, 2013 5:39 PM > To: "user@hive.apache.org" > > Subject: Re: Create table like with partitions > > It's an excellent book, and not too expensive so I recommend buying your > own

Re: Create table like with partitions

2013-06-11 Thread Sanjay Subramanian
Date: Tuesday, June 11, 2013 5:39 PM To: "user@hive.apache.org<mailto:user@hive.apache.org>" mailto:user@hive.apache.org>> Subject: Re: Create table like with partitions It's an excellent book, and not too expensive so I recommend buying your own copy from O'Reilly

Re: Create table like with partitions

2013-06-11 Thread Lefty Leverenz
e Server: > Name Server: > Name Server: > Name Server: > Name Server: > Name Server: > Name Server: > Name Server: > > > From: Dean Wampler > Reply-To: "user@hive.apache.org" > Date: Tuesday, June 11, 2013 11:04 AM > To: "user@hive.apache.org"

Re: Create table like with partitions

2013-06-11 Thread Sanjay Subramanian
rg<mailto:user@hive.apache.org>" mailto:user@hive.apache.org>> Date: Tuesday, June 11, 2013 11:04 AM To: "user@hive.apache.org<mailto:user@hive.apache.org>" mailto:user@hive.apache.org>> Cc: "user@hive.apache.org<mailto:user@hive.apache.org>&quo

Re: Create table like with partitions

2013-06-11 Thread Dean Wampler
I confirmed it is a pirate site. Sent from my rotary phone. On Jun 11, 2013, at 10:33 AM, Edward Capriolo 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 > wrote: >> Hi all, >> >> Found

Re: Create table like with partitions

2013-06-11 Thread Edward Capriolo
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 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 > wrote:

Re: Create table like with partitions

2013-06-11 Thread Richa Sharma
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 wrote: > Thanks for sharing! > > I looked at these links .. Is there any documentation with more examples > with both static and dynamic partitions covered toge

Re: Create table like with partitions

2013-06-11 Thread Richa Sharma
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 wrote: > Dynamic partitions are described in the Hive design docs here: > https://cwiki.

Re: Create table like with partitions

2013-06-11 Thread Lefty Leverenz
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 (sear

Re: Create table like with partitions

2013-06-10 Thread Owen O'Malley
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.enforc

Re: Create table like with partitions

2013-06-10 Thread Richa Sharma
Hi, Can you please point to documentation on Dynamic partitioning. I dont fully understand meaning of values for these parameters. Regards Richa On Mon, Jun 10, 2013 at 7:08 PM, Nitin Pawar wrote: > If a table is not partitioned and then you want to partition the table on > the data already

Re: Create table like with partitions

2013-06-10 Thread Nitin Pawar
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