How to create temp table in vertica from RStudio chunk

Publishing Your Results
,
1

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.

2

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