Yaniv Dary has uploaded a new change for review.

Change subject: etl: fixed issue with user_logged_in_to_guest column null 
handling
......................................................................

etl: fixed issue with user_logged_in_to_guest column null handling

etl did not handle null values well, this is now fixed.

Change-Id: Ib70d02aaf4d8de4f6f6af6d3ce1b5f511e64c3a8
Bug-Url: https://bugzilla.redhat.com/1057412
Signed-off-by: Yaniv Dary <yd...@redhat.com>
---
M etl_export/src/ovirt_engine_dwh/aggregationtodaily_3_4/AggregationToDaily.java
M 
etl_export/src/ovirt_engine_dwh/aggregationtohourly_3_4/AggregationToHourly.java
M tos_project/process/AggregationToDaily_3.4.item
M tos_project/process/AggregationToDaily_3.4.properties
M tos_project/process/AggregationToHourly_3.4.item
M tos_project/process/AggregationToHourly_3.4.properties
6 files changed, 38 insertions(+), 14 deletions(-)


  git pull ssh://gerrit.ovirt.org:29418/ovirt-dwh refs/changes/09/23709/1

diff --git 
a/etl_export/src/ovirt_engine_dwh/aggregationtodaily_3_4/AggregationToDaily.java
 
b/etl_export/src/ovirt_engine_dwh/aggregationtodaily_3_4/AggregationToDaily.java
index dd3fe7c..d93f02d 100644
--- 
a/etl_export/src/ovirt_engine_dwh/aggregationtodaily_3_4/AggregationToDaily.java
+++ 
b/etl_export/src/ovirt_engine_dwh/aggregationtodaily_3_4/AggregationToDaily.java
@@ -24183,7 +24183,8 @@
                                                // # Output table : 
'complete_aggregate_users'
                                                
complete_aggregate_users_tmp.history_datetime = row14.history_datetime;
                                                
complete_aggregate_users_tmp.user_name = row14.user_name;
-                                               
complete_aggregate_users_tmp.user_logged_in_to_guest = 
row14.user_logged_in_to_guest > 0;
+                                               
complete_aggregate_users_tmp.user_logged_in_to_guest = 
row14.user_logged_in_to_guest != null ? row14.user_logged_in_to_guest > 0
+                                                               : null;
                                                
complete_aggregate_users_tmp.vm_id = row14.vm_id;
                                                
complete_aggregate_users_tmp.session_time_in_minutes = 
row14.session_time_in_minutes;
                                                
complete_aggregate_users_tmp.cpu_usage_percent = row14.cpu_usage_percent;
@@ -25990,6 +25991,6 @@
        ResumeUtil resumeUtil = null;
 }
 
/************************************************************************************************
- * 748765 characters generated by Talend Open Studio for Data Integration on 
the
- * January 21, 2014 3:54:34 PM IST
+ * 748810 characters generated by Talend Open Studio for Data Integration on 
the
+ * January 26, 2014 2:12:33 PM IST
  
************************************************************************************************/
diff --git 
a/etl_export/src/ovirt_engine_dwh/aggregationtohourly_3_4/AggregationToHourly.java
 
b/etl_export/src/ovirt_engine_dwh/aggregationtohourly_3_4/AggregationToHourly.java
index 72bed5b..7e11a58 100644
--- 
a/etl_export/src/ovirt_engine_dwh/aggregationtohourly_3_4/AggregationToHourly.java
+++ 
b/etl_export/src/ovirt_engine_dwh/aggregationtohourly_3_4/AggregationToHourly.java
@@ -24182,7 +24182,8 @@
                                                // # Output table : 
'complete_aggregation'
                                                
complete_aggregation_tmp.history_datetime = row14.history_datetime;
                                                
complete_aggregation_tmp.user_name = row14.user_name;
-                                               
complete_aggregation_tmp.user_logged_in_to_guest = 
row14.user_logged_in_to_guest > 0;
+                                               
complete_aggregation_tmp.user_logged_in_to_guest = 
row14.user_logged_in_to_guest != null ? row14.user_logged_in_to_guest > 0
+                                                               : null;
                                                complete_aggregation_tmp.vm_id 
= row14.vm_id;
                                                
