Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Suppose we have .sas7bdat files on a hadoop server. I want to view the same files on a different hadoop server and convert them to spds.

Highlighted

Suppose we have .sas7bdat files on a hadoop server. I want to view the same files on a different hadoop server and convert them to spds.

New Contributor

How do I view them in a library? I am not able to view those .sas7bdat files.

3 REPLIES 3

Re: Suppose we have .sas7bdat files on a hadoop server. I want to view the same files on a different hadoop server and convert them to spds.

Super Collaborator

do you have the files in hdfs? if the other hadoop server is in the same cluster, you just need the hdfs client there.

the storage location is also important to define the correct library (in SAS i guess?). With SAS >9.3 you should be able to define a libname for a hdfs storage:

http://support.sas.com/documentation/cdl/en/acreldb/65247/HTML/default/viewer.htm#n1h398otek0j00n1it...

But if the files are stored directly on a local dir of the machine, you can access them with any SAS version, but you will need to have access to the dir from SAS (via share and mount typically).

With hdfs and SAS <9.3 you will have to use the nfs gateway for hdfs, which enables to access hdfs as a network share, which you can then use define a libname on.

Re: Suppose we have .sas7bdat files on a hadoop server. I want to view the same files on a different hadoop server and convert them to spds.

New Contributor

Thanks @Harald Berghoff for the response.

Yes, I do have the files in hdfs, not in local.

As per using the hdfs gateway, does it enable us to view files of any type? Or it restricts the view to the engine type (SPDE in this case)?

Re: Suppose we have .sas7bdat files on a hadoop server. I want to view the same files on a different hadoop server and convert them to spds.

Super Collaborator

The hdfs gateway provides the complete hdfs file system as a NFS share. So you can access any file of any type. if that's also a good solution is something else. I think the SPD server from SAS is supposed to interact directly with hdfs, but i can't really tell. But if the SPD server 'talks' hdfs you will not need any gateway.

Don't have an account?
Coming from Hortonworks? Activate your account here