gcloud_alpha_dataproc_jobs_submit_spark-sql (1)

NAME

gcloud alpha dataproc jobs submit spark-sql - submit a Spark SQL job to a cluster

SYNOPSIS

gcloud alpha dataproc jobs submit spark-sql --cluster=CLUSTER (--execute=QUERY, -e QUERY | --file=FILE, -f FILE) [--async] [--bucket=BUCKET] [--driver-log-levels=[PACKAGE=LEVEL,...]] [--jars=[JAR,...]] [--labels=[KEY=VALUE,...]] [--max-failures-per-hour=MAX_FAILURES_PER_HOUR] [--params=[PARAM=VALUE,...]] [--properties=[PROPERTY=VALUE,...]] [--region=REGION] [GCLOUD_WIDE_FLAG ...]

DESCRIPTION

(ALPHA) Submit a Spark SQL job to a cluster.

REQUIRED FLAGS

--cluster=CLUSTER

The Dataproc cluster to submit the job to.

Exactly one of these must be specified:

--execute=QUERY, -e QUERY

A Spark SQL query to execute as part of the job.

--file=FILE, -f FILE

HCFS URI of file containing Spark SQL script to execute as the job.

OPTIONAL FLAGS

--async

Does not wait for the job to run.

--bucket=BUCKET

The Cloud Storage bucket to stage files in. Defaults to the cluster's configured bucket.

--driver-log-levels=[PACKAGE=LEVEL,...]

A list of package to log4j log level pairs to configure driver logging. For example: root=FATAL,com.example=INFO

--jars=[JAR,...]

Comma separated list of jar files to be provided to the executor and driver classpaths. May contain UDFs.

--labels=[KEY=VALUE,...]

List of label KEY=VALUE pairs to add.
Keys must start with a lowercase character and contain only hyphens (-), underscores (_), lowercase characters, and numbers. Values must contain only hyphens (-), underscores (_), lowercase characters, and numbers.

--max-failures-per-hour=MAX_FAILURES_PER_HOUR

Specifies maximum number of times a job can be restarted in event of failure. Expressed as a per-hour rate. Default is 0 (no failure retries).

--params=[PARAM=VALUE,...]

A list of key value pairs to set variables in the Hive queries.

--properties=[PROPERTY=VALUE,...]

A list of key value pairs to configure Hive.

--region=REGION

Cloud Dataproc region to use. Each Cloud Dataproc region constitutes an independent resource namespace constrained to deploying instances into Compute Engine zones inside the region. The default value of global is a special multi-region namespace which is capable of deploying instances into all Compute Engine zones globally, and is disjoint from other Cloud Dataproc regions. Overrides the default dataproc/region property value for this command invocation.

GCLOUD WIDE FLAGS

These flags are available to all commands: --account, --configuration, --flags-file, --flatten, --format, --help, --log-http, --project, --quiet, --trace-token, --user-output-enabled, --verbosity. Run $ gcloud help for details.

EXAMPLES

To submit a Spark SQL job with a local script, run:

$ gcloud alpha dataproc jobs submit spark-sql --cluster my_cluster \
    --file my_queries.ql

To submit a Spark SQL job with inline queries, run:

$ gcloud alpha dataproc jobs submit spark-sql --cluster my_cluster \
    -e \
    "CREATE EXTERNAL TABLE foo(bar int) LOCATION\
 'gs://my_bucket/'" -e "SELECT * FROM foo WHERE bar > 2"

NOTES

This command is currently in ALPHA and may change without notice. If this command fails with API permission errors despite specifying the right project, you will have to apply for early access and have your projects registered on the API whitelist to use it. To do so, contact Support at cloud.google.com/support These variants are also available:

$ gcloud dataproc jobs submit spark-sql $ gcloud beta dataproc jobs submit spark-sql