complete_aggregation_tmp.session_time_in_minutes = 
row14.session_time_in_minutes;
                                                
complete_aggregation_tmp.cpu_usage_percent = row14.cpu_usage_percent;
@@ -25985,6 +25986,6 @@
        ResumeUtil resumeUtil = null;
 }
 
/************************************************************************************************
- * 748813 characters generated by Talend Open Studio for Data Integration on 
the
- * January 21, 2014 3:54:33 PM IST
+ * 748859 characters generated by Talend Open Studio for Data Integration on 
the
+ * January 26, 2014 2:12:32 PM IST
  
************************************************************************************************/
diff --git a/tos_project/process/AggregationToDaily_3.4.item 
b/tos_project/process/AggregationToDaily_3.4.item
index fa5d0ee..3afca66 100644
--- a/tos_project/process/AggregationToDaily_3.4.item
+++ b/tos_project/process/AggregationToDaily_3.4.item
@@ -128,6 +128,7 @@
     <elementParameter field="CHECK" name="DIE_ON_ERROR" value="true"/>
     <elementParameter field="CHECK" name="LKUP_PARALLELIZE" value="false"/>
     <elementParameter field="TEXT" name="ROWS_BUFFER_SIZE" value="2000000"/>
+    <elementParameter field="CHECK" 
name="CHANGE_HASH_AND_EQUALS_FOR_BIGDECIMAL" value="false"/>
     <elementParameter field="TEXT" name="CONNECTION_FORMAT" value="row"/>
     <elementParameter field="CHECK" name="INFORMATION" value="false"/>
     <elementParameter field="MEMO" name="COMMENT" value=""/>
@@ -362,6 +363,7 @@
     <elementParameter field="CHECK" name="DIE_ON_ERROR" value="true"/>
     <elementParameter field="CHECK" name="LKUP_PARALLELIZE" value="false"/>
     <elementParameter field="TEXT" name="ROWS_BUFFER_SIZE" value="2000000"/>
+    <elementParameter field="CHECK" 
name="CHANGE_HASH_AND_EQUALS_FOR_BIGDECIMAL" value="false"/>
     <elementParameter field="TEXT" name="CONNECTION_FORMAT" value="row"/>
     <elementParameter field="CHECK" name="INFORMATION" value="false"/>
     <elementParameter field="MEMO" name="COMMENT" value=""/>
@@ -385,7 +387,7 @@
       <column comment="" key="false" length="4" 
name="host_configuration_version" nullable="true" pattern="" precision="0" 
sourceType="INT4" type="id_Integer" usefulColumn="true"/>
     </metadata>
     <nodeData xsi:type="MapperData">
-      <uiProperties shellMaximized="true"/>
+      <uiProperties/>
       <varTables sizeState="INTERMEDIATE" name="Var" minimized="true"/>
       <outputTables sizeState="INTERMEDIATE" name="host_aggregation">
         <mapperTableEntries name="history_datetime" 
expression="RoutineHistoryETL.startOfDay(row2.history_datetime) " 
type="id_Date"/>
@@ -860,6 +862,7 @@
     <elementParameter field="CHECK" name="DIE_ON_ERROR" value="true"/>
     <elementParameter field="CHECK" name="LKUP_PARALLELIZE" value="false"/>
     <elementParameter field="TEXT" name="ROWS_BUFFER_SIZE" value="2000000"/>
+    <elementParameter field="CHECK" 
name="CHANGE_HASH_AND_EQUALS_FOR_BIGDECIMAL" value="false"/>
     <elementParameter field="TEXT" name="CONNECTION_FORMAT" value="row"/>
     <elementParameter field="CHECK" name="INFORMATION" value="false"/>
     <elementParameter field="MEMO" name="COMMENT" value=""/>
@@ -1111,6 +1114,7 @@
     <elementParameter field="CHECK" name="DIE_ON_ERROR" value="true"/>
     <elementParameter field="CHECK" name="LKUP_PARALLELIZE" value="false"/>
     <elementParameter field="TEXT" name="ROWS_BUFFER_SIZE" value="2000000"/>
