Creating Databases Based on COS
Last updated: 2021-08-12 10:25:16
Creating Databases Based on COS
Last updated: 2021-08-12 10:25:16
There are two ways to create a Cloud Object Storage (COS) data warehouse:
Method 1: Creating 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. Then, load data into the table, which can be used in exactly the same way as HDFS.create table record(id int, name string) row format delimited fields terminated by ',' stored as textfile;
Method 2: Moving 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. At this time, the table is stored in COS.
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No
Feedback