大数据培训Impala之存储和压缩

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.

Impala之存储和压缩