Comments on: Analyze your data in Azure Data Lake with R (R extension)

By: Tsuyoshi Matsuzaki

Tsuyoshi Matsuzaki — Fri, 21 Dec 2018 01:57:24 +0000

Hi Adeoluwa-san, I’m so sorry, but I haven’t tried for multiple rowsets. But I think it might be impossible, because the official document says as follows.
https://docs.microsoft.com/en-us/u-sql/statements-and-expressions/table-valued-function-expression
“A U-SQL TVF can either return a single rowset or multiple rowsets. If it returns multiple rowsets it can only be assigned to rowset variables and cannot be called in a FROM clause, set expressions, or OUTPUT.”

LikeLike

By: Adeoluwa Adelugba

Adeoluwa Adelugba — Thu, 20 Dec 2018 15:05:57 +0000

Hi Tsuyoshi, do you know if one can use two rowsets at the same time in the R Script? That is, having two “inputFromUSQL”.

LikeLike

By: Dan Reznik

Dan Reznik — Mon, 25 Dec 2017 11:13:48 +0000

How can I gain access to the processing power of ADLA from RStudio directly. The workflow would consist in (a) connecting to the ADLA, (b) using a library to query the ADLA and do parallel processing with it, (c) retrieving the results. I find it extremely cumbersome that R must be inlined into U-SQL, and would prefer to avoid it.

LikeLike

By: Tsuyoshi Matsuzaki

Tsuyoshi Matsuzaki — Fri, 16 Jun 2017 02:53:59 +0000

In reply to Stian.

No, you cannot. You must load by “DEPLOY RESOURCE” for accessing files. (Except for “inputFromUSQL” data frame.)

LikeLike

By: Stian

Stian — Wed, 14 Jun 2017 06:32:50 +0000

By the way; Instead of loading the models though DELPOY/load, is it possible to access the data lake directly from the r script run by ADLA?

LikeLike

By: Stian

Stian — Wed, 14 Jun 2017 06:21:10 +0000

Thank you!

Finally some more practical examples on the R-integration!

LikeLiked by 1 person

By: Hempsoft

Hempsoft — Thu, 08 Jun 2017 13:09:34 +0000

Thanks for great information.

LikeLike