HIVE

질의(결과 입력)

* hive 테이블에 입력

hive> insert overwrite table zipcode_result 

select zip, sido, gugun, dong, doro 

from zipcode 

where ver='2012-01-01' and doro like '%역%';

 * 결과를 HDFS에 저장

hive> insert overwrite directory '/tmp/zipcode_result'

select zip, sido, gugun, dong, doro 

from zipcode 

where ver='2012-01-01' and doro like '%역%';

* 결과를 로컬 디렉토리에 저장

hive> insert overwrite local directory '/tmp/zipcode_result'

select zip, sido, gugun, dong, doro 

from zipcode 

where ver='2012-01-01' and doro like '%역%';

http://egloos.zum.com/dancal/v/10929223