You have to put the actual ID and KEY in the storage plugin (not recommended per se if you don't have the WebUI secured).
Or you can edit the core-site.xml file in the drill conf directory to add the s3a ID and KEY there. Also use s3a not s3 in the later versions of Drill. http://drill.apache.org/docs/s3-storage-plugin/ <http://drill.apache.org/docs/s3-storage-plugin/> --Andries > On Aug 3, 2016, at 5:48 PM, <mdhr...@yahoo.com.INVALID> > <mdhr...@yahoo.com.INVALID> wrote: > > > Hi, > I am trying to configure an s3 bucket and I am getting this error. Can any > one help me > org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: > IllegalArgumentException: AWS Access Key ID and Secret Access Key must be > specified as the username or password (respectively) of a s3 URL, or by > setting the fs.s3.awsAccessKeyId or fs.s3.awsSecretAccessKey properties > (respectively).[Error Id: 02956e73-87a8-4279-b6db-cb89d11821b8 on > 10.64.86.175:31010] > > The bucket name is itgs-hiss-reporting > are the sub folder in it. > /staging/oneems > The storage plugin is{ > "type": "file", > "enabled": true, > "connection": "s3://itgs-hiss-reporting", > "config": { > "fs.s3a.awsAccessKeyId": "id", > "fs.s3a.awsSecretAccessKey": "key" > }, > "workspaces": { > "root": { > "location": "/staging", > "writable": false, > "defaultInputFormat": "csv" > }, > the core-site.xml config is > <configuration> > > <property> > <name>fs.s3a.access.key</name> > <value>ID</value> > </property> > > <property> > <name>fs.s3a.secret.key</name> > <value>Secret Key</value> > > </property> > > </configuration> > > When I got to drill ip:8047 > > and then do a show databases I get this error > org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: > IllegalArgumentException: AWS Access Key ID and Secret Access Key must be > specified as the username or password (respectively) of a s3 URL, or by > setting the fs.s3.awsAccessKeyId or fs.s3.awsSecretAccessKey properties > (respectively).[Error Id: 352382c5-76ec-4253-b323-35e167f14db6 > > > > >
