Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: how to add maximum length for GROUP_CONCAT in pentaho report designer

  1. #1
    Join Date
    Feb 2010
    Posts
    114

    Question how to add maximum length for GROUP_CONCAT in pentaho report designer

    Dear All,

    In one report I am using group_concat() function of mysql but it shows limited data as it has default value 1024 char.

    If i am adding SET SESSION GROUP_CONCAT_MAX_LEN = 1000000; run it on SQLYog then it shows data but when same query i am trying to add PRD 3.6 it gives error. PRD is not allowing me to add GROUP_CONCAT_MAX_LEN to increase length for group_concat function.

    query is :-

    SET SESSION GROUP_CONCAT_MAX_LEN = 1000000;
    SELECT employee.department, Group_concat(employee.name) as empName
    from employee
    group by employee.department

    Anyone suggest me how to increase length of group_concat function??????

  2. #2
    Join Date
    Feb 2010
    Posts
    114

    Default

    Dear All,

    I have forgot to SET GLOBAL previliges to increase length.

    here it is :- SET GLOBAL group_concat_max_len = 1000000;

    issue resolved.

  3. #3
    Join Date
    Jun 2016
    Posts
    107

    Default

    Hi All,

    I am also facing this issue.Anyone please suggest me.

  4. #4
    Join Date
    Feb 2010
    Posts
    114

    Default

    Quote Originally Posted by Jahnavi View Post
    Hi All,

    I am also facing this issue.Anyone please suggest me.
    Plz check my blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.