0 Replies Latest reply on Feb 12, 2019 9:22 PM by devpriyo.bhattacharya

    LEFT, STR, INT tableau functions do Not work with Hive ODBC DSN

    devpriyo.bhattacharya

      Hi All,

       

      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?

       

      Best Regards