Impala之儲存和壓縮

注：impala不支援ORC格式

1.建立parquet格式的表並插入資料進行查詢

[hadoop104:21000] > create table student2(id int, name string)

> row format delimited

> fields terminated by ‘\t’

> stored as PARQUET;

[hadoop104:21000] > insert into table student2 values(1001,’zhangsan’);

[hadoop104:21000] > select * from student2;

2.建立sequenceFile格式的表，插入資料時報錯

[hadoop104:21000] > insert into table student3 values(1001,’zhangsan’);

Query: insert into table student3 values(1001,’zhangsan’)

Query submitted at: 2018-10-25 20:59:31 (Coordinator: http://hadoop104:25000)

Query progress can be monitored at: http://hadoop104:25000/query_plan?query_id=da4c59eb23481bdc:26f012ca00000000

WARNINGS: Writing to table format SEQUENCE_FILE is not supported. Use query option ALLOW_UNSUPPORTED_FORMATS to override.

大資料培訓