Why does query count return zero rows when table is being loaded?
I'm loading a target cluster table from a corresponding table in a source cluster using the vsql technique described at http://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/ConnectingToHPVertica/vsql/CopyingDataUsingVsql.htm?Highlight=vsql ("Copying Data Using Vsql"). Essentially this is what is running:-
vsql -U username -w passwd -h testdb01 -d vmart -At -c "SELECT * from store.store_sales_fact" \
| vsql -U username -w passwd -d vmart -c "COPY store.store_sales_fact FROM STDIN DELIMITER '|';"
As my version of this is running, I see the disk on the target cluster filling (so data is being copied), but when I issue a simple count query on the target cluster to see how many rows are present :-
SELECT COUNT(*) FROM target_table_name;
I always get zero rows returned. There's a large amount of data to copy, so it's a long running operation. However, running this query at various intervals ALWAYS yields zero rows - why? When will the data get flushed so this query reports accurately?
Thanks in advance!