Forum Discussion

bosho's avatar
bosho
Frequent Visitor
2 years ago
Solved

sql command in SparkR

Hi,

 

I'm following along with the SparkR demo for Fabric notebooks that's on the microsoft website here:
https://learn.microsoft.com/en-us/fabric/data-science/r-use-sparkr

However, when I try to run any of the sql commands in a cell, instead of actually processing the command my notebook seems to just print out the SQL statement. Any ideas what I might be doing wrong?

Cheers,


data engineering
  • bosho's avatar
    bosho
    2 years ago

    Have since seen it's beecause I had loaded tidyverse in that notebook to work on some R stuff, and dplyr's sql() command seems to mask SparkR's. Think that's why it wasn't executing it on my spark dataframe.

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi bosho ,

    Thanks for using Fabric Community.
    I cannot find issue while I am executing the below code -


    Can you please share your test code so I can guide you better?

  • bosho's avatar
    bosho
    Frequent Visitor
    2 years ago

    Thanks for the quick responses. Yes trying it again today I don't seem to be able to replicate the issue, and I see what you're seeing. Previously it was just printing the SQL code back but today I'm getting what you're getting. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi bosho ,

      Glad to know that you no longer see the issue. Please continue using Fabric Community for your further queries.

      • bosho's avatar
        bosho
        Frequent Visitor
        2 years ago

        Have since seen it's beecause I had loaded tidyverse in that notebook to work on some R stuff, and dplyr's sql() command seems to mask SparkR's. Think that's why it wasn't executing it on my spark dataframe.