1 Reply Latest reply on Apr 24, 2018 2:23 PM by Patrick A Van Der Hyde

    Issue with DateTime data when Connecting Tableau with Hadoop through impala

    Rajesh Kota

      Hi,

       

      I am facing an issue with DateTime when connecting Tableau with Hadoop database through impala.

       

      In the hadoop database, i have a dimension 'DateTime' (YYYY-MM-DD HH:MM:SS AM/PM) which is in a string format.

       

      I converted that string format to datetime format in tableau.

       

      When i am working with Extract connection, the Datetime dimension is working fine and i can able to filter out values based on Time since i am using this field as filter. Where as in Live connection, the Datetime dimension is not working and if you try to filter out the values, data is not coming.

       

      I tried changing the datatype to TIMESTAMP using custom sql query but i am getting null values.

       

      I should use live connection for this data.

       

      Any way to handle this issue?

       

      Any help would be appreciated. Thanks in advance.