- export
格式:export table to ‘hdfs_path’
hive (default)> export table liangman21 to '/user/liangman/input'
> ;
FAILED: SemanticException Line 1:13 Invalid path ''/user/liangman/input'': Target is not an empty directory : hdfs://hadoop02-linux.alibaba.com:8020/user/liangman/input
hive (default)>
Copying data from file:/tmp/liangman/hive_2017-01-11_01-21-38_311_5363185718196375169-1/-local-10000/_metadata
Copying file: file:/tmp/liangman/hive_2017-01-11_01-21-38_311_5363185718196375169-1/-local-10000/_metadata
Copying data from hdfs://hadoop02-linux.alibaba.com:8020/user/hive/warehouse/liangman21
Copying file: hdfs://hadoop02-linux.alibaba.com:8020/user/hive/warehouse/liangman21/lm.txt
OK
Time taken: 0.541 seconds
注意:一定是个空文件,文件可以没有被创建
2.import table tbname from ‘hdfs_path’