How to create temp table in vertica from RStudio chunk

I am trying to create a temporary table from an RStudio chunk.

-- save baseline table at participant grain
CREATE LOCAL TEMPORARY TABLE my_temp ON COMMIT PRESERVE ROWS AS /*+direct*/
SELECT
    treatment_name,
    id,
    assign_date,
FROM my_table;

The query works within RStudio if I don't try to create a temp table, but the temp table creation triggers the following error

Error in .verify.JDBC.result(r, "Unable to retrieve JDBC result set for ", :
Unable to retrieve JDBC result set for
...restates my query...
Failed to execute SQL chunk

I can use this exact code to create a temp table from Alation, but I'm trying to automate report creation in RStudio so I'd prefer all the queries to initiate in RStudio.

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