Unable to Extract minute from timestamp in Sparklyr

df<-data.frame(utc_time_stamp=c("2019-04-28 18:35:26","2019-04-28 21:28:58","2019-04-28 18:59:01"),city=c("Tokyo","Brisbane","Delhi"))

#loading data into spark

df1<-copy_to(sc,df,"df1",overwrite = T)

df2<- df1 %>%
mutate(local_minute= minute(timestamp(utc_time_stamp)))

df2

This is the error I get when i execute code related to hour extraction

Error: org.apache.spark.sql.catalyst.parser.ParseException:
missing ')' at 'FROM'(line 1, pos 65)

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.