很简单，看看下面的列子：

ROM staged_employees se  
INSERT INTO TABLE employess   
  PARTTITION (country = 'US',state = 'OR')  
  SELECT * WHERE se.cnty = 'US' AND se.st = 'OR';  
INSERT INTO TABLE employess   
  PARTTITION (country = 'US',state = 'CA')  
  SELECT * WHERE se.cnty = 'US' AND se.st = 'CA';  
INSERT INTO TABLE employess   
  PARTTITION (country = 'US',state = 'IL')  
  SELECT * WHERE se.cnty = 'US' AND se.st = 'IL'; 

你只扫描一次表就可以将数据插入到对应的分区中。这个很强大的。