Try 6 out of 6<br>Exception:<br>SLF4J: Class path contains multiple SLF4J bindings.<br>SLF4J: Found binding in [jar:file:/usr/lib/hive/lib/log4j-slf4j-impl-2.6.2.jar!/org/slf4j/impl/StaticLoggerBinder.class]<br>SLF4J: Found binding in [jar:file:/usr/lib/hadoop/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class]<br>SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.<br>SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]<br><br>Logging initialized using configuration in file:/etc/hive/conf.analytics-hadoop/hive-log4j2.properties Async: true<br>OK<br>Time taken: 1.736 seconds<br>Added [/tmp/882daf65-2e4d-4d4b-a8d1-5b602b8b903b_resources/refinery-hive-0.0.91-SNAPSHOT.jar] to class path<br>Added resources: [hdfs://analytics-hadoop/user/ebernhardson/refinery-hive-0.0.91-SNAPSHOT.jar]<br>OK<br>Time taken: 0.044 seconds<br>OK<br>Time taken: 0.029 seconds<br>WARNING: Hive-on-MR is deprecated in Hive 2 and may not be available in the future versions. Consider using a different execution engine (i.e. spark, tez) or using Hive 1.X releases.<br>Query ID = analytics-search_20220307174834_143241c4-bf62-4bc2-9571-95589b26a087<br>Total jobs = 8<br>Launching Job 1 out of 8<br>Launching Job 2 out of 8<br>Number of reduce tasks not specified. Estimated from input data size: 1<br>In order to change the average load for a reducer (in bytes):<br>  set hive.exec.reducers.bytes.per.reducer=<number><br>In order to limit the maximum number of reducers:<br>  set hive.exec.reducers.max=<number><br>In order to set a constant number of reducers:<br>  set mapreduce.job.reduces=<number><br>Number of reduce tasks not specified. Estimated from input data size: 260<br>In order to change the average load for a reducer (in bytes):<br>  set hive.exec.reducers.bytes.per.reducer=<number><br>In order to limit the maximum number of reducers:<br>  set hive.exec.reducers.max=<number><br>In order to set a constant number of reducers:<br>  set mapreduce.job.reduces=<number><br>org.apache.hadoop.security.AccessControlException: Permission denied: user=analytics-search, access=READ_EXECUTE, inode="/wmf/data/wmf/webrequest/webrequest_source=text/year=2022/month=3/day=7/hour=14":analytics:hdfs:drwxr-x---<br>	at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.check(FSPermissionChecker.java:351)<br>	at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.checkPermission(FSPermissionChecker.java:257)<br>	at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.checkPermission(FSPermissionChecker.java:189)<br>	at org.apache.hadoop.hdfs.server.namenode.FSDirectory.checkPermission(FSDirectory.java:1756)<br>	at org.apache.hadoop.hdfs.server.namenode.FSDirectory.checkPermission(FSDirectory.java:1740)<br>	at org.apache.hadoop.hdfs.server.namenode.FSDirectory.checkPathAccess(FSDirectory.java:1690)<br>	at org.apache.hadoop.hdfs.server.namenode.FSDirStatAndListingOp.getListingInt(FSDirStatAndListingOp.java:77)<br>	at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.getListing(FSNamesystem.java:3660)<br>	at org.apache.hadoop.hdfs.server.namenode.NameNodeRpcServer.getListing(NameNodeRpcServer.java:1147)<br>	at org.apache.hadoop.hdfs.protocolPB.ClientNamenodeProtocolServerSideTranslatorPB.getListing(ClientNamenodeProtocolServerSideTranslatorPB.java:671)<br>	at org.apache.hadoop.hdfs.protocol.proto.ClientNamenodeProtocolProtos$ClientNamenodeProtocol$2.callBlockingMethod(ClientNamenodeProtocolProtos.java)<br>	at org.apache.hadoop.ipc.ProtobufRpcEngine$Server$ProtoBufRpcInvoker.call(ProtobufRpcEngine.java:507)<br>	at org.apache.hadoop.ipc.RPC$Server.call(RPC.java:1034)<br>	at org.apache.hadoop.ipc.Server$RpcCall.run(Server.java:1003)<br>	at org.apache.hadoop.ipc.Server$RpcCall.run(Server.java:931)<br>	at java.security.AccessController.doPrivileged(Native Method)<br>	at javax.security.auth.Subject.doAs(Subject.java:422)<br>	at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1926)<br>	at org.apache.hadoop.ipc.Server$Handler.run(Server.java:2854)<br><br>	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)<br>	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)<br>	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)<br>	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)<br>	at org.apache.hadoop.ipc.RemoteException.instantiateException(RemoteException.java:121)<br>	at org.apache.hadoop.ipc.RemoteException.unwrapRemoteException(RemoteException.java:88)<br>	at org.apache.hadoop.hdfs.DFSClient.listPaths(DFSClient.java:1656)<br>	at org.apache.hadoop.hdfs.DFSClient.listPaths(DFSClient.java:1638)<br>	at org.apache.hadoop.hdfs.DistributedFileSystem.listStatusInternal(DistributedFileSystem.java:984)<br>	at org.apache.hadoop.hdfs.DistributedFileSystem.access$1000(DistributedFileSystem.java:118)<br>	at org.apache.hadoop.hdfs.DistributedFileSystem$24.doCall(DistributedFileSystem.java:1048)<br>	at org.apache.hadoop.hdfs.DistributedFileSystem$24.doCall(DistributedFileSystem.java:1045)<br>	at org.apache.hadoop.fs.FileSystemLinkResolver.resolve(FileSystemLinkResolver.java:81)<br>	at org.apache.hadoop.hdfs.DistributedFileSystem.listStatus(DistributedFileSystem.java:1055)<br>	at org.apache.hadoop.fs.FileSystem.listStatus(FileSystem.java:1809)<br>	at org.apache.hadoop.fs.FileSystem.listStatus(FileSystem.java:1854)<br>	at org.apache.hadoop.hive.ql.exec.Utilities.isEmptyPath(Utilities.java:2313)<br>	at org.apache.hadoop.hive.ql.exec.Utilities.isEmptyPath(Utilities.java:2307)<br>	at org.apache.hadoop.hive.ql.exec.Utilities$GetInputPathsCallable.call(Utilities.java:3087)<br>	at org.apache.hadoop.hive.ql.exec.Utilities.getInputPaths(Utilities.java:3051)<br>	at org.apache.hadoop.hive.ql.exec.mr.ExecDriver.execute(ExecDriver.java:350)<br>	at org.apache.hadoop.hive.ql.exec.mr.MapRedTask.execute(MapRedTask.java:151)<br>	at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:199)<br>	at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:100)<br>	at org.apache.hadoop.hive.ql.exec.TaskRunner.run(TaskRunner.java:79)<br>Caused by: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.AccessControlException): Permission denied: user=analytics-search, access=READ_EXECUTE, inode="/wmf/data/wmf/webrequest/webrequest_source=text/year=2022/month=3/day=7/hour=14":analytics:hdfs:drwxr-x---<br>	at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.check(FSPermissionChecker.java:351)<br>	at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.checkPermission(FSPermissionChecker.java:257)<br>	at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.checkPermission(FSPermissionChecker.java:189)<br>	at org.apache.hadoop.hdfs.server.namenode.FSDirectory.checkPermission(FSDirectory.java:1756)<br>	at org.apache.hadoop.hdfs.server.namenode.FSDirectory.checkPermission(FSDirectory.java:1740)<br>	at org.apache.hadoop.hdfs.server.namenode.FSDirectory.checkPathAccess(FSDirectory.java:1690)<br>	at org.apache.hadoop.hdfs.server.namenode.FSDirStatAndListingOp.getListingInt(FSDirStatAndListingOp.java:77)<br>	at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.getListing(FSNamesystem.java:3660)<br>	at org.apache.hadoop.hdfs.server.namenode.NameNodeRpcServer.getListing(NameNodeRpcServer.java:1147)<br>	at org.apache.hadoop.hdfs.protocolPB.ClientNamenodeProtocolServerSideTranslatorPB.getListing(ClientNamenodeProtocolServerSideTranslatorPB.java:671)<br>	at org.apache.hadoop.hdfs.protocol.proto.ClientNamenodeProtocolProtos$ClientNamenodeProtocol$2.callBlockingMethod(ClientNamenodeProtocolProtos.java)<br>	at org.apache.hadoop.ipc.ProtobufRpcEngine$Server$ProtoBufRpcInvoker.call(ProtobufRpcEngine.java:507)<br>	at org.apache.hadoop.ipc.RPC$Server.call(RPC.java:1034)<br>	at org.apache.hadoop.ipc.Server$RpcCall.run(Server.java:1003)<br>	at org.apache.hadoop.ipc.Server$RpcCall.run(Server.java:931)<br>	at java.security.AccessController.doPrivileged(Native Method)<br>	at javax.security.auth.Subject.doAs(Subject.java:422)<br>	at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1926)<br>	at org.apache.hadoop.ipc.Server$Handler.run(Server.java:2854)<br><br>	at org.apache.hadoop.ipc.Client.getRpcResponse(Client.java:1549)<br>	at org.apache.hadoop.ipc.Client.call(Client.java:1495)<br>	at org.apache.hadoop.ipc.Client.call(Client.java:1394)<br>	at org.apache.hadoop.ipc.ProtobufRpcEngine$Invoker.invoke(ProtobufRpcEngine.java:232)<br>	at org.apache.hadoop.ipc.ProtobufRpcEngine$Invoker.invoke(ProtobufRpcEngine.java:118)<br>	at com.sun.proxy.$Proxy29.getListing(Unknown Source)<br>	at org.apache.hadoop.hdfs.protocolPB.ClientNamenodeProtocolTranslatorPB.getListing(ClientNamenodeProtocolTranslatorPB.java:601)<br>	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br>	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)<br>	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br>	at java.lang.reflect.Method.invoke(Method.java:498)<br>	at org.apache.hadoop.io.retry.RetryInvocationHandler.invokeMethod(RetryInvocationHandler.java:422)<br>	at org.apache.hadoop.io.retry.RetryInvocationHandler$Call.invokeMethod(RetryInvocationHandler.java:165)<br>	at org.apache.hadoop.io.retry.RetryInvocationHandler$Call.invoke(RetryInvocationHandler.java:157)<br>	at org.apache.hadoop.io.retry.RetryInvocationHandler$Call.invokeOnce(RetryInvocationHandler.java:95)<br>	at org.apache.hadoop.io.retry.RetryInvocationHandler.invoke(RetryInvocationHandler.java:359)<br>	at com.sun.proxy.$Proxy30.getListing(Unknown Source)<br>	at org.apache.hadoop.hdfs.DFSClient.listPaths(DFSClient.java:1654)<br>	... 18 more<br>Job Submission failed with exception 'org.apache.hadoop.security.AccessControlException(Permission denied: user=analytics-search, access=READ_EXECUTE, inode="/wmf/data/wmf/webrequest/webrequest_source=text/year=2022/month=3/day=7/hour=14":analytics:hdfs:drwxr-x---<br>	at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.check(FSPermissionChecker.java:351)<br>	at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.checkPermission(FSPermissionChecker.java:257)<br>	at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.checkPermission(FSPermissionChecker.java:189)<br>	at org.apache.hadoop.hdfs.server.namenode.FSDirectory.checkPermission(FSDirectory.java:1756)<br>	at org.apache.hadoop.hdfs.server.namenode.FSDirectory.checkPermission(FSDirectory.java:1740)<br>	at org.apache.hadoop.hdfs.server.namenode.FSDirectory.checkPathAccess(FSDirectory.java:1690)<br>	at org.apache.hadoop.hdfs.server.namenode.FSDirStatAndListingOp.getListingInt(FSDirStatAndListingOp.java:77)<br>	at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.getListing(FSNamesystem.java:3660)<br>	at org.apache.hadoop.hdfs.server.namenode.NameNodeRpcServer.getListing(NameNodeRpcServer.java:1147)<br>	at org.apache.hadoop.hdfs.protocolPB.ClientNamenodeProtocolServerSideTranslatorPB.getListing(ClientNamenodeProtocolServerSideTranslatorPB.java:671)<br>	at org.apache.hadoop.hdfs.protocol.proto.ClientNamenodeProtocolProtos$ClientNamenodeProtocol$2.callBlockingMethod(ClientNamenodeProtocolProtos.java)<br>	at org.apache.hadoop.ipc.ProtobufRpcEngine$Server$ProtoBufRpcInvoker.call(ProtobufRpcEngine.java:507)<br>	at org.apache.hadoop.ipc.RPC$Server.call(RPC.java:1034)<br>	at org.apache.hadoop.ipc.Server$RpcCall.run(Server.java:1003)<br>	at org.apache.hadoop.ipc.Server$RpcCall.run(Server.java:931)<br>	at java.security.AccessController.doPrivileged(Native Method)<br>	at javax.security.auth.Subject.doAs(Subject.java:422)<br>	at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1926)<br>	at org.apache.hadoop.ipc.Server$Handler.run(Server.java:2854)<br>)'<br>log4j:ERROR No output stream or file set for the appender named [console].<br>FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask. Permission denied: user=analytics-search, access=READ_EXECUTE, inode="/wmf/data/wmf/webrequest/webrequest_source=text/year=2022/month=3/day=7/hour=14":analytics:hdfs:drwxr-x---<br>	at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.check(FSPermissionChecker.java:351)<br>	at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.checkPermission(FSPermissionChecker.java:257)<br>	at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.checkPermission(FSPermissionChecker.java:189)<br>	at org.apache.hadoop.hdfs.server.namenode.FSDirectory.checkPermission(FSDirectory.java:1756)<br>	at org.apache.hadoop.hdfs.server.namenode.FSDirectory.checkPermission(FSDirectory.java:1740)<br>	at org.apache.hadoop.hdfs.server.namenode.FSDirectory.checkPathAccess(FSDirectory.java:1690)<br>	at org.apache.hadoop.hdfs.server.namenode.FSDirStatAndListingOp.getListingInt(FSDirStatAndListingOp.java:77)<br>	at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.getListing(FSNamesystem.java:3660)<br>	at org.apache.hadoop.hdfs.server.namenode.NameNodeRpcServer.getListing(NameNodeRpcServer.java:1147)<br>	at org.apache.hadoop.hdfs.protocolPB.ClientNamenodeProtocolServerSideTranslatorPB.getListing(ClientNamenodeProtocolServerSideTranslatorPB.java:671)<br>	at org.apache.hadoop.hdfs.protocol.proto.ClientNamenodeProtocolProtos$ClientNamenodeProtocol$2.callBlockingMethod(ClientNamenodeProtocolProtos.java)<br>	at org.apache.hadoop.ipc.ProtobufRpcEngine$Server$ProtoBufRpcInvoker.call(ProtobufRpcEngine.java:507)<br>	at org.apache.hadoop.ipc.RPC$Server.call(RPC.java:1034)<br>	at org.apache.hadoop.ipc.Server$RpcCall.run(Server.java:1003)<br>	at org.apache.hadoop.ipc.Server$RpcCall.run(Server.java:931)<br>	at java.security.AccessController.doPrivileged(Native Method)<br>	at javax.security.auth.Subject.doAs(Subject.java:422)<br>	at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1926)<br>	at org.apache.hadoop.ipc.Server$Handler.run(Server.java:2854)<br><br>java.io.IOException: java.lang.InterruptedException<br>	at org.apache.hadoop.ipc.Client.call(Client.java:1453)<br>	at org.apache.hadoop.ipc.Client.call(Client.java:1394)<br>	at org.apache.hadoop.ipc.ProtobufRpcEngine$Invoker.invoke(ProtobufRpcEngine.java:232)<br>	at org.apache.hadoop.ipc.ProtobufRpcEngine$Invoker.invoke(ProtobufRpcEngine.java:118)<br>	at com.sun.proxy.$Proxy29.delete(Unknown Source)<br>	at org.apache.hadoop.hdfs.protocolPB.ClientNamenodeProtocolTranslatorPB.delete(ClientNamenodeProtocolTranslatorPB.java:572)<br>	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br>	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)<br>	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br>	at java.lang.reflect.Method.invoke(Method.java:498)<br>	at org.apache.hadoop.io.retry.RetryInvocationHandler.invokeMethod(RetryInvocationHandler.java:422)<br>	at org.apache.hadoop.io.retry.RetryInvocationHandler$Call.invokeMethod(RetryInvocationHandler.java:165)<br>	at org.apache.hadoop.io.retry.RetryInvocationHandler$Call.invoke(RetryInvocationHandler.java:157)<br>	at org.apache.hadoop.io.retry.RetryInvocationHandler$Call.invokeOnce(RetryInvocationHandler.java:95)<br>	at org.apache.hadoop.io.retry.RetryInvocationHandler.invoke(RetryInvocationHandler.java:359)<br>	at com.sun.proxy.$Proxy30.delete(Unknown Source)<br>	at org.apache.hadoop.hdfs.DFSClient.delete(DFSClient.java:1614)<br>	at org.apache.hadoop.hdfs.DistributedFileSystem$19.doCall(DistributedFileSystem.java:882)<br>	at org.apache.hadoop.hdfs.DistributedFileSystem$19.doCall(DistributedFileSystem.java:879)<br>	at org.apache.hadoop.fs.FileSystemLinkResolver.resolve(FileSystemLinkResolver.java:81)<br>	at org.apache.hadoop.hdfs.DistributedFileSystem.delete(DistributedFileSystem.java:889)<br>	at org.apache.hadoop.mapreduce.JobSubmitter.submitJobInternal(JobSubmitter.java:264)<br>	at org.apache.hadoop.mapreduce.Job$11.run(Job.java:1570)<br>	at org.apache.hadoop.mapreduce.Job$11.run(Job.java:1567)<br>	at java.security.AccessController.doPrivileged(Native Method)<br>	at javax.security.auth.Subject.doAs(Subject.java:422)<br>	at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1926)<br>	at org.apache.hadoop.mapreduce.Job.submit(Job.java:1567)<br>	at org.apache.hadoop.mapred.JobClient$1.run(JobClient.java:576)<br>	at org.apache.hadoop.mapred.JobClient$1.run(JobClient.java:571)<br>	at java.security.AccessController.doPrivileged(Native Method)<br>	at javax.security.auth.Subject.doAs(Subject.java:422)<br>	at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1926)<br>	at org.apache.hadoop.mapred.JobClient.submitJobInternal(JobClient.java:571)<br>	at org.apache.hadoop.mapred.JobClient.submitJob(JobClient.java:562)<br>	at org.apache.hadoop.hive.ql.exec.mr.ExecDriver.execute(ExecDriver.java:414)<br>	at org.apache.hadoop.hive.ql.exec.mr.MapRedTask.execute(MapRedTask.java:151)<br>	at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:199)<br>	at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:100)<br>	at org.apache.hadoop.hive.ql.exec.TaskRunner.run(TaskRunner.java:79)<br>Caused by: java.lang.InterruptedException<br>	at java.util.concurrent.FutureTask.awaitDone(FutureTask.java:404)<br>	at java.util.concurrent.FutureTask.get(FutureTask.java:191)<br>	at org.apache.hadoop.ipc.Client$Connection.sendRpcRequest(Client.java:1168)<br>	at org.apache.hadoop.ipc.Client.call(Client.java:1447)<br>	... 39 more<br>Job Submission failed with exception 'java.io.IOException(java.lang.InterruptedException)'<br><br>Log: <a href="http://localhost:8080/admin/airflow/log?execution_date=2022-03-07T13%3A00%3A00%2B00%3A00&task_id=transform_hourly&dag_id=query_clicks_hourly">Link</a><br>Host: an-airflow1001.eqiad.wmnet<br>Log file: /var/log/airflow/query_clicks_hourly/transform_hourly/2022-03-07T13:00:00+00:00.log<br>Mark success: <a href="http://localhost:8080/success?task_id=transform_hourly&dag_id=query_clicks_hourly&execution_date=2022-03-07T13%3A00%3A00%2B00%3A00&upstream=false&downstream=false">Link</a><br>