map_name | map_type_name | is_same_map | is_only_id | is_id_output | is_bulk_map | is_match_all | source_name | obj_type_name | attr_name | source_name | obj_type_name | attr_name | map_class | exec_type | map_call | safe_point_size |
mappingtest1 | testmapping | 0 | 1 | 1 | 1 | 0 | testdb1 | testobjects1 | ID1 | testdb2 | testobjects2 | ID2 | id | sql | Driver=org.gjt.mm.mysql.Driver;URL=jdbc:mysql://139.18.13.64:3306/test_db2;user=peter;password=retep;QUERYPATTERN=SELECT ID2,value2 as value from test_objects2 WHERE ID2 in ([Query]) | -1 |
querytestobjects1 | querytest1 | 1 | 1 | 1 | 0 | 0 | testdb1 | query | (null) | testdb1 | testobjects1 | ID1 | query | sql | Driver=org.gjt.mm.mysql.Driver;URL=jdbc:mysql://139.18.13.64:3306/test_db1;user=peter;password=retep;QUERYPATTERN=SELECT ID1,Value1 as Value from test_objects1 WHERE [Query] | 10000 |
querytestobjects2 | querytest2 | 1 | 1 | 1 | 0 | 0 | testdb2 | query | (null) | testdb2 | testobjects2 | ID2 | query | sql | Driver=org.gjt.mm.mysql.Driver;URL=jdbc:mysql://139.18.13.64:3306/test_db2;user=peter;password=retep;QUERYPATTERN=SELECT ID2,value2 as value from test_objects2 WHERE [Query] | -1 |