How can i load data without timestamp? please provide any solution if it is there.

[ranjan321]

Loading json which is not having any timestamp field.but not able to load as it is throwing exception timestampSpec is not available.

[QiuMM]

Data load to Druid must have a timestamp field, you can preprocess your data to add one.

[ghulands]

@QiuMM that is not accurate. If you have data that is partitioned and are ingesting it based on that partitioning you don't have to have a column in that data to contain an actual timestamp. You can specify the timestamp spec as follows

"timestampSpec": {
"format": "yyyy-MM-dd",
"column": "ts",
"missingValue": "2018-08-20"
}

ts does not need to exist.

Hope that helps @ranjan321

[QiuMM]

@ghulands Got it, thanks for your reminder.

[ranjan321]

@ghulands Thanks for your input..it is perfectly working fine