infobright 小节

=====

Infobright有两个版本ICE和IEE，目前ICE的版本是3.3.1，支持64位Linux和32位windows。ICE不支持DML，也就是不支持insert、update等操作

Infobright是开源的MySQL数据仓库解决方案，引入了列存储方案，高强度的数据压缩，优化的统计计算(类似sum/avg/group by之类)

=====

infobright 中执行一般的sql可能会出现如下错误:

SQLException: The query includes syntax that is not supported by the Infobright Optimizer. Either restructure the query with supported syntax, or enable the MySQL Query Path in the brighthouse.ini file to execute the query with reduced performance.

操作方式:

1:

 找到所有的brighthouse.ini文件,在最后添加一行:

AllowMySQLQueryPath = 1

 2:

重启infobright

=====

=====