Error when using Custom SQL containing Date parameter with Impala

Published: 01 Aug 2017
Last Modified Date: 01 Aug 2017


When connecting to Cloudera Hadoop Impala using Custom SQL with a Date parameter in Tableau Desktop, the following error occurs: 
[Cloudera][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] : AnalysisException: Unsupported data type: DATE Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database.


  • Tableau Desktop 10.3.1, 10.1.6, 10.0.5, 9.3.11
  • Cloudera Hadoop Impala



Option 1

Use a date time parameter instead of a date.

Note: This may not display as cleanly in the parameter control, for example 1/1/2001 may show as 1/1/2001 00:00:00. 

Option 2

Remove the date causing the issue from the custom SQL query and add it as a data source filter instead. 
Did this article resolve the issue?