DimensionSpec for "Date/Time" Dimension


I am experimenting with Druid and have following dimensions

[T1, T2, D1, D2], Notice that T1 and T2 are of Date/Time and others are of type String.

My parser Spec / DimensionsSpec is something like this. I have excluded other portions for clarity

“parseSpec”: {

“format”: “tsv”,

“delimiter”: “|”,

“timestampSpec”: {

“column”: “T1”,

“format”: “yyyy-MM-dd HH:mm:ss”,


“columns”: [“T1”,





I understand that timeStampSpec is special and only one column can be specified with it. Is that understanding correct?

“dimensionsSpec”: {

“dimensions”: [



{ “type”: <??????????????> , “name”: “T2” }



My question is what should be type here for a Dimension of type Date/Time? Note that this is not the timeStamp of the event or record but some other Dimension of type Date/Time.