Update materialized view with latest s3 file starrocks
So with starrocks I have a pipe that looks for new files in my s3 bucket, now I would like to have this file in a temporary table which would get overwritten with the latest file that lands in my s3 bucket. But a starrocks pipe does not support INSERT OVERWRITE so how would one achieve something like this. My materialized view looks something like this.
Update materialized view with latest s3 file starrocks
So with starrocks I have a pipe that looks for new files in my s3 bucket, now I would like to have this file in a temporary table which would get overwritten with the latest file that lands in my s3 bucket. But a starrocks pipe does not support INSERT OVERWRITE so how would one achieve something like this. My materialized view looks something like this.
Update materialized view with latest s3 file starrocks
So with starrocks I have a pipe that looks for new files in my s3 bucket, now I would like to have this file in a temporary table which would get overwritten with the latest file that lands in my s3 bucket. But a starrocks pipe does not support INSERT OVERWRITE so how would one achieve something like this. My materialized view looks something like this.
Update materialized view with latest s3 file starrocks
So with starrocks I have a pipe that looks for new files in my s3 bucket, now I would like to have this file in a temporary table which would get overwritten with the latest file that lands in my s3 bucket. But a starrocks pipe does not support INSERT OVERWRITE so how would one achieve something like this. My materialized view looks something like this.
Update materialized view with latest s3 file starrocks
So with starrocks I have a pipe that looks for new files in my s3 bucket, now I would like to have this file in a temporary table which would get overwritten with the latest file that lands in my s3 bucket. But a starrocks pipe does not support INSERT OVERWRITE so how would one achieve something like this. My materialized view looks something like this.
Update materialized view with latest s3 file starrocks
So with starrocks I have a pipe that looks for new files in my s3 bucket, now I would like to have this file in a temporary table which would get overwritten with the latest file that lands in my s3 bucket. But a starrocks pipe does not support INSERT OVERWRITE so how would one achieve something like this. My materialized view looks something like this.