产品动态
产品公告
安全公告
hive
hive> create database hivewithcos location 'cosn://${bucketname}/${path}';
hive> show databases;OKdefaulthivewithcosTime taken: 0.094 seconds, Fetched: 2 row(s)
hive> use hivewithcos;hive> create table record(id int, name string) row format delimited fields terminated by ',' stored as textfile;
hive> show tables;OKrecordTime taken: 0.063 seconds, Fetched: 1 row(s)
hive> create database test;hive> use test;
hive> create table record(id int, name string) row format delimited fields terminated by ',' stored as textfile location 'cosn://$bucketname/$path';
hive> show tables;OKrecordTime taken: 0.063 seconds, Fetched: 1 row(s)
hive
hive> create database hivewithofs location 'ofs://${mountpoint}/${path}';
hive> show databases;OKdefaulthivewithofsTime taken: 0.094 seconds, Fetched: 2 row(s)
hive> use hivewithofs;hive> create table record(id int, name string) row format delimited fields terminated by ',' stored as textfile;
hive> show tables;OKrecordTime taken: 0.063 seconds, Fetched: 1 row(s)
hive> create database test2;hive> use test2;
hive> create table record(id int, name string) row format delimited fields terminated by ',' stored as textfile location 'cosn://$mountpoint/$path';
hive> show tables;OKrecordTime taken: 0.063 seconds, Fetched: 1 row(s)
文档反馈