#title Hive 예제파일

{{{
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 키워드를 뺀다. ''

attachment:Hive예제파일/data.zip
 * attachment:Hive예제파일/dept.txt
 * attachment:Hive예제파일/emp.txt
 * attachment:Hive예제파일/salgrade.txt