大数据培训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.

想要了解跟多关于大数据培训课程内容欢迎关注尚硅谷大数据培训，尚硅谷除了这些技术文章外还有免费的高质量大数据培训课程视频供广大学员下载学习。