_ | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
FrontPage › 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 れ襯 觝.

data.zip
蠍 蠍郁鍵..
企: : るジ讓曙 襦螻豺 企Ν 譯殊語. 襦螻豺
EditText : Print : Mobile : FindPage : DeletePage : LikePages : Powered by MoniWiki : Last modified 2018-04-13 23:12:53

螳 覲旧企 螻 蠏 螻覦燕 蟆企. (A. 讌)