topic Load Hadoop file to CAS in SAS Viya

Load Hadoop file to CAS

telligent — Mon, 06 Jan 2020 03:58:52 GMT

I get to my Hadoop files using a libname with a schema.

When I tried to load a Hadoop file to CAS using proc casutil using the Hadoop libref (the same way I would load a base sas file), I got an error saying that THE filename was too long.

Does Cas only allow very short filenames? Or is a libref the wrong way to load Hadoop files into CAS.

Re: Load Hadoop file to CAS

alexal — Mon, 06 Jan 2020 12:16:41 GMT

@telligent ,

I would like to review your SAS log with an error.

Re: Load Hadoop file to CAS

telligent — Tue, 07 Jan 2020 04:50:01 GMT

Instead could you help me with some sample code (or a link to some) for loading from a hadoop library to cas. Thanks.

libname xxx HADOOP server="123.456.789" schema=yyy;

has file zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz.

I am pretty certain I am doing the step below incorrectly. Should I use the physical name from the log? Do I need an incaslib? Should I use file= instead of data=?.

proc casutil;
load data="xxx.zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz" outcaslib="casuser" ;
run;

ERROR: The physical file name "xxx.zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz" is too long.

Re: Load Hadoop file to CAS

alexal — Tue, 07 Jan 2020 12:19:11 GMT

@telligent ,

How many characters are in your library name?

Re: Load Hadoop file to CAS

telligent — Tue, 07 Jan 2020 15:05:58 GMT

4 characters

Re: Load Hadoop file to CAS

alexal — Fri, 17 Jan 2020 14:45:15 GMT

@telligent ,

Please show me the output from a program below:

proc options option=VALIDVARNAME value; run;