SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

What is happening with data during uploading data to LASR and registering table

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 9
Accepted Solution

What is happening with data during uploading data to LASR and registering table

[ Edited ]

Hi,

 

I have a question about LASR 2.8

 

From what I read, loading data into LASR is the same as putting data into memory (not physically copying it to other place in hard drive)

To do this in non-distributed version we have to just use data step to create table in lasr server.

 (For example, copy data as table from one database system to LASR)

 

So now, after moving it to memory we have to register our table to be able to use it with SAS VA.

 

What happens when we register this table with metalib procedure?

We have to select name of registered table and folder to store data.

 

Please let me know if this text is true so far and let me know answers to below questions:
1. If we copy table to LASR, is the data only in memory and it stays in memory? When is it removed?

2. When we register table with metalib procedure, does it create physical file? Does this procedure create any form of our data? Just beside of metadata which I understand as basic information about the table and not the data itself.

3. What is the folder given in metalib procedure? Does it indicate place where the data is stored/saved? Is in in memory?

 

 

Thank you

Jakub


Accepted Solutions
Solution
‎08-18-2017 03:18 AM
Super User
Posts: 3,866

Re: What is happening with data during uploading data to LASR and registering table

Posted in reply to jakubniescior

1. A LASR table stays in memory until it is deleted/unloaded by a VA user or the LASR server is stopped or the SAS VA app server is rebooted.

 

2. Registering the table in metadata is just that - it is quite separate from loading the table into LASR memory. METALIB only does the metadata registration, not the loading into LASR. You can't register a table until it is loaded into LASR memory, but you can delete a LASR table and still keep the metadata registration. You can also load a table without registering it in metadata, but that means you can't use it in SAS VA reporting.

 

3. The metadata folder relates to metadata only and is nothing to do with physical file folders. Metadata folders are a way organising objects and controlling permissions and access to the LASR data, and other metadata objects like VA report definitions.  

View solution in original post


All Replies
Solution
‎08-18-2017 03:18 AM
Super User
Posts: 3,866

Re: What is happening with data during uploading data to LASR and registering table

Posted in reply to jakubniescior

1. A LASR table stays in memory until it is deleted/unloaded by a VA user or the LASR server is stopped or the SAS VA app server is rebooted.

 

2. Registering the table in metadata is just that - it is quite separate from loading the table into LASR memory. METALIB only does the metadata registration, not the loading into LASR. You can't register a table until it is loaded into LASR memory, but you can delete a LASR table and still keep the metadata registration. You can also load a table without registering it in metadata, but that means you can't use it in SAS VA reporting.

 

3. The metadata folder relates to metadata only and is nothing to do with physical file folders. Metadata folders are a way organising objects and controlling permissions and access to the LASR data, and other metadata objects like VA report definitions.  

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 175 views
  • 1 like
  • 2 in conversation