INSERT OVERWRITE TABLE source_table SELECT t1, t3 FROM
> target_table;"
>
> ** **
>
> -Chinna Rao Lalam
>
> ** **
> --
>
> *From:* 曹坤 [mailto:caofang...@gmail.com]
> *Sent:* Wednesday, August 03, 2011 11:00 AM
> *To:* chinna...@huawei.com
> *Cc:*
=val1, partcol2=val2 ...)]
select_statement1 FROM from_statement;
-Chinna Rao Lalam
-Original Message-
From: 曹坤 [mailto:caofang...@gmail.com]
Sent: Wednesday, August 03, 2011 8:30 AM
To: dev@hive.apache.org
Subject: how to insert data to specified columns
Hello :
Any idea about how to inse
...)]
> select_statement1 FROM from_statement;
>
> -Chinna Rao Lalam
>
> -Original Message-
> From: 曹坤 [mailto:caofang...@gmail.com]
> Sent: Wednesday, August 03, 2011 8:30 AM
> To: dev@hive.apache.org
> Subject: how to insert data to specified columns
>
> H
TABLE tablename1 [PARTITION (partcol1=val1, partcol2=val2 ...)]
select_statement1 FROM from_statement;
-Chinna Rao Lalam
-Original Message-
From: 曹坤 [mailto:caofang...@gmail.com]
Sent: Wednesday, August 03, 2011 8:30 AM
To: dev@hive.apache.org
Subject: how to insert data to specified columns
Hello :
Any idea about how to insert data to specified columns?
In a way like follow :
INSERT OVERWRITE TABLE target_table
PARTITION (day='20110803' , hour='11')
(target_table_column1,target_t
