You will learn
- Adding a HANA Reference element to the project
- Joining event streams to SAP HANA tables in order to enrich raw event data.
- Filtering and analyzing data based on context or historical information from HANA.
Part 4 of 9. Add a HANA Reference element and using a Join operator to combine reference and streaming data.
This is a continuation from part 3 of this tutorial group. Before proceeding, please make sure that
"freezer_monitoring" project is opened and the project diagram is the active tab in HANA Studio. If not, go to File > Open File… to open the project. Navigate to the SAP HANA Administration Console perspective.
Open the Catalog for the HANA system in the HANA Systems view.
Open the “SYSTEM” schema and drag then drop the table
MACHINE_REF onto the canvas.
Note: if you don’t see the tables you have created, try right clicking the schema and selecting Refresh. Make sure to use the same schema you create the table with before. In this case, you are using SYSTEM.
Select Reference, Inline and then click OK.
Change the name of the reference element to
MACHINE_REF by clicking on the icon shown below.
Click Join in the Palette and drop it onto the canvas.
Select the Connector tool. (Tip: press Shift key while performing the action. This will keep it selected for adding multiple connections)
First click on
MACHINEDATA and then
Join1 to connect them.
Now add a connection from
Click Select in the Palette to release the Connector tool (or press ESC).
DEVICE_EVENTS and press Enter key.
Hover over the
DEVICE_EVENTS shape so that the toolbar appears and then click the f(x) (Add Column Expression) icon shown below.
Click the Copy Columns from Input menu item to execute it. You can also press c.
Click Select All or you can also press Alt+s. Uncheck the 2nd MACHINEID field that is named
MACHINE_REF.MACHINEID (we don’t want it twice) and then click OK.
Now set the join condition. Double-click on
When it prompts you to save the project, click Yes.
We want to join on MACHINEID. Select MACHINEID : string in each source column and then click Add. Once its been added click OK.