< Back
Invoke-AzureHDInsightHiveJob
Post
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:
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: