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 





Reply via email to