I need some help.My English is poor.
ICE_User_Guide document”
A value inserted into a column with a decomposition defined does not have to match the rule. Such non-matching values are inserted into a separate subcollection. This subcollection of outliers is compressed and stored independently of other subcollections.
You can obtain the accuracy of decomposition rules by setting the ControlMessages parameter in the brighthouse.ini file to 2 (or higher):ControlMessages = 2
If the parameter is set on each COMMIT for each column, Infobright reports the number of outliers among the committed values (from INSERTs and LOADs).For example:
2011-05-25 16:59:03 Decomposition of ./network/connection.ip left 15 outliers.
“
I set ControlMessages = 4,but I didn’t find in bh.err
mysql> show variables like 'version_comment';
+-----------------+--------------------------------------------------+
| Variable_name | Value |
+-----------------+--------------------------------------------------+
| version_comment | build number (revision)=IB_4.0_r13151_13690(ice) |
+-----------------+--------------------------------------------------+
mysql> show variables like 'brighthouse_ini_controlmessages';
+---------------------------------+-------+
| Variable_name | Value |
+---------------------------------+-------+
| brighthouse_ini_controlmessages | 4 |
+---------------------------------+-------+
mysql> desc t8;
+-------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+----------+------+-----+---------+-------+
| n | char(10) | YES | | NULL | |
+-------+----------+------+-----+---------+-------+
1 row in set (0.00 sec)
mysql> CALL sys_infobright.SHOW_DECOMPOSITION('test','t8');
+---+-------------+-----------+---------------+--------+
| # | column name | data type | decomposition | rule |
+---+-------------+-----------+---------------+--------+
| 1 | n | char | t8r | :::.%d |
+---+-------------+-----------+---------------+--------+
mysql> begin;
Query OK, 0 rows affected (0.00 sec)
mysql> load data infile '/tmp/b.txt' into table t8;
Query OK, 1 row affected (0.03 sec)
Records: 1 Deleted: 0 Skipped: 0 Warnings: 0
mysql> commit;
Query OK, 0 rows affected (0.00 sec)
[root@test /tmp]# cat b.txt
"abcde"
rule is :::.%d
“abcde” is non-matching values
but I didn’t find in bh.err,why ?
