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.
Navigate to the Streaming SQL Console.
The Streaming SQL Console opens in a new window.
- Go to your cluster in Cloudera Manager.
- Select SQL Stream Builder from the list of services.
- Click SQLStreamBuilder Console.
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.
Select datagen from the
CREATE TABLEstatement is imported to the SQL window.
SELECTquery to the SQL window after the datagen template.
SELECT * FROM <table_name>
You can see the generated output on the Results tab.
Click on the Stop button to stop the job.