create table tb_dept( deptno int, dname string, loc string ) row format delimited fields terminated by ‘\t’;
10 ACCOUNTING NewYork 20 RESEARCH Boston 30 SALES Dallas 40 OPERATIONS Chicago
tb_empcreate table tb_emp( empno int, ename string, job string, mgr int, hiredate string, sal float, comm float, deptno int ) row format delimited fields terminated by ‘\t’;
7369 SMITH CLERK 7902 1980-12-17 800.00 NULL 20 7499 ALLEN SALESMAN 7698 1981-02-20 1600.00 300.00 30 7521 WARD SALESMAN 7698 1981-02-22 1250.00 500.00 30 7566 JONES MANAGER 7839 1981-04-02 2975.00 NULL 20 7654 MARTIN SALESMAN 7698 1981-09-28 1250.00 1400.00 30 7698 BLAKE MANAGER 7839 1981-05-01 2850.00 NULL 30 7782 CLARK MANAGER 7839 1981-06-09 2450.00 NULL 10 7788 SCOTT ANALYST 7566 1987-04-19 3000.00 NULL 20 7839 KING PRESIDENT NULL 1981-11-17 5000.00 NULL 10 7844 TURNER SALESMAN 7698 1981-09-08 1500.00 0.00 30 7876 ADAMS CLERK 7788 1987-05-23 1100.00 NULL 20 7900 JAMES CLERK 7698 1981-12-03 950.00 NULL 30 7902 FORD ANALYST 7566 1981-12-03 3000.00 NULL 20 7934 MILLER CLERK 7782 1982-01-23 1300.00 NULL 10
