opensearch-project / opensearch-project/sql-jdbc
[BUG] Incorrect Timestamp Displayed in Tableau Desktop & Tableau Prep from OpenSearch Database
Nobody has claimed this yet.
- Dominant language
- Java
- Stars
- 28
- Forks
- 39
- PR merge metrics
- No merged PRs in 30d
Description
What is the bug?
Incorrect Timestamp Displayed in Tableau Desktop & Tableau Prep from OpenSearch Database.
When we load data into Tableau Desktop or Tableau Prep, the timestamp field incorrectly display the year as 1970. However, the actual timestamp in the OpenSearch JSON is correctly recorded as 2025.
How can one reproduce the bug?
Steps to reproduce the behavior:
- Please refer to the attached figures.
- Install the required .taco and drivers for opensearch and Tableau Desktop to communicate.
- Open Tableau Desktop and connect OpenSearch by OpenSearch Project
- After reading the data, preview one of the tables containing timestamp
- One can see the wrong year 1970, should be 2025
What is the expected behavior?
The timestamp should match the data in OpenSearch (2025) and not default to 1970 in Tableau Desktop and Tableau Prep.
What is your host/environment?
- OS: Linux CentOS 7.9 for OpenSearch
- OpenSearch by OpenSearch Project version: 1.3.19
- Connectors for opensearch and Tableau Desktop:
- opensearch_sql_jdbc.taco
- opensearch_sql_jdbc-v1.0.1.taco
- opensearch_sql_jdbc-1.1.0.1.jar
- Tableau Desktop Professional Edition 2024.3.2 (20243.24.1211.0901) Windows version
- Tableau Prep Builder 2024.3 (24.32.24.1209.1136) Windows version
Do you have any screenshots?
Install the required .taco and drivers for opensearch and Tableau Desktop to communicate:
Required .taco files
Required .jar file
OpenSearch Dashboard showing the original timestamp (which is the correct year 2025):
Connect OpenSearch to Tableau:
timestamp in Tableau Desktop showing the wrong year 1970, should be 2025:
Do you have any additional context?
Add any other context about the problem.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reproducing the timestamp conversion with the listed OpenSearch, .taco, and JDBC driver versions, using Tableau Desktop or Tableau Prep. Trace how the JDBC driver exposes the OpenSearch timestamp to Tableau. Done means the same timestamp displays as 2025 rather than 1970 in both affected Tableau applications.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 42/100