1 Reply Latest reply on Nov 9, 2017 10:44 AM by patrick.byrne.0

    Impala to Tableau issue

    sandeep kumar

      @

      My calculated fields are coming as null values when i connect to impala from tableau in LIVE connection mode.

      Had anyone faced the same issue. please provide me your inputs, if there is any workaround

      Forums

        • 1. Re: Impala to Tableau issue
          patrick.byrne.0

          Hello Sandeep,

           

          I found the following information on Impala and Tableau.

           

          NULL value returned

          A NULL value is returned when you open a workbook in Tableau 9.0.1 and later and 8.3.5 and later 8.3.x releases that was created in an earlier version and has date/time data stored as a string in a format that Hive doesn't support. To resolve this issue, change the field type back to String and create a calculated field using DATEPARSE() or DATE() to convert the date. Use DATEPARSE() when working with an extract, otherwise use the DATE() function.

           

          Hope this helps!

           

          Cheers,

          Byrne, Patrick