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>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:

[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.

Reply via email to