create table dept
(
    dname string
,   loc string
,   deptno int
)
row format delimited
fields terminated by ',';

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 ',';


create table salgrade
(
    grade int
,   losal int
,   hisal int
)
row format delimited
fields terminated by ',';

load data local inpath 'dept.csv'
overwrite into table dept;

load data local inpath 'emp.csv'
overwrite into table emp;

load data local inpath 'salgrade.csv'
overwrite into table salgrade;

set hive.cli.print.header=true;
select * from emp;

• 만약 파일이 hdfs에 있으면, local 키워드를 뺀다.
  
  

data.zip

• dept.txt
  
• emp.txt
  
• salgrade.txt