You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@madlib.apache.org by ri...@apache.org on 2017/03/13 20:57:59 UTC
[37/50] [abbrv] incubator-madlib git commit: Release v1.10:
http://git-wip-us.apache.org/repos/asf/incubator-madlib/blob/90f4dc15/src/madpack/changelist_1.7_1.9.1.yaml
----------------------------------------------------------------------
diff --git a/src/madpack/changelist_1.7_1.9.1.yaml b/src/madpack/changelist_1.7_1.9.1.yaml
deleted file mode 100644
index 0134607..0000000
--- a/src/madpack/changelist_1.7_1.9.1.yaml
+++ /dev/null
@@ -1,836 +0,0 @@
-# Changelist for MADlib version 1.7 to 1.7.1
-
-# This file contains all changes that were introduced in a new version of
-# MADlib. This changelist is used by the upgrade script to detect what objects
-# should be upgraded (while retaining all other objects from the previous version)
-
-# New modules (actually .sql_in files) added in upgrade version
-# For these files the sql_in code is retained as is with the functions in the
-# file installed on the upgrade version. All other files (that don't have
-# updates), are cleaned up to remove object replacements
-new module:
- # ----------------- Changes from 1.7 to 1.7.1 ----------
- # ----------------- Changes from 1.7.1 to 1.8 ----------
- text_utilities:
-
-# Changes in the types (UDT) including removal and modification
-udt:
-
- # ----------------- Changes from 1.7 to 1.7.1 ----------
- # ----------------- Changes from 1.8 to 1.9 ----------
- __enc_tbl_result:
- __gen_acc_time:
- __rep_type:
- __train_result:
- c45_classify_result:
- c45_train_result:
- correlation_result:
- lsvm_sgd_model_rec:
- lsvm_sgd_result:
- rf_classify_result:
- rf_train_result:
- svm_cls_result:
- svm_model_pr:
- svm_model_rec:
- svm_nd_result:
- svm_reg_result:
- svm_support_vector:
- _prune_result_type:
- _tree_result_type:
- linear_svm_result:
- # ----------------- Changes from 1.9 to 1.9.1 ----------
- profile_result:
-
-# List of the UDF changes that affect the user externally. This includes change
-# in function name, return type, argument order or types, or removal of
-# the function. In each case, the original function is as good as removed and a
-# new function is created. In such cases, we should abort the upgrade if there
-# are user views dependent on this function, since the original function will
-# not be present in the upgraded version.
-udf:
- # ----------------- Changes from 1.7 to 1.7.1 ----------
- - discrete_distribution_merge: # replaced by array_add
- rettype: double precision[]
- argument: double precision[], double precision[]
- - _compute_leaf_stats_transition:
- rettype: schema_madlib.bytea8
- argument: schema_madlib.bytea8, schema_madlib.bytea8, integer[], double precision[], double precision, double precision, integer[], schema_madlib.bytea8, smallint
- - _compute_surr_stats_transition:
- rettype: schema_madlib.bytea8
- argument: schema_madlib.bytea8, schema_madlib.bytea8, integer[], double precision[], integer[], schema_madlib.bytea8
- # ----------------- Changes from 1.7.1 to 1.8 ----------
- - __filter_input_relation:
- rettype: character varying
- argument: character varying, character varying
- - __lda_util_unnest:
- rettype: SETOF bigint[]
- argument: bigint[]
- - matrix_block_mult:
- rettype: schema_madlib.matrix_result
- argument: text, text, text
- - matrix_block_square:
- rettype: schema_madlib.matrix_result
- argument: text, text
- - matrix_block_trans:
- rettype: schema_madlib.matrix_result
- argument: text, text
- - matrix_block_trans:
- rettype: schema_madlib.matrix_result
- argument: text, text, boolean
- - matrix_blockize:
- rettype: schema_madlib.matrix_result
- argument: text, integer, integer, text
- - matrix_densify:
- rettype: schema_madlib.matrix_result
- argument: text, text, text, text, text, boolean
- - matrix_mult:
- rettype: schema_madlib.matrix_result
- argument: text, boolean, text, boolean, text
- - matrix_mult:
- rettype: schema_madlib.matrix_result
- argument: text, text, text, text, boolean, text, text, text, text, boolean, text
- - matrix_norm:
- rettype: double precision
- argument: text
- - matrix_scale_and_add:
- rettype: void
- argument: text, text, double precision, text
- - matrix_sparsify:
- rettype: schema_madlib.matrix_result
- argument: text, text, boolean
- - matrix_square:
- rettype: schema_madlib.matrix_result
- argument: text, text
- - matrix_trans:
- rettype: schema_madlib.matrix_result
- argument: text, text, boolean
- - matrix_trans:
- rettype: schema_madlib.matrix_result
- argument: text, text, text, text, text, boolean
- - matrix_unblockize:
- rettype: schema_madlib.matrix_result
- argument: text, text
- # ----------------- Changes from 1.8 to 1.9 ----------
-
- - _dt_apply:
- rettype: schema_madlib._tree_result_type
- argument: schema_madlib.bytea8,schema_madlib.bytea8,schema_madlib.bytea8,smallint,smallint,smallint,boolean,integer
-
- - internal_linear_svm_igd_result:
- rettype: schema_madlib.linear_svm_result
- argument: double precision[]
-
- - _prune_and_cplist:
- rettype: schema_madlib._prune_result_type
- argument: schema_madlib.bytea8,double precision,boolean
-
- - __array_elem_in:
- rettype: boolean[]
- argument: anyarray, anyarray
-
- - __array_indexed_agg_ffunc:
- rettype: double precision[]
- argument: double precision[]
-
- - __array_indexed_agg_prefunc:
- rettype: double precision[]
- argument: double precision[], double precision[]
-
- - __array_indexed_agg_sfunc:
- rettype: double precision[]
- argument: double precision[], double precision, bigint, bigint
-
- - __array_search:
- rettype: boolean
- argument: anyelement, anyarray
-
- - __array_sort:
- rettype: anyarray
- argument: anyarray
-
- - __assert:
- rettype: void
- argument: boolean, text
-
- - __assert_table:
- rettype: void
- argument: text, boolean
-
- - __best_scv_prefunc:
- rettype: double precision[]
- argument: double precision[], double precision[]
-
- - __best_scv_sfunc:
- rettype: double precision[]
- argument: double precision[], double precision[], integer, double precision
-
- - __bigint_array_add:
- rettype: bigint[]
- argument: bigint[], bigint[]
-
- - __breakup_table:
- rettype: void
- argument: text, text, text, text, text, text[], boolean[], integer, integer
-
- - __check_dt_common_params:
- rettype: void
- argument: text, text, text, text, text, text, text, text, integer, double precision, double precision, integer, text
-
- - __check_training_table:
- rettype: void
- argument: text, text[], text[], text, text, integer
-
- - __column_exists:
- rettype: boolean
- argument: text, text
-
- - __columns_in_table:
- rettype: boolean
- argument: text[], text
-
- - __create_metatable:
- rettype: void
- argument: text
-
- - __create_tree_tables:
- rettype: void
- argument: text
-
- - __csvstr_to_array:
- rettype: text[]
- argument: text
-
- - __display_node_sfunc:
- rettype: text
- argument: text, integer, boolean, text, text, double precision, double precision, text, integer
-
- - __display_tree_no_ordered_aggr:
- rettype: text
- argument: text, integer, integer, integer, boolean, double precision, text, integer, integer
-
- - __distinct_feature_value:
- rettype: integer
- argument: text, integer
-
- - __drop_metatable:
- rettype: void
- argument: text
-
- - __dt_acc_count_sfunc:
- rettype: bigint[]
- argument: bigint[], integer, bigint, integer
-
- - __dt_get_node_split_fids:
- rettype: integer[]
- argument: integer, integer, integer, integer[]
-
- - __ebp_calc_errors:
- rettype: double precision
- argument: double precision, double precision, double precision
-
- - __ebp_prune_tree:
- rettype: void
- argument: text
-
- - __encode_and_train:
- rettype: record
- argument: text, text, integer, integer, text, text, text, text, text, text, text, double precision, text, integer, double precision, boolean, double precision, double precision, text, integer
-
- - __encode_columns:
- rettype: void
- argument: text, text, integer, integer
-
- - __encode_table:
- rettype: void
- argument: text, text, text, integer, integer
-
- - __encode_table:
- rettype: void
- argument: text, text, text[], text, text[], text, text, integer, integer
-
- - __find_best_split:
- rettype: void
- argument: text, double precision, text, integer, integer, text, integer, integer
-
- - __format:
- rettype: text
- argument: text, text
-
- - __format:
- rettype: text
- argument: text, text, text
-
- - __format:
- rettype: text
- argument: text, text, text, text
-
- - __format:
- rettype: text
- argument: text, text, text, text, text
-
- - __format:
- rettype: text
- argument: text, text[]
-
- - __gen_acc:
- rettype: __gen_acc_time
- argument: text, text, text, text, text, integer, integer, boolean, integer
-
- - __gen_enc_meta_names:
- rettype: text[]
- argument: text, text
-
- - __gen_horizontal_encoded_table:
- rettype: void
- argument: text, text, integer, integer
-
- - __gen_vertical_encoded_table:
- rettype: void
- argument: text, text, text, boolean, integer
-
- - __generate_final_tree:
- rettype: void
- argument: text
-
- - __get_class_column_name:
- rettype: text
- argument: text
-
- - __get_class_value:
- rettype: text
- argument: integer, text
-
- - __get_classtable_name:
- rettype: text
- argument: text
-
- - __get_column_value:
- rettype: text
- argument: integer, integer, character, text
-
- - __get_feature_name:
- rettype: text
- argument: integer, text
-
- - __get_feature_value:
- rettype: text
- argument: integer, integer, text
-
- - __get_features_of_nodes:
- rettype: text
- argument: text, text, integer, integer, integer
-
- - __get_id_column_name:
- rettype: text
- argument: text
-
- - __get_schema_name:
- rettype: text
- argument: text
-
- - __get_table_name:
- rettype: text
- argument: text
-
- - __insert_into_metatable:
- rettype: void
- argument: text, integer, text, character, boolean, text, integer
-
- - __is_valid_enc_table:
- rettype: boolean
- argument: text
-
- - __num_of_class:
- rettype: integer
- argument: text
-
- - __num_of_columns:
- rettype: integer
- argument: text
-
- - __num_of_feature:
- rettype: integer
- argument: text
-
- - __regclass_to_text:
- rettype: text
- argument: regclass
-
- - __rename_table:
- rettype: void
- argument: text, text
-
- - __rep_aggr_class_count_ffunc:
- rettype: bigint[]
- argument: bigint[]
-
- - __rep_aggr_class_count_sfunc:
- rettype: bigint[]
- argument: bigint[], integer, integer, integer
-
- - __rep_prune_tree:
- rettype: void
- argument: text, text, integer
-
- - __sample_with_replacement:
- rettype: void
- argument: integer, bigint, text, text
-
- - __sample_within_range:
- rettype: SETOF bigint
- argument: bigint, bigint, bigint
-
- - __scv_aggr_ffunc:
- rettype: double precision[]
- argument: double precision[]
-
- - __scv_aggr_prefunc:
- rettype: double precision[]
- argument: double precision[], double precision[]
-
- - __scv_aggr_sfunc:
- rettype: double precision[]
- argument: double precision[], integer, boolean, integer, double precision[], double precision[], bigint
-
- - __strip_schema_name:
- rettype: text
- argument: text
-
- - __svm_random_ind2:
- rettype: double precision[]
- argument: integer
-
- - __svm_random_ind:
- rettype: double precision[]
- argument: integer
-
- - __svm_target_cl_func:
- rettype: double precision
- argument: double precision[]
-
- - __svm_target_reg_func:
- rettype: double precision
- argument: double precision[]
-
- - __table_exists:
- rettype: boolean
- argument: text
-
- - __train_tree:
- rettype: __train_result
- argument: text, integer, integer, text, text, text, text, text, text, double precision, integer, double precision, double precision, double precision, boolean, integer, integer
-
- - __treemodel_classify_internal:
- rettype: text[]
- argument: text, text, integer
-
- - __treemodel_classify_internal_serial:
- rettype: text[]
- argument: text, text, integer
-
- - __treemodel_display_no_ordered_aggr:
- rettype: SETOF text
- argument: text, integer[], integer
-
- - __treemodel_display_with_ordered_aggr:
- rettype: SETOF text
- argument: text, integer[], integer
-
- - __treemodel_get_vote_result:
- rettype: void
- argument: text, text
-
- - __treemodel_score:
- rettype: double precision
- argument: text, text, integer
-
- - __validate_input_table:
- rettype: void
- argument: text, text[], text, text
-
- - __validate_metatable:
- rettype: void
- argument: text
-
- - c45_classify:
- rettype: c45_classify_result
- argument: text, text, text
-
- - c45_classify:
- rettype: c45_classify_result
- argument: text, text, text, integer
-
- - c45_clean:
- rettype: boolean
- argument: text
-
- - c45_display:
- rettype: SETOF text
- argument: text
-
- - c45_display:
- rettype: SETOF text
- argument: text, integer
-
- - c45_genrule:
- rettype: SETOF text
- argument: text
-
- - c45_genrule:
- rettype: SETOF text
- argument: text, integer
-
- - c45_score:
- rettype: double precision
- argument: text, text
-
- - c45_score:
- rettype: double precision
- argument: text, text, integer
-
- - c45_train:
- rettype: c45_train_result
- argument: text, text, text
-
- - c45_train:
- rettype: c45_train_result
- argument: text, text, text, text, text, text, text, text, double precision, text
-
- - c45_train:
- rettype: c45_train_result
- argument: text, text, text, text, text, text, text, text, double precision, text, integer, double precision, double precision, integer
-
- - correlation:
- rettype: correlation_result
- argument: character varying, character varying
-
- - correlation:
- rettype: correlation_result
- argument: character varying, character varying, character varying
-
- - correlation:
- rettype: correlation_result
- argument: character varying, character varying, character varying, boolean
-
- - linear_svm_igd_transition:
- rettype: double precision[]
- argument: double precision[], double precision[], boolean, double precision[], integer, double precision, double precision
-
- - lsvm_classification:
- rettype: SETOF lsvm_sgd_result
- argument: text, text
-
- - lsvm_classification:
- rettype: SETOF lsvm_sgd_result
- argument: text, text, boolean
-
- - lsvm_classification:
- rettype: SETOF lsvm_sgd_result
- argument: text, text, boolean, boolean, double precision, double precision
-
- - lsvm_classification:
- rettype: SETOF lsvm_sgd_result
- argument: text, text, boolean, boolean, double precision, double precision, integer
-
- - lsvm_predict:
- rettype: double precision
- argument: double precision[], double precision[]
-
- - lsvm_predict_batch:
- rettype: text
- argument: text, text, text, text, text
-
- - lsvm_predict_batch:
- rettype: text
- argument: text, text, text, text, text, boolean
-
- - matrix_block_trans:
- rettype: matrix_result
- argument: text, text, text, text, boolean
-
- - matrix_densify:
- rettype: matrix_result
- argument: text, text, text, text, boolean
-
- - matrix_sparsify:
- rettype: matrix_result
- argument: text, text, text, text, boolean
-
- - matrix_trans:
- rettype: matrix_result
- argument: text, text, text, text, boolean
-
- - rf_classify:
- rettype: rf_classify_result
- argument: text, text, text
-
- - rf_classify:
- rettype: rf_classify_result
- argument: text, text, text, boolean, integer
-
- - rf_classify:
- rettype: rf_classify_result
- argument: text, text, text, integer
-
- - rf_clean:
- rettype: boolean
- argument: text
-
- - rf_display:
- rettype: SETOF text
- argument: text
-
- - rf_display:
- rettype: SETOF text
- argument: text, integer[]
-
- - rf_display:
- rettype: SETOF text
- argument: text, integer[], integer
-
- - rf_score:
- rettype: double precision
- argument: text, text
-
- - rf_score:
- rettype: double precision
- argument: text, text, integer
-
- - rf_train:
- rettype: rf_train_result
- argument: text, text, text
-
- - rf_train:
- rettype: rf_train_result
- argument: text, text, text, integer, integer, double precision, text, text, text, text, text, integer, double precision, double precision, integer
-
- - svdmf_run:
- rettype: text
- argument: text, text, text, text, integer
-
- - svdmf_run:
- rettype: text
- argument: text, text, text, text, integer, integer, double precision
-
- - svm_classification:
- rettype: SETOF svm_cls_result
- argument: text, text, boolean, text
-
- - svm_classification:
- rettype: SETOF svm_cls_result
- argument: text, text, boolean, text, boolean, double precision, double precision
-
- - svm_classification:
- rettype: SETOF svm_cls_result
- argument: text, text, boolean, text, boolean, double precision, double precision, double precision
-
- - svm_classification:
- rettype: SETOF svm_cls_result
- argument: text, text, boolean, text, double precision
-
- - svm_cls_update:
- rettype: schema_madlib.svm_model_rec
- argument: schema_madlib.svm_model_rec, double precision[], double precision, text, double precision, double precision, double precision
-
- - svm_data_normalization:
- rettype: void
- argument: text
-
- - svm_dot:
- rettype: double precision
- argument: double precision[], double precision[]
-
- - svm_dot:
- rettype: double precision
- argument: double precision[], double precision[], double precision
-
- - svm_drop_model:
- rettype: void
- argument: text
-
- - svm_gaussian:
- rettype: double precision
- argument: double precision[], double precision[], double precision
-
- - svm_generate_cls_data:
- rettype: void
- argument: text, integer, integer
-
- - svm_generate_nd_data:
- rettype: void
- argument: text, integer, integer
-
- - svm_generate_reg_data:
- rettype: void
- argument: text, integer, integer
-
- - svm_nd_update:
- rettype: schema_madlib.svm_model_rec
- argument: schema_madlib.svm_model_rec, double precision[], text, double precision, double precision, double precision
-
- - svm_novelty_detection:
- rettype: SETOF schema_madlib.svm_nd_result
- argument: text, text, boolean, text
-
- - svm_novelty_detection:
- rettype: SETOF schema_madlib.svm_nd_result
- argument: text, text, boolean, text, boolean, double precision, double precision
-
- - svm_novelty_detection:
- rettype: SETOF schema_madlib.svm_nd_result
- argument: text, text, boolean, text, boolean, double precision, double precision, double precision
-
- - svm_polynomial:
- rettype: double precision
- argument: double precision[], double precision[], double precision
-
- - svm_predict:
- rettype: double precision
- argument: schema_madlib.svm_model_rec, double precision[], text, double precision
-
- - svm_predict_batch:
- rettype: text
- argument: text, text, text, text, text, boolean
-
- - svm_predict_sub:
- rettype: double precision
- argument: integer, integer, double precision[], double precision[], double precision[], text, double precision
-
- - svm_reg_update:
- rettype: schema_madlib.svm_model_rec
- argument: schema_madlib.svm_model_rec, double precision[], double precision, text, double precision, double precision, double precision, double precision
-
- - svm_regression:
- rettype: SETOF svm_reg_result
- argument: text, text, boolean, text
-
- - svm_regression:
- rettype: SETOF svm_reg_result
- argument: text, text, boolean, text, boolean, double precision, double precision, double precision
-
- - svm_regression:
- rettype: SETOF svm_reg_result
- argument: text, text, boolean, text, boolean, double precision, double precision, double precision, double precision
-
- - svm_store_model:
- rettype: void
- argument: text, text, text
-
- # ----------------- Changes from 1.9 to 1.9.1 ----------
- - array_collapse:
- rettype: anyarray
- argument: anyarray
- - linear_svm_igd_transition:
- rettype: double precision[]
- argument: double precision[], double precision[], double precision, double precision[], integer, double precision, double precision, boolean, integer, double precision, boolean
- - profile:
- rettype: SETOF schema_madlib.profile_result
- argument: text
- - profile_full:
- rettype: SETOF schema_madlib.profile_result
- argument: text, integer
- - profile:
- rettype: schema_madlib.profile_result
- argument: text
- - profile_full:
- rettype: schema_madlib.profile_result
- argument: text, integer
- - quantile:
- rettype: double precision
- argument: text, text, double precision
- - quantile_big:
- rettype: double precision
- argument: text, text, double precision
-
-# Changes to aggregates (UDA) including removal and modification
-# Overloaded functions should be mentioned separately
-uda:
- # ----------------- Changes from 1.7 to 1.7.1 ----------
- - discrete_distribution_agg: # merge function replaced
- rettype: double precision[]
- argument: integer, double precision, integer
- - _compute_leaf_stats: # dup_count added
- rettype: schema_madlib.bytea8
- argument: schema_madlib.bytea8, integer[], double precision[], double precision, double precision, integer[], schema_madlib.bytea8, smallint
- - _compute_surr_stats: # dup_count added
- rettype: schema_madlib.bytea8
- argument: schema_madlib.bytea8, integer[], double precision[], integer[], schema_madlib.bytea8
- # ----------------- Changes from 1.7.1 to 1.8 ----------
- - discrete_distribution_agg:
- rettype: double precision[]
- argument: integer, double precision, integer
- - vectorized_distribution_agg:
- rettype: double precision[]
- argument: integer[], integer[]
- # ----------------- Changes from 1.8 to 1.9 ----------
-
- - __array_indexed_agg:
- rettype: double precision[]
- argument: double precision, bigint, bigint
-
- - __best_scv_aggr:
- rettype: double precision[]
- argument: double precision[], integer, double precision
-
- - __bigint_array_sum:
- rettype: bigint[]
- argument: bigint[]
-
- - __display_tree_aggr:
- rettype: text
- argument: integer, boolean, text, text, double precision, double precision, text, integer
-
- - __dt_acc_count_aggr:
- rettype: bigint[]
- argument: integer, bigint, integer
-
- - __rep_aggr_class_count:
- rettype: bigint[]
- argument: integer, integer, integer
-
- - __scv_aggr:
- rettype: double precision[]
- argument: integer, boolean, integer, double precision[], double precision[], bigint
-
- - linear_svm_igd_step:
- rettype: double precision[]
- argument: double precision[], boolean, double precision[], integer, double precision, double precision
-
- - linear_svm_igd_step_serial:
- rettype: double precision[]
- argument: double precision[], boolean, double precision[], integer, double precision, double precision
-
- - svm_cls_agg:
- rettype: schema_madlib.svm_model_rec
- argument: double precision[], double precision, text, double precision, double precision, double precision
-
- - svm_nd_agg:
- rettype: schema_madlib.svm_model_rec
- argument: double precision[], text, double precision, double precision, double precision
-
- - svm_reg_agg:
- rettype: schema_madlib.svm_model_rec
- argument: double precision[], double precision, text, double precision, double precision, double precision, double precision
-
- - __svm_random_ind2:
- rettype: double precision[]
- argument: integer
- # ----------------- Changes from 1.9 to 1.9.1 ----------
- - array_agg:
- rettype: anyarray
- argument: anyelement
- - linear_svm_igd_step:
- rettype: double precision[]
- argument: double precision[], double precision, double precision[], integer, double precision, double precision, boolean, integer, double precision, boolean
-
-# Casts (UDC) updated/removed
-udc:
- # ----------------- Changes from 1.7 to 1.7.1 ----------
-
-# Operators (UDO) removed/updated
-udo:
- # ----------------- Changes from 1.7 to 1.7.1 ----------
-
-# Operator Classes (UDOC) removed/updated
-udoc:
- # ----------------- Changes from 1.7 to 1.7.1 ----------
http://git-wip-us.apache.org/repos/asf/incubator-madlib/blob/90f4dc15/src/madpack/changelist_1.8_1.10.yaml
----------------------------------------------------------------------
diff --git a/src/madpack/changelist_1.8_1.10.yaml b/src/madpack/changelist_1.8_1.10.yaml
new file mode 100644
index 0000000..d85877b
--- /dev/null
+++ b/src/madpack/changelist_1.8_1.10.yaml
@@ -0,0 +1,857 @@
+# ------------------------------------------------------------------------------
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+# ------------------------------------------------------------------------------
+
+# Changelist for MADlib version 1.8 to 1.10
+
+# This file contains all changes that were introduced in a new version of
+# MADlib. This changelist is used by the upgrade script to detect what objects
+# should be upgraded (while retaining all other objects from the previous version)
+
+# New modules (actually .sql_in files) added in upgrade version
+# For these files the sql_in code is retained as is with the functions in the
+# file installed on the upgrade version. All other files (that don't have
+# updates), are cleaned up to remove object replacements
+new module:
+ # ----------------- Changes from 1.9.1 to 1.0 ----------
+ sssp:
+ encode_categorical:
+ knn:
+
+# Changes in the types (UDT) including removal and modification
+udt:
+
+ # ----------------- Changes from 1.8 to 1.9 ----------
+ __enc_tbl_result:
+ __gen_acc_time:
+ __rep_type:
+ __train_result:
+ c45_classify_result:
+ c45_train_result:
+ correlation_result:
+ lsvm_sgd_model_rec:
+ lsvm_sgd_result:
+ rf_classify_result:
+ rf_train_result:
+ svm_cls_result:
+ svm_model_pr:
+ svm_model_rec:
+ svm_nd_result:
+ svm_reg_result:
+ svm_support_vector:
+ _prune_result_type:
+ _tree_result_type:
+ linear_svm_result:
+ # ----------------- Changes from 1.9 to 1.9.1 ----------
+ profile_result:
+ # ----------------- Changes from 1.9.1 to 1.0 ----------
+ _tree_result_type:
+ _prune_result_type:
+ kmeans_result:
+ kmeans_state:
+
+# List of the UDF changes that affect the user externally. This includes change
+# in function name, return type, argument order or types, or removal of
+# the function. In each case, the original function is as good as removed and a
+# new function is created. In such cases, we should abort the upgrade if there
+# are user views dependent on this function, since the original function will
+# not be present in the upgraded version.
+udf:
+
+ # ----------------- Changes from 1.8 to 1.9 ----------
+ - _dt_apply:
+ rettype: schema_madlib._tree_result_type
+ argument: schema_madlib.bytea8,schema_madlib.bytea8,schema_madlib.bytea8,smallint,smallint,smallint,boolean,integer
+
+ - internal_linear_svm_igd_result:
+ rettype: schema_madlib.linear_svm_result
+ argument: double precision[]
+
+ - _prune_and_cplist:
+ rettype: schema_madlib._prune_result_type
+ argument: schema_madlib.bytea8,double precision,boolean
+
+ - __array_elem_in:
+ rettype: boolean[]
+ argument: anyarray, anyarray
+
+ - __array_indexed_agg_ffunc:
+ rettype: double precision[]
+ argument: double precision[]
+
+ - __array_indexed_agg_prefunc:
+ rettype: double precision[]
+ argument: double precision[], double precision[]
+
+ - __array_indexed_agg_sfunc:
+ rettype: double precision[]
+ argument: double precision[], double precision, bigint, bigint
+
+ - __array_search:
+ rettype: boolean
+ argument: anyelement, anyarray
+
+ - __array_sort:
+ rettype: anyarray
+ argument: anyarray
+
+ - __assert:
+ rettype: void
+ argument: boolean, text
+
+ - __assert_table:
+ rettype: void
+ argument: text, boolean
+
+ - __best_scv_prefunc:
+ rettype: double precision[]
+ argument: double precision[], double precision[]
+
+ - __best_scv_sfunc:
+ rettype: double precision[]
+ argument: double precision[], double precision[], integer, double precision
+
+ - __bigint_array_add:
+ rettype: bigint[]
+ argument: bigint[], bigint[]
+
+ - __breakup_table:
+ rettype: void
+ argument: text, text, text, text, text, text[], boolean[], integer, integer
+
+ - __check_dt_common_params:
+ rettype: void
+ argument: text, text, text, text, text, text, text, text, integer, double precision, double precision, integer, text
+
+ - __check_training_table:
+ rettype: void
+ argument: text, text[], text[], text, text, integer
+
+ - __column_exists:
+ rettype: boolean
+ argument: text, text
+
+ - __columns_in_table:
+ rettype: boolean
+ argument: text[], text
+
+ - __create_metatable:
+ rettype: void
+ argument: text
+
+ - __create_tree_tables:
+ rettype: void
+ argument: text
+
+ - __csvstr_to_array:
+ rettype: text[]
+ argument: text
+
+ - __display_node_sfunc:
+ rettype: text
+ argument: text, integer, boolean, text, text, double precision, double precision, text, integer
+
+ - __display_tree_no_ordered_aggr:
+ rettype: text
+ argument: text, integer, integer, integer, boolean, double precision, text, integer, integer
+
+ - __distinct_feature_value:
+ rettype: integer
+ argument: text, integer
+
+ - __drop_metatable:
+ rettype: void
+ argument: text
+
+ - __dt_acc_count_sfunc:
+ rettype: bigint[]
+ argument: bigint[], integer, bigint, integer
+
+ - __dt_get_node_split_fids:
+ rettype: integer[]
+ argument: integer, integer, integer, integer[]
+
+ - __ebp_calc_errors:
+ rettype: double precision
+ argument: double precision, double precision, double precision
+
+ - __ebp_prune_tree:
+ rettype: void
+ argument: text
+
+ - __encode_and_train:
+ rettype: record
+ argument: text, text, integer, integer, text, text, text, text, text, text, text, double precision, text, integer, double precision, boolean, double precision, double precision, text, integer
+
+ - __encode_columns:
+ rettype: void
+ argument: text, text, integer, integer
+
+ - __encode_table:
+ rettype: void
+ argument: text, text, text, integer, integer
+
+ - __encode_table:
+ rettype: void
+ argument: text, text, text[], text, text[], text, text, integer, integer
+
+ - __find_best_split:
+ rettype: void
+ argument: text, double precision, text, integer, integer, text, integer, integer
+
+ - __format:
+ rettype: text
+ argument: text, text
+
+ - __format:
+ rettype: text
+ argument: text, text, text
+
+ - __format:
+ rettype: text
+ argument: text, text, text, text
+
+ - __format:
+ rettype: text
+ argument: text, text, text, text, text
+
+ - __format:
+ rettype: text
+ argument: text, text[]
+
+ - __gen_acc:
+ rettype: __gen_acc_time
+ argument: text, text, text, text, text, integer, integer, boolean, integer
+
+ - __gen_enc_meta_names:
+ rettype: text[]
+ argument: text, text
+
+ - __gen_horizontal_encoded_table:
+ rettype: void
+ argument: text, text, integer, integer
+
+ - __gen_vertical_encoded_table:
+ rettype: void
+ argument: text, text, text, boolean, integer
+
+ - __generate_final_tree:
+ rettype: void
+ argument: text
+
+ - __get_class_column_name:
+ rettype: text
+ argument: text
+
+ - __get_class_value:
+ rettype: text
+ argument: integer, text
+
+ - __get_classtable_name:
+ rettype: text
+ argument: text
+
+ - __get_column_value:
+ rettype: text
+ argument: integer, integer, character, text
+
+ - __get_feature_name:
+ rettype: text
+ argument: integer, text
+
+ - __get_feature_value:
+ rettype: text
+ argument: integer, integer, text
+
+ - __get_features_of_nodes:
+ rettype: text
+ argument: text, text, integer, integer, integer
+
+ - __get_id_column_name:
+ rettype: text
+ argument: text
+
+ - __get_schema_name:
+ rettype: text
+ argument: text
+
+ - __get_table_name:
+ rettype: text
+ argument: text
+
+ - __insert_into_metatable:
+ rettype: void
+ argument: text, integer, text, character, boolean, text, integer
+
+ - __is_valid_enc_table:
+ rettype: boolean
+ argument: text
+
+ - __num_of_class:
+ rettype: integer
+ argument: text
+
+ - __num_of_columns:
+ rettype: integer
+ argument: text
+
+ - __num_of_feature:
+ rettype: integer
+ argument: text
+
+ - __regclass_to_text:
+ rettype: text
+ argument: regclass
+
+ - __rename_table:
+ rettype: void
+ argument: text, text
+
+ - __rep_aggr_class_count_ffunc:
+ rettype: bigint[]
+ argument: bigint[]
+
+ - __rep_aggr_class_count_sfunc:
+ rettype: bigint[]
+ argument: bigint[], integer, integer, integer
+
+ - __rep_prune_tree:
+ rettype: void
+ argument: text, text, integer
+
+ - __sample_with_replacement:
+ rettype: void
+ argument: integer, bigint, text, text
+
+ - __sample_within_range:
+ rettype: SETOF bigint
+ argument: bigint, bigint, bigint
+
+ - __scv_aggr_ffunc:
+ rettype: double precision[]
+ argument: double precision[]
+
+ - __scv_aggr_prefunc:
+ rettype: double precision[]
+ argument: double precision[], double precision[]
+
+ - __scv_aggr_sfunc:
+ rettype: double precision[]
+ argument: double precision[], integer, boolean, integer, double precision[], double precision[], bigint
+
+ - __strip_schema_name:
+ rettype: text
+ argument: text
+
+ - __svm_random_ind2:
+ rettype: double precision[]
+ argument: integer
+
+ - __svm_random_ind:
+ rettype: double precision[]
+ argument: integer
+
+ - __svm_target_cl_func:
+ rettype: double precision
+ argument: double precision[]
+
+ - __svm_target_reg_func:
+ rettype: double precision
+ argument: double precision[]
+
+ - __table_exists:
+ rettype: boolean
+ argument: text
+
+ - __train_tree:
+ rettype: __train_result
+ argument: text, integer, integer, text, text, text, text, text, text, double precision, integer, double precision, double precision, double precision, boolean, integer, integer
+
+ - __treemodel_classify_internal:
+ rettype: text[]
+ argument: text, text, integer
+
+ - __treemodel_classify_internal_serial:
+ rettype: text[]
+ argument: text, text, integer
+
+ - __treemodel_display_no_ordered_aggr:
+ rettype: SETOF text
+ argument: text, integer[], integer
+
+ - __treemodel_display_with_ordered_aggr:
+ rettype: SETOF text
+ argument: text, integer[], integer
+
+ - __treemodel_get_vote_result:
+ rettype: void
+ argument: text, text
+
+ - __treemodel_score:
+ rettype: double precision
+ argument: text, text, integer
+
+ - __validate_input_table:
+ rettype: void
+ argument: text, text[], text, text
+
+ - __validate_metatable:
+ rettype: void
+ argument: text
+
+ - c45_classify:
+ rettype: c45_classify_result
+ argument: text, text, text
+
+ - c45_classify:
+ rettype: c45_classify_result
+ argument: text, text, text, integer
+
+ - c45_clean:
+ rettype: boolean
+ argument: text
+
+ - c45_display:
+ rettype: SETOF text
+ argument: text
+
+ - c45_display:
+ rettype: SETOF text
+ argument: text, integer
+
+ - c45_genrule:
+ rettype: SETOF text
+ argument: text
+
+ - c45_genrule:
+ rettype: SETOF text
+ argument: text, integer
+
+ - c45_score:
+ rettype: double precision
+ argument: text, text
+
+ - c45_score:
+ rettype: double precision
+ argument: text, text, integer
+
+ - c45_train:
+ rettype: c45_train_result
+ argument: text, text, text
+
+ - c45_train:
+ rettype: c45_train_result
+ argument: text, text, text, text, text, text, text, text, double precision, text
+
+ - c45_train:
+ rettype: c45_train_result
+ argument: text, text, text, text, text, text, text, text, double precision, text, integer, double precision, double precision, integer
+
+ - correlation:
+ rettype: correlation_result
+ argument: character varying, character varying
+
+ - correlation:
+ rettype: correlation_result
+ argument: character varying, character varying, character varying
+
+ - correlation:
+ rettype: correlation_result
+ argument: character varying, character varying, character varying, boolean
+
+ - linear_svm_igd_transition:
+ rettype: double precision[]
+ argument: double precision[], double precision[], boolean, double precision[], integer, double precision, double precision
+
+ - lsvm_classification:
+ rettype: SETOF lsvm_sgd_result
+ argument: text, text
+
+ - lsvm_classification:
+ rettype: SETOF lsvm_sgd_result
+ argument: text, text, boolean
+
+ - lsvm_classification:
+ rettype: SETOF lsvm_sgd_result
+ argument: text, text, boolean, boolean, double precision, double precision
+
+ - lsvm_classification:
+ rettype: SETOF lsvm_sgd_result
+ argument: text, text, boolean, boolean, double precision, double precision, integer
+
+ - lsvm_predict:
+ rettype: double precision
+ argument: double precision[], double precision[]
+
+ - lsvm_predict_batch:
+ rettype: text
+ argument: text, text, text, text, text
+
+ - lsvm_predict_batch:
+ rettype: text
+ argument: text, text, text, text, text, boolean
+
+ - matrix_block_trans:
+ rettype: matrix_result
+ argument: text, text, text, text, boolean
+
+ - matrix_densify:
+ rettype: matrix_result
+ argument: text, text, text, text, boolean
+
+ - matrix_sparsify:
+ rettype: matrix_result
+ argument: text, text, text, text, boolean
+
+ - matrix_trans:
+ rettype: matrix_result
+ argument: text, text, text, text, boolean
+
+ - rf_classify:
+ rettype: rf_classify_result
+ argument: text, text, text
+
+ - rf_classify:
+ rettype: rf_classify_result
+ argument: text, text, text, boolean, integer
+
+ - rf_classify:
+ rettype: rf_classify_result
+ argument: text, text, text, integer
+
+ - rf_clean:
+ rettype: boolean
+ argument: text
+
+ - rf_display:
+ rettype: SETOF text
+ argument: text
+
+ - rf_display:
+ rettype: SETOF text
+ argument: text, integer[]
+
+ - rf_display:
+ rettype: SETOF text
+ argument: text, integer[], integer
+
+ - rf_score:
+ rettype: double precision
+ argument: text, text
+
+ - rf_score:
+ rettype: double precision
+ argument: text, text, integer
+
+ - rf_train:
+ rettype: rf_train_result
+ argument: text, text, text
+
+ - rf_train:
+ rettype: rf_train_result
+ argument: text, text, text, integer, integer, double precision, text, text, text, text, text, integer, double precision, double precision, integer
+
+ - svdmf_run:
+ rettype: text
+ argument: text, text, text, text, integer
+
+ - svdmf_run:
+ rettype: text
+ argument: text, text, text, text, integer, integer, double precision
+
+ - svm_classification:
+ rettype: SETOF svm_cls_result
+ argument: text, text, boolean, text
+
+ - svm_classification:
+ rettype: SETOF svm_cls_result
+ argument: text, text, boolean, text, boolean, double precision, double precision
+
+ - svm_classification:
+ rettype: SETOF svm_cls_result
+ argument: text, text, boolean, text, boolean, double precision, double precision, double precision
+
+ - svm_classification:
+ rettype: SETOF svm_cls_result
+ argument: text, text, boolean, text, double precision
+
+ - svm_cls_update:
+ rettype: schema_madlib.svm_model_rec
+ argument: schema_madlib.svm_model_rec, double precision[], double precision, text, double precision, double precision, double precision
+
+ - svm_data_normalization:
+ rettype: void
+ argument: text
+
+ - svm_dot:
+ rettype: double precision
+ argument: double precision[], double precision[]
+
+ - svm_dot:
+ rettype: double precision
+ argument: double precision[], double precision[], double precision
+
+ - svm_drop_model:
+ rettype: void
+ argument: text
+
+ - svm_gaussian:
+ rettype: double precision
+ argument: double precision[], double precision[], double precision
+
+ - svm_generate_cls_data:
+ rettype: void
+ argument: text, integer, integer
+
+ - svm_generate_nd_data:
+ rettype: void
+ argument: text, integer, integer
+
+ - svm_generate_reg_data:
+ rettype: void
+ argument: text, integer, integer
+
+ - svm_nd_update:
+ rettype: schema_madlib.svm_model_rec
+ argument: schema_madlib.svm_model_rec, double precision[], text, double precision, double precision, double precision
+
+ - svm_novelty_detection:
+ rettype: SETOF schema_madlib.svm_nd_result
+ argument: text, text, boolean, text
+
+ - svm_novelty_detection:
+ rettype: SETOF schema_madlib.svm_nd_result
+ argument: text, text, boolean, text, boolean, double precision, double precision
+
+ - svm_novelty_detection:
+ rettype: SETOF schema_madlib.svm_nd_result
+ argument: text, text, boolean, text, boolean, double precision, double precision, double precision
+
+ - svm_polynomial:
+ rettype: double precision
+ argument: double precision[], double precision[], double precision
+
+ - svm_predict:
+ rettype: double precision
+ argument: schema_madlib.svm_model_rec, double precision[], text, double precision
+
+ - svm_predict_batch:
+ rettype: text
+ argument: text, text, text, text, text, boolean
+
+ - svm_predict_sub:
+ rettype: double precision
+ argument: integer, integer, double precision[], double precision[], double precision[], text, double precision
+
+ - svm_reg_update:
+ rettype: schema_madlib.svm_model_rec
+ argument: schema_madlib.svm_model_rec, double precision[], double precision, text, double precision, double precision, double precision, double precision
+
+ - svm_regression:
+ rettype: SETOF svm_reg_result
+ argument: text, text, boolean, text
+
+ - svm_regression:
+ rettype: SETOF svm_reg_result
+ argument: text, text, boolean, text, boolean, double precision, double precision, double precision
+
+ - svm_regression:
+ rettype: SETOF svm_reg_result
+ argument: text, text, boolean, text, boolean, double precision, double precision, double precision, double precision
+
+ - svm_store_model:
+ rettype: void
+ argument: text, text, text
+
+ # ----------------- Changes from 1.9 to 1.9.1 ----------
+ - array_collapse:
+ rettype: anyarray
+ argument: anyarray
+ - linear_svm_igd_transition:
+ rettype: double precision[]
+ argument: double precision[], double precision[], double precision, double precision[], integer, double precision, double precision, boolean, integer, double precision, boolean
+ - profile:
+ rettype: SETOF schema_madlib.profile_result
+ argument: text
+ - profile_full:
+ rettype: SETOF schema_madlib.profile_result
+ argument: text, integer
+ - profile:
+ rettype: schema_madlib.profile_result
+ argument: text
+ - profile_full:
+ rettype: schema_madlib.profile_result
+ argument: text, integer
+ - quantile:
+ rettype: double precision
+ argument: text, text, double precision
+ - quantile_big:
+ rettype: double precision
+ argument: text, text, double precision
+
+ # ----------------- Changes from 1.9.1 to 1.0 ----------
+ - _dt_apply:
+ rettype: schema_madlib._tree_result_type
+ argument: schema_madlib.bytea8, schema_madlib.bytea8, schema_madlib.bytea8, smallint, smallint, smallint, boolean, integer
+ - _prune_and_cplist:
+ rettype: schema_madlib._prune_result_type
+ argument: schema_madlib.bytea8, double precision, boolean
+ - kmeans:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, double precision[], character varying, character varying, integer, double precision
+ - kmeans:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, double precision[], character varying, character varying, integer
+ - kmeans:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, double precision[], character varying, character varying
+ - kmeans:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, double precision[], character varying
+ - kmeans:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, double precision[]
+ - kmeans:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, character varying, character varying, character varying, character varying, integer, double precision
+ - kmeans:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, character varying, character varying, character varying, character varying, integer
+ - kmeans:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, character varying, character varying, character varying, character varying
+ - kmeans:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, character varying, character varying, character varying
+ - kmeans:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, character varying, character varying
+ - kmeanspp:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, integer, character varying, character varying, integer, double precision, double precision
+ - kmeanspp:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, integer, character varying, character varying, integer, double precision
+ - kmeanspp:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, integer, character varying, character varying, integer
+ - kmeanspp:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, integer, character varying, character varying
+ - kmeanspp:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, integer, character varying
+ - kmeanspp:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, integer
+ - kmeans_random:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, integer, character varying, character varying, integer, double precision
+ - kmeans_random:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, integer, character varying, character varying, integer
+ - kmeans_random:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, integer, character varying, character varying
+ - kmeans_random:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, integer, character varying
+ - kmeans_random:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, integer
+ - internal_execute_using_kmeans_args:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, character varying, character varying, character varying, integer, double precision
+
+
+# Changes to aggregates (UDA) including removal and modification
+# Overloaded functions should be mentioned separately
+uda:
+
+ # ----------------- Changes from 1.8 to 1.9 ----------
+ - __array_indexed_agg:
+ rettype: double precision[]
+ argument: double precision, bigint, bigint
+
+ - __best_scv_aggr:
+ rettype: double precision[]
+ argument: double precision[], integer, double precision
+
+ - __bigint_array_sum:
+ rettype: bigint[]
+ argument: bigint[]
+
+ - __display_tree_aggr:
+ rettype: text
+ argument: integer, boolean, text, text, double precision, double precision, text, integer
+
+ - __dt_acc_count_aggr:
+ rettype: bigint[]
+ argument: integer, bigint, integer
+
+ - __rep_aggr_class_count:
+ rettype: bigint[]
+ argument: integer, integer, integer
+
+ - __scv_aggr:
+ rettype: double precision[]
+ argument: integer, boolean, integer, double precision[], double precision[], bigint
+
+ - linear_svm_igd_step:
+ rettype: double precision[]
+ argument: double precision[], boolean, double precision[], integer, double precision, double precision
+
+ - linear_svm_igd_step_serial:
+ rettype: double precision[]
+ argument: double precision[], boolean, double precision[], integer, double precision, double precision
+
+ - svm_cls_agg:
+ rettype: schema_madlib.svm_model_rec
+ argument: double precision[], double precision, text, double precision, double precision, double precision
+
+ - svm_nd_agg:
+ rettype: schema_madlib.svm_model_rec
+ argument: double precision[], text, double precision, double precision, double precision
+
+ - svm_reg_agg:
+ rettype: schema_madlib.svm_model_rec
+ argument: double precision[], double precision, text, double precision, double precision, double precision, double precision
+
+ - __svm_random_ind2:
+ rettype: double precision[]
+ argument: integer
+
+ # ----------------- Changes from 1.9 to 1.9.1 ----------
+ - array_agg:
+ rettype: anyarray
+ argument: anyelement
+ - linear_svm_igd_step:
+ rettype: double precision[]
+ argument: double precision[], double precision, double precision[], integer, double precision, double precision, boolean, integer, double precision, boolean
+
+# Casts (UDC) updated/removed
+udc:
+ # ----------------- Changes from 1.8 to 1.9 ----------
+
+# Operators (UDO) removed/updated
+udo:
+ # ----------------- Changes from 1.8 to 1.9 ----------
+
+# Operator Classes (UDOC) removed/updated
+udoc:
+ # ----------------- Changes from 1.8 to 1.9 ----------
http://git-wip-us.apache.org/repos/asf/incubator-madlib/blob/90f4dc15/src/madpack/changelist_1.8_1.9.1.yaml
----------------------------------------------------------------------
diff --git a/src/madpack/changelist_1.8_1.9.1.yaml b/src/madpack/changelist_1.8_1.9.1.yaml
deleted file mode 100644
index 2a50cdb..0000000
--- a/src/madpack/changelist_1.8_1.9.1.yaml
+++ /dev/null
@@ -1,772 +0,0 @@
-# ------------------------------------------------------------------------------
-# Licensed to the Apache Software Foundation (ASF) under one
-# or more contributor license agreements. See the NOTICE file
-# distributed with this work for additional information
-# regarding copyright ownership. The ASF licenses this file
-# to you under the Apache License, Version 2.0 (the
-# "License"); you may not use this file except in compliance
-# with the License. You may obtain a copy of the License at
-#
-# http://www.apache.org/licenses/LICENSE-2.0
-#
-# Unless required by applicable law or agreed to in writing,
-# software distributed under the License is distributed on an
-# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-# KIND, either express or implied. See the License for the
-# specific language governing permissions and limitations
-# under the License.
-# ------------------------------------------------------------------------------
-
-# Changelist for MADlib version 1.8 to 1.9.1
-
-# This file contains all changes that were introduced in a new version of
-# MADlib. This changelist is used by the upgrade script to detect what objects
-# should be upgraded (while retaining all other objects from the previous version)
-
-# New modules (actually .sql_in files) added in upgrade version
-# For these files the sql_in code is retained as is with the functions in the
-# file installed on the upgrade version. All other files (that don't have
-# updates), are cleaned up to remove object replacements
-new module:
-# Changes in the types (UDT) including removal and modification
-udt:
-
- # ----------------- Changes from 1.8 to 1.9 ----------
- __enc_tbl_result:
- __gen_acc_time:
- __rep_type:
- __train_result:
- c45_classify_result:
- c45_train_result:
- correlation_result:
- lsvm_sgd_model_rec:
- lsvm_sgd_result:
- rf_classify_result:
- rf_train_result:
- svm_cls_result:
- svm_model_pr:
- svm_model_rec:
- svm_nd_result:
- svm_reg_result:
- svm_support_vector:
- _prune_result_type:
- _tree_result_type:
- linear_svm_result:
- # ----------------- Changes from 1.9 to 1.9.1 ----------
- profile_result:
-
-# List of the UDF changes that affect the user externally. This includes change
-# in function name, return type, argument order or types, or removal of
-# the function. In each case, the original function is as good as removed and a
-# new function is created. In such cases, we should abort the upgrade if there
-# are user views dependent on this function, since the original function will
-# not be present in the upgraded version.
-udf:
-
- # ----------------- Changes from 1.8 to 1.9 ----------
- - _dt_apply:
- rettype: schema_madlib._tree_result_type
- argument: schema_madlib.bytea8,schema_madlib.bytea8,schema_madlib.bytea8,smallint,smallint,smallint,boolean,integer
-
- - internal_linear_svm_igd_result:
- rettype: schema_madlib.linear_svm_result
- argument: double precision[]
-
- - _prune_and_cplist:
- rettype: schema_madlib._prune_result_type
- argument: schema_madlib.bytea8,double precision,boolean
-
- - __array_elem_in:
- rettype: boolean[]
- argument: anyarray, anyarray
-
- - __array_indexed_agg_ffunc:
- rettype: double precision[]
- argument: double precision[]
-
- - __array_indexed_agg_prefunc:
- rettype: double precision[]
- argument: double precision[], double precision[]
-
- - __array_indexed_agg_sfunc:
- rettype: double precision[]
- argument: double precision[], double precision, bigint, bigint
-
- - __array_search:
- rettype: boolean
- argument: anyelement, anyarray
-
- - __array_sort:
- rettype: anyarray
- argument: anyarray
-
- - __assert:
- rettype: void
- argument: boolean, text
-
- - __assert_table:
- rettype: void
- argument: text, boolean
-
- - __best_scv_prefunc:
- rettype: double precision[]
- argument: double precision[], double precision[]
-
- - __best_scv_sfunc:
- rettype: double precision[]
- argument: double precision[], double precision[], integer, double precision
-
- - __bigint_array_add:
- rettype: bigint[]
- argument: bigint[], bigint[]
-
- - __breakup_table:
- rettype: void
- argument: text, text, text, text, text, text[], boolean[], integer, integer
-
- - __check_dt_common_params:
- rettype: void
- argument: text, text, text, text, text, text, text, text, integer, double precision, double precision, integer, text
-
- - __check_training_table:
- rettype: void
- argument: text, text[], text[], text, text, integer
-
- - __column_exists:
- rettype: boolean
- argument: text, text
-
- - __columns_in_table:
- rettype: boolean
- argument: text[], text
-
- - __create_metatable:
- rettype: void
- argument: text
-
- - __create_tree_tables:
- rettype: void
- argument: text
-
- - __csvstr_to_array:
- rettype: text[]
- argument: text
-
- - __display_node_sfunc:
- rettype: text
- argument: text, integer, boolean, text, text, double precision, double precision, text, integer
-
- - __display_tree_no_ordered_aggr:
- rettype: text
- argument: text, integer, integer, integer, boolean, double precision, text, integer, integer
-
- - __distinct_feature_value:
- rettype: integer
- argument: text, integer
-
- - __drop_metatable:
- rettype: void
- argument: text
-
- - __dt_acc_count_sfunc:
- rettype: bigint[]
- argument: bigint[], integer, bigint, integer
-
- - __dt_get_node_split_fids:
- rettype: integer[]
- argument: integer, integer, integer, integer[]
-
- - __ebp_calc_errors:
- rettype: double precision
- argument: double precision, double precision, double precision
-
- - __ebp_prune_tree:
- rettype: void
- argument: text
-
- - __encode_and_train:
- rettype: record
- argument: text, text, integer, integer, text, text, text, text, text, text, text, double precision, text, integer, double precision, boolean, double precision, double precision, text, integer
-
- - __encode_columns:
- rettype: void
- argument: text, text, integer, integer
-
- - __encode_table:
- rettype: void
- argument: text, text, text, integer, integer
-
- - __encode_table:
- rettype: void
- argument: text, text, text[], text, text[], text, text, integer, integer
-
- - __find_best_split:
- rettype: void
- argument: text, double precision, text, integer, integer, text, integer, integer
-
- - __format:
- rettype: text
- argument: text, text
-
- - __format:
- rettype: text
- argument: text, text, text
-
- - __format:
- rettype: text
- argument: text, text, text, text
-
- - __format:
- rettype: text
- argument: text, text, text, text, text
-
- - __format:
- rettype: text
- argument: text, text[]
-
- - __gen_acc:
- rettype: __gen_acc_time
- argument: text, text, text, text, text, integer, integer, boolean, integer
-
- - __gen_enc_meta_names:
- rettype: text[]
- argument: text, text
-
- - __gen_horizontal_encoded_table:
- rettype: void
- argument: text, text, integer, integer
-
- - __gen_vertical_encoded_table:
- rettype: void
- argument: text, text, text, boolean, integer
-
- - __generate_final_tree:
- rettype: void
- argument: text
-
- - __get_class_column_name:
- rettype: text
- argument: text
-
- - __get_class_value:
- rettype: text
- argument: integer, text
-
- - __get_classtable_name:
- rettype: text
- argument: text
-
- - __get_column_value:
- rettype: text
- argument: integer, integer, character, text
-
- - __get_feature_name:
- rettype: text
- argument: integer, text
-
- - __get_feature_value:
- rettype: text
- argument: integer, integer, text
-
- - __get_features_of_nodes:
- rettype: text
- argument: text, text, integer, integer, integer
-
- - __get_id_column_name:
- rettype: text
- argument: text
-
- - __get_schema_name:
- rettype: text
- argument: text
-
- - __get_table_name:
- rettype: text
- argument: text
-
- - __insert_into_metatable:
- rettype: void
- argument: text, integer, text, character, boolean, text, integer
-
- - __is_valid_enc_table:
- rettype: boolean
- argument: text
-
- - __num_of_class:
- rettype: integer
- argument: text
-
- - __num_of_columns:
- rettype: integer
- argument: text
-
- - __num_of_feature:
- rettype: integer
- argument: text
-
- - __regclass_to_text:
- rettype: text
- argument: regclass
-
- - __rename_table:
- rettype: void
- argument: text, text
-
- - __rep_aggr_class_count_ffunc:
- rettype: bigint[]
- argument: bigint[]
-
- - __rep_aggr_class_count_sfunc:
- rettype: bigint[]
- argument: bigint[], integer, integer, integer
-
- - __rep_prune_tree:
- rettype: void
- argument: text, text, integer
-
- - __sample_with_replacement:
- rettype: void
- argument: integer, bigint, text, text
-
- - __sample_within_range:
- rettype: SETOF bigint
- argument: bigint, bigint, bigint
-
- - __scv_aggr_ffunc:
- rettype: double precision[]
- argument: double precision[]
-
- - __scv_aggr_prefunc:
- rettype: double precision[]
- argument: double precision[], double precision[]
-
- - __scv_aggr_sfunc:
- rettype: double precision[]
- argument: double precision[], integer, boolean, integer, double precision[], double precision[], bigint
-
- - __strip_schema_name:
- rettype: text
- argument: text
-
- - __svm_random_ind2:
- rettype: double precision[]
- argument: integer
-
- - __svm_random_ind:
- rettype: double precision[]
- argument: integer
-
- - __svm_target_cl_func:
- rettype: double precision
- argument: double precision[]
-
- - __svm_target_reg_func:
- rettype: double precision
- argument: double precision[]
-
- - __table_exists:
- rettype: boolean
- argument: text
-
- - __train_tree:
- rettype: __train_result
- argument: text, integer, integer, text, text, text, text, text, text, double precision, integer, double precision, double precision, double precision, boolean, integer, integer
-
- - __treemodel_classify_internal:
- rettype: text[]
- argument: text, text, integer
-
- - __treemodel_classify_internal_serial:
- rettype: text[]
- argument: text, text, integer
-
- - __treemodel_display_no_ordered_aggr:
- rettype: SETOF text
- argument: text, integer[], integer
-
- - __treemodel_display_with_ordered_aggr:
- rettype: SETOF text
- argument: text, integer[], integer
-
- - __treemodel_get_vote_result:
- rettype: void
- argument: text, text
-
- - __treemodel_score:
- rettype: double precision
- argument: text, text, integer
-
- - __validate_input_table:
- rettype: void
- argument: text, text[], text, text
-
- - __validate_metatable:
- rettype: void
- argument: text
-
- - c45_classify:
- rettype: c45_classify_result
- argument: text, text, text
-
- - c45_classify:
- rettype: c45_classify_result
- argument: text, text, text, integer
-
- - c45_clean:
- rettype: boolean
- argument: text
-
- - c45_display:
- rettype: SETOF text
- argument: text
-
- - c45_display:
- rettype: SETOF text
- argument: text, integer
-
- - c45_genrule:
- rettype: SETOF text
- argument: text
-
- - c45_genrule:
- rettype: SETOF text
- argument: text, integer
-
- - c45_score:
- rettype: double precision
- argument: text, text
-
- - c45_score:
- rettype: double precision
- argument: text, text, integer
-
- - c45_train:
- rettype: c45_train_result
- argument: text, text, text
-
- - c45_train:
- rettype: c45_train_result
- argument: text, text, text, text, text, text, text, text, double precision, text
-
- - c45_train:
- rettype: c45_train_result
- argument: text, text, text, text, text, text, text, text, double precision, text, integer, double precision, double precision, integer
-
- - correlation:
- rettype: correlation_result
- argument: character varying, character varying
-
- - correlation:
- rettype: correlation_result
- argument: character varying, character varying, character varying
-
- - correlation:
- rettype: correlation_result
- argument: character varying, character varying, character varying, boolean
-
- - linear_svm_igd_transition:
- rettype: double precision[]
- argument: double precision[], double precision[], boolean, double precision[], integer, double precision, double precision
-
- - lsvm_classification:
- rettype: SETOF lsvm_sgd_result
- argument: text, text
-
- - lsvm_classification:
- rettype: SETOF lsvm_sgd_result
- argument: text, text, boolean
-
- - lsvm_classification:
- rettype: SETOF lsvm_sgd_result
- argument: text, text, boolean, boolean, double precision, double precision
-
- - lsvm_classification:
- rettype: SETOF lsvm_sgd_result
- argument: text, text, boolean, boolean, double precision, double precision, integer
-
- - lsvm_predict:
- rettype: double precision
- argument: double precision[], double precision[]
-
- - lsvm_predict_batch:
- rettype: text
- argument: text, text, text, text, text
-
- - lsvm_predict_batch:
- rettype: text
- argument: text, text, text, text, text, boolean
-
- - matrix_block_trans:
- rettype: matrix_result
- argument: text, text, text, text, boolean
-
- - matrix_densify:
- rettype: matrix_result
- argument: text, text, text, text, boolean
-
- - matrix_sparsify:
- rettype: matrix_result
- argument: text, text, text, text, boolean
-
- - matrix_trans:
- rettype: matrix_result
- argument: text, text, text, text, boolean
-
- - rf_classify:
- rettype: rf_classify_result
- argument: text, text, text
-
- - rf_classify:
- rettype: rf_classify_result
- argument: text, text, text, boolean, integer
-
- - rf_classify:
- rettype: rf_classify_result
- argument: text, text, text, integer
-
- - rf_clean:
- rettype: boolean
- argument: text
-
- - rf_display:
- rettype: SETOF text
- argument: text
-
- - rf_display:
- rettype: SETOF text
- argument: text, integer[]
-
- - rf_display:
- rettype: SETOF text
- argument: text, integer[], integer
-
- - rf_score:
- rettype: double precision
- argument: text, text
-
- - rf_score:
- rettype: double precision
- argument: text, text, integer
-
- - rf_train:
- rettype: rf_train_result
- argument: text, text, text
-
- - rf_train:
- rettype: rf_train_result
- argument: text, text, text, integer, integer, double precision, text, text, text, text, text, integer, double precision, double precision, integer
-
- - svdmf_run:
- rettype: text
- argument: text, text, text, text, integer
-
- - svdmf_run:
- rettype: text
- argument: text, text, text, text, integer, integer, double precision
-
- - svm_classification:
- rettype: SETOF svm_cls_result
- argument: text, text, boolean, text
-
- - svm_classification:
- rettype: SETOF svm_cls_result
- argument: text, text, boolean, text, boolean, double precision, double precision
-
- - svm_classification:
- rettype: SETOF svm_cls_result
- argument: text, text, boolean, text, boolean, double precision, double precision, double precision
-
- - svm_classification:
- rettype: SETOF svm_cls_result
- argument: text, text, boolean, text, double precision
-
- - svm_cls_update:
- rettype: schema_madlib.svm_model_rec
- argument: schema_madlib.svm_model_rec, double precision[], double precision, text, double precision, double precision, double precision
-
- - svm_data_normalization:
- rettype: void
- argument: text
-
- - svm_dot:
- rettype: double precision
- argument: double precision[], double precision[]
-
- - svm_dot:
- rettype: double precision
- argument: double precision[], double precision[], double precision
-
- - svm_drop_model:
- rettype: void
- argument: text
-
- - svm_gaussian:
- rettype: double precision
- argument: double precision[], double precision[], double precision
-
- - svm_generate_cls_data:
- rettype: void
- argument: text, integer, integer
-
- - svm_generate_nd_data:
- rettype: void
- argument: text, integer, integer
-
- - svm_generate_reg_data:
- rettype: void
- argument: text, integer, integer
-
- - svm_nd_update:
- rettype: schema_madlib.svm_model_rec
- argument: schema_madlib.svm_model_rec, double precision[], text, double precision, double precision, double precision
-
- - svm_novelty_detection:
- rettype: SETOF schema_madlib.svm_nd_result
- argument: text, text, boolean, text
-
- - svm_novelty_detection:
- rettype: SETOF schema_madlib.svm_nd_result
- argument: text, text, boolean, text, boolean, double precision, double precision
-
- - svm_novelty_detection:
- rettype: SETOF schema_madlib.svm_nd_result
- argument: text, text, boolean, text, boolean, double precision, double precision, double precision
-
- - svm_polynomial:
- rettype: double precision
- argument: double precision[], double precision[], double precision
-
- - svm_predict:
- rettype: double precision
- argument: schema_madlib.svm_model_rec, double precision[], text, double precision
-
- - svm_predict_batch:
- rettype: text
- argument: text, text, text, text, text, boolean
-
- - svm_predict_sub:
- rettype: double precision
- argument: integer, integer, double precision[], double precision[], double precision[], text, double precision
-
- - svm_reg_update:
- rettype: schema_madlib.svm_model_rec
- argument: schema_madlib.svm_model_rec, double precision[], double precision, text, double precision, double precision, double precision, double precision
-
- - svm_regression:
- rettype: SETOF svm_reg_result
- argument: text, text, boolean, text
-
- - svm_regression:
- rettype: SETOF svm_reg_result
- argument: text, text, boolean, text, boolean, double precision, double precision, double precision
-
- - svm_regression:
- rettype: SETOF svm_reg_result
- argument: text, text, boolean, text, boolean, double precision, double precision, double precision, double precision
-
- - svm_store_model:
- rettype: void
- argument: text, text, text
-
- # ----------------- Changes from 1.9 to 1.9.1 ----------
- - array_collapse:
- rettype: anyarray
- argument: anyarray
- - linear_svm_igd_transition:
- rettype: double precision[]
- argument: double precision[], double precision[], double precision, double precision[], integer, double precision, double precision, boolean, integer, double precision, boolean
- - profile:
- rettype: SETOF schema_madlib.profile_result
- argument: text
- - profile_full:
- rettype: SETOF schema_madlib.profile_result
- argument: text, integer
- - profile:
- rettype: schema_madlib.profile_result
- argument: text
- - profile_full:
- rettype: schema_madlib.profile_result
- argument: text, integer
- - quantile:
- rettype: double precision
- argument: text, text, double precision
- - quantile_big:
- rettype: double precision
- argument: text, text, double precision
-
-# Changes to aggregates (UDA) including removal and modification
-# Overloaded functions should be mentioned separately
-uda:
-
- # ----------------- Changes from 1.8 to 1.9 ----------
- - __array_indexed_agg:
- rettype: double precision[]
- argument: double precision, bigint, bigint
-
- - __best_scv_aggr:
- rettype: double precision[]
- argument: double precision[], integer, double precision
-
- - __bigint_array_sum:
- rettype: bigint[]
- argument: bigint[]
-
- - __display_tree_aggr:
- rettype: text
- argument: integer, boolean, text, text, double precision, double precision, text, integer
-
- - __dt_acc_count_aggr:
- rettype: bigint[]
- argument: integer, bigint, integer
-
- - __rep_aggr_class_count:
- rettype: bigint[]
- argument: integer, integer, integer
-
- - __scv_aggr:
- rettype: double precision[]
- argument: integer, boolean, integer, double precision[], double precision[], bigint
-
- - linear_svm_igd_step:
- rettype: double precision[]
- argument: double precision[], boolean, double precision[], integer, double precision, double precision
-
- - linear_svm_igd_step_serial:
- rettype: double precision[]
- argument: double precision[], boolean, double precision[], integer, double precision, double precision
-
- - svm_cls_agg:
- rettype: schema_madlib.svm_model_rec
- argument: double precision[], double precision, text, double precision, double precision, double precision
-
- - svm_nd_agg:
- rettype: schema_madlib.svm_model_rec
- argument: double precision[], text, double precision, double precision, double precision
-
- - svm_reg_agg:
- rettype: schema_madlib.svm_model_rec
- argument: double precision[], double precision, text, double precision, double precision, double precision, double precision
-
- - __svm_random_ind2:
- rettype: double precision[]
- argument: integer
-
- # ----------------- Changes from 1.9 to 1.9.1 ----------
- - array_agg:
- rettype: anyarray
- argument: anyelement
- - linear_svm_igd_step:
- rettype: double precision[]
- argument: double precision[], double precision, double precision[], integer, double precision, double precision, boolean, integer, double precision, boolean
-
-# Casts (UDC) updated/removed
-udc:
- # ----------------- Changes from 1.8 to 1.9 ----------
-
-# Operators (UDO) removed/updated
-udo:
- # ----------------- Changes from 1.8 to 1.9 ----------
-
-# Operator Classes (UDOC) removed/updated
-udoc:
- # ----------------- Changes from 1.8 to 1.9 ----------
http://git-wip-us.apache.org/repos/asf/incubator-madlib/blob/90f4dc15/src/madpack/changelist_1.9_1.10.yaml
----------------------------------------------------------------------
diff --git a/src/madpack/changelist_1.9_1.10.yaml b/src/madpack/changelist_1.9_1.10.yaml
new file mode 100644
index 0000000..41082ad
--- /dev/null
+++ b/src/madpack/changelist_1.9_1.10.yaml
@@ -0,0 +1,156 @@
+# Changelist for MADlib version 1.9 to 1.10
+
+# This file contains all changes that were introduced in a new version of
+# MADlib. This changelist is used by the upgrade script to detect what objects
+# should be upgraded (while retaining all other objects from the previous version)
+
+# New modules (actually .sql_in files) added in upgrade version
+# For these files the sql_in code is retained as is with the functions in the
+# file installed on the upgrade version. All other files (that don't have
+# updates), are cleaned up to remove object replacements
+new module:
+ # ----------------- Changes from 1.9.1 to 1.0 ----------
+ sssp:
+ encode_categorical:
+ knn:
+
+# Changes in the types (UDT) including removal and modification
+udt:
+ # ----------------- Changes from 1.9 to 1.9.1 ----------
+ profile_result:
+ # ----------------- Changes from 1.9.1 to 1.0 ----------
+ _tree_result_type:
+ _prune_result_type:
+ kmeans_result:
+ kmeans_state:
+
+# List of the UDF changes that affect the user externally. This includes change
+# in function name, return type, argument order or types, or removal of
+# the function. In each case, the original function is as good as removed and a
+# new function is created. In such cases, we should abort the upgrade if there
+# are user views dependent on this function, since the original function will
+# not be present in the upgraded version.
+udf:
+ # ----------------- Changes from 1.9 to 1.9.1 ----------
+ - array_collapse:
+ rettype: anyarray
+ argument: anyarray
+ - linear_svm_igd_transition:
+ rettype: double precision[]
+ argument: double precision[], double precision[], double precision, double precision[], integer, double precision, double precision, boolean, integer, double precision, boolean
+ - profile:
+ rettype: SETOF schema_madlib.profile_result
+ argument: text
+ - profile_full:
+ rettype: SETOF schema_madlib.profile_result
+ argument: text, integer
+ - profile:
+ rettype: schema_madlib.profile_result
+ argument: text
+ - profile_full:
+ rettype: schema_madlib.profile_result
+ argument: text, integer
+ - quantile:
+ rettype: double precision
+ argument: text, text, double precision
+ - quantile_big:
+ rettype: double precision
+ argument: text, text, double precision
+ # ----------------- Changes from 1.9.1 to 1.0 ----------
+ - _dt_apply:
+ rettype: schema_madlib._tree_result_type
+ argument: schema_madlib.bytea8, schema_madlib.bytea8, schema_madlib.bytea8, smallint, smallint, smallint, boolean, integer
+ - _prune_and_cplist:
+ rettype: schema_madlib._prune_result_type
+ argument: schema_madlib.bytea8, double precision, boolean
+ - kmeans:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, double precision[], character varying, character varying, integer, double precision
+ - kmeans:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, double precision[], character varying, character varying, integer
+ - kmeans:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, double precision[], character varying, character varying
+ - kmeans:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, double precision[], character varying
+ - kmeans:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, double precision[]
+ - kmeans:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, character varying, character varying, character varying, character varying, integer, double precision
+ - kmeans:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, character varying, character varying, character varying, character varying, integer
+ - kmeans:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, character varying, character varying, character varying, character varying
+ - kmeans:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, character varying, character varying, character varying
+ - kmeans:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, character varying, character varying
+ - kmeanspp:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, integer, character varying, character varying, integer, double precision, double precision
+ - kmeanspp:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, integer, character varying, character varying, integer, double precision
+ - kmeanspp:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, integer, character varying, character varying, integer
+ - kmeanspp:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, integer, character varying, character varying
+ - kmeanspp:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, integer, character varying
+ - kmeanspp:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, integer
+ - kmeans_random:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, integer, character varying, character varying, integer, double precision
+ - kmeans_random:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, integer, character varying, character varying, integer
+ - kmeans_random:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, integer, character varying, character varying
+ - kmeans_random:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, integer, character varying
+ - kmeans_random:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, integer
+ - internal_execute_using_kmeans_args:
+ rettype: schema_madlib.kmeans_result
+ argument: character varying, character varying, character varying, character varying, character varying, integer, double precision
+
+
+# Changes to aggregates (UDA) including removal and modification
+# Overloaded functions should be mentioned separately
+uda:
+ # ----------------- Changes from 1.9 to 1.9.1 ----------
+ - array_agg:
+ rettype: anyarray
+ argument: anyelement
+ - linear_svm_igd_step:
+ rettype: double precision[]
+ argument: double precision[], double precision, double precision[], integer, double precision, double precision, boolean, integer, double precision, boolean
+
+
+# Casts (UDC) updated/removed
+udc:
+ # ----------------- Changes from 1.9 to 1.9.1 ----------
+
+# Operators (UDO) removed/updated
+udo:
+ # ----------------- Changes from 1.9 to 1.9.1 ----------
+
+# Operator Classes (UDOC) removed/updated
+udoc:
+ # ----------------- Changes from 1.9 to 1.9.1 ----------
http://git-wip-us.apache.org/repos/asf/incubator-madlib/blob/90f4dc15/src/madpack/diff_udf.sql
----------------------------------------------------------------------
diff --git a/src/madpack/diff_udf.sql b/src/madpack/diff_udf.sql
index d00f964..da345b5 100644
--- a/src/madpack/diff_udf.sql
+++ b/src/madpack/diff_udf.sql
@@ -139,7 +139,7 @@ $$ LANGUAGE plpythonu;
DROP TABLE IF EXISTS functions_madlib_old_version;
DROP TABLE IF EXISTS functions_madlib_new_version;
-SELECT get_functions('madlib_v19');
+SELECT get_functions('madlib_old_vers');
SELECT
--'\t-' || name || ':' || '\n\t\t-rettype: ' || retype || '\n\t\t-argument: ' || argtypes
http://git-wip-us.apache.org/repos/asf/incubator-madlib/blob/90f4dc15/src/madpack/diff_udt.sql
----------------------------------------------------------------------
diff --git a/src/madpack/diff_udt.sql b/src/madpack/diff_udt.sql
index 5cbf1e7..e521a09 100644
--- a/src/madpack/diff_udt.sql
+++ b/src/madpack/diff_udt.sql
@@ -66,44 +66,44 @@ $$ LANGUAGE plpythonu;
-- Get UDTs
DROP TABLE IF EXISTS types_madlib;
-DROP TABLE IF EXISTS types_madlib_v19;
+DROP TABLE IF EXISTS types_madlib_old_vers;
SELECT get_types('madlib');
-SELECT get_types('madlib_v19');
+SELECT get_types('madlib_old_vers');
--SELECT name FROM types_madlib;
--SELECT name FROM types_madlib_v15;
--Dropped
SELECT
- v19.name AS "Dropped UDTs"
+ old_vers.name AS "Dropped UDTs"
FROM
- types_madlib_v19 AS v19
+ types_madlib_old_vers AS old_vers
LEFT JOIN
- types_madlib AS v191
+ types_madlib AS new_vers
USING (name)
-WHERE v191.name IS NULL;
+WHERE new_vers.name IS NULL;
--Added
SELECT
- v191.name AS "Added UDTs"
+ new_vers.name AS "Added UDTs"
FROM
- types_madlib_v19 AS v19
+ types_madlib_old_vers AS old_vers
RIGHT JOIN
- types_madlib AS v191
+ types_madlib AS new_vers
USING (name)
-WHERE v19.name IS NULL;
+WHERE old_vers.name IS NULL;
--Common
DROP TABLE IF EXISTS types_common;
CREATE TABLE types_common AS
SELECT
- v19.name, v19.typrelid AS old_relid, v191.typrelid AS new_relid
+ old_vers.name, old_vers.typrelid AS old_relid, new_vers.typrelid AS new_relid
FROM
- types_madlib_v19 AS v19
+ types_madlib_old_vers AS old_vers
JOIN
- types_madlib AS v191
+ types_madlib AS new_vers
USING (name)
-WHERE v19.typrelid <> 0; -- 0 means base type
+WHERE old_vers.typrelid <> 0; -- 0 means base type
SELECT
array_upper(detect_changed_types('types_common'), 1) AS N,
http://git-wip-us.apache.org/repos/asf/incubator-madlib/blob/90f4dc15/src/madpack/madpack.py
----------------------------------------------------------------------
diff --git a/src/madpack/madpack.py b/src/madpack/madpack.py
index 2e21fa4..3b66b17 100755
--- a/src/madpack/madpack.py
+++ b/src/madpack/madpack.py
@@ -657,6 +657,13 @@ def _db_upgrade(schema, dbrev):
_info("Current MADlib version already up to date.", True)
return
+ if _is_rev_gte([1,7,1],_get_rev_num(dbrev)):
+ _error("""
+ MADlib versions prior to v1.8 are not supported for upgrade.
+ Please try upgrading to v1.9.1 and then upgrade to this version.
+ """, True)
+ return
+
_info("Upgrading MADlib into %s schema..." % schema.upper(), True)
_info("\tDetecting dependencies...", True)