drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Charles Givre <cgi...@gmail.com>
Subject S3 Connection Issues
Date Thu, 19 Oct 2017 03:14:30 GMT
Hello all, 
I’m trying to use Drill to query data in an S3 bucket and running into some issues which
I can’t seem to fix.  I followed the various instructions online to set up Drill with S3,
and put my keys in both the conf-site.xml and in the plugin config, but every time I attempt
to do anything I get the following errors:


 jdbc:drill:zk=local> show databases;
Error: SYSTEM ERROR: AmazonS3Exception: Status Code: 403, AWS Service: Amazon S3, AWS Request
ID: 56D1999BD1E62DEB, AWS Error Code: null, AWS Error Message: Forbidden


[Error Id: 65d0bb52-a923-4e98-8ab1-65678169140e on charless-mbp-2.fios-router.home:31010]
(state=,code=0)
0: jdbc:drill:zk=local> show databases;
Error: SYSTEM ERROR: AmazonS3Exception: Status Code: 403, AWS Service: Amazon S3, AWS Request
ID: 4D2CBA8D42A9ECA0, AWS Error Code: null, AWS Error Message: Forbidden


[Error Id: 25a2d008-2f4d-4433-a809-b91ae063e61a on charless-mbp-2.fios-router.home:31010]
(state=,code=0)
0: jdbc:drill:zk=local> show files in s3.root;
Error: SYSTEM ERROR: AmazonS3Exception: Status Code: 403, AWS Service: Amazon S3, AWS Request
ID: 2C635944EDE591F0, AWS Error Code: null, AWS Error Message: Forbidden


[Error Id: 02e136f5-68c0-4b47-9175-a9935bda5e1c on charless-mbp-2.fios-router.home:31010]
(state=,code=0)
0: jdbc:drill:zk=local> show schemas;
Error: SYSTEM ERROR: AmazonS3Exception: Status Code: 403, AWS Service: Amazon S3, AWS Request
ID: 646EB5B2EBCF7CD2, AWS Error Code: null, AWS Error Message: Forbidden


[Error Id: 954aaffe-616a-4f40-9ba5-d4b7c04fe238 on charless-mbp-2.fios-router.home:31010]
(state=,code=0)

I have verified that the keys are correct but using the AWS CLI and downloaded some of the
files, but I’m kind of at a loss as to how to debug.  Any suggestions?
Thanks in advance,
— C
Mime
View raw message