Re: partitioned by usage

2014-01-07 Thread Nitin Pawar
its something like this create table xyz (a int, b string) partitioned by (c string); LOAD DATA LOCAL INPATH 'abc' INTO TABLE xyx PARTITION(c="abc"); remember if your data has multiple values on partition column and you do not want to write mapreduce code or pig scripts then you will need a tempo

Re: partitioned by usage

2014-01-07 Thread Kishore kumar
How to create partitioned table without creating intermediate table? simply.. On Tue, Jan 7, 2014 at 10:21 AM, Nitin Pawar wrote: > can you put your question in with an example? > > > On Tue, Jan 7, 2014 at 2:43 PM, Kishore kumar wrote: > >> Hi Experts, >> >> As per this link >> >> >> http://sta

Re: partitioned by usage

2014-01-07 Thread Nitin Pawar
can you put your question in with an example? On Tue, Jan 7, 2014 at 2:43 PM, Kishore kumar wrote: > Hi Experts, > > As per this link > > > http://stackoverflow.com/questions/10276584/hive-table-partition-with-column-in-the-middle > > I understood that we can create the partitioned table when w