KNOWLEDGE BASE

Date Parameter Does Not Return Expected Data with Impala Connection in Tableau Desktop


Published: 08 Sep 2016
Last Modified Date: 22 Mar 2017

Issue

When connected to Cloudera Impala, certain parameter-based date calculations fail to return expected data. 

This issue can been seen in calculations such as the following where a calculated field is used to convert the date type parameter to strings:

[string date field]=STR([date parameter])

Environment

  • Tableau Desktop 8.3-9.2.14, 9.3.0-9.3.9, 10.0.0-10.0.3, 10.1.0-10.1.1
  • Cloudera Hadoop Impala

Resolution

Option 1

Upgrade to 9.2.15, 9.3.11, 10.0.5, 10.1.3 or later version. For more information, see Upgrading Tableau Desktop.

Option 2

If unable to upgrade, try changing the calculated field to convert the string date field to a date instead of changing the date parameter to a string, such as below:

DATE([string date field])=[date parameter]

Cause

  • This behavior is related to a known issue (ID 560077) which has been fixed in later versions of the product.
  • In older versions, Impala forces a strict date format that is only represented as "YYYY-MM-DD HH:mm:ss" which appears to push the date parameter to include a 00:00:00 timestamp at the end. Therefore, the string conversion does not match the date string if it only reflects "YYYY-MM-DD" information.
Did this article resolve the issue?