Hi Vaibhav, Which version do you use for testing?
In Hive 0.7 (trunk, I'm currently using), Both 'INSERT OVERWRITE ... SELECT' and 'LOAD DATA ..' statements throw an error when I try to insert data into a partitioned table without specifying a 'PARTITION' clause. - Youngwoo 2011/1/7 vaibhav negi <sssssssena...@gmail.com> > > Hi Youngwoo, > > Hive allows u to load data into a partiotioned table without specifying > partiiton column value. > > I did this simple test. > > 1. create hive table with 1 partition coulumn > 2. load data into table without specifying partition column, got success > message. > 3. can see data file in hadoop, but if u query hive, u can't access that. > > It's a bug > > Thanks and Regards > > Vaibhav Negi > > > > On Fri, Jan 7, 2011 at 3:17 PM, 김영우 <warwit...@gmail.com> wrote: > >> Hi Jeff, >> >> How could you insert data into a partitioned table without specify >> partition columns or value? >> >> >> - Youngwoo >> >> 2011/1/7 Jeff Zhang <zjf...@gmail.com> >> >> Hi all >>> >>> I create a table with a partition. Then I import data into this table >>> without specify partition, in this case I cannot retrieval data from >>> this table using select statement. >>> But I can retrieve data when importing data with specify partition. >>> >>> So I think since hive do not allow me to retrieve data in the first >>> case, it should not allow me to import data without specify partition >>> >>> >>> -- >>> Best Regards >>> >>> Jeff Zhang >>> >> >> >
