Till now we had been using Hortonworks Hadoop Hive connector and had the following calculation:
IF LEFT(STR([DATE_FK]),6)=STR([VINT_FK]) THEN ACCOUNTS ELSE 0 END
This used to work fine so never really ran the query in hive to check results.
Now, we have shifted to ODBC DSN with Kerberos and the above calculation is not working. Actually, it does Not work in Hive itself. The hive alternate is:
SUBSTR(CAST(DATE_FK AS STRING),0,6)=SUBSTR(CAST(VINT_FK AS STRING),0,6). But this does NOT fit in Tableau!
Also, in tableau, INT(String) is being sent as CAST(String as INT) to Hive and that is also failing in Hive!
How do I get these calculations modified in tableau with Hive ODBC DSN? Any suggestions?
One possibility that jumps to my mind is embedding the sql that works in a RAWSQL function in Tableau Desktop. See Pass-Through Functions (RAWSQL) - Tableau
Hope this helps
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...