+    <elementParameter field="CHECK" 
name="CHANGE_HASH_AND_EQUALS_FOR_BIGDECIMAL" value="false"/>
     <elementParameter field="TEXT" name="CONNECTION_FORMAT" value="row"/>
     <elementParameter field="CHECK" name="INFORMATION" value="false"/>
     <elementParameter field="MEMO" name="COMMENT" value=""/>
@@ -1480,6 +1484,7 @@
     <elementParameter field="CHECK" name="DIE_ON_ERROR" value="true"/>
     <elementParameter field="CHECK" name="LKUP_PARALLELIZE" value="false"/>
     <elementParameter field="TEXT" name="ROWS_BUFFER_SIZE" value="2000000"/>
+    <elementParameter field="CHECK" 
name="CHANGE_HASH_AND_EQUALS_FOR_BIGDECIMAL" value="false"/>
     <elementParameter field="TEXT" name="CONNECTION_FORMAT" value="row"/>
     <elementParameter field="CHECK" name="INFORMATION" value="false"/>
     <elementParameter field="MEMO" name="COMMENT" value=""/>
@@ -1697,6 +1702,7 @@
     <elementParameter field="CHECK" name="DIE_ON_ERROR" value="true"/>
     <elementParameter field="CHECK" name="LKUP_PARALLELIZE" value="false"/>
     <elementParameter field="TEXT" name="ROWS_BUFFER_SIZE" value="2000000"/>
+    <elementParameter field="CHECK" 
name="CHANGE_HASH_AND_EQUALS_FOR_BIGDECIMAL" value="false"/>
     <elementParameter field="TEXT" name="CONNECTION_FORMAT" value="row"/>
     <elementParameter field="CHECK" name="INFORMATION" value="false"/>
     <elementParameter field="MEMO" name="COMMENT" value=""/>
@@ -1847,6 +1853,7 @@
     <elementParameter field="CHECK" name="DIE_ON_ERROR" value="true"/>
     <elementParameter field="CHECK" name="LKUP_PARALLELIZE" value="false"/>
     <elementParameter field="TEXT" name="ROWS_BUFFER_SIZE" value="2000000"/>
+    <elementParameter field="CHECK" 
name="CHANGE_HASH_AND_EQUALS_FOR_BIGDECIMAL" value="false"/>
     <elementParameter field="TEXT" name="CONNECTION_FORMAT" value="row"/>
     <elementParameter field="CHECK" name="INFORMATION" value="false"/>
     <elementParameter field="MEMO" name="COMMENT" value=""/>
@@ -2096,6 +2103,7 @@
     <elementParameter field="CHECK" name="DIE_ON_ERROR" value="true"/>
     <elementParameter field="CHECK" name="LKUP_PARALLELIZE" value="false"/>
     <elementParameter field="TEXT" name="ROWS_BUFFER_SIZE" value="2000000"/>
+    <elementParameter field="CHECK" 
name="CHANGE_HASH_AND_EQUALS_FOR_BIGDECIMAL" value="false"/>
     <elementParameter field="TEXT" name="CONNECTION_FORMAT" value="row"/>
     <elementParameter field="CHECK" name="INFORMATION" value="false"/>
     <elementParameter field="MEMO" name="COMMENT" value=""/>
@@ -2468,6 +2476,7 @@
     <elementParameter field="CHECK" name="DIE_ON_ERROR" value="true"/>
     <elementParameter field="CHECK" name="LKUP_PARALLELIZE" value="false"/>
     <elementParameter field="TEXT" name="ROWS_BUFFER_SIZE" value="2000000"/>
+    <elementParameter field="CHECK" 
name="CHANGE_HASH_AND_EQUALS_FOR_BIGDECIMAL" value="false"/>
     <elementParameter field="TEXT" name="CONNECTION_FORMAT" value="row"/>
     <elementParameter field="CHECK" name="INFORMATION" value="false"/>
     <elementParameter field="MEMO" name="COMMENT" value=""/>
@@ -2639,6 +2648,7 @@
     <elementParameter field="CHECK" name="DIE_ON_ERROR" value="true"/>
     <elementParameter field="CHECK" name="LKUP_PARALLELIZE" value="false"/>
     <elementParameter field="TEXT" name="ROWS_BUFFER_SIZE" value="2000000"/>
