user3682145
user3682145

Reputation: 11

Getting error while executing Hive query in windows azure

After connecting to windows azure through powershells I am executing hive query just to show the tables. But I am getting following error.

Invoke-Hive : The remote server returned an error: (403) Forbidden.
At line:1 char:13
+ $response = Invoke-Hive -Query @"
+             ~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [Invoke-AzureHDInsightHiveJob], StorageException
    + FullyQualifiedErrorId : Microsoft.WindowsAzure.Storage.StorageException,Microsoft.WindowsAzure.Management.HDInsi
   ght.Cmdlet.PSCmdlets.InvokeHiveCmdlet

Could you please guide me what to do ? I am using windows 7 OS Home premium , service pack 1

Upvotes: 0

Views: 197

Answers (1)

user3682145
user3682145

Reputation: 11

I am able to resolve this issue. This issue is related with system clock (laptop clock). I had to re-set my laptop clock as per my current time zone then I re-login through powershell to execute hive query and that went fine.

Upvotes: 1

Related Questions