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