版权声明：本文为博主原创文章，未经博主允许不得转载。 https://blog.csdn.net/chengqiuming/article/details/78725181
一 查询语法
二 查询时使用过滤的实例
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
