Re: Find a case that does not make sense in hive

2011-01-07 Thread Edward Capriolo
On Fri, Jan 7, 2011 at 5:17 AM, 김영우 wrote: > 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 '

Re: Find a case that does not make sense in hive

2011-01-07 Thread 김영우
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 neg

Re: Find a case that does not make sense in hive

2011-01-07 Thread vaibhav negi
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

Re: Find a case that does not make sense in hive

2011-01-07 Thread 김영우
Hi Jeff, How could you insert data into a partitioned table without specify partition columns or value? - Youngwoo 2011/1/7 Jeff Zhang > 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 > th