can anyone suggest me whats wrong in this csv file uploading query..
this is my query for my csv file.
{
"type" : "index",
"dataSource" : "newcarpurchaseinquiries_fullarchiveon28032018",
"granularitySpec" : {
"type" : "string",
"gran" : "date",
"intervals" : [ "2018-01-10/2018-01-10" ]
},
"aggregators" : [ {
"type" : "count",
"name" : "count"
}, {
"type" : "doubleSum",
"name" : "value",
"fieldName" : "value"
}],
"firehose" : {
"type" : "local",
"baseDir" : "/home/dwtest2/druid-0.12.2/quickstart",
"filter" : "newcarpurchaseinquiries_fullarchiveon28032018.csv",
"parser" : {
"timestampSpec" : {
"column" : "ReqDateTimeDatePart",
"format" : "auto"
},
"data" : {
"type" : "csv",
"columns" : [ "CustomerId",
"CarVersionId",
"Color",
"NoOfCars",
"BuyTime",
"Comments",
"RequestDateTime",
"IsApproved",
"IsFake",
"StatusId",
"IsForwarded",
"IsRejected",
"IsViewed",
"IsMailSend",
"TestdriveDate",
"TestDriveLocation",
"LatestOffers",
"ForwardedLead",
"SourceId",
"ReqDateTimeDatePart",
"VisitedDealership",
"CRM_LeadId",
"ClientIP",
"PQPageId",
"LTSRC",
"UtmaCookie",
"UtmzCookie"],
"dimensions" : [ "CustomerId",
"CarVersionId",
"Color",
"NoOfCars",
"BuyTime",
"Comments",
"RequestDateTime",
"IsApproved",
"IsFake",
"StatusId",
"IsForwarded",
"IsRejected",
"IsViewed",
"IsMailSend",
"TestdriveDate",
"TestDriveLocation",
"LatestOffers",
"ForwardedLead",
"SourceId",
"ReqDateTimeDatePart",
"VisitedDealership",
"CRM_LeadId",
"ClientIP",
"PQPageId",
"LTSRC",
"UtmaCookie",
"UtmzCookie"]
}
}
}
While loading above query i get following error mesaage
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1"/>
<title>Error 500 </title>
</head>
<body>
<h2>HTTP ERROR: 500</h2>
<p>Problem accessing /druid/indexer/v1/task. Reason:
<pre> javax.servlet.ServletException:
com.fasterxml.jackson.core.JsonParseException: Unexpected end-of-input:
expected close marker for OBJECT (from [Source:
HttpInputOverHTTP@2d5e6422[c=2096,q=0,[0]=null,s=EOF]; line: 1, column: 0])
at [Source: HttpInputOverHTTP@2d5e6422[c=2096,q=0,[0]=null,s=EOF]; line: 1,
column: 4193]</pre></p>
<hr /><a href="http://eclipse.org/jetty";>Powered by Jetty://
9.3.19.v20170502</a><hr/>
</body>
</html>
Please suggest me if any changes.And my csv file doesnt contain 1st column
named as timestamp it has "id"...
So what should i do for uploading the above query.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@druid.apache.org
For additional commands, e-mail: dev-h...@druid.apache.org
