Skip to content

Fork of Apache Calcite - Avatica to solve Weekday interpretation incompatibility between Apache Druid and Tableau

License

Notifications You must be signed in to change notification settings

akrymskiy/calcite-avatica

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Apache Calcite -- Avatica

The purpose of this fork is to solve a specific issue querying data in Apache Druid from Tableau, where weekday names are incorrectly presented due to Tableau expecting Sunday=1, ..., Saturday=7 and Druid using the Monday=1, ..., Sunday=7 scheme. The "fix" is accomplished by modifying SQL string passed into AvaticaStatement.executeInternal method, wrapping weekday related functions into a SQL CASE statement, which adjust the numeric values returned by Druid to Tableau's liking.

To build the shaded JDBC jar - clone this repository and issue the following in the repository root folder:

Mac/Unix:

./gradle build -p shaded -Prelease

Windows:

gradlew build -p shaded -Prelease

About

Fork of Apache Calcite - Avatica to solve Weekday interpretation incompatibility between Apache Druid and Tableau

Topics

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages

  • Java 93.4%
  • Kotlin 2.6%
  • SCSS 1.7%
  • HTML 1.0%
  • Shell 0.7%
  • Dockerfile 0.3%
  • Ruby 0.3%