dplyr function compute() failed, ParseException but other functions works

General
,
1

Hello,

I tried to use dplyr with the version 1.1.2, 1.1.1, 1.1.0 and it works fine for the functions in packages except for the compute().

I'm not good with R and didn't find many code examples explained clearly how the compute() function work.

Here some code I tried but failed:

test <- df_select_20 %>% filter(quality >= 5) %>% select(chlorides:quality) %>% ungroup() %>% compute(name="new_tmp_view")

which is for a dataframe of wine quality in opensource. I might not use it correctly but here the error log I got:

Error in `db_save_query.DBIConnection()`:
! Can't save query to "dbplyr_002".
Caused by error:
! org.apache.spark.sql.catalyst.parser.ParseException: 
no viable alternative at input 'CREATE OR REPLACE TEMPORARY VIEW \n"dbplyr_002"'(line 2, pos 0)

== SQL ==
CREATE OR REPLACE TEMPORARY VIEW 
"dbplyr_002" AS SELECT *
^^^
FROM `sparklyr_tmp_275a91a3_e06b_44e4_a469_f3593c483a2d`

Thank.

2

The solution that works was changing the version of the package dbplyr from 2.3.3 to 2.3.1

3

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

If you have a query related to it or one of the replies, start a new topic and refer back with a link.