+    <elementParameter field="CHECK" 
name="CHANGE_HASH_AND_EQUALS_FOR_BIGDECIMAL" value="false"/>
     <elementParameter field="TEXT" name="CONNECTION_FORMAT" value="row"/>
     <elementParameter field="CHECK" name="INFORMATION" value="false"/>
     <elementParameter field="MEMO" name="COMMENT" value=""/>
@@ -2807,6 +2817,7 @@
     <elementParameter field="CHECK" name="DIE_ON_ERROR" value="true"/>
     <elementParameter field="CHECK" name="LKUP_PARALLELIZE" value="false"/>
     <elementParameter field="TEXT" name="ROWS_BUFFER_SIZE" value="2000000"/>
+    <elementParameter field="CHECK" 
name="CHANGE_HASH_AND_EQUALS_FOR_BIGDECIMAL" value="false"/>
     <elementParameter field="TEXT" name="CONNECTION_FORMAT" value="row"/>
     <elementParameter field="CHECK" name="INFORMATION" value="false"/>
     <elementParameter field="MEMO" name="COMMENT" value=""/>
@@ -2832,12 +2843,12 @@
       <column comment="" key="false" length="4" 
name="current_host_configuration_version" nullable="true" pattern="" 
precision="0" sourceType="INT4" type="id_Integer" usefulColumn="true"/>
     </metadata>
     <nodeData xsi:type="MapperData">
-      <uiProperties/>
+      <uiProperties shellMaximized="true"/>
       <varTables sizeState="INTERMEDIATE" name="Var" minimized="true"/>
       <outputTables sizeState="INTERMEDIATE" name="complete_aggregate_users">
         <mapperTableEntries name="history_datetime" 
expression="row14.history_datetime" type="id_Date"/>
         <mapperTableEntries name="user_name" expression="row14.user_name" 
type="id_String" nullable="true"/>
-        <mapperTableEntries name="user_logged_in_to_guest" 
expression="row14.user_logged_in_to_guest > 0 " type="id_Boolean" 
nullable="true"/>
+        <mapperTableEntries name="user_logged_in_to_guest" 
expression="row14.user_logged_in_to_guest != null 
?row14.user_logged_in_to_guest > 0 : null" type="id_Boolean" nullable="true"/>
         <mapperTableEntries name="vm_id" expression="row14.vm_id" 
type="id_Object"/>
         <mapperTableEntries name="session_time_in_minutes" 
expression="row14.session_time_in_minutes" type="id_Double"/>
         <mapperTableEntries name="cpu_usage_percent" 
expression="row14.cpu_usage_percent" type="id_Short" nullable="true"/>
diff --git a/tos_project/process/AggregationToDaily_3.4.properties 
b/tos_project/process/AggregationToDaily_3.4.properties
index 487bd06..610423e 100644
--- a/tos_project/process/AggregationToDaily_3.4.properties
+++ b/tos_project/process/AggregationToDaily_3.4.properties
@@ -1,6 +1,6 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <xmi:XMI xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI"; 
xmlns:TalendProperties="http://www.talend.org/properties";>
-  <TalendProperties:Property xmi:id="_6qukwEi2EeCv8PaoeAjHHg" 
id="_s0iQoFShEeCW44CWrpjEnA" label="AggregationToDaily" 
creationDate="2011-07-06T14:17:29.833+0300" 
modificationDate="2014-01-05T15:11:11.917+0200" version="3.4" statusCode="" 
item="_6qukwki2EeCv8PaoeAjHHg" displayName="AggregationToDaily">
+  <TalendProperties:Property xmi:id="_6qukwEi2EeCv8PaoeAjHHg" 
id="_s0iQoFShEeCW44CWrpjEnA" label="AggregationToDaily" 
creationDate="2011-07-06T14:17:29.833+0300" 
modificationDate="2014-01-26T14:08:31.067+0200" version="3.4" statusCode="" 
item="_6qukwki2EeCv8PaoeAjHHg" displayName="AggregationToDaily">
     <author href="../talend.project#_SapC4EJlEeCWRqOtaF5m-w"/>
   </TalendProperties:Property>
   <TalendProperties:ItemState xmi:id="_s1bogFShEeCW44CWrpjEnA" path=""/>
