Hi Shuporno,
Did you try following the suggestions from Abhishek? Please let us know your observations. Also, please share the CTAS command you are using to write to s3. Gautam ________________________________ From: Shuporno Choudhury <[email protected]> Sent: Thursday, May 25, 2017 12:11:40 AM To: [email protected] Subject: Re: Writing to s3 using Drill My s3 plugin info is as follows: { "type": "file", "enabled": true, "connection": "s3a://abcd", "config": { "fs.s3a.access.key": "abcd", "fs.s3a.secret.key": "abcd" }, "workspaces": { "root": { "location": "/", "writable": false, "defaultInputFormat": null }, "tmp": { "location": "/", "writable": *true*, "defaultInputFormat": "parquet" } } I have removed the info about the formats to keep the mail small. Also, I am using Dill on *Windows 10* On Mon, May 22, 2017 at 3:57 PM, Shuporno Choudhury < [email protected]> wrote: > Hi, > > Is it possible to write to a folder in an s3 bucket using the *s3.tmp* > workspace? > Whenever I try, it gives me the follwing error: > > *Error: VALIDATION ERROR: Schema [s3.tmp] is not valid with respect to > either root schema or current default schema.* > *Current default schema: s3.root* > > Also, s3.tmp doesn't appear while using the command "*show schemas*" > though the tmp workspace exists in the web console > > I am using Drill Version 1.10; embedded mode on my local system. > > However, I have no problem reading from an s3 bucket, the problem is only > writing to a s3 bucket. > -- > Regards, > Shuporno Choudhury > -- Regards, Shuporno Choudhury
