Creating Databases Based on COS
Last updated: 2019-07-26 17:48:40PDF
There are two ways to create a Cloud Object Storage (COS) database:
Create the whole database in COS
To do so, run the following statement:
create database hivewithcos location ’cosn://huadong/hive’;
Here, huadong is the bucket name, and hive is the path, which can be set as needed. After creating the database, you can create a data table.
create table record(id int, name string) row format delimited fields terminated by ’,’ stored as textfile;
Then, load data into the table, which can be used in exactly the same way as HDFS.
Move the specified table into COS
First, select or create a database in Hive. Then move the specified table into COS by running the following statement:
create table record(id int, name string) row format delimited fields terminated by ’,’ stored as textfile location ’cosn://huadong/hive/cos’;
Load data into the table. Now the table is stored in COS.