Missing Records in Vertica

snjung

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!

FiliN

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 )