1 Reply Latest reply on Mar 20, 2016 8:04 PM by Bill Lyons

    Getting Null while converting string into date while extracting data from Hive through Denodo

    chinmaya jena

      Hi,

       

      I have been searching some solution for this kind of conversion issue in tableaue desktop 9.2. My source system is hadoop. I am getting some site related data from Hadoop and date field coming as string like "yyyy-mm-dd". I have tried all the options but could not get rid of null value issue.

      tried extract instead of live and use date function or dateparse( it says not supported ) and left ,right ,mid function and concatenate and convert to date but got error even doing that. I got same null values while writing custom sql, so now not having any option . Please help me.I am newbie in this area.