在hive中虚构dual表

xiaoxiao2021-02-28  194

步骤:

1.创建一个dual表

hive> create table dual(dummy string);

2.

创建/home/hadoop/djt/dual.txt

echo 'X'>>/home/hadoop/djt/dual.txt

3.把dual.txt导入dual表

hive> load data local inpath '/home/hadoop/djt/dual.txt' into table dual;

4.测试

hive> select length('aades') from dual;   OK 5

转载请注明原文地址: https://www.6miu.com/read-60496.html

最新回复(0)