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 ...
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.

govindarajan_d's avatar
govindarajan_d
Icon for Super User rankSuper User
2 years ago

Hi bosho,

 

Did you use the SQL command like this:

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