Hello columners,

I have this error message in brighthouse.log:

.. it seems bad .. is it as bad as it seems ?

Thanks

Eriam

Hi eriam,

The decompositions dictionary needed only for domain expert and shouldn’t affect anything else. To fix the warning, please execute the following:

drop database if exists sys_infobright; create database
sys_infobright; use sys_infobright; CREATE TABLE `columns` (
`database_name` varchar(255) COLLATE latin1_bin NOT NULL,
`table_name` varchar(255) COLLATE latin1_bin NOT NULL,
`column_name` varchar(255) COLLATE latin1_bin NOT NULL,
`decomposition` varchar(20) COLLATE latin1_bin NOT NULL
) ENGINE=CSV DEFAULT CHARSET=latin1 COLLATE=latin1_bin;

CREATE TABLE `decomposition_dictionary` (
`ID` varchar(20) COLLATE latin1_bin NOT NULL,
`RULE` varchar(100) COLLATE latin1_bin NOT NULL,
`COMMENT` varchar(255) COLLATE latin1_bin NOT NULL
) ENGINE=CSV DEFAULT CHARSET=latin1 COLLATE=latin1_bin ;

source /usr/local/infobright/share/infobright/infobright_upgrade.sql;

regards,
Kethees.