antoniomuso commented on issue #6763:
URL:
https://github.com/apache/incubator-devlake/issues/6763#issuecomment-1882939169
There is a discrepancy:
```sql
SELECT count(id)
FROM lake._raw_gitlab_api_job
```
Return to me 4534738 entries. If I try to query the domain layer
```sql
WITH _t AS
(SELECT repo_id, count(t.id) as jobs
FROM lake.cicd_tasks t, lake.cicd_pipelines p, cicd_pipeline_commits c
WHERE t.pipeline_id = p.id AND c.pipeline_id = p.id
GROUP BY repo_id
)
select sum(jobs) from _t
```
I obtain 240414 entries.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
