How can I avoid WARNING: The following columns could have a length in SAS of 32767... in Hadoop

Accepted Solution Solved
Reply
Trusted Advisor
Posts: 1,519
Accepted Solution

How can I avoid WARNING: The following columns could have a length in SAS of 32767... in Hadoop

[ Edited ]

 

Hi

I run this code to extract Hadoop Metadata

proc sql;
 connect to hadoop ( &hadoop_connection.);
 create table METADATA as
   select * from connection to hadoop ( describe extended &tableout. );
 disconnect from hadoop;
quit;

 

 and I can't get rid of the dreaded Hadoop warning:

WARNING: The following columns could have a length in SAS of 32767. If so, SAS performance is impacted. See SAS/ACCESS documentation for details.

 

Any way to disable this pesky warning and extract the metadata ?


Accepted Solutions
Solution
‎03-18-2017 06:11 AM
Trusted Advisor
Posts: 1,519

Re: How can I avoid WARNING: The following columns could have a length in SAS of 32767... in Hadoop

[ Edited ]

Not ideal but a way to avoid the message here

View solution in original post


All Replies
Esteemed Advisor
Posts: 7,301

Re: How can I avoid WARNING: The following columns could have a length in SAS of 32767... in Hadoop

Take a look at page 20 of the following document: http://support.sas.com/resources/thirdpartysupport/v94/hadoop/sas-hadoop-performance-strategies.pdf

 

The answer, I think, is to issue alter statements to Hadoop in order to set the desired SAS properties.

 

Art, CEO, AnalystFinder.com

 

Grand Advisor
Posts: 9,596

Re: How can I avoid WARNING: The following columns could have a length in SAS of 32767... in Hadoop

Not sure if this option could work.


options VARLENCHK=nowarn;


Trusted Advisor
Posts: 1,519

Re: How can I avoid WARNING: The following columns could have a length in SAS of 32767... in Hadoop

Thank you for your answers. Sady no luck yet.

@art297 I am not reading a table so I cannot set column properties.
@Ksharp This option is only used by data steps.

Solution
‎03-18-2017 06:11 AM
Trusted Advisor
Posts: 1,519

Re: How can I avoid WARNING: The following columns could have a length in SAS of 32767... in Hadoop

[ Edited ]

Not ideal but a way to avoid the message here

☑ This topic is SOLVED.

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

Discussion stats
  • 4 replies
  • 208 views
  • 0 likes
  • 3 in conversation