Writing to s3 using Drill

2017-05-22 Thread Shuporno Choudhury
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,

Re: Writing to s3 using Drill

2017-05-22 Thread Gautam Parai
Hi Shuporno, Could you please specify the configuration from S3 storage plugin here and the output of `show schemas` as it pertains to s3? Is `writable` set to true? Gautam From: Shuporno Choudhury Sent: Monday, May 22, 2017

Re: Writing to s3 using Drill

2017-05-22 Thread Sorabh Hamirwasia
Hi Shuporno, Can you please share your S3 plugin configuration ? Looks like in your configuration you might be missing something like below: "tmp": { "location": "drill-tmp", "writable": true, "defaultInputFormat": null } Thanks, Sorabh