Debunking GROUP BY myths

-


http://rpbouman.blogspot.co.uk/2007/05/debunking-group-by-myths.html

Comments

Post a Comment

Popular posts from this blog

CAS with Pentaho Community Edition

-
In this week I integrate one of the most useful feature i.e. CAS (Single Sign on) with the help my collegue and online user community . So with my boss’ blessing, I decided to document what I had to do to make this work in the spirit of giving back to the community. Plus with the rising awareness of the benefits of BI even for small to medium corporations, I have no doubt that this information would be useful for someone somewhere. The need 1) CAS Server 2) Pentaho BI 3.x server (Community Edition) 3) Install certificate IMPLEMENTATION OF CAS CLIENT IN PENTAHO BI SERVER 1) \biserver-ce\pentaho-solutions\system\applicationContext-spring-security.xml make changes in applicationContext file for CAS Client. and add following jars in biserver-ce\tomcat\webapps\pentaho\WEB-INF\lib folder 1) spring-security-cas-client-2.0.5.RELEASE.jar 2) cas-client-core-3.1.10.jar After added jars and configuration in applicationContext file then install certificate step-1) download...
Read more

How to increase GROUP_CONCAT function length in MySQL

-
http://forums.pentaho.com/showthread.php?135082-how-to-add-maximum-length-for-GROUP_CONCAT-in-pentaho-report-designer&p=330725#post330725 GROUP_CONCAT() in a MySQL query to convert multiple rows into a single string. However, the maximum length of the result of this function is 1024 characters.  I'm very well aware that I can change the param group_concat_max_len to increase this limit: SET SESSION group_concat_max_len = 1000000 ; Above is set for SESSION SET GLOBAL group_concat_max_len = 1000000; above is set for GLOBAL ref :- http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_group-concat http://rpbouman.blogspot.in/2008/07/calculating-nth-percentile-in-mysql.html http://rpbouman.blogspot.in/2009_03_01_archive.html
Read more