topic Re: How do I find Greenplum indexed columns with SAS? in SAS Data Management

How do I find Greenplum indexed columns with SAS?

waterfall — Mon, 28 Nov 2016 20:22:54 GMT

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::SQLStatistics "","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

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

JBailey — Wed, 30 Nov 2016 16:51:22 GMT

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;

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

LinusH — Fri, 02 Dec 2016 00:05:36 GMT

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.