RE: Inserting data into Hive Tables from queries

2009-09-05 Thread Ashish Thusoo
: Vijay [tec...@gmail.com] Sent: Friday, September 04, 2009 9:09 PM To: hive-user@hadoop.apache.org Subject: Inserting data into Hive Tables from queries Hi, When using the INSERT OVERWRITE TABLE ... FROM SELECT syntax, you can specify partition information for the inserts. However, these partition

Inserting data into Hive Tables from queries

2009-09-04 Thread Vijay
Hi, When using the INSERT OVERWRITE TABLE ... FROM SELECT syntax, you can specify partition information for the inserts. However, these partition values can only be literals. This seems too restrictive. For example, I have a query like this: SELECT month, day, count(1) FROM tab1 GROUP BY month, da