Hologres笔记

Hologres笔记

一、常用命令

-- 创建内部表
begin;
create table [if not exists] [schema_name.]table_name(
	id bigint primary key,
    b text,
    ds text,
)
partition by list(ds);
commit;

-- 创建子表
create table if not exists table_name_date_202101 partition of table_name for values in ('202101');

-- 创建外部表
CREATE FOREIGN TABLE odps_students (
	id bigint,
    b text,
    ds text,
)
SERVER odps_server
OPTIONS (project_name 'public_data', table_name 'oracle2odps_cust');

-- 删除表	
DROP TABLE [ IF EXISTS ] table_name [, ...];

-- 删除外部表
DROP FOREIGN TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]

-- 修改表名
ALTER TABLE table_name RENAME to new_table_name;

-- 修改外部表名
ALTER FOREIGN TABLE [ IF EXISTS ] name RENAME TO new_name;

-- 增加列
ALTER TABLE IF EXISTS table_name ADD COLUMN new_column_name data_type; 
ALTER TABLE IF EXISTS table_name ADD COLUMN col_add_1 data_type, ADD COLUMN col_add_2 TEXT IF NOT EXISTS col_add_2 data_type;

-- 给表增加注释
COMMENT ON TABLE table_name IS 'my comments on table table_name.';

-- 给列增加注释
COMMENT ON COLUMN table_name.col1 IS 'This my first col1';

-- 给外部表增加注释
COMMENT ON FOREIGN TABLE foreign_table IS ' comments on my foreign table';

-- 查询执行计划
explain querysql;