Local file broker load error. type:ETL_RUN_FAIL; msg:No source file in this table(cities).

[alberttwong]

following tutorial at https://github.com/StarRocks/starrocks/discussions/22777.

parquet file from https://docs.snowflake.com/en/_downloads/0c1e6c4f4140561029eeb20afdd02664/cities.parquet

atwong@Alberts-MBP-2 Downloads % file /Users/atwong/Downloads/cities.parquet /Users/atwong/Downloads/cities.parquet: Apache Parquet

use testparquet;
CREATE TABLE `cities`
(
    `continent` varchar(65533 ) NULL DEFAULT "" COMMENT "continent",
    `country` varchar(65533 ) NULL DEFAULT "" COMMENT "country",
    `city` JSON NULL  COMMENT "city"
)
ENGINE=OLAP
DUPLICATE KEY(`continent`)
DISTRIBUTED BY HASH(`continent`) BUCKETS 
10
;

load label abc(data infile("file:///Users/atwong/Downloads/cities.parquet") into table cities (continent, country)) with broker properties("timeout"="3600");

error.

| 10119 | abc   | CANCELLED | ETL:N/A; LOAD:N/A | BROKER | NORMAL   | 0        | 0            | 0              | 0        | NULL    | resource:N/A; timeout(s):3600; max_filter_ratio:0.0 | type:ETL_RUN_FAIL; msg:No source file in this table(cities).                                                                          | 2023-06-27 21:13:00 | NULL         | NULL          | NULL          | 2023-06-27 21:13:01 |             | {"All backends":{},"FileNumber":0,"FileSize":0,"InternalTableLoadBytes":0,"InternalTableLoadRows":0,"ScanBytes":0,"ScanRows":0,"TaskNumber":0,"Unfinished backends":{}} |

[alberttwong]

related to https://github.com/StarRocks/starrocks/issues/26060

[alberttwong]

broker is now in allin1 as of 3.1