HIVE export import

来源:互联网 发布:学川教育网络课 编辑:程序博客网 时间:2024/05/13 14:22
  1. 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/inputhive (default)>
Copying data from file:/tmp/liangman/hive_2017-01-11_01-21-38_311_5363185718196375169-1/-local-10000/_metadataCopying file: file:/tmp/liangman/hive_2017-01-11_01-21-38_311_5363185718196375169-1/-local-10000/_metadataCopying data from hdfs://hadoop02-linux.alibaba.com:8020/user/hive/warehouse/liangman21Copying file: hdfs://hadoop02-linux.alibaba.com:8020/user/hive/warehouse/liangman21/lm.txtOKTime taken: 0.541 seconds

注意:一定是个空文件,文件可以没有被创建
2.import table tbname from ‘hdfs_path’

0 0
原创粉丝点击