< Back

Invoke-AzureHDInsightHiveJob

Wed Jan 30, 2019 5:47 pm

NAME Invoke-AzureHDInsightHiveJob



SYNOPSIS

Submits Hive queries to the HDInsight cluster, shows progress of the query execution, and retrieves query results in one operation.





SYNTAX

Invoke-AzureHDInsightHiveJob [[-Query] <String>] [-Arguments <String[]>] [-Defines <Hashtable>] [-File <String>] [-Files <String[]>] [-JobName <String>]

[-StatusFolder <String>] [<CommonParameters>]





DESCRIPTION

Submits Hive queries to the HDInsight cluster, shows progress of the query execution, and retrieves query results in one operation. The

Use-AzureHDInsightCluster cmdlet needs to be used before calling Invoke-Hive to specify which HDInsight cluster the query will be submitted to.



This topic describes the cmdlet in the .7.2 version of the Microsoft Azure PowerShell module. To find out the version of the module you're using, from

the Azure PowerShell console, type (get-module azure).version.





PARAMETERS

-Arguments <String[]>

Arguments of the Hadoop job. The arguments will be passed as command line arguments to each task.



Required? false

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



-Defines <Hashtable>

Hadoop configuration values to be set during the job execution.



Required? false

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



-File <String>

The wasb path to a file in Azure Blob Storage that contains the query to be executed. Use this File parameter in place of a query parameter.



Required? false

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



-Files <String[]>

A collection of files required for the Hive job to execute.



Required? false

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



-JobName <String>

The name of the Hive job being defined. If the name is not specified, it is "Hive: <first 100 characters of Query>" by default.



Required? false

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



-Query <String>

The Hive query to be executed.



Required? false

Position? 2

Default value

Accept pipeline input? false

Accept wildcard characters? false



-StatusFolder <String>

Location of the status folder where the standard and error outputs of the job will be stored, including its exit code and task logs.



Required? false

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



<CommonParameters>

This cmdlet supports the common parameters: Verbose, Debug,

ErrorAction, ErrorVariable, WarningAction, WarningVariable,

OutBuffer, PipelineVariable, and OutVariable. For more information, see

about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).



INPUTS











OUTPUTS











NOTES





Keywords: azure, azuresm, servicemanagement, management, service, utilities



Submit a Hive query



PS C:\\>Use-AzureHDInsightCluster yourcluster -Subscription (Get-AzureSubscription -Current).SubscriptionId

Invoke-Hive "select * from hivesampletable limit 10"



Submit a Hive queries to the HDInsight cluster.



RELATED LINKS

Online Version: