Error "ERROR 4286: Operator does not exist: timestamp" When Nesting Date Functions with Live Vertica Connection

Published: 13 Jan 2017
Last Modified Date: 22 Jan 2020


When attempting to nest date functions with a live connection to Vertica (e.g. DATEPART within a DATEADD calculation), the following error might occur:
"ERROR 4286: Operator does not exist: timestamp   time HINT: No operator matches the given name and argument type(s). You may need to add explicit type casts."


  • Tableau Desktop
  • Tableau Server
  • Vertica (Live connection)


Option 1

Upgrade to Tableau Desktop 2019.2.4, 2019.1.8, 2018.3.11 or a newer version. Click here for downloads of current and previous versions of Tableau Desktop: Tableau Desktop Downloads and Release Notes.  For more information on current releases, see Upgrade Tableau Desktop and Desktop Upgrade.

Option 2

Wrap the nested portion of the function in INT().  
For example, DATEADD('date_part', (DATEPART(date_part, [Date1]), [Date2]) can be edited to DATEADD('date_part', INT((DATEPART(date_part, [Date1])), [Date2])


The query to Vertica is not casting elements of the query as an integer.  For example, DATEADD requires an integer for the interval argument, however this was not occurring when that argument was a DATEPART function.

This behavior is related to a known issue (IDs: 603107 and 944192) that has been fixed in a recent version of Tableau Desktop. 
Did this article resolve the issue?