KNOWLEDGE BASE

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


Published: 14 Sep 2016
Last Modified Date: 05 Sep 2017

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.
Did this article resolve the issue?