Hi Guys, I am trying to connect to a Cloudera cluster and run a query there by using an execute statement: libname sas2 hadoop uri='.........' schema="data_analyst" SERVER="1***.**.**.***" TRANSCODE_FAIL=SILENT DBMAX_TEXT=50; libname vantage hadoop uri='.........' schema="vantage" SERVER="***.**.**.***" TRANSCODE_FAIL=SILENT DBMAX_TEXT=50; proc sql; connect to HADOOP ( SERVER="***.**.**.***" uri='......' ); execute( create table sas.T0 as SELECT A.var1, A.var2, B.var3,B.var4, FROM sas2.data_set_1 as A left join vantage.data_set_2 as B on A.column1=B.column2) by hadoop; disconnect from hadoop; quit; The problem is that (since I want to "execute" in Cloudera) I cannot use the name sas2 as a Libref for the first schema. I must give it the name "data_analyst" which is not a valid SAS Libname... . So I cannot access/use the dataset sas2.data_set_1 in the query above. Any solution other than renaming the Cloudera schema "data_analyst" to something less than 9 characters ?
... View more