sql command in SparkR

[bosho]

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,

[HimanshuS-msft]

Hello @bosho ,

Can you please share the test code which you are running ?

Thanks 
Himanshu

[govindarajan_d]

Hi @bosho,

Did you use the SQL command like this:

sqlquery <- sql("SELECT * FROM TABLE")

[Anonymous]

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]

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]

Hi @bosho ,

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

[bosho · Accepted solution]

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.