为了更快的定位您的问题,请提供以下信息,谢谢
【详述】sr 3.2.8 查询 hive catalog, gz 格式的external表, be 直接crash, 可以稳定复现。
【背景】
【业务影响】 不能查表
| CREATE EXTERNAL TABLE rta.iqiyi_rta_gz_new
( |
| ts
string COMMENT ‘from deserializer’, |
| ra
string COMMENT ‘from deserializer’, |
| md
string COMMENT ‘from deserializer’, |
| uri
string COMMENT ‘from deserializer’, |
| st
int COMMENT ‘from deserializer’, |
| ua
string COMMENT ‘from deserializer’, |
| hh
string COMMENT ‘from deserializer’, |
| bb
struct<imei_md5:string,idfa_md5:string,city:int,gender:string,platform:int,age:int,advertiser_ids:array,oaid:string,open_udid:string,request_id_md5:string> COMMENT ‘from deserializer’) |
| PARTITIONED BY ( |
| dt
string, |
| hour
string) |
| ROW FORMAT SERDE |
| ‘org.openx.data.jsonserde.JsonSerDe’ |
| STORED AS INPUTFORMAT |
| ‘org.apache.hadoop.mapred.TextInputFormat’ |
| OUTPUTFORMAT |
| ‘org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat’ |
| LOCATION |
| ‘oss://entobit-dw/rta/iqiyi_rta_gz_new’ |
| TBLPROPERTIES ( |
| ‘bucketing_version’=‘2’, |
| ‘last_modified_time’=‘1718873312’, |
| ‘transient_lastDdlTime’=‘1718873312’) |
±---------------------------------------------------+
【是否存算分离】是
【StarRocks版本】3.2.8
【集群规模】1fe + 2be
【机器信息】16核 + 128G
error log: W0621 17:35:10.448318 31929 cache_file.h:150] write star cache file meta/00000000001D8583_000000000000034A.meta failed, errmsg: INTERNAL: cache is loading meta