1 Reply Latest reply on Mar 7, 2019 11:16 AM by patrick.byrne.0

    Custom SQL for Tableau/Qubole link

    Alexander Stockler

      Hi Everyone!

       

      I just connected up Tableau to the Qubole API but whenever I run a custom SQL query I can see that Tableau is adding "s to the query like this:

       

      ...extract from query as typed in:

       

       

      "Sum(case when cast(ContentPromoter as varchar) !='' or ContentPromoter is null then cast(ContentPromoter as double) else 0 end) as ContentPromoter"

       

      When I look in the Qubole API I can see that it has actually been sent there as Sum(case when cast(ContentPromoter as "varchar") !='' or ContentPromoter is null then cast(ContentPromoter as double) else 0 end) as ContentPromoter

       

      Any ideas of how to stop this?

       

      Thanks!

       

      Alex