Have you tried Disabling the ACID for that particular session and then try to run perform the query:- 1- Login to beeline or Hive CLI 2- Disable ACID for the session:- set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DummyTxnManager; set hive.support.concurrency=false; 3- Run the Query now to copy the data. ... View more

https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.1/bk_cloud-data-access/content/s3-get-started.html ... View more

S3 Seems to be working fine with HDP 2.6 as You have the option to Define URL in Ranger Hive Policy Section ... View more