oushuDB之各类压缩表如何创建

最新推荐文章于 2023-01-03 09:54:41 发布

xiao_mini

最新推荐文章于 2023-01-03 09:54:41 发布

阅读量316

点赞数

分类专栏： oushuDB hawq greenplum

本文链接：https://blog.csdn.net/qq_23490833/article/details/115706586

版权

本文介绍了oushuDB中不同类型的压缩表创建方法，包括Append only table、Parquet table和Native Orc table。详细列出了Snappy、Lz4、Zlib和zstd等压缩算法的使用，并指出在某些情况下，压缩级别的设置可能无效，会默认为level=1。

摘要由CSDN通过智能技术生成

oushuDB version

PostgreSQL 8.2.15 (OushuDB 4.1.0.0 build 25055 Enterprise Edition) 
(Apache HAWQ 2.4.0.0) (Greenplum Database 4.2.0)

Table type

Append only table

None

CREATE TABLE ao_demo_none (id int) 
with (appendonly =true, orientation =row );

Snappy [ - ]

CREATE TABLE ao_demo_snappy (id int) 
with (appendonly =true, orientation =row , compresstype = snappy);

Lz4 [ 0-9 ]

CREATE TABLE ao_demo_lz4 (id int) 
with (appendonly =true, orientation =row , compresstype = lz4);

CREATE TABLE ao_demo_lz4_01 (id int) 
with (appendonly =true, orientation =row , compresstype = lz4,compresslevel=1);

CREATE TABLE ao_demo_lz4_02 (id int) 
with (appendonly =true, orientation =row , compresstype = lz4,compresslevel=2);

CREATE TABLE ao_demo_lz4_03 (id int) 
with (appendonly =true, orientation =row , compresstype = lz4,compresslevel=3);

CREATE TABLE ao_demo_lz4_04 (id int) 
with (appendonly =true, orientation =row , compresstype = lz4,compresslevel=4);

CREATE TABLE ao_demo_lz4_05 (id int) 
with (appendonly =true, orientation =row , compresstype = lz4,compresslevel=5);

CREATE TABLE ao_demo_lz4_06 (id int) 
with (appendonly =true, orientation =row , compresstype = lz4,compresslevel=6);

CREATE TABLE ao_demo_lz4_07 (id int) 
with (appendonly =true, orientation =row , compresstype = lz4,compresslevel=7);

CREATE TABLE ao_demo_lz4_08 (id int) 
with (appendonly =true, orientation =row , compresstype = lz4,compresslevel=8);

CREATE TABLE

最低0.47元/天解锁文章