I suspect that working with Drill via generic ODBC driver
(even with customizations written in MapRDrillODBC.tdc file) has limitations --
such as extracting Weekday or Weeknumber in particular.
One could investigate it further -- may be by making adjustments
to MapRDrillODBC.tdc file, using this Tableau document as a reference:
The last two customization strings in MapRDrillODBC.tdc file --
those with SQL_TIMEDATE -- are of interest to start with.
Others of SQL_TIMEDATE / DATETIME family are of interest as well.
Hope this could help a bit.
I understand that this would be a pure trial-and-error exercise.
Whether to ask Tableau folks (or better Drill ones) -- you decide.
Thanks a lot, that was very helpful. I need to play a little bit more with the values but it's almost working.
It would be of great help to hear about
customizations that work for you (finally).
Sure, I'll post once as soon as it's working properly. Besides the TDC file, I had to patch both Drill and Calcite to add support for Week and Weekdays, and I think I still need to implement a few more functions before the experience is smooth.