Re-posted from #memsql-public-chat since this is a big question.
I am having a couple of issues with Tableau and MemSQL 6.7. I will post as separate messages to facilitate separate threads. One issue is with the built-in MemSQL connector and the other is from a workaround we are trying using the MySQL JDBC connector with Tableau (Tableau recently started supporting JDBC connectors).
Issue when using Tableau & MemSQL connector: When our columns are stored as
text in MemSQL, Tableau is truncating them to 8 characters. This problem goes away when we change the MemSQL column type to VARCHAR. We have a ticket open with Tableau but wondering if anyone else has seen this issue.
The other issue can actually be recreated outside of Tableau with a SQL client. Tableau is generated the following query which isn’t too special:
SELECT ADDDATE( DATE_FORMAT( `fact_surveys_columnstore`.`launched_at`, '%Y-%m-01 00:00:00' ), INTERVAL 0 SECOND ) AS `tmn_launched_at_ok` FROM `fact_surveys_columnstore` INNER JOIN `dim_survey` ON (`fact_surveys_columnstore`.`survey_id` = `dim_survey`.`id`) GROUP BY 1
It then complains about the type of
tmn_launched_at_ok not being correct. If I run this query in SequelPro, I can indeed see that the type is
Char whereas the expected return type for ADDDATE is DATETIME: https://docs.memsql.com/sql-reference/v6.7/date_add/