diff --git a/tos_project/process/AggregationToHourly_3.4.item 
b/tos_project/process/AggregationToHourly_3.4.item
index 4ef17eb..48b46f8 100644
--- a/tos_project/process/AggregationToHourly_3.4.item
+++ b/tos_project/process/AggregationToHourly_3.4.item
@@ -128,6 +128,7 @@
     <elementParameter field="CHECK" name="DIE_ON_ERROR" value="true"/>
     <elementParameter field="CHECK" name="LKUP_PARALLELIZE" value="false"/>
     <elementParameter field="TEXT" name="ROWS_BUFFER_SIZE" value="2000000"/>
+    <elementParameter field="CHECK" 
name="CHANGE_HASH_AND_EQUALS_FOR_BIGDECIMAL" value="false"/>
     <elementParameter field="TEXT" name="CONNECTION_FORMAT" value="row"/>
     <elementParameter field="CHECK" name="INFORMATION" value="false"/>
     <elementParameter field="MEMO" name="COMMENT" value=""/>
@@ -362,6 +363,7 @@
     <elementParameter field="CHECK" name="DIE_ON_ERROR" value="true"/>
     <elementParameter field="CHECK" name="LKUP_PARALLELIZE" value="false"/>
     <elementParameter field="TEXT" name="ROWS_BUFFER_SIZE" value="2000000"/>
+    <elementParameter field="CHECK" 
name="CHANGE_HASH_AND_EQUALS_FOR_BIGDECIMAL" value="false"/>
     <elementParameter field="TEXT" name="CONNECTION_FORMAT" value="row"/>
     <elementParameter field="CHECK" name="INFORMATION" value="false"/>
     <elementParameter field="MEMO" name="COMMENT" value=""/>
@@ -385,7 +387,7 @@
       <column comment="" key="false" length="4" 
name="host_configuration_version" nullable="true" pattern="" precision="0" 
sourceType="INT4" type="id_Integer" usefulColumn="true"/>
     </metadata>
     <nodeData xsi:type="MapperData">
-      <uiProperties shellMaximized="true"/>
+      <uiProperties/>
       <varTables sizeState="INTERMEDIATE" name="Var" minimized="true"/>
       <outputTables sizeState="INTERMEDIATE" name="host_aggregation">
         <mapperTableEntries name="history_datetime" 
expression="RoutineHistoryETL.startOfHour(row2.history_datetime) " 
type="id_Date"/>
@@ -860,6 +862,7 @@
     <elementParameter field="CHECK" name="DIE_ON_ERROR" value="true"/>
     <elementParameter field="CHECK" name="LKUP_PARALLELIZE" value="false"/>
     <elementParameter field="TEXT" name="ROWS_BUFFER_SIZE" value="2000000"/>
+    <elementParameter field="CHECK" 
name="CHANGE_HASH_AND_EQUALS_FOR_BIGDECIMAL" value="false"/>
     <elementParameter field="TEXT" name="CONNECTION_FORMAT" value="row"/>
     <elementParameter field="CHECK" name="INFORMATION" value="false"/>
     <elementParameter field="MEMO" name="COMMENT" value=""/>
@@ -1114,6 +1117,7 @@
     <elementParameter field="CHECK" name="DIE_ON_ERROR" value="true"/>
     <elementParameter field="CHECK" name="LKUP_PARALLELIZE" value="false"/>
     <elementParameter field="TEXT" name="ROWS_BUFFER_SIZE" value="2000000"/>
+    <elementParameter field="CHECK" 
name="CHANGE_HASH_AND_EQUALS_FOR_BIGDECIMAL" value="false"/>
     <elementParameter field="TEXT" name="CONNECTION_FORMAT" value="row"/>
     <elementParameter field="CHECK" name="INFORMATION" value="false"/>
     <elementParameter field="MEMO" name="COMMENT" value=""/>
@@ -1484,6 +1488,7 @@
     <elementParameter field="CHECK" name="DIE_ON_ERROR" value="true"/>
     <elementParameter field="CHECK" name="LKUP_PARALLELIZE" value="false"/>
     <elementParameter field="TEXT" name="ROWS_BUFFER_SIZE" value="2000000"/>
