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



      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.