SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

How do I find Greenplum indexed columns with SAS?

Reply
Learner
Posts: 1

How do I find Greenplum indexed columns with SAS?

I'm trying some pass-through code without success.  I was able to find Oracle indexes with pass-through code, but perhaps I should not assume this is also possible with Greenplum.  The log below shows what I tried:

Thanks for any help.

 

1378 proc sql;

1379

1380 connect to greenplm (user=xxxxx password=XXXXXXXXXXX dsn=gpdl_prd);

1381

1382 select * from connection to greenplm

1383 (Greenplum:Smiley FrustratedQLStatistics "","wcdl_pharm","NET_PAID_VW");

NOTE: No rows were selected.

1384 disconnect from greenplm;

1385 quit;

NOTE: PROCEDURE SQL used (Total process time):

real time 0.27 seconds

cpu time 0.06 seconds

 

 

 

SAS Employee
Posts: 203

Re: How do I find Greenplum indexed columns with SAS?

[ Edited ]

Hi @waterfall,

 

Could there be a problem with the schema and tablename? Are you sure that table exists?

 

This works for me...

 

libname gplum greenplm server='greenplum.somecompany.com'
                                        database=indb
                                        schema=myuser
                                        user=myuser password=password;
 
data work.testdata;
   do i = 1 to 100;
      x='aaaaaaaaaaaaaaaaaaaaaaaaaaaaa';
      y='bbbbbbbbbbbbbbbbbbbbbbbbbbbbb';
      z='ccccccccccccccccccccccccccccc';
      output;
   end;
run;
 
proc append base=gplum.testdata data=work.testdata;
run;
 
proc sql;
   connect using gplum;
   select * from connection to gplum
      (Greenplum::SQLStatistics "", "myuser","testdata");
quit;

 

Super User
Posts: 5,257

Re: How do I find Greenplum indexed columns with SAS?

I just want to stress that anything that is specified within a connection to block is database specific, you will probably be better off asking this at a Greenplum forum.
Data never sleeps
Ask a Question
Discussion stats
  • 2 replies
  • 144 views
  • 0 likes
  • 3 in conversation