Write a SELECT * on the VIEW and show data flowing

<< Click to Display Table of Contents >>

Navigation:  Building Streaming Applications > Tutorial 2: Introduction to Coding with Streaming SQL > Tutorial 2A: Creating a Stream and View in SQLstream s-Studio >

Write a SELECT * on the VIEW and show data flowing

Previous pageReturn to chapter overviewNext page

You can query any objects that contain data directly from s-Studio. Here, we will run a query on the view we just created.

Right-click the speeders view and choose New Query.

sbur_studio_new_query

In the window that opens, enter the following text:

select stream * from "speeders"

 

Click the green arrow at the top of the tab to execute the query. Observe that data starts flowing in the bottom of the tab. If you scroll over to the speeders column, you will see that only rows with speeds above 75 appear.

sbur_studio_view_query_results