There are two ways to create a Cloud Object Storage (COS) data warehouse:
To do so, run the following statement:
create database hivewithcos location 'cosn://huadong/hive';
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.
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.