Yaniv Dary has uploaded a new change for review. Change subject: history: fixed issue with many ips in vm users table. ......................................................................
history: fixed issue with many ips in vm users table. Change-Id: Ic579a899d6b25785b9bea6c2f77d02bc4517c76c Bug-Url: https://bugzilla.redhat.com/1016968 Signed-off-by: Yaniv Dary <yd...@redhat.com> --- M data-warehouse/history_etl/tos_project/process/AggregationToDaily_3.3.item M data-warehouse/history_etl/tos_project/process/AggregationToDaily_3.3.properties M data-warehouse/history_etl/tos_project/process/AggregationToHourly_3.3.item M data-warehouse/history_etl/tos_project/process/AggregationToHourly_3.3.properties M data-warehouse/history_etl/tos_project/talend.project A data-warehouse/historydbscripts_postgres/upgrade/03_03_0050_changed_users_vm_ip_column_to_text.sql 6 files changed, 18 insertions(+), 15 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-dwh refs/changes/19/20019/1 diff --git a/data-warehouse/history_etl/tos_project/process/AggregationToDaily_3.3.item b/data-warehouse/history_etl/tos_project/process/AggregationToDaily_3.3.item index 2ff2d1a..ac81d78 100644 --- a/data-warehouse/history_etl/tos_project/process/AggregationToDaily_3.3.item +++ b/data-warehouse/history_etl/tos_project/process/AggregationToDaily_3.3.item @@ -2593,7 +2593,7 @@ <column comment="" defaultValue=""0"" key="false" length="2" name="memory_usage_percent" nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" usefulColumn="true"/> <column comment="" defaultValue=""0"" key="false" length="2" name="user_cpu_usage_percent" nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" usefulColumn="true"/> <column comment="" defaultValue=""0"" key="false" length="2" name="system_cpu_usage_percent" nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" usefulColumn="true"/> - <column comment="" key="false" length="255" name="vm_ip" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/> + <column comment="" key="false" name="vm_ip" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/> <column comment="" key="false" length="255" name="vm_client_ip" nullable="true" pattern="" sourceType="" type="id_String" originalLength="255" usefulColumn="true"/> <column comment="" key="false" length="16" name="currently_running_on_host" nullable="true" pattern="" precision="0" sourceType="POINT" type="id_Object" usefulColumn="true"/> <column comment="" key="false" length="4" name="vm_configuration_version" nullable="true" pattern="" precision="0" sourceType="INT4" type="id_Integer" usefulColumn="true"/> @@ -2623,7 +2623,7 @@ <column comment="" defaultValue=""0"" key="false" length="2" name="memory_usage_percent" nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" usefulColumn="true"/> <column comment="" defaultValue=""0"" key="false" length="2" name="user_cpu_usage_percent" nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" usefulColumn="true"/> <column comment="" defaultValue=""0"" key="false" length="2" name="system_cpu_usage_percent" nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" usefulColumn="true"/> - <column comment="" key="false" length="255" name="vm_ip" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/> + <column comment="" key="false" name="vm_ip" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/> <column comment="" key="false" length="255" name="vm_client_ip" nullable="true" pattern="" sourceType="" type="id_String" originalLength="255" usefulColumn="true"/> <column comment="" key="false" length="16" name="currently_running_on_host" nullable="true" pattern="" precision="0" sourceType="POINT" type="id_Object" usefulColumn="true"/> <column comment="" key="false" length="4" name="vm_configuration_version" nullable="true" pattern="" precision="0" sourceType="INT4" type="id_Integer" usefulColumn="true"/> @@ -2761,7 +2761,7 @@ <column comment="" defaultValue=""0"" key="false" length="2" name="max_user_cpu_usage_percent" nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" usefulColumn="true"/> <column comment="" defaultValue=""0"" key="false" length="2" name="system_cpu_usage_percent" nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" usefulColumn="true"/> <column comment="" defaultValue=""0"" key="false" length="2" name="max_system_cpu_usage_percent" nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" usefulColumn="true"/> - <column comment="" key="false" length="255" name="vm_ip" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/> + <column comment="" key="false" name="vm_ip" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/> <column comment="" key="false" length="255" name="vm_client_ip" nullable="true" pattern="" sourceType="" type="id_String" originalLength="255" usefulColumn="true"/> <column comment="" key="false" length="16" name="currently_running_on_host" nullable="true" pattern="" precision="0" sourceType="POINT" type="id_Object" usefulColumn="true"/> <column comment="" key="false" length="4" name="vm_configuration_version" nullable="true" pattern="" precision="0" sourceType="INT4" type="id_Integer" usefulColumn="true"/> @@ -2795,7 +2795,7 @@ <column comment="" defaultValue=""0"" key="false" length="2" name="max_user_cpu_usage_percent" nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" usefulColumn="true"/> <column comment="" defaultValue=""0"" key="false" length="2" name="system_cpu_usage_percent" nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" usefulColumn="true"/> <column comment="" defaultValue=""0"" key="false" length="2" name="max_system_cpu_usage_percent" nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" usefulColumn="true"/> - <column comment="" key="false" length="255" name="vm_ip" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/> + <column comment="" key="false" name="vm_ip" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/> <column comment="" key="false" length="255" name="vm_client_ip" nullable="true" pattern="" sourceType="" type="id_String" originalLength="255" usefulColumn="true"/> <column comment="" key="false" length="16" name="currently_running_on_host" nullable="true" pattern="" precision="0" sourceType="POINT" type="id_Object" usefulColumn="true"/> <column comment="" key="false" length="4" name="vm_configuration_version" nullable="true" pattern="" precision="0" sourceType="INT4" type="id_Integer" usefulColumn="true"/> @@ -2981,7 +2981,7 @@ <column comment="" defaultValue=""0"" key="false" length="2" name="max_user_cpu_usage_percent" nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" usefulColumn="true"/> <column comment="" defaultValue=""0"" key="false" length="2" name="system_cpu_usage_percent" nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" usefulColumn="true"/> <column comment="" defaultValue=""0"" key="false" length="2" name="max_system_cpu_usage_percent" nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" usefulColumn="true"/> - <column comment="" key="false" length="255" name="vm_ip" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/> + <column comment="" key="false" name="vm_ip" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/> <column comment="" key="false" length="255" name="vm_client_ip" nullable="true" pattern="" sourceType="" type="id_String" originalLength="255" usefulColumn="true"/> <column comment="" key="false" length="16" name="currently_running_on_host" nullable="true" pattern="" precision="0" sourceType="POINT" type="id_Object" usefulColumn="true"/> <column comment="" key="false" length="4" name="vm_configuration_version" nullable="true" pattern="" precision="0" sourceType="INT4" type="id_Integer" usefulColumn="true"/> @@ -3001,7 +3001,7 @@ <column comment="" defaultValue=""0"" key="false" length="2" name="max_user_cpu_usage_percent" nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" usefulColumn="true"/> <column comment="" defaultValue=""0"" key="false" length="2" name="system_cpu_usage_percent" nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" usefulColumn="true"/> <column comment="" defaultValue=""0"" key="false" length="2" name="max_system_cpu_usage_percent" nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" usefulColumn="true"/> - <column comment="" key="false" length="255" name="vm_ip" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/> + <column comment="" key="false" name="vm_ip" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/> <column comment="" key="false" length="255" name="vm_client_ip" nullable="true" pattern="" sourceType="" type="id_String" originalLength="255" usefulColumn="true"/> <column comment="" key="false" length="16" name="currently_running_on_host" nullable="true" pattern="" precision="0" sourceType="POINT" type="id_Object" usefulColumn="true"/> <column comment="" key="false" length="4" name="vm_configuration_version" nullable="true" pattern="" precision="0" sourceType="INT4" type="id_Integer" usefulColumn="true"/> diff --git a/data-warehouse/history_etl/tos_project/process/AggregationToDaily_3.3.properties b/data-warehouse/history_etl/tos_project/process/AggregationToDaily_3.3.properties index 0d7baca..6745f37 100644 --- a/data-warehouse/history_etl/tos_project/process/AggregationToDaily_3.3.properties +++ b/data-warehouse/history_etl/tos_project/process/AggregationToDaily_3.3.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="2013-08-11T18:44:31.955+0300" version="3.3" statusCode="" item="_6qukwki2EeCv8PaoeAjHHg" displayName="AggregationToDaily"> + <TalendProperties:Property xmi:id="_6qukwEi2EeCv8PaoeAjHHg" id="_s0iQoFShEeCW44CWrpjEnA" label="AggregationToDaily" creationDate="2011-07-06T14:17:29.833+0300" modificationDate="2013-10-09T13:19:49.383+0300" version="3.3" statusCode="" item="_6qukwki2EeCv8PaoeAjHHg" displayName="AggregationToDaily"> <author href="../talend.project#_SapC4EJlEeCWRqOtaF5m-w"/> </TalendProperties:Property> <TalendProperties:ItemState xmi:id="_s1bogFShEeCW44CWrpjEnA" path=""/> diff --git a/data-warehouse/history_etl/tos_project/process/AggregationToHourly_3.3.item b/data-warehouse/history_etl/tos_project/process/AggregationToHourly_3.3.item index 70edb1c..2bb241b 100644 --- a/data-warehouse/history_etl/tos_project/process/AggregationToHourly_3.3.item +++ b/data-warehouse/history_etl/tos_project/process/AggregationToHourly_3.3.item @@ -2597,7 +2597,7 @@ <column comment="" defaultValue=""0"" key="false" length="2" name="memory_usage_percent" nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" usefulColumn="true"/> <column comment="" defaultValue=""0"" key="false" length="2" name="user_cpu_usage_percent" nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" usefulColumn="true"/> <column comment="" defaultValue=""0"" key="false" length="2" name="system_cpu_usage_percent" nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" usefulColumn="true"/> - <column comment="" key="false" length="255" name="vm_ip" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/> + <column comment="" key="false" name="vm_ip" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/> <column comment="" key="false" length="255" name="vm_client_ip" nullable="true" pattern="" sourceType="" type="id_String" originalLength="255" usefulColumn="true"/> <column comment="" key="false" length="16" name="currently_running_on_host" nullable="true" pattern="" precision="0" sourceType="POINT" type="id_Object" usefulColumn="true"/> <column comment="" key="false" length="4" name="vm_configuration_version" nullable="true" pattern="" precision="0" sourceType="INT4" type="id_Integer" usefulColumn="true"/> @@ -2627,7 +2627,7 @@ <column comment="" defaultValue=""0"" key="false" length="2" name="memory_usage_percent" nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" usefulColumn="true"/> <column comment="" defaultValue=""0"" key="false" length="2" name="user_cpu_usage_percent" nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" usefulColumn="true"/> <column comment="" defaultValue=""0"" key="false" length="2" name="system_cpu_usage_percent" nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" usefulColumn="true"/> - <column comment="" key="false" length="255" name="vm_ip" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/> + <column comment="" key="false" name="vm_ip" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/> <column comment="" key="false" length="255" name="vm_client_ip" nullable="true" pattern="" sourceType="" type="id_String" originalLength="255" usefulColumn="true"/> <column comment="" key="false" length="16" name="currently_running_on_host" nullable="true" pattern="" precision="0" sourceType="POINT" type="id_Object" usefulColumn="true"/> <column comment="" key="false" length="4" name="vm_configuration_version" nullable="true" pattern="" precision="0" sourceType="INT4" type="id_Integer" usefulColumn="true"/> @@ -2765,7 +2765,7 @@ <column comment="" defaultValue=""0"" key="false" length="2" name="max_user_cpu_usage_percent" nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" usefulColumn="true"/> <column comment="" defaultValue=""0"" key="false" length="2" name="system_cpu_usage_percent" nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" usefulColumn="true"/> <column comment="" defaultValue=""0"" key="false" length="2" name="max_system_cpu_usage_percent" nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" usefulColumn="true"/> - <column comment="" key="false" length="255" name="vm_ip" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/> + <column comment="" key="false" name="vm_ip" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/> <column comment="" key="false" length="255" name="vm_client_ip" nullable="true" pattern="" sourceType="" type="id_String" originalLength="255" usefulColumn="true"/> <column comment="" key="false" length="16" name="currently_running_on_host" nullable="true" pattern="" precision="0" sourceType="POINT" type="id_Object" usefulColumn="true"/> <column comment="" key="false" length="4" name="vm_configuration_version" nullable="true" pattern="" precision="0" sourceType="INT4" type="id_Integer" usefulColumn="true"/> @@ -2799,7 +2799,7 @@ <column comment="" defaultValue=""0"" key="false" length="2" name="max_user_cpu_usage_percent" nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" usefulColumn="true"/> <column comment="" defaultValue=""0"" key="false" length="2" name="system_cpu_usage_percent" nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" usefulColumn="true"/> <column comment="" defaultValue=""0"" key="false" length="2" name="max_system_cpu_usage_percent" nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" usefulColumn="true"/> - <column comment="" key="false" length="255" name="vm_ip" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/> + <column comment="" key="false" name="vm_ip" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/> <column comment="" key="false" length="255" name="vm_client_ip" nullable="true" pattern="" sourceType="" type="id_String" originalLength="255" usefulColumn="true"/> <column comment="" key="false" length="16" name="currently_running_on_host" nullable="true" pattern="" precision="0" sourceType="POINT" type="id_Object" usefulColumn="true"/> <column comment="" key="false" length="4" name="vm_configuration_version" nullable="true" pattern="" precision="0" sourceType="INT4" type="id_Integer" usefulColumn="true"/> @@ -2985,7 +2985,7 @@ <column comment="" defaultValue=""0"" key="false" length="2" name="max_user_cpu_usage_percent" nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" usefulColumn="true"/> <column comment="" defaultValue=""0"" key="false" length="2" name="system_cpu_usage_percent" nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" usefulColumn="true"/> <column comment="" defaultValue=""0"" key="false" length="2" name="max_system_cpu_usage_percent" nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" usefulColumn="true"/> - <column comment="" key="false" length="255" name="vm_ip" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/> + <column comment="" key="false" name="vm_ip" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/> <column comment="" key="false" length="255" name="vm_client_ip" nullable="true" pattern="" sourceType="" type="id_String" originalLength="255" usefulColumn="true"/> <column comment="" key="false" length="16" name="currently_running_on_host" nullable="true" pattern="" precision="0" sourceType="POINT" type="id_Object" usefulColumn="true"/> <column comment="" key="false" length="4" name="vm_configuration_version" nullable="true" pattern="" precision="0" sourceType="INT4" type="id_Integer" usefulColumn="true"/> @@ -3005,7 +3005,7 @@ <column comment="" defaultValue=""0"" key="false" length="2" name="max_user_cpu_usage_percent" nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" usefulColumn="true"/> <column comment="" defaultValue=""0"" key="false" length="2" name="system_cpu_usage_percent" nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" usefulColumn="true"/> <column comment="" defaultValue=""0"" key="false" length="2" name="max_system_cpu_usage_percent" nullable="true" pattern="" precision="0" sourceType="INT2" type="id_Short" usefulColumn="true"/> - <column comment="" key="false" length="255" name="vm_ip" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/> + <column comment="" key="false" name="vm_ip" nullable="true" pattern="" precision="0" sourceType="VARCHAR" type="id_String" usefulColumn="true"/> <column comment="" key="false" length="255" name="vm_client_ip" nullable="true" pattern="" sourceType="" type="id_String" originalLength="255" usefulColumn="true"/> <column comment="" key="false" length="16" name="currently_running_on_host" nullable="true" pattern="" precision="0" sourceType="POINT" type="id_Object" usefulColumn="true"/> <column comment="" key="false" length="4" name="vm_configuration_version" nullable="true" pattern="" precision="0" sourceType="INT4" type="id_Integer" usefulColumn="true"/> diff --git a/data-warehouse/history_etl/tos_project/process/AggregationToHourly_3.3.properties b/data-warehouse/history_etl/tos_project/process/AggregationToHourly_3.3.properties index ab72a9b..803b4bd 100644 --- a/data-warehouse/history_etl/tos_project/process/AggregationToHourly_3.3.properties +++ b/data-warehouse/history_etl/tos_project/process/AggregationToHourly_3.3.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="2013-08-11T18:44:00.205+0300" version="3.3" statusCode="" item="_6qukwki2EeCv8PaoeAjHHg" displayName="AggregationToHourly"> + <TalendProperties:Property xmi:id="_6qukwEi2EeCv8PaoeAjHHg" id="_6qsvkEi2EeCv8PaoeAjHHg" label="AggregationToHourly" creationDate="2011-07-06T14:17:18.376+0300" modificationDate="2013-10-09T13:18:38.433+0300" version="3.3" statusCode="" item="_6qukwki2EeCv8PaoeAjHHg" displayName="AggregationToHourly"> <author href="../talend.project#_SapC4EJlEeCWRqOtaF5m-w"/> </TalendProperties:Property> <TalendProperties:ItemState xmi:id="_6qukwUi2EeCv8PaoeAjHHg" path=""/> diff --git a/data-warehouse/history_etl/tos_project/talend.project b/data-warehouse/history_etl/tos_project/talend.project index 274644a..738b08f 100644 --- a/data-warehouse/history_etl/tos_project/talend.project +++ b/data-warehouse/history_etl/tos_project/talend.project @@ -852,7 +852,7 @@ <migrationTask xmi:id="_G1Uu69vkEeKmz4H4vIrR2g" id="org.talend.repository.model.migration.ChangePigVersionOfPigLoadMigrationTask" breaks="5.3.0" version="5.3.0" status="ok"/> <migrationTask xmi:id="_G1VV4NvkEeKmz4H4vIrR2g" id="org.talend.repository.model.migration.ChangeHadoopVersionsOfReferenceComponentsMigrationTask" breaks="5.3.0" version="5.3.0" status="ok"/> <migrationTask xmi:id="_G1VV4dvkEeKmz4H4vIrR2g" id="org.talend.repository.model.migration.AutoUpdateRelationsMigrationTask" breaks="5.1.1" version="5.1.2" status="ok"/> - <migrationTask xmi:id="_rXKqASnWEeORcf7J-W1A5w" id="org.talend.repository.model.migration.UpdateExistentMigrationTasksToAdaptNewMigrationSystemMigrationTask" breaks="5.1.1" version="5.1.2" status="ok"/> + <migrationTask xmi:id="_BgGgoTAlEeOuzJh2oQvweg" id="org.talend.repository.model.migration.UpdateExistentMigrationTasksToAdaptNewMigrationSystemMigrationTask" breaks="5.1.1" version="5.1.2" status="ok"/> </TalendProperties:Project> <TalendProperties:User xmi:id="_SapC4EJlEeCWRqOtaF5m-w" login="yd...@redhat.com" password="D41D8CD98F00B204E9800998ECF8427E"/> <TalendProperties:User xmi:id="_9rn8MCu-EeGwyfNuL-eF9g" login="t...@talend.com" password="D41D8CD98F00B204E9800998ECF8427E"/> diff --git a/data-warehouse/historydbscripts_postgres/upgrade/03_03_0050_changed_users_vm_ip_column_to_text.sql b/data-warehouse/historydbscripts_postgres/upgrade/03_03_0050_changed_users_vm_ip_column_to_text.sql new file mode 100644 index 0000000..7deea53 --- /dev/null +++ b/data-warehouse/historydbscripts_postgres/upgrade/03_03_0050_changed_users_vm_ip_column_to_text.sql @@ -0,0 +1,3 @@ +-- Changed vm_ip type to text to allow match engine and allow more then 18 ip per vm +ALTER TABLE statistics_vms_users_usage_daily ALTER COLUMN vm_ip TYPE text; +ALTER TABLE statistics_vms_users_usage_hourly ALTER COLUMN vm_ip TYPE text; -- To view, visit http://gerrit.ovirt.org/20019 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Ic579a899d6b25785b9bea6c2f77d02bc4517c76c 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
