Cloudera Docs

Running a simple SQL job

You can use this Getting Started use case to get familiar with the most simple form of running a SQL Stream job.

The Getting Started contains the basic steps of running a SQL Stream job. When executing the job, you do not need to select a sink as the results are displayed in the browser. SQL Stream Builder provisions a job on your cluster to run the SQL queries. You can select the Logs tab to review the status of the SQL job. As data is returned, it shows up in the Results tab.
  1. Navigate to the Streaming SQL Console.
    1. Go to your cluster in Cloudera Manager.
    2. Select SQL Stream Builder from the list of services.
    3. Click SQLStreamBuilder Console.
    The Streaming SQL Console opens in a new window.
  2. Provide a name for the SQL job in the SQL Job Name text box.
    You can also use the random name button to generate a name for your job.
  3. Select datagen from the Templates.
    The CREATE TABLE statement is imported to the SQL window.
  4. Add a SELECT query to the SQL window after the datagen template. 
    SELECT * FROM <table_name>
  5. Click Execute.
    You can see the generated output on the Results tab.
  6. Click on the Stop button to stop the job.