Tue Sep 17, 2019 10:43 pm
Login Register Lost Password? Contact Us


Call published queries

Questions and comments related to the rHPCC integration plugin

Wed May 22, 2013 1:55 pm Change Time Zone

IMO, the R plugin can be of tremendous advantage in two situations:

1. You need R to do sophisticated reporting (using R graphics packages, etc.) based on datasets computed from HPCC. The current typical apporach is to output and despray a CSV file which is then ingested into R. However, a direct import into R from HPCC workunits (run from the R plugin or run previously) is the most ideal scenario as we reduce the scope for using inconsistent (desprayed) files.

2. Calling HPCC web services (Roxie published queries) from within R, which at the moment is not very easy to do as SOAP support in R is not ideal. A roundabout way to do this is to use the stored procedure calls in HPCC JDBC driver but the SQL standard has its own limitations (eg. no support for nested datasets).

Is there a plan to allow for accessing Roxie published queries directly from R?
sbagaria
Community Advisory Board Member
Community Advisory Board Member
 
Posts: 92
Joined: Thu Jul 05, 2012 9:23 pm

Fri May 24, 2013 7:36 pm Change Time Zone

Great Ideas.

"1. You need R to do sophisticated reporting (using R graphics packages, etc.) based on datasets computed from HPCC. The current typical apporach is to output and despray a CSV file which is then ingested into R. However, a direct import into R from HPCC workunits (run from the R plugin or run previously) is the most ideal scenario as we reduce the scope for using inconsistent (desprayed) files."

We had the same intention. Please take a look at:

http://hpccsystems.com/products-and-ser ... ntegration

We stopped short of implementing data frames. The idea was to see if somebody in the community would continue the development.

2. Calling HPCC web services (Roxie published queries) from within R, which at the moment is not very easy to do as SOAP support in R is not ideal. A roundabout way to do this is to use the stored procedure calls in HPCC JDBC driver but the SQL standard has its own limitations (eg. no support for nested datasets).

Again, please take a look at the integration above. All ROXIE and Thor queires expose a REST interface. Even though we did not integrate Roxie in this implementation, the idea of calling out to a service is the same.
arjuna chala
Community Advisory Board Member
Community Advisory Board Member
 
Posts: 21
Joined: Mon Jul 11, 2011 1:57 pm


Return to R Plugin

Who is online

Users browsing this forum: No registered users and 1 guest