We are using Hortonworks ODBC driver to connect hive from C# application. Here is a sample code to fire query on Hive. static void Main(string[] args) { string connectionString = "DSN=AzureHDP"; string query = "SELECT * FROM schema_5218.demandquantity"; int queryTimeout = 100; try { using (var connection = new OdbcConnection(connectionString)) { Console.WriteLine("Opening Hive connection."); connection.Open(); using (var cmd = connection.CreateCommand()) { cmd.CommandTimeout = queryTimeout; cmd.CommandText = query; Console.WriteLine("Executing Hive query."); cmd.ExecuteNonQuery(); Console.WriteLine("Hive query executed successfully."); Console.ReadKey(false); } } } catch (Exception e) { Console.WriteLine($"Encountered error during Hive query execution. [{e.Message}]"); Console.ReadKey(false); throw; } } Issue is that if the network connection drops after the query has been fired on Hive(before query returns) the resulting exception results in application crash. Reason is that AccessViolcationException is thrown which are not sent to application catch block. So this exception becomes an un-handled exception causing the application to crash. Is this due to any bug in the ODBC driver? Is there any workaround or fix awaited? There are certain settings which can be done to catch such exception but those are not recommended by Microsoft. Due this this reason I am not very keep to use these settings. Those settings are [HandleProcessCorruptedStateExceptions] & [SecurityCritical] and legacyCorruptedStateExceptionsPolicy. Attaching actual application code screenshot. You can that the exception is thrown at the close of the connection using clause and the control does not go to the catch block. Hortonworks Driver Version: 2.01.10.1014 .Net Version: 4.7 C# version: 7.3 ... View more

I am trying to deploy HDP cluster on Azure which uses Azure Data Lake storage. I followed the instructions here for Ambari and cluster setup. I followed the instruction here for ADLS access. When is try to start Hive I get the following error. <code>Exception in thread "main" java.lang.RuntimeException: java.io.IOException: The ownership on the staging directory adl://home/tmp/hive/root/_tez_session_dir/c96088dd-444e-42e3-9293-251656b01b17 is not as expected. It is owned by <ADLS Service Principal>. The directory must be owned by the submitter root or by root at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:582) at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:681) at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:625) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.hadoop.util.RunJar.run(RunJar.java:233) at org.apache.hadoop.util.RunJar.main(RunJar.java:148) I am able to access ADLS via the HDFS commands Permission on /tmp folder > hdfs dfs -ls /tmp Found 1 items drwxrwxrwt+ - <ADLS Service Principal> 0 2018-01-20 21:29 /tmp/hive TIA <br> ... View more