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.
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.