Loading a Table on the SAS LASR Analytic Server :: SAS(R) Data Integration Studio 4.9: User's Guide

Problem

You want to load the output table from a transformation to the Hadoop Distributed File System (HDFS). The HDFS table should then be loaded onto the SAS LASR Analytic Server, where it can be analyzed with SAS Visual Analytics.

Solution

You can create a process flow similar to the one shown in the next display.

Example Flow for High-Performance Analytics Transformations

The process flow in the previous display includes the following components:

The first ALL_EMP table in the flow is the output from a previous transformation in the flow. It is a table in a Base SAS library.
The SAS Data in HDFS Loader reads the first ALL_EMP in the flow. It loads the contents of ALL_EMP into a table with the same physical storage name in a SAS Data in HDFS library. The library is used to make the connection to HDFS.
The SAS LASR Analytic Server Loader reads the second ALL_EMP in the flow and loads its contents into a table with the same physical storage name in a SAS LASR Analytic Server library. The library is used to make the connection to the SAS LASR Analytic Server cluster and load the table into memory.

It is assumed that you are familiar with how to create a SAS Data Integration Studio job, as described in Creating a Process Flow for a Job. Perform the following tasks.

Verify Prerequisites for the HPA Loaders
Register Target Tables for the HPA Loaders
Create and Run a Job with HPA Loaders

Tasks

Verify Prerequisites for the HPA Loaders

See the prerequisites topic For SAS Data Integration Studio Users .

Register Target Tables for the HPA Loaders

The second and third tables in Example Flow for High-Performance Analytics Transformations do not yet exist. They are created the first time the job is run. In order to create a flow similar to the one shown in the display, use the New Table wizard to register the new tables. Later, you can drag and drop this metadata onto the target position in a process flow. When the process flow is executed, SAS Data Integration Studio uses the metadata for the target table to create a physical instance of that table. The physical storage page of the wizard prompts you to select a library that contains the table to be registered. Typically, this library has been registered ahead of time.

In the current example, you register one target table in a SAS Data in HDFS library. Then you register another target table in a SAS LASR Analytic Server library.

Note: See Target Table for HPA Transformations Must Have the Same SAS Name as the Source Table.

Create and Run a Job with HPA Loaders

Create a job with a flow similar to that shown in Example Flow for High-Performance Analytics Transformations. Run the job and verify the output.