+    <elementParameter field="CHECK" 
name="CHANGE_HASH_AND_EQUALS_FOR_BIGDECIMAL" value="false"/>
     <elementParameter field="TEXT" name="CONNECTION_FORMAT" value="row"/>
     <elementParameter field="CHECK" name="INFORMATION" value="false"/>
     <elementParameter field="MEMO" name="COMMENT" value=""/>
@@ -1701,6 +1706,7 @@
     <elementParameter field="CHECK" name="DIE_ON_ERROR" value="true"/>
     <elementParameter field="CHECK" name="LKUP_PARALLELIZE" value="false"/>
     <elementParameter field="TEXT" name="ROWS_BUFFER_SIZE" value="2000000"/>
+    <elementParameter field="CHECK" 
name="CHANGE_HASH_AND_EQUALS_FOR_BIGDECIMAL" value="false"/>
     <elementParameter field="TEXT" name="CONNECTION_FORMAT" value="row"/>
     <elementParameter field="CHECK" name="INFORMATION" value="false"/>
     <elementParameter field="MEMO" name="COMMENT" value=""/>
@@ -1851,6 +1857,7 @@
     <elementParameter field="CHECK" name="DIE_ON_ERROR" value="true"/>
     <elementParameter field="CHECK" name="LKUP_PARALLELIZE" value="false"/>
     <elementParameter field="TEXT" name="ROWS_BUFFER_SIZE" value="2000000"/>
+    <elementParameter field="CHECK" 
name="CHANGE_HASH_AND_EQUALS_FOR_BIGDECIMAL" value="false"/>
     <elementParameter field="TEXT" name="CONNECTION_FORMAT" value="row"/>
     <elementParameter field="CHECK" name="INFORMATION" value="false"/>
     <elementParameter field="MEMO" name="COMMENT" value=""/>
@@ -2100,6 +2107,7 @@
     <elementParameter field="CHECK" name="DIE_ON_ERROR" value="true"/>
     <elementParameter field="CHECK" name="LKUP_PARALLELIZE" value="false"/>
     <elementParameter field="TEXT" name="ROWS_BUFFER_SIZE" value="2000000"/>
+    <elementParameter field="CHECK" 
name="CHANGE_HASH_AND_EQUALS_FOR_BIGDECIMAL" value="false"/>
     <elementParameter field="TEXT" name="CONNECTION_FORMAT" value="row"/>
     <elementParameter field="CHECK" name="INFORMATION" value="false"/>
     <elementParameter field="MEMO" name="COMMENT" value=""/>
@@ -2472,6 +2480,7 @@
     <elementParameter field="CHECK" name="DIE_ON_ERROR" value="true"/>
     <elementParameter field="CHECK" name="LKUP_PARALLELIZE" value="false"/>
     <elementParameter field="TEXT" name="ROWS_BUFFER_SIZE" value="2000000"/>
+    <elementParameter field="CHECK" 
name="CHANGE_HASH_AND_EQUALS_FOR_BIGDECIMAL" value="false"/>
     <elementParameter field="TEXT" name="CONNECTION_FORMAT" value="row"/>
     <elementParameter field="CHECK" name="INFORMATION" value="false"/>
     <elementParameter field="MEMO" name="COMMENT" value=""/>
@@ -2643,6 +2652,7 @@
     <elementParameter field="CHECK" name="DIE_ON_ERROR" value="true"/>
     <elementParameter field="CHECK" name="LKUP_PARALLELIZE" value="false"/>
     <elementParameter field="TEXT" name="ROWS_BUFFER_SIZE" value="2000000"/>
+    <elementParameter field="CHECK" 
name="CHANGE_HASH_AND_EQUALS_FOR_BIGDECIMAL" value="false"/>
     <elementParameter field="TEXT" name="CONNECTION_FORMAT" value="row"/>
     <elementParameter field="CHECK" name="INFORMATION" value="false"/>
     <elementParameter field="MEMO" name="COMMENT" value=""/>
@@ -2811,6 +2821,7 @@
     <elementParameter field="CHECK" name="DIE_ON_ERROR" value="true"/>
     <elementParameter field="CHECK" name="LKUP_PARALLELIZE" value="false"/>
     <elementParameter field="TEXT" name="ROWS_BUFFER_SIZE" value="2000000"/>
