Hi Ali, Did you tried to pass "hive.execution.engine=tez" as session config property in JDBC connection URL. Please try that and let me if that works. e.g. con = DriverManager.getConnection("jdbc:hive2://host:10000/default?hive.execution.engine=tez") ... View more

@Predrag Minovic I also tried this work around it is working partially for me as i have to recover all the table partition because somehow it doesn't detect s3 sub directories . ... View more

@Rajesh Balamohan I have aws access id & secret stored in in hive-site and hdfs-site config file. ... View more

@hduraiswamy I am able to execute alter query, I didn't get any errors . Yes i have tried extended describe command as well to get location info. ... View more

@Wes Floyd @srai @mqureshi Thank you so much for your quick responses to my question. As I already have staging table to orc table implementation structure I will try to use csv column headers to create staging tables and then I will load staging data to actual table. ... View more

@mqureshi I am able to run same query through hive view and hive cli but not through jdbc . Cluster configuration is as below: Name node and Secondary node (8 Core / 28 GB RAM each) 3 Data Nodes (8 Core / 28 GB RAM each) I tried to set hive.execution.engine=tez by appending it to jdbc connect url but it doesn't work. ... View more

@Takahiko Saito Stack trace just after jdbc query failure. Container exited with a non-zero exit code 127 Failing this attempt. Failing the application. 2016-07-28 00:11:22,769 INFO rmapp.RMAppImpl (RMAppImpl.java:handle(767)) - application_1466711437570_0051 State change from FINAL_SAVING to FAILED 2016-07-28 00:11:22,769 WARN resourcemanager.RMAuditLogger (RMAuditLogger.java:logFailure(323)) - USER="girish" OPERATION=Application Finished - Failed TARGET=RMAppManager RESULT=FAILURE DESCRIPTION=App failed with state: FAILED PERMISSIONS=Application application_1466711437570_0051 failed 2 times due to AM Container for appattempt_1466711437570_0051_000002 exited with exitCode: 127 For more detailed output, check application tracking page then click on links to logs of each attempt. Diagnostics: Exception from container-launch. Container id: container_e02_1466711437570_0051_02_000001 Exit code: 127 Exception message: /bin/bash: /mnt/resource/usercache/girish/appcache/application_1466711437570_0051/container_e02_1466711437570_0051_02_000001/default_container_executor_session.sh: No such file or directory Stack trace: ExitCodeException exitCode=127: /bin/bash: /mnt/resource/usercache/girish/appcache/application_1466711437570_0051/container_e02_1466711437570_0051_02_000001/default_container_executor_session.sh: No such file or directory at org.apache.hadoop.util.Shell.runCommand(Shell.java:576) at org.apache.hadoop.util.Shell.run(Shell.java:487) at org.apache.hadoop.util.Shell$ShellCommandExecutor.execute(Shell.java:753) at org.apache.hadoop.yarn.server.nodemanager.DefaultContainerExecutor.launchContainer(DefaultContainerExecutor.java:212) at org.apache.hadoop.yarn.server.nodemanager.containermanager.launcher.ContainerLaunch.call(ContainerLaunch.java:303) at org.apache.hadoop.yarn.server.nodemanager.containermanager.launcher.ContainerLaunch.call(ContainerLaunch.java:82) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Container exited with a non-zero exit code 127 Failing this attempt. Failing the application. APPID=application_1466711437570_0051 2016-07-28 00:11:22,769 INFO capacity.ParentQueue (ParentQueue.java:removeApplication(372)) - Application removed - appId: application_1466711437570_0051 user: "girish" leaf-queue of parent: root #applications: 0 2016-07-28 00:11:23,446 INFO resourcemanager.RMAuditLogger (RMAuditLogger.java:logSuccess(170)) - USER="girish" IP=10.0.0.5 OPERATION=Kill Application Request TARGET=ClientRMService RESULT=SUCCESS APPID=application_1466711437570_0051 CALLERCONTEXT=HIVE_SSN_ID:d8a476e9-84c4-4633-a980-3f8a9dd7dac8 ... View more