New-AzureRmHDInsightHiveJobDefinition

Creates a Hive job object.

Syntax

New-AzureRmHDInsightHiveJobDefinition [-Arguments <String[]>] [-Files <String[]>] [-StatusFolder <String>]
 [-Defines <Hashtable>] [-File <String>] [-JobName <String>] [-Query <String>] [-RunAsFileJob]
 [-InformationAction <ActionPreference>] [-InformationVariable <String>] [<CommonParameters>]

Description

The New-AzureRmHDInsightHiveJobDefinition cmdlet defines a Hive job object for use with an Azure HDInsight cluster.

Examples

Example 1: Create a Hive job definition

PS C:\># Cluster info
PS C:\>$clusterName = "your-hadoop-001"
PS C:\>$clusterCreds = Get-Credential

# Hive job details
PS C:\>$statusFolder = ""        
PS C:\>$query = "SHOW TABLES"

PS C:\>New-AzureRmHDInsightHiveJobDefinition -StatusFolder $statusFolder `
            -Query $query `
        | Start-AzureRmHDInsightJob `
            -ClusterName $clusterName `
            -ClusterCredential $clusterCreds
This command creates a Hive job definition.

Parameters

-Arguments

Specifies an array of arguments for the job.
The arguments are passed as command-line arguments to each task.

Type:String[]
Position:Named
Default value:None
Accept pipeline input:False

-Files

Specifies a collection of files that are associated with a Hive job.

Type:String[]
Position:Named
Default value:None
Accept pipeline input:False

-StatusFolder

Specifies the location of the folder that contains standard outputs and error outputs for a job.

Type:String
Position:Named
Default value:None
Accept pipeline input:False

-Defines

Specifies Hadoop configuration values to set for when the job runs.

Type:Hashtable
Position:Named
Default value:None
Accept pipeline input:False

-File

Specifies the path to a file that contains the query to run.
The file must be available on the storage account associated with the cluster.
You can use this parameter instead of the Query parameter.

Type:String
Position:Named
Default value:None
Accept pipeline input:False

-JobName

Specifies the name of the job.

Type:String
Position:Named
Default value:None
Accept pipeline input:False

-Query

Specifies the Hive query.

Type:String
Position:Named
Default value:None
Accept pipeline input:False

-RunAsFileJob

Indicates that this cmdlet creates a file in the default Azure storage account in which to store a query.
This cmdlet submits the job that references this file as a script to run.

You can use this functionality to handle special characters such as percent sign (%) that would fail on a job submission through Templeton, because Templeton interprets a query with a percent sign as a URL parameter.

Type:SwitchParameter
Position:Named
Default value:None
Accept pipeline input:False

-InformationAction

Specifies how this cmdlet responds to an information event.

The acceptable values for this parameter are:

- Continue
- Ignore
- Inquire
- SilentlyContinue
- Stop
- Suspend

Type:ActionPreference
Aliases:System.Object[]
Position:Named
Default value:None
Accept pipeline input:False

-InformationVariable

Specifies an information variable.

Type:String
Aliases:System.Object[]
Position:Named
Default value:None
Accept pipeline input:False