DATE() Returns NULL in Live Connection to MapR Hadoop Hive

Published: 14 Sep 2016
Last Modified Date: 14 Oct 2019


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.


  • Tableau Desktop
  • MapR Hadoop Hive


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. 


MapR Hadoop Hive expects a date format of yyyy-MM-dd or yyyy-MM-dd hh:mm:ss.
Did this article resolve the issue?