【已解决】doris查询结果导出parquet格式成功,但是查询hive结果为空

Viewed 60

Doris版本:1.2.7

导出语句如下:
SELECT
biz_id,
raw_product_num,
operate_tm
FROM
xxx
INTO OUTFILE "hdfs://nameservice1/test/doris_query_result/pt=20240319/"
FORMAT AS PARQUET
PROPERTIES (
"fs.defaultFS" = "hdfs://nameservice1",
"dfs.nameservices" = "nameservice1",
"dfs.ha.namenodes.nameservice1" = "nn1,nn2",
"dfs.namenode.rpc-address.nameservice1.nn1" = "xxx:8020",
"dfs.namenode.rpc-address.nameservice1.nn2" = "xxx:8020",
"dfs.client.failover.proxy.provider.nameservice1" = "org.apache.hadoop.hdfs.server.namenode.ha.ConfiguredFailoverProxyProvider",
"hadoop.security.authentication" = "simple",
"hadoop.username" = "hdfs",
"schema"="required,byte_array,biz_id;required,int32,raw_product_num;required,int64,operate_tm"
);

导出结果返回成功,但是查询hive表无记录。hive外表分区字段为pt,location为hdfs://nameservice1/test/doris_query_result。

1 Answers

你要手动再导入一下hive才能识别