I wonder if you are missing some parameters.. you need to add serviceDiscoveryMode and zookeeperNamespace to the JDBC URL.   The format is like:   jdbc:hive2://{quorum};serviceDiscoveryMode=zooKeeper;zooKeeperNamespace={namespace}   so something like:   jdbc:hive2://hadoopcluster01:2181,hadoopcluster02:2181;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2 ... View more

Hi, if its a local file, then it has to be on the machine that HiveServer2 is running in, as its the process that is going to do the loading.  Can you check that?  Thanks. ... View more

It sounds like a permission issue.  Can you check if the user of hive has permission for that file? ... View more

Yea I agree, it is mostly likely a permission error, I would check the hive logs to see exactly which file/dir path is giving the error.   Thanks Szehon ... View more

Looks like you need to increase the memory of the HS2 process itself.  That flag you mentioned will only affect the MR jobs that is spawned by Hive, but the stack indicates that it didn't make it past the compiler.   Hope that helps, Szehon ... View more