hadoop dept100.csv 를 dept 테이블에 입력

[22기_양은주]

[oracle@centos ~]$ hadoop fs -mkdir /tmp/yej2
[oracle@centos ~]$ hadoop fs -put /home/oracle/emp.csv /user/oracle/emp100.csv
[oracle@centos ~]$ hadoop fs -put /home/oracle/dept.csv /user/oracle/dept100.csv
[oracle@centos ~]$ hadoop fs -ls /tmp/
Found 3 items
drwxrwxrwx   - oracle supergroup          0 2026-02-09 14:20 /tmp/hive
drwxrwxrwx   - oracle supergroup          0 2026-02-09 15:42 /tmp/yej
drwxr-xr-x   - oracle supergroup          0 2026-02-09 15:45 /tmp/yej2
[oracle@centos ~]$ hadoop fs -chmod 777 /tmp/yej2


CREATE TABLE emp (

empno INT,

ename STRING,

job STRING,

mgr INT,

hiredate STRING,

sal INT,

comm INT,

deptno INT

)

ROW FORMAT DELIMITED

FIELDS TERMINATED BY ','

LINES TERMINATED BY '\n'

STORED AS TEXTFILE

LOCATION '/tmp/yej';

load data inpath '/user/oracle/emp100.csv'

overwrite into table emp;

CREATE TABLE dept

( DEPTNO int,

DNAME string,

LOC string

)

ROW FORMAT DELIMITED

FIELDS TERMINATED BY ','

LINES TERMINATED BY '\n'

STORED AS TEXTFILE

LOCATION '/tmp/yej2';

load data inpath '/user/oracle/dept100.csv' into table dept;

select * from emp;

select * from dept;