storm-hive整合数据成功写入hdfs中对应的桶中，但在hive对应的表中查询不到写入的数据

Question

344942 [hive-bolt-0] INFO o.a.o.i.PhysicalFsWriter - ORC writer created for path: hdfs://namenode.hadoop:8020/warehouse/tablespace/managed/hive/jsw.db/test/city=sunnyvale/state=ca/delta_0089191_0089200/bucket_00002 with stripeSize: 8388608 blockSize: 268435456 compression: NONE bufferSize: 32768
344950 [hive-bolt-0] INFO o.a.o.i.WriterImpl - ORC writer created for path: hdfs://namenode.hadoop:8020/warehouse/tablespace/managed/hive/jsw.db/test/city=sunnyvale/state=ca/delta_0089191_0089200/bucket_00002 with stripeSize: 8388608 blockSize: 268435456 compression: NONE bufferSize: 32768
2 user2 123456 street2 sunnyvale ca

Answer 1

提问者 mybatis 2018-10-19 19:35:20

请问老师如何刷新？

• Michael_PK #1

  fsck啥的，你查下hive官网ddl语法

Answer 2

Michael_PK 2018-10-19 16:45:52

你尝试刷新下hive meta数据实现，是不是数据和元数据没同步

Answer 3

提问者 mybatis 2018-10-19 15:32:45

建表语句：

create table test( id INT, name STRING, phone STRING, street STRING) partitioned by (city STRING, state STRING) CLUSTERED BY (id) INTO 4 BUCKETS stored as orc tblproperties ("orc.compress"="NONE");

Answer 4

提问者 mybatis 2018-10-19 15:30:24

太奇怪了，并且没有报任何错误

Answer 5

提问者 mybatis 2018-10-19 15:27:41

请Michael__PK老师帮忙分析下是什么原因？