SALES: 1-800-867-1380

Invoke-AzureHDInsightHiveJob

[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

Invoke-AzureHDInsightHiveJob

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

Syntax

Parameter Set: Default
Invoke-AzureHDInsightHiveJob [[-Query] <String> ] [-Arguments <String[]> ] [-Defines <Hashtable> ] [-File <String> ] [-Files <String[]> ] [-JobName <String> ] [-StatusFolder <String> ] [ <CommonParameters>]




Detailed 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 0.8.1 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.


Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-Defines<Hashtable>

Hadoop configuration values to be set during the job execution.


Aliases

Params

Required?

false

Position?

named

Default Value

none

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.


Aliases

QueryFile

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-Files<String[]>

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


Aliases

none

Required?

false

Position?

named

Default Value

none

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.


Aliases

Name

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-Query<String>

The Hive query to be executed.


Aliases

QueryText

Required?

false

Position?

2

Default Value

none

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.


Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

<CommonParameters>

This cmdlet supports the common parameters: -Verbose, -Debug, -ErrorAction, -ErrorVariable, -OutBuffer, and -OutVariable. For more information, see  about_CommonParameters (http://go.microsoft.com/fwlink/p/?LinkID=113216).

Inputs

The input type is the type of the objects that you can pipe to the cmdlet.

Outputs

The output type is the type of the objects that the cmdlet emits.

Examples

Submit a Hive query

Submit a Hive queries to the HDInsight cluster.


PS C:\> Use-AzureHDInsightCluster yourcluster 
Invoke-Hive "select * from hivesampletable limit 10"

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2015 Microsoft