Druid unable to publish string type dimesion

HI,
i create below specification :

{

“type”: “index”,

“spec”: {

“ioConfig”: {

“type”: “index”,

“firehose”: {

“baseDir”: “/data/c2m/druid-data/jsonDruid/”,

“filter”: “c2mkeyspace_346-c2mtable_29272.json”,

“type”: “local”

},

“appendToExisting”: true

},

“dataSchema”: {

“dataSource”: “c2mtable_29272”,

“granularitySpec”: {

“type”: “uniform”,

“segmentGranularity”: “hour”,

“queryGranularity”: “none”

},

“parser”: {

“type”: “string”,

“parseSpec”: {

“format”: “json”,

“dimensionsSpec”: {

“dimensions”: [

{

“name”: “disdouble”,

“type”: “double”

},

{

“name”: “accdecmial”,

“type”: “decimal”

},

{

“name”: “c2mversion”,

“type”: “bigint”

},

{

“name”: “c2mseqno”,

“type”: “bigint”

},

“opstring”,

{

“name”: “c2mdatetime”,

“type”: “timestamp”

},

“shipString”,

{

“name”: “c2muserid”,

“type”: “bigint”

},

{

“name”: “odouble”,

“type”: “double”

},

{

“name”: “sdouble”,

“type”: “double”

},

{

“name”: “c2mfeedid”,

“type”: “bigint”

}

],

“dimensionExclusions”: ,

“spatialDimensions”:

},

“timestampSpec”: {

“column”: “c2mdatetime”,

“format”: “auto”

}

}

},

“metricsSpec”: [

{

“type”: “doubleSum”,

“name”: “odouble_sum”,

“fieldName”: “odouble”

},

{

“type”: “doubleMin”,

“name”: “odouble_min”,

“fieldName”: “odouble”

},

{

“type”: “doubleMax”,

“name”: “odouble_max”,

“fieldName”: “odouble”

},

{

“type”: “doubleSum”,

“name”: “sdouble_sum”,

“fieldName”: “sdouble”

},

{

“type”: “doubleMin”,

“name”: “sdouble_min”,

“fieldName”: “sdouble”

},

{

“type”: “doubleMax”,

“name”: “sdouble_max”,

“fieldName”: “sdouble”

},

{

“type”: “doubleSum”,

“name”: “disdouble_sum”,

“fieldName”: “disdouble”

},

{

“type”: “doubleMin”,

“name”: “disdouble_min”,

“fieldName”: “disdouble”

},

{

“type”: “doubleMax”,

“name”: “disdouble_max”,

“fieldName”: “disdouble”

},

{

“type”: “doubleSum”,

“name”: “accdecmial_sum”,

“fieldName”: “accdecmial”

},

{

“type”: “doubleMin”,

“name”: “accdecmial_min”,

“fieldName”: “accdecmial”

},

{

“type”: “doubleMax”,

“name”: “accdecmial_max”,

“fieldName”: “accdecmial”

},

{

“type”: “count”,

“name”: “count”,

“fieldName”: null

}

]

},

“tuningConfig”: {

“type”: “index”,

“targetPartitionSize”: 5000000,

“maxRowsInMemory”: 75000,

“forceExtendableShardSpecs”: true

}

}

}

but when middle-manger process the task and i am not able to get data from string data type .

i unable to get data from “shipString” and “opstring” .please help me on this.

Capture-dimesion.PNG

task_log (108 KB)

Hi Vipin,
Can you give correct types like long for timestamp and bigint ?

I think druid stores __time and other timestamp columns of milliseconds as long.

timestamp and bigint are java datatypes. You might have to give correct datatypes in your ingestion spec.

Thanks,

–siva