Options
Export not working with Local Temp Tables
Arumugaguru_M
Vertica Employee ✭
Hi,
I tried to export one table data from our PROD vertica DB to UAT vertica DB using some local temp table but it is not working.
The connect statement works fine only the problem with export
Query:
CREATE LOCAL TEMP TABLE EMPLOYEE
(
EMP_ID INT,
DOJ DATE
)
ON COMMIT PRESERVER ROWS;
INSERT INTO EMPLOYEE
SELECT EMP_ID, DOJ FROM TGT_SCH.EMPLOYEE_DATES LIMIT 10;
EXPORT TO VERTICA UAT_DB.SCHM.EMPLOYEE AS SELECT A.* FROM TGT_SCH.EMPLOYEE A INNER JOIN EMPLOYEE B on A.EMP_ID = B.EMP_ID;
EXPORT TO VERTICA UAT_DB.SCHM.EMPLOYEE_SALARY AS SELECT A.* FROM TGT_SCH.EMPLOYEE_SALARY A INNER JOIN EMPLOYEE B on A.EMP_ID = B.EMP_ID;
Can someone pls help.
I tried to export one table data from our PROD vertica DB to UAT vertica DB using some local temp table but it is not working.
The connect statement works fine only the problem with export
Query:
CREATE LOCAL TEMP TABLE EMPLOYEE
(
EMP_ID INT,
DOJ DATE
)
ON COMMIT PRESERVER ROWS;
INSERT INTO EMPLOYEE
SELECT EMP_ID, DOJ FROM TGT_SCH.EMPLOYEE_DATES LIMIT 10;
EXPORT TO VERTICA UAT_DB.SCHM.EMPLOYEE AS SELECT A.* FROM TGT_SCH.EMPLOYEE A INNER JOIN EMPLOYEE B on A.EMP_ID = B.EMP_ID;
EXPORT TO VERTICA UAT_DB.SCHM.EMPLOYEE_SALARY AS SELECT A.* FROM TGT_SCH.EMPLOYEE_SALARY A INNER JOIN EMPLOYEE B on A.EMP_ID = B.EMP_ID;
Can someone pls help.
0
Comments
RTFM - click on link and read an article, please.
http://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/AdministratorsGuide/Tables/AboutTemporaryT...