0 Replies Latest reply on Mar 31, 2014 8:46 PM by Tableau Evaluation

    Errors with Infobright Community Edition

    Tableau Evaluation

      I have always had issues with using Tableau with Infobright Community Edition(ICE).

      There are some older threads describing a TDC to use, which I've used.

       

      However the problem I am having now is that Tableau reports an error communicating with the datasource.

      The error is from the MYSQL driver, "Brighthouse other specific error: type not supported".

      When I find the underlying SQL query and run it directly against ICE, I do indeed get the error message.

      Error Code: 1105

      Brighthouse other specific error: type not supported

       

      The formatted SQL query is below.

      Does anybody know what might be causing this, and is there some way of stopping this occuring (e.g. in a TDC file).

       

      SELECT

        `subscription_model`.`suboffer_id` AS `none_suboffer_id_ok`,

        COUNT(

          DISTINCT `subscription_model`.`user_id`

        ) AS `usr_Calculation_8360327173757343_ok`

      FROM

        `subscription_model`

      WHERE (

          (

            `subscription_model`.`subscription_type` = 'current'

          )

          AND (

            ADDDATE(

              CONCAT(

                DATE_FORMAT(

                  `subscription_model`.`subscription_modified`,

                  '%Y-'

                ),

                (

                  3 * (

                    QUARTER(

                      `subscription_model`.`subscription_modified`

                    ) - 1

                  ) + 1

                ),

                '-01 00:00:00'

              ),

              INTERVAL 0 SECOND

            ) = TIMESTAMP('2014-01-01 00:00:00')

          )

        )

      GROUP BY 1 ;