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 >> > >
