Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
creating temp table as select using vsql does not load data into table
I am trying to create temp table as select using vsql as shown below:
[dbadmin procedures]$/opt/vertica/bin/vsql -c "CREATE TEMP TABLE TMP_TECH ON COMMIT PRESERVE ROWS AS
SELECT A.DRIVE_ID,A.DEVICE_ID,A.DEVICE_TECH_ID
FROM CALL_DATA.LU_MARKET_CARRIER A
INNER JOIN CALL_DATA.STG_CURRENT_DRIVES B
ON A.DRIVE_ID = B.DRIVE_ID
GROUP BY A.DRIVE_ID,A.DEVICE_ID,A.DEVICE_TECH_ID
SEGMENTED BY HASH(DRIVE_ID,DEVICE_ID,DEVICE_TECH_ID) ALL NODES;" -d Nielson_db -U dbadmin -w password
The table is created but no data loaded into it. While after connecting to database and then running below query creates and loads the data into temp table:
Example_db=>CREATE TEMP TABLE TMP_TECH ON COMMIT PRESERVE ROWS AS
SELECT A.DRIVE_ID,A.DEVICE_ID,A.DEVICE_TECH_ID
FROM CALL_DATA.LU_MARKET_CARRIER A
INNER JOIN CALL_DATA.STG_CURRENT_DRIVES B
ON A.DRIVE_ID = B.DRIVE_ID
GROUP BY A.DRIVE_ID,A.DEVICE_ID,A.DEVICE_TECH_ID
SEGMENTED BY HASH(DRIVE_ID,DEVICE_ID,DEVICE_TECH_ID) ALL NODES;
Please let me know what may be reason.
[dbadmin procedures]$/opt/vertica/bin/vsql -c "CREATE TEMP TABLE TMP_TECH ON COMMIT PRESERVE ROWS AS
SELECT A.DRIVE_ID,A.DEVICE_ID,A.DEVICE_TECH_ID
FROM CALL_DATA.LU_MARKET_CARRIER A
INNER JOIN CALL_DATA.STG_CURRENT_DRIVES B
ON A.DRIVE_ID = B.DRIVE_ID
GROUP BY A.DRIVE_ID,A.DEVICE_ID,A.DEVICE_TECH_ID
SEGMENTED BY HASH(DRIVE_ID,DEVICE_ID,DEVICE_TECH_ID) ALL NODES;" -d Nielson_db -U dbadmin -w password
The table is created but no data loaded into it. While after connecting to database and then running below query creates and loads the data into temp table:
Example_db=>CREATE TEMP TABLE TMP_TECH ON COMMIT PRESERVE ROWS AS
SELECT A.DRIVE_ID,A.DEVICE_ID,A.DEVICE_TECH_ID
FROM CALL_DATA.LU_MARKET_CARRIER A
INNER JOIN CALL_DATA.STG_CURRENT_DRIVES B
ON A.DRIVE_ID = B.DRIVE_ID
GROUP BY A.DRIVE_ID,A.DEVICE_ID,A.DEVICE_TECH_ID
SEGMENTED BY HASH(DRIVE_ID,DEVICE_ID,DEVICE_TECH_ID) ALL NODES;
Please let me know what may be reason.
0
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
Comments