{
“type” : “index”,
“spec” : {
“dataSchema” : {
“dataSource” : “charge”,
“parser” : {
“type” : “string”,
“parseSpec” : {
“format” : “csv”,
“columns”: [
“user_id”,
“pile_id”,
“start_time”,
“end_time”,
“create_time”,
“quantity”,
“charge_price”
],
“dimensionsSpec” : {
“dimensions” : [
“user_id”,
“pile_id”,
“start_time”,
“end_time”,
“create_time”,
{ “name” : “quantity”, “type” : “float” },
{ “name” : “charge_price”, “type” : “float” }
]
},
“timestampSpec” : {
“format” : “auto”,
“column” : “start_time”
}
}
},
“metricsSpec” : ,
“granularitySpec” : {
“type” : “uniform”,
“segmentGranularity” : “day”,
“queryGranularity” : “none”,
“intervals” : [“2000-06-27/2017-07-20”],
“rollup” : false
}
},
“ioConfig” : {
“type” : “index”,
“firehose” : {
“type” : “local”,
“baseDir” : “quickstart/”,
“filter” : “charge.csv”,
},
“appendToExisting” : false
},
“tuningConfig” : {
“type” : “index”,
“targetPartitionSize” : 5000000,
“maxRowsInMemory” : 25000,
“forceExtendableShardSpecs” : true
}
}
}
``
Here are a few lines of my csv data:
“1461047878564306”,“1110105001007002”,“2016-04-19 14:46:01”,“2016-04-19 16:01:20”,“2016/4/19 16:01:20”,26.35,31.62
“1457521991343639”,“1014570992883692906”,“2016-04-01 17:55:32”,“2016-04-01 18:52:16”,“2016/4/1 18:52:40”,1861.0,22.33
“1459649854475645”,“1110113001001006”,“2016-04-04 14:33:07”,“2016-04-06 11:36:08”,“2016/4/6 11:36:08”,56187302.0,0.0
…
``
My task finishes with no error, but I cannot view my data. My dsql queries return “no charge table” exception, and when I check my overload console, it shows my task’s status as ‘success’. However when I check my broker at 8082 there is no index task nor a new table. What have I done wrong here?