Hive queries are failing in Ineractive quey HDInsight 3.6

[#1]

Hello Team,

we had recently enabled https for azure storage and changed fs.defaultFS parameter in core-site.xml. we are able to access the hdfs file system . Now our hive queries are failing with the below error ? Error: java.io.IOException: org.apache.hadoop.fs.azure.AzureException: com.microsoft.azure.storage.StorageException: The account being accessed does not support http. (state=,code=0) we have changed the parameter for hive.aux.jars.path to use wasbs. still we are facing the same issue ? do we missed anything in hive-site.xml to reach wasbs ? Any help to overcome this issue much appreciated Thanks in advance!

[#2 · Accepted solution]

You might look at the table definition (show create table x) and verify the prefix on the table location. Hive stores the whole filespec including the protocol.