topic Re: Facing issue in proc sql pass through for SAS - Hadoop in SAS Programming

Facing issue in proc sql pass through for SAS - Hadoop

shubhamjain — Sun, 16 Sep 2018 06:10:43 GMT

Hi,

I have been facing error while executing a test query in SAS for Hadoop. PFB query and error.

proc sql;
connect to hadoop as hd
 (server='server-name' user=username password='********' schema='schema-name' subprotocol=hive2 connection=global)

 

create table work.test as
select * from connection to hd(
select * from schema-name.table_name);

disconnect from hd;
quit;

ERROR: Unable to read from pipe: Success
ERROR: Fetch error.

Can someone please let me know how to resolve above error?

Re: Facing issue in proc sql pass through for SAS - Hadoop

ChrisNZ — Mon, 17 Sep 2018 05:20:04 GMT

What do you get when you run

proc contents data=HD.table_name;
run;

Re: Facing issue in proc sql pass through for SAS - Hadoop

shubhamjain — Mon, 17 Sep 2018 05:53:04 GMT

Hi Chris,

The proc contents ran successfully and I got the details of the tables and alphabetic list of variables and attributes.

Thanks,

Shubham Jain

Re: Facing issue in proc sql pass through for SAS - Hadoop

ChrisNZ — Tue, 18 Sep 2018 00:13:19 GMT

That's odd.

Please show us the log when running:

proc sql;
 connect using hd;
 create table work.test as
 select * from connection to hd(
  select * from schema-name.table_name);
 disconnect from hd;
quit;
proc sql;
  select * from hd.table_name;
quit;

Re: Facing issue in proc sql pass through for SAS - Hadoop

LinusH — Wed, 19 Sep 2018 05:40:13 GMT

Try an implicit pass through using a libname instead. Then you use the SASTRACE debugging options.