I have successfully set up an s3 access point which works for me using
* AWS CLI * AW C# SDK I would like to use Apache Drill and I have seen it supports access points here : https://hadoop.apache.org/docs/stable/hadoop-aws/tools/hadoop-aws/index.html#accesspoints So I currently have this in the Drill s3 storage setup, which as far as I can tell is correct [cid:image001.png@01D8FA85.98A58B90] Where the following is true * "Connection" points ot the actual s3 location * fs.s3a.binli-qlik-test-bucket.accesspoint.arn : is my specific access point ARN for that bucket, which seems to be what the docs show here [cid:image004.png@01D8FA85.D6A547A0] In my core-site.xml I have the following lines commented out <!-- <property> <name>fs.s3a.access.key</name> <value>AKIA6QKOBPZIAWLWD5OZ</value> </property> <property> <name>fs.s3a.secret.key</name> <value>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</value> </property> <property> <name>fs.s3a.endpoint</name> <value>s3.eu-west-1.amazonaws.com</value> </property> --> So when I run this query in the web UI select * from s3.`subfolder` limit 10 I get this error: [cid:image005.png@01D8FA86.8C551EE0] As I say this works in 2 other demos outside of Apache Drill. What am I doing wrong with Acess Poinits there is not many web pages explaning this. I am a bit lost Kind regards, Sacha Barber Technical Lead TP ICAP [cid:image006.png@01D8FA86.8C551EE0]<http://www.tpicap.com/> Classification: Public This communication is sent by TP ICAP plc on behalf of the ICAP Energy Limited Tullett Prebon (Europe) Limited and Spectron Energy Services Limited (together the “Tankard Parties”). All information contained in or attached to it (including, but not limited to market prices/levels and market commentary) (the "Information") is for information purposes only, is confidential, may be legally privileged and is the intellectual property of the Tankard Parties. The Information is subject to any terms of business as published or communicated to clients from time to time and is directed to Eligible Counterparties and Professional Customers only and is not intended for Retail Clients (as each term is defined by the rules of the Financial Conduct Authority). The Information is not, and should not be construed as, an offer, bid, recommendation or solicitation in relation to any financial instrument or investment or to participate in any particular trading strategy. The Information is not to be relied upon and is not warranted, including, but not limited, as to completeness, timeliness or accuracy and is subject to change without notice. All representations and warranties are expressly disclaimed. Access to the Information by anyone other than the intended recipient is unauthorised and any disclosure, copying or redistribution is prohibited. For further regulatory information please see www.icap.com. If you receive this message in error, please immediately delete all copies of it and notify the sender. We have taken precautions to minimise the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Tullett Prebon (Europe) Limited and ICAP Energy Limited are part of TP ICAP group. TP ICAP Group plc | Registered in Jersey | Company number 130617. For further information please visit www.tpicap.com.