Yaniv Dary has submitted this change and it was merged. Change subject: etl: fixed duplicate row issues (#838962) ...................................................................... etl: fixed duplicate row issues (#838962) Due to wrong data selection data was missing or two row were created for each hour\day. This patch fixes the selects. https://bugzilla.redhat.com/838962 Change-Id: I8f41a017ae5ebf91f230881485850e41a4f2eb53 Signed-off-by: Yaniv Dary <ydary(a)redhat.com&gt; --- M data-warehouse/history_etl/etl_sources/historyETLProcedure/src/main/java/ovirt_engine_dwh/aggregationtodaily_3_1/AggregationToDaily.java M data-warehouse/history_etl/etl_sources/historyETLProcedure/src/main/java/ovirt_engine_dwh/aggregationtohourly_3_1/AggregationToHourly.java M data-warehouse/history_etl/tos_project/process/AggregationToDaily_3.1.item M data-warehouse/history_etl/tos_project/process/AggregationToDaily_3.1.properties M data-warehouse/history_etl/tos_project/process/AggregationToHourly_3.1.item M data-warehouse/history_etl/tos_project/process/AggregationToHourly_3.1.properties M data-warehouse/history_etl/tos_project/talend.project 7 files changed, 502 insertions(+), 502 deletions(-) Approvals: Eli Mesika: Looks good to me, approved Yaniv Dary: Verified; Looks good to me, but someone else must approve -- To view, visit http://gerrit.ovirt.org/6150 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: merged Gerrit-Change-Id: I8f41a017ae5ebf91f230881485850e41a4f2eb53 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-dwh Gerrit-Branch: master Gerrit-Owner: Yaniv Dary <ydary(a)redhat.com&gt; Gerrit-Reviewer: Eli Mesika <emesika(a)redhat.com&gt; Gerrit-Reviewer: Yaniv Dary <ydary(a)redhat.com&gt;