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_table_column2)
SELECT source_table_column1,  source_table_column2
FROM source_table;

-- 
Best wishs！