在hive下使用dual伪表
2018-03-06 14:27 staryea-bigdata 阅读(2148) 评论(0) 编辑 收藏 举报[hive@nn1 ~]$ touch dual.txt
[hive@nn1 ~]$ echo 'X' >dual.txt
hive> load data local inpath '/home/hive/dual.txt' overwrite into table dual;
hive> select 'a' from dual;
OK
a
Time taken: 1.03 seconds, Fetched: 1 row(s)
hive>