KNOWLEDGE BASE
DATE() Returns NULL in Live Connection to MapR Hadoop Hive
Published: 14 Sep 2016
Last Modified Date: 09 Dec 2022
Issue
When 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.
Environment
- Tableau Desktop
- MapR Hadoop Hive
Resolution
Option 1
Modify the formula to use one of the following date formats:
- yyyy-MM-dd
- yyyy-MM-dd hh:mm:ss
Option 2
Change the field type back to String. For more information, see NULL value returned in Tableau Help.
Cause
MapR Hadoop Hive expects a date format of yyyy-MM-dd or yyyy-MM-dd hh:mm:ss.