Hi Sacha
This mailing list does not support images in emails so we can't see a
lot of what you've sent. Where the images are screenshots of text can
you include the text instead? If there are still cases where you want to
send an image rather than text, please use a paste bin service and
include hyperlinks in your email.
Thanks
James
On 2022/11/17 15:14, Barber, Sacha wrote:
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
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
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>4/DPE5E4YeBRilJklWlt5nBEA6T/PKGMsxA1TyjR</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:
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
<http://www.tpicap.com/>
Classification: Public
*Honesty | Integrity | Respect | Excellence *
------------------------------------------------------------------------
The information contained in this email is confidential and may also
contain privileged information. Sender does not waive confidentiality
or legal privilege. If you are not the intended recipient please
notify the sender immediately; you should not retain this message or
disclose its content to anyone.
Internet communications are not secure or error free and the sender
does not accept any liability for the content of the email. Although
emails are routinely screened for viruses, the sender does not accept
responsibility for any damage caused. Replies to this email may be
monitored.
TP ICAP Group plc | Registered in Jersey | Company number 130617.
Please visit www.tpicap.com for further information on TP ICAP group.
------------------------------------------------------------------------
