Missing Records in Vertica
Hi all,
I am currently facing an issue where my insert statement isn't fully publishing all of the records in the source set. Here is an example:
INSERT /*direct*/ INTO target
(id,
b)
select
src1.id,
src2.a
from src1
inner join src2
on src1.id=src2.id
--inserts 100 records
If commit the following query, I get 1,000 records returned:
select
count(*)
from src1
inner join src2
on src1.id=src2.id
--1000 records returned
Has anyone encountered this issue before?To add to this, when I modify my insert to where src1.id is a specific value, the values are accurately inserted, even when the full query without the filter did not.
Any help is appreciated.
Thank you!
0
Comments
Vertica gets count(*) from container header (somethings like this)/ I guess it takes for both of tables but not from resulting dataset.
This is just a guess )