1.8
User Documentation for MADlib
dt_preproc.sql_in File Reference

Functions used in C4.5 and random forest for data preprocessing. More...

Functions

void __validate_input_table (text full_table_name, text[] feature_columns, text id_column, text class_column)
 
text __get_classtable_name (text meta_tbl_name)
 
void __drop_metatable (text meta_tbl_name)
 
void __create_metatable (text meta_tbl_name)
 
void __insert_into_metatable (text meta_tbl_name, int col_index, text column_name, char column_type, boolean is_cont, text table_name, int num_dist_value)
 
void __validate_metatable (text meta_tbl_name)
 
int4 __distinct_feature_value (text meta_tbl_name, int feature_id)
 
int4 __num_of_feature (text meta_tbl_name)
 
int4 __num_of_class (text meta_tbl_name)
 
text __get_feature_name (int feature_index, text meta_tbl_name)
 
text __get_column_value (int column_index, int code, char column_type, text meta_tbl_name)
 
text __get_feature_value (int feature_index, int code, text meta_tbl_name)
 
text __get_id_column_name (text meta_tbl_name)
 
text __get_class_column_name (text meta_tbl_name)
 
text __get_class_value (int code, text meta_tbl_name)
 
void __breakup_table (text input_tbl_name, text breakup_tbl_name, text kv_cls_name, text id_col_name, text cls_col_name, text[] attr_col_names, bool[] is_conts, int h2hmv_routine_id, int verbosity)
 
void __gen_vertical_encoded_table (text breakup_tbl_name, text enc_tbl_name, text kv_attr_name, bool is_tbl_tmp, int verbosity)
 
void __gen_horizontal_encoded_table (text hor_tbl_name, text ver_tbl_name, int attr_count, int verbosity)
 
void __encode_columns (text kv_attr_name, text breakup_tbl_name, int h2hmv_routine_id, int verbosity)
 
void __encode_table (text input_tbl_name, text id_col_name, text[] feature_names, text cls_col_name, text[] cont_attr_names, text enc_table_name, text meta_tbl_name, int h2hmv_routine_id, int verbosity)
 
void __encode_table (text input_tbl_name, text enc_tbl_name, text meta_tbl_name, int h2hmv_routine_id, int verbosity)
 

Detailed Description

Date
July 19, 2012

Function Documentation

void __breakup_table ( text  input_tbl_name,
text  breakup_tbl_name,
text  kv_cls_name,
text  id_col_name,
text  cls_col_name,
text[]  attr_col_names,
bool[]  is_conts,
int  h2hmv_routine_id,
int  verbosity 
)
void __create_metatable ( text  meta_tbl_name)
int4 __distinct_feature_value ( text  meta_tbl_name,
int  feature_id 
)
void __drop_metatable ( text  meta_tbl_name)
void __encode_columns ( text  kv_attr_name,
text  breakup_tbl_name,
int  h2hmv_routine_id,
int  verbosity 
)
void __encode_table ( text  input_tbl_name,
text  id_col_name,
text[]  feature_names,
text  cls_col_name,
text[]  cont_attr_names,
text  enc_table_name,
text  meta_tbl_name,
int  h2hmv_routine_id,
int  verbosity 
)
void __encode_table ( text  input_tbl_name,
text  enc_tbl_name,
text  meta_tbl_name,
int  h2hmv_routine_id,
int  verbosity 
)
void __gen_horizontal_encoded_table ( text  hor_tbl_name,
text  ver_tbl_name,
int  attr_count,
int  verbosity 
)
void __gen_vertical_encoded_table ( text  breakup_tbl_name,
text  enc_tbl_name,
text  kv_attr_name,
bool  is_tbl_tmp,
int  verbosity 
)
text __get_class_column_name ( text  meta_tbl_name)
text __get_class_value ( int  code,
text  meta_tbl_name 
)
text __get_classtable_name ( text  meta_tbl_name)
text __get_column_value ( int  column_index,
int  code,
char  column_type,
text  meta_tbl_name 
)
text __get_feature_name ( int  feature_index,
text  meta_tbl_name 
)
text __get_feature_value ( int  feature_index,
int  code,
text  meta_tbl_name 
)
text __get_id_column_name ( text  meta_tbl_name)
void __insert_into_metatable ( text  meta_tbl_name,
int  col_index,
text  column_name,
char  column_type,
boolean  is_cont,
text  table_name,
int  num_dist_value 
)
int4 __num_of_class ( text  meta_tbl_name)
int4 __num_of_feature ( text  meta_tbl_name)
void __validate_input_table ( text  full_table_name,
text[]  feature_columns,
text  id_column,
text  class_column 
)
void __validate_metatable ( text  meta_tbl_name)