DATE() Returns NULL in Live Connection to MapR Hadoop Hive
Published: 14 Sep 2016
Last Modified Date: 14 Oct 2019
IssueWhen connecting live to Mapr Hadoop Hive or refreshing a extract, then a calculated field using DATE() returns NULL values.
Making any change to the calculated field while the data source is extracted will temporarily fix the issue.
- Tableau Desktop
- MapR Hadoop Hive
Modify the formula to use one of the following date formats:
- yyyy-MM-dd hh:mm:ss
Change the field type back to String. For more information, see NULL value returned in Tableau Help.
CauseMapR Hadoop Hive expects a date format of yyyy-MM-dd or yyyy-MM-dd hh:mm:ss.