Data Engineering Integration
- Data Engineering Integration 10.5.2
- All Products
CREATE TABLE TEST_RCFIle (id int, name string) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe' STORED AS RCFILE;
File Format
| Table Property Name
| Table Property Values
|
---|---|---|
Avro
| avro.compression
| BZIP2, deflate, Snappy
|
ORC
| orc.compress
| Snappy, ZLIB
|
Parquet
| parquet.compression
| GZIP, Snappy
|
RCFile
| rcfile.compression
| Snappy, ZLIB
|
Sequence
| sequencefile.compression
| BZIP2, GZIP, LZ4, Snappy
|
Text
| text.compression
| BZIP2, GZIP, LZ4, Snappy
|
create table CBO_3T_JOINS_CUSTOMER_HIVE_SEQ_GZIP (C_CUSTKEY DECIMAL(38,0), C_NAME STRING,C_ADDRESS STRING, C_PHONE STRING,C_ACCTBAL DECIMAL(10,2), C_MKTSEGMENT VARCHAR(10),C_COMMENT vARCHAR(117)) partitioned by (C_NATIONKEY DECIMAL(38,0)) TBLPROPERTIES ('sequencefile.compression'='gzip') stored as SEQUENCEFILE;
ALTER TABLE table_name SET TBLPROPERTIES (avro.compression'='BZIP2');