1 Reply Latest reply on Nov 1, 2018 12:46 PM by Patrick A Van Der Hyde

    Date conversion issue while connecting tableau to Impala(Hive) tables

    keerthy.reddy

      Hi All,

       

      i am having an issue with one of the date attribute in my table while connecting to impala-hive tables.

      i have a date column with string data type ex-(5/25/2018 11:40:37 AM) i need to show only years in my report. when i am using that attribute in my report by live connection m getting null values.i also tried by creating a calculated field with Mid it didn't work and date parse is not supported by hive.

       

      Looking for your responses.

      Thanks in advance.