Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hive queries are failing in Ineractive quey HDInsight 3.6

Solved Go to solution
Highlighted

Hive queries are failing in Ineractive quey HDInsight 3.6

Super Collaborator

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!

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Hive queries are failing in Ineractive quey HDInsight 3.6

Expert Contributor

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.

1 REPLY 1

Re: Hive queries are failing in Ineractive quey HDInsight 3.6

Expert Contributor

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.