Hello all! I'm trying to export data from a table to my S3 bucket using the following command:

INSERT INTO
  EXTERN(
    s3(bucket => 'test-bucket', prefix => 'druid')
  )
AS CSV
select * from "test_table" limit 100

but I'm getting this error:

Error: SQL parse failed

Encountered "(" at line 3, column 7. More...

org.apache.calcite.sql.parser.SqlParseException

Druid version is 25, the druid-s3-extensions extension is installed. What could be the issue?

This is not available in Druid 25 - it was introduced in 29 https://druid.apache.org/docs/29.0.0/release-info/release-notes#msq-export-statements-experimental

If you want to use export, please use druid 31

@Kyle Hoondert @Karan Kumar Thank you for the feedback! I was able to install the new (version 31) Druid, but now when I make the previous request, I get the following error:

Error: UNCATEGORIZED (DEVELOPER)
Unable to provision, see the following errors: 1) Problem parsing object at prefix[druid.msq.intermediate.storage]: Missing required creator property 'bucket' (index 0) at [Source: UNKNOWN; line: -1, column: -1] (through reference chain: org.apache.druid.storage.s3.output.S3OutputConfig["bucket"]). at org.apache.druid.guice.JsonConfigProvider.bind(JsonConfigProvider.java:151) (via modules: com.google.inject.util.Modules$OverrideModule -> org.apache.druid.storage.s3.output.S3StorageConnectorModule) at org.apache.druid.guice.JsonConfigProvider.bind(JsonConfigProvider.java:151) (via modules: com.google.inject.util.Modules$OverrideModule -> org.apache.druid.storage.s3.output.S3StorageConnectorModule) while locating org.apache.druid.storage.s3.output.S3OutputConfig for the 1st parameter of org.apache.druid.storage.s3.output.S3UploadManager.<init>(S3UploadManager.java:72) at org.apache.druid.storage.s3.output.S3UploadManager.class(S3UploadManager.java:60) while locating org.apache.druid.storage.s3.output.S3UploadManager 1 error

What could be the reason?

It looks like you are missing a property in the config https://druid.apache.org/docs/latest/multi-stage-query/reference/#durable-storage-configurations