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.