准备
vi stu.txt
1 xiapi
2 xiaoxue
3 qingqing
上传文件到hdfs
hadoop fs -copyFromLocal -f /home/hadoop/examples/stu.txt hdfs://192.168.129.102:8020/hive/examples/stu.txt
查看目录
hadoop fs -ls hdfs://192.168.129.102:8020/hive/examples
查看内容
hadoop fs -cat hdfs://192.168.129.102:8020/hive/examples/stu.txt
hive建表,bin/hive启动hive客户端执行:
drop table default.stu ;
create external table default.stu (
id int,
name string
)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'
location 'hdfs://192.168.129.102:8020/hive/examples'
;
查询
select * from default.stu ;
删除外部表并查看数据(外部表数据不会被删除)
drop table default.stu ;
hadoop fs -cat hdfs://192.168.129.102:8020/hive/examples/stu.txt