alter external TABLENAME刷新错误

Question

错误消息- SQL执行内部错误:由于错误300002:1263389222，处理中止；事件9679362。

正在尝试刷新S3上的外部表。它以前也起过作用。

create or replace external table EXT_ANIXTER_WNT_PART(event_timestamp datetime as TO_TIMESTAMP(value:wirepas.wirepas.packetReceivedEvent.rxTimeMsEpoch::varchar),
source_endpoint int as (value:wirepas.wirepas.packetReceivedEvent.sourceEndpoint::int),
source_address int as  (value:wirepas.wirepas.packetReceivedEvent.sourceAddress::int),
folder varchar as (split_part(metadata$filename,'/', 1)::varchar),
message_date date as to_date(split_part(metadata$filename,'/', 2) ||'/' || split_part(metadata$filename,'/', 3) ||'/' || split_part(metadata$filename,'/', 4), 'YYYY/MM/DD')
partition by (folder, message_date)
location = @LABS_DATA.SBAS.PROLOGIS2WPEWNT_EXTWIREPAS_COM
file_format = (type = JSON)
refresh_on_create = TRUE
auto_refresh = TRUE

Answer 1

尝试增加仓库大小，看看是否有效。根据S3存储桶中的文件数量，当前仓库可能不足以读取所有文件(这可能是由于当前仓库大小的内存不足)。