+    <elementParameter field="CHECK" 
name="CHANGE_HASH_AND_EQUALS_FOR_BIGDECIMAL" value="false"/>
     <elementParameter field="TEXT" name="CONNECTION_FORMAT" value="row"/>
     <elementParameter field="CHECK" name="INFORMATION" value="false"/>
     <elementParameter field="MEMO" name="COMMENT" value=""/>
@@ -2836,12 +2847,12 @@
       <column comment="" key="false" length="4" 
name="current_host_configuration_version" nullable="true" pattern="" 
precision="0" sourceType="INT4" type="id_Integer" usefulColumn="true"/>
     </metadata>
     <nodeData xsi:type="MapperData">
-      <uiProperties/>
+      <uiProperties shellMaximized="true"/>
       <varTables sizeState="INTERMEDIATE" name="Var" minimized="true"/>
       <outputTables sizeState="INTERMEDIATE" name="complete_aggregation">
         <mapperTableEntries name="history_datetime" 
expression="row14.history_datetime" type="id_Date"/>
         <mapperTableEntries name="user_name" expression="row14.user_name" 
type="id_String" nullable="true"/>
-        <mapperTableEntries name="user_logged_in_to_guest" 
expression="row14.user_logged_in_to_guest > 0" type="id_Boolean" 
nullable="true"/>
+        <mapperTableEntries name="user_logged_in_to_guest" 
expression="row14.user_logged_in_to_guest != null 
?row14.user_logged_in_to_guest > 0 : null" type="id_Boolean" nullable="true"/>
         <mapperTableEntries name="vm_id" expression="row14.vm_id" 
type="id_Object"/>
         <mapperTableEntries name="session_time_in_minutes" 
expression="row14.session_time_in_minutes" type="id_Double"/>
         <mapperTableEntries name="cpu_usage_percent" 
expression="row14.cpu_usage_percent" type="id_Short" nullable="true"/>
diff --git a/tos_project/process/AggregationToHourly_3.4.properties 
b/tos_project/process/AggregationToHourly_3.4.properties
index 6f6fcb8..486a7aa 100644
--- a/tos_project/process/AggregationToHourly_3.4.properties
+++ b/tos_project/process/AggregationToHourly_3.4.properties
@@ -1,6 +1,6 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <xmi:XMI xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI"; 
xmlns:TalendProperties="http://www.talend.org/properties";>
-  <TalendProperties:Property xmi:id="_6qukwEi2EeCv8PaoeAjHHg" 
id="_6qsvkEi2EeCv8PaoeAjHHg" label="AggregationToHourly" 
creationDate="2011-07-06T14:17:18.376+0300" 
modificationDate="2014-01-05T15:08:18.791+0200" version="3.4" statusCode="" 
item="_6qukwki2EeCv8PaoeAjHHg" displayName="AggregationToHourly">
+  <TalendProperties:Property xmi:id="_6qukwEi2EeCv8PaoeAjHHg" 
id="_6qsvkEi2EeCv8PaoeAjHHg" label="AggregationToHourly" 
creationDate="2011-07-06T14:17:18.376+0300" 
modificationDate="2014-01-26T14:08:15.001+0200" version="3.4" statusCode="" 
item="_6qukwki2EeCv8PaoeAjHHg" displayName="AggregationToHourly">
     <author href="../talend.project#_SapC4EJlEeCWRqOtaF5m-w"/>
   </TalendProperties:Property>
   <TalendProperties:ItemState xmi:id="_6qukwUi2EeCv8PaoeAjHHg" path=""/>


-- 
To view, visit http://gerrit.ovirt.org/23709
To unsubscribe, visit http://gerrit.ovirt.org/settings

Gerrit-MessageType: newchange
Gerrit-Change-Id: Ib70d02aaf4d8de4f6f6af6d3ce1b5f511e64c3a8
Gerrit-PatchSet: 1
Gerrit-Project: ovirt-dwh
Gerrit-Branch: master
Gerrit-Owner: Yaniv Dary <yd...@redhat.com>
_______________________________________________
Engine-patches mailing list
Engine-patches@ovirt.org
http://lists.ovirt.org/mailman/listinfo/engine-patches

Reply via email to