Hive在查询中使用过滤

来源：互联网发布：软件布道师编辑：程序博客网时间：2024/06/08 05:00

一 查询语法

二 查询时使用过滤的实例

1、查询10号部门的员工

select * from emp where deptno =10;

hive> select * from emp where deptno =10;

OK

1001.0 Tome null 5000.0 10.0

1002.0 Tome null 5000.0 10.0

7782.0 CLARK MANAGER 8450.0 10.0

7839.0 KING PRESIDENT 12111.0 10.0

7934.0 MILLER CLERK 5300.0 10.0

Time taken: 0.792 seconds, Fetched: 5 row(s)

2、查询名叫KING的员工

select * from emp where ename='KING';

hive> select * from emp where ename='KING';

OK

7839.0 KING PRESIDENT 12111.0 10.0

Time taken: 0.16 seconds, Fetched: 1 row(s)

3、查询部门号未10.薪水小于6000的员工

hive> select * from emp where deptno=10 and sal<6000;

OK

1001.0 Tome null 5000.0 10.0

1002.0 Tome null 5000.0 10.0

7934.0 MILLER CLERK 5300.0 10.0

Time taken: 0.206 seconds, Fetched: 3 row(s)

4、模糊查询：查询名字以S打头的员工

select empno,ename,sal from emp where ename like 'S%'

hive> select empno,ename,sal from emp where ename like 'S%';

OK

7369.0 SMITH 4800.0

7788.0 SCOTT 7000.0

5、模糊查询：查询名字含有下划线的员工

select empno,ename,sal from emp where ename like '%\\_%'

hive> select empno,ename,sal from emp where ename like '%\\_%';

OK

Time taken: 0.092 seconds

阅读全文

0 0