hive建表

准备
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 '/hive/examples' 

;

查询
select * from default.stu ;