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 ;
Become a Viz Whiz on the Forums! Support the Community and master Tableau.