You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Karan Verma (Tech - BLR)" <ka...@flipkart.com> on 2016/07/07 04:26:18 UTC
Need help with hive's explode function.
Hi,
I'm working on writing a custom Map Reduce job, which mimics a hive query.
This query works on JSON type data and there are multiple nested lists,
which are exploded. I have been struggling with writing an Exploder class
which is very specific to the data. I just can't seem to get the number of
outputs correct. I'll mail you the details, just let me know, if you'd be
willing to help me on this.
Thanks,
Karan.
Re: Need help with hive's explode function.
Posted by "Karan Verma (Tech - BLR)" <ka...@flipkart.com>.
This is how an example row looks like:
{
"schemaVersion": "8.1",
"data": {
"referenceId": "532ecc06-64c4-42f2-836f-f7327b5db164",
"clientId": "94a955e8-9608-43a6-9b22-7cb45f1a5343",
"customerDetails": {
"customerId": "ACCB376AAB538FD4128AFAF9DEB73DA9E26B"
},
"salesChannel": "AndroidApp",
"destinationPincode": "577201",
"timestamp": "2016-05-25T07:33:41.410",
"listingSourcePromiseDetails": [{
"listingDetails": {
"listingId": "listingIdSeven",
"categoryId": "20002",
"sellerId": "f67a393d10584f7b",
"itemSize": "Small",
"sellingPrice": 350,
"quantity": 1,
"serviceProfile": "NON_FBF",
"itemType": "PHYSICAL",
"listingState": "current",
"deliveryOption": "delivery",
"supplyChainTypes": [],
"freebie": false
},
"sourcePromiseDetails": [{
"tier": "REGULAR",
"promiseDetails": {
"slotted": false,
"allottedSources": [],
"holidays": [],
"codEnabled": false,
"prepaidEnabled": false
}
}, {
"tier": "EXPRESS",
"promiseDetails": {
"slotted": false,
"allottedSources": [],
"holidays": [],
"codEnabled": false,
"prepaidEnabled": false
}
}, {
"tier": "PREMIUM",
"promiseDetails": {
"slotted": false,
"allottedSources": [],
"holidays": [],
"codEnabled": false,
"prepaidEnabled": false
}
}, {
"tier": "ECONOMY"
}]
}, {
"listingDetails": {
"listingId": "listingIdOne",
"categoryId": "20002",
"sellerId": "1620abcb20f442d9",
"itemSize": "Small",
"sellingPrice": 340,
"quantity": 1,
"serviceProfile": "NON_FBF",
"itemType": "PHYSICAL",
"listingState": "current",
"deliveryOption": "delivery",
"supplyChainTypes": [],
"freebie": false
},
"sourcePromiseDetails": [{
"tier": "REGULAR",
"promiseDetails": {
"promiseBeforeDate": "2016-06-02T23:59:59.000",
"cutoffDate": "2016-05-28T10:00:00.000",
"shippingCharges": 0,
"slotted": false,
"allottedSources": [{
"sourcePincode": "110084",
"quantityAllotted": 1,
"epht": "2016-05-28T00:00:00.000",
"lpht": "2016-05-28T10:01:00.000",
"slas": [{
"sla": 5760,
"slaType": "Logistics"
}],
"shipmentMovementType": "inter_zone",
"zoneBuffer": 0,
"promiseDate": "2016-06-02T10:01:00.000",
"holidays": [{
"reason": "SUNDAY",
"startTime": "2016-05-29T00:00:00.000",
"endTime": "2016-05-29T23:59:59.000",
"displayable": true,
"holidayType": "logistics"
}],
"promiseSubType": "SELLER",
"source": {
"warehouse": "all",
"type": "seller",
"slas": [{
"sla": 0,
"slaType": "Warehouse"
}, {
"sla": 3,
"slaType": "Proc"
}],
"holidays": [],
"quantity": 13,
"atpThreshold": 0,
"softReservation": 0,
"oos": false,
"overrideThreshold": 0,
"sourcePincode": "110084",
"effectiveQuantity": 13
},
"pickupCompletionDate": "null",
"logisticsCompletionDate": "2016-06-02T10:01:00.000",
"dispatchCutoff": "2016-05-28T10:00:00+0530",
"dispatchSlotDetails": [{
"source": "Alipur_DEL_PL",
"logisticsType": "EKL",
"startTime": "2016-05-25T07:33:41.425",
"endTime": "2016-05-28T10:00:00.000",
"orderCutoffTime": "2016-05-28T09:55:00.000",
"availableCapacityDetails": [{
"sourceCapacity": 6012,
"sourceRunningCounter": 5309.91175,
"planCapacity": 6012,
"planRunningCounter": 3091.14367,
"priority": 1,
"distributionProfile": 0.642,
"cutoff": "2016-05-25T10:00:00.000"
}, {
"sourceCapacity": 6012,
"sourceRunningCounter": 2453.55606,
"planCapacity": 6012,
"planRunningCounter": 1448.96851,
"priority": 1,
"distributionProfile": 0.3151,
"cutoff": "2016-05-26T10:00:00.000"
}, {
"sourceCapacity": 6012,
"sourceRunningCounter": 269.65157,
"planCapacity": 6012,
"planRunningCounter": 156.86232,
"priority": 1,
"distributionProfile": 0.0354,
"cutoff": "2016-05-27T10:00:00.000"
}, {
"sourceCapacity": 6012,
"sourceRunningCounter": 3.84151,
"planCapacity": 6012,
"planRunningCounter": 1.79148,
"priority": 1,
"distributionProfile": 0.0074,
"cutoff": "2016-05-28T10:00:00.000"
}]
}],
"sellerCapability": "REGULAR",
"dispatchServiceTier": "REGULAR"
}],
"holidays": [{
"reason": "SUNDAY",
"startTime": "2016-05-29T00:00:00.000",
"endTime": "2016-05-29T23:59:59.000",
"displayable": true,
"holidayType": "logistics"
}],
"codEnabled": true,
"prepaidEnabled": true
},
"eligibleSourcesDetails": []
}, {
"tier": "EXPRESS",
"ineligibleSourcesDetails": [{
"sourceType": "seller",
"warehouse": "all",
"sourcePincode": "110084",
"ineligibilityCode": "NOT_SERVICEABLE",
"availableQuantity": 13,
"effectiveQuantity": 13,
"sellerCapability": "REGULAR",
"dispatchServiceTier": "REGULAR"
}],
"promiseDetails": {
"promiseBeforeDate": "2016-05-25T23:59:59.000",
"cutoffDate": "2016-05-25T07:33:41.459",
"shippingCharges": 0,
"slotted": false,
"allottedSources": [],
"holidays": [],
"codEnabled": false,
"prepaidEnabled": false
}
}, {
"tier": "PREMIUM",
"ineligibleSourcesDetails": [{
"sourceType": "seller",
"warehouse": "all",
"sourcePincode": "110084",
"ineligibilityCode": "NOT_SERVICEABLE",
"availableQuantity": 13,
"effectiveQuantity": 13,
"sellerCapability": "REGULAR",
"dispatchServiceTier": "REGULAR"
}],
"promiseDetails": {
"promiseBeforeDate": "2016-05-25T23:59:59.000",
"cutoffDate": "2016-05-25T07:33:41.459",
"shippingCharges": 0,
"slotted": false,
"allottedSources": [],
"holidays": [],
"codEnabled": false,
"prepaidEnabled": false
}
}, {
"tier": "ECONOMY",
"eligibleSourcesDetails": [{
"epht": "2016-05-28T00:00:00.000",
"lpht": "2016-05-28T10:01:00.000",
"slas": [{
"sla": 5760,
"slaType": "Logistics"
}],
"shipmentMovementType": "inter_zone",
"zoneBuffer": 0,
"promiseDate": "2016-06-02T10:01:00.000",
"holidays": [{
"reason": "SUNDAY",
"startTime": "2016-05-29T00:00:00.000",
"endTime": "2016-05-29T23:59:59.000",
"displayable": true,
"holidayType": "logistics"
}],
"source": {
"warehouse": "all",
"type": "seller",
"slas": [{
"sla": 0,
"slaType": "Warehouse"
}, {
"sla": 3,
"slaType": "Proc"
}],
"holidays": [{
"reason": "weekly holiday",
"startTime": "2016-06-12T00:00:00.000",
"endTime": "2016-06-12T23:59:59.000",
"displayable": false,
"holidayType": "seller"
}, {
"reason": "weekly holiday",
"startTime": "2016-06-05T00:00:00.000",
"endTime": "2016-06-05T23:59:59.000",
"displayable": false,
"holidayType": "seller"
}, {
"reason": "weekly holiday",
"startTime": "2016-06-19T00:00:00.000",
"endTime": "2016-06-19T23:59:59.000",
"displayable": false,
"holidayType": "seller"
}, {
"reason": "weekly holiday",
"startTime": "2016-05-29T00:00:00.000",
"endTime": "2016-05-29T23:59:59.000",
"displayable": false,
"holidayType": "seller"
}, {
"reason": "Holiday",
"startTime": "2016-04-10T00:00:00.000",
"endTime": "2016-04-10T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-03-13T00:00:00.000",
"endTime": "2016-03-13T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-04-24T00:00:00.000",
"endTime": "2016-04-24T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-03-06T00:00:00.000",
"endTime": "2016-03-06T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-05-08T00:00:00.000",
"endTime": "2016-05-08T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-03-20T00:00:00.000",
"endTime": "2016-03-20T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-02-21T00:00:00.000",
"endTime": "2016-02-21T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-02-28T00:00:00.000",
"endTime": "2016-02-28T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-04-17T00:00:00.000",
"endTime": "2016-04-17T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-06-26T00:00:00.000",
"endTime": "2016-06-26T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-03-27T00:00:00.000",
"endTime": "2016-03-27T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-05-22T00:00:00.000",
"endTime": "2016-05-22T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-01-24T00:00:00.000",
"endTime": "2016-01-24T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-01-31T00:00:00.000",
"endTime": "2016-01-31T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-02-07T00:00:00.000",
"endTime": "2016-02-07T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-01-26T00:00:00.000",
"endTime": "2016-01-26T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-06-19T00:00:00.000",
"endTime": "2016-06-19T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-06-05T00:00:00.000",
"endTime": "2016-06-05T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-04-03T00:00:00.000",
"endTime": "2016-04-03T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-06-12T00:00:00.000",
"endTime": "2016-06-12T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-02-14T00:00:00.000",
"endTime": "2016-02-14T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-05-15T00:00:00.000",
"endTime": "2016-05-15T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-05-01T00:00:00.000",
"endTime": "2016-05-01T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-03-24T00:00:00.000",
"endTime": "2016-03-24T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-05-29T00:00:00.000",
"endTime": "2016-05-29T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}],
"quantity": 13,
"atpThreshold": 0,
"softReservation": 0,
"oos": false,
"overrideThreshold": 0,
"sourcePincode": "110084",
"effectiveQuantity": 13
},
"promiseSubType": "SELLER",
"pickupCompletionDate": "null",
"logisticsCompletionDate": "2016-06-02T10:01:00.000",
"dispatchCutoff": "2016-05-28T10:00:00+0530",
"dispatchSlotDetails": [{
"source": "Alipur_DEL_PL",
"logisticsType": "EKL",
"startTime": "2016-05-25T07:33:41.427",
"endTime": "2016-05-28T10:00:00.000",
"orderCutoffTime": "2016-05-28T10:00:00.000",
"availableCapacityDetails": [{
"sourceCapacity": 6012,
"sourceRunningCounter": 5309.91175,
"planCapacity": 6012,
"planRunningCounter": 2218.76808,
"priority": 100,
"distributionProfile": 0.642,
"cutoff": "2016-05-25T10:00:00.000"
}, {
"sourceCapacity": 6012,
"sourceRunningCounter": 2453.55606,
"planCapacity": 6012,
"planRunningCounter": 1004.58755,
"priority": 100,
"distributionProfile": 0.3151,
"cutoff": "2016-05-26T10:00:00.000"
}, {
"sourceCapacity": 6012,
"sourceRunningCounter": 269.65157,
"planCapacity": 6012,
"planRunningCounter": 112.78925,
"priority": 100,
"distributionProfile": 0.0354,
"cutoff": "2016-05-27T10:00:00.000"
}, {
"sourceCapacity": 6012,
"sourceRunningCounter": 3.84151,
"planCapacity": 6012,
"planRunningCounter": 2.05003,
"priority": 100,
"distributionProfile": 0.0074,
"cutoff": "2016-05-28T10:00:00.000"
}]
}],
"sellerCapability": "REGULAR",
"dispatchServiceTier": "REGULAR"
}]
}]
}, {
"listingDetails": {
"listingId": "listingIdTwo",
"categoryId": "20002",
"sellerId": "6aea101d3faa4d29",
"itemSize": "Small",
"sellingPrice": 535,
"quantity": 1,
"serviceProfile": "NON_FBF",
"itemType": "PHYSICAL",
"listingState": "current",
"deliveryOption": "delivery",
"supplyChainTypes": [],
"freebie": false
},
"sourcePromiseDetails": [{
"tier": "REGULAR",
"promiseDetails": {
"promiseBeforeDate": "2016-06-03T23:59:59.000",
"cutoffDate": "2016-05-28T09:55:00.000",
"shippingCharges": 0,
"slotted": false,
"allottedSources": [{
"sourcePincode": "400604",
"quantityAllotted": 1,
"epht": "2016-05-28T00:00:00.000",
"lpht": "2016-05-28T14:00:00.000",
"slas": [{
"sla": 6240,
"slaType": "Logistics"
}],
"shipmentMovementType": "inter_zone",
"zoneBuffer": 0,
"promiseDate": "2016-06-03T20:30:00.000",
"holidays": [{
"reason": "SUNDAY",
"startTime": "2016-05-29T00:00:00.000",
"endTime": "2016-05-29T23:59:59.000",
"displayable": true,
"holidayType": "logistics"
}],
"promiseSubType": "SELLER",
"source": {
"warehouse": "all",
"type": "seller",
"slas": [{
"sla": 0,
"slaType": "Warehouse"
}, {
"sla": 3,
"slaType": "Proc"
}],
"holidays": [],
"quantity": 50,
"atpThreshold": 0,
"softReservation": 0,
"oos": false,
"overrideThreshold": 0,
"sourcePincode": "400604",
"effectiveQuantity": 50
},
"pickupCompletionDate": "2016-05-28T22:00:00.000",
"logisticsCompletionDate": "2016-06-03T20:30:00.000",
"dispatchCutoff": "2016-05-28T10:00:00+0530",
"dispatchSlotDetails": [{
"source": "ThaneHub_MUM_PL",
"logisticsType": "EKL",
"startTime": "2016-05-25T10:01:00.000",
"endTime": "2016-05-28T10:00:00.000",
"orderCutoffTime": "2016-05-28T09:55:00.000",
"availableCapacityDetails": [{
"sourceCapacity": 486,
"sourceRunningCounter": 185.26499,
"planCapacity": 486,
"planRunningCounter": 143.29266,
"priority": 1,
"distributionProfile": 0.9228,
"cutoff": "2016-05-26T10:00:00.000"
}, {
"sourceCapacity": 486,
"sourceRunningCounter": 31.58216,
"planCapacity": 486,
"planRunningCounter": 23.33853,
"priority": 1,
"distributionProfile": 0.0614,
"cutoff": "2016-05-27T10:00:00.000"
}, {
"sourceCapacity": 486,
"sourceRunningCounter": 2.21765,
"planCapacity": 486,
"planRunningCounter": 1.61176,
"priority": 1,
"distributionProfile": 0.0158,
"cutoff": "2016-05-28T10:00:00.000"
}]
}],
"sellerCapability": "REGULAR",
"dispatchServiceTier": "REGULAR"
}],
"holidays": [{
"reason": "SUNDAY",
"startTime": "2016-05-29T00:00:00.000",
"endTime": "2016-05-29T23:59:59.000",
"displayable": true,
"holidayType": "logistics"
}],
"codEnabled": true,
"prepaidEnabled": true
},
"eligibleSourcesDetails": []
}, {
"tier": "EXPRESS",
"ineligibleSourcesDetails": [{
"sourceType": "seller",
"warehouse": "all",
"sourcePincode": "400604",
"ineligibilityCode": "NOT_SERVICEABLE",
"availableQuantity": 50,
"effectiveQuantity": 50,
"sellerCapability": "REGULAR",
"dispatchServiceTier": "REGULAR"
}],
"promiseDetails": {
"promiseBeforeDate": "2016-05-25T23:59:59.000",
"cutoffDate": "2016-05-25T07:33:41.457",
"shippingCharges": 0,
"slotted": false,
"allottedSources": [],
"holidays": [],
"codEnabled": false,
"prepaidEnabled": false
}
}, {
"tier": "PREMIUM",
"ineligibleSourcesDetails": [{
"sourceType": "seller",
"warehouse": "all",
"sourcePincode": "400604",
"ineligibilityCode": "NOT_SERVICEABLE",
"availableQuantity": 50,
"effectiveQuantity": 50,
"sellerCapability": "REGULAR",
"dispatchServiceTier": "REGULAR"
}],
"promiseDetails": {
"promiseBeforeDate": "2016-05-25T23:59:59.000",
"cutoffDate": "2016-05-25T07:33:41.458",
"shippingCharges": 0,
"slotted": false,
"allottedSources": [],
"holidays": [],
"codEnabled": false,
"prepaidEnabled": false
}
}, {
"tier": "ECONOMY",
"ineligibleSourcesDetails": [{
"sourceType": "seller",
"warehouse": "all",
"sourcePincode": "400604",
"ineligibilityCode": "NOT_SERVICEABLE",
"availableQuantity": 50,
"effectiveQuantity": 50,
"sellerCapability": "REGULAR",
"dispatchServiceTier": "REGULAR"
}]
}]
}, {
"listingDetails": {
"listingId": "listingIdThree",
"categoryId": "20002",
"sellerId": "709486803798420c",
"itemSize": "Small",
"sellingPrice": 493,
"quantity": 1,
"serviceProfile": "NON_FBF",
"itemType": "PHYSICAL",
"listingState": "current",
"deliveryOption": "delivery",
"supplyChainTypes": [],
"freebie": false
},
"sourcePromiseDetails": [{
"tier": "REGULAR",
"promiseDetails": {
"slotted": false,
"allottedSources": [],
"holidays": [],
"codEnabled": false,
"prepaidEnabled": false
}
}, {
"tier": "EXPRESS",
"promiseDetails": {
"slotted": false,
"allottedSources": [],
"holidays": [],
"codEnabled": false,
"prepaidEnabled": false
}
}, {
"tier": "PREMIUM",
"promiseDetails": {
"slotted": false,
"allottedSources": [],
"holidays": [],
"codEnabled": false,
"prepaidEnabled": false
}
}, {
"tier": "ECONOMY"
}]
}, {
"listingDetails": {
"listingId": "listingIdFour",
"categoryId": "20002",
"sellerId": "af4c82e7dd6e4a3c",
"itemSize": "Small",
"sellingPrice": 340,
"quantity": 1,
"serviceProfile": "NON_FBF",
"itemType": "PHYSICAL",
"listingState": "current",
"deliveryOption": "delivery",
"supplyChainTypes": [],
"freebie": false
},
"sourcePromiseDetails": [{
"tier": "REGULAR",
"promiseDetails": {
"slotted": false,
"allottedSources": [],
"holidays": [],
"codEnabled": false,
"prepaidEnabled": false
}
}, {
"tier": "EXPRESS",
"promiseDetails": {
"slotted": false,
"allottedSources": [],
"holidays": [],
"codEnabled": false,
"prepaidEnabled": false
}
}, {
"tier": "PREMIUM",
"promiseDetails": {
"slotted": false,
"allottedSources": [],
"holidays": [],
"codEnabled": false,
"prepaidEnabled": false
}
}, {
"tier": "ECONOMY"
}]
}, {
"listingDetails": {
"listingId": "listingIdFive",
"categoryId": "20002",
"sellerId": "c20e1014c462404a",
"itemSize": "Small",
"sellingPrice": 350,
"quantity": 1,
"serviceProfile": "NON_FBF",
"itemType": "PHYSICAL",
"listingState": "current",
"deliveryOption": "delivery",
"supplyChainTypes": [],
"freebie": false
},
"sourcePromiseDetails": [{
"tier": "REGULAR",
"promiseDetails": {
"promiseBeforeDate": "2016-06-01T23:59:59.000",
"cutoffDate": "2016-05-27T09:55:00.000",
"shippingCharges": 0,
"slotted": false,
"allottedSources": [{
"sourcePincode": "600029",
"quantityAllotted": 1,
"epht": "2016-05-27T00:00:00.000",
"lpht": "2016-05-27T14:00:00.000",
"slas": [{
"sla": 4800,
"slaType": "Logistics"
}],
"shipmentMovementType": "intra_zone",
"zoneBuffer": 0,
"promiseDate": "2016-06-01T10:00:00.000",
"holidays": [{
"reason": "SUNDAY",
"startTime": "2016-05-29T00:00:00.000",
"endTime": "2016-05-29T23:59:59.000",
"displayable": true,
"holidayType": "logistics"
}],
"promiseSubType": "SELLER",
"source": {
"warehouse": "all",
"type": "seller",
"slas": [{
"sla": 0,
"slaType": "Warehouse"
}, {
"sla": 2,
"slaType": "Proc"
}],
"holidays": [],
"quantity": 21,
"atpThreshold": 0,
"softReservation": 0,
"oos": false,
"overrideThreshold": 0,
"sourcePincode": "600029",
"effectiveQuantity": 21
},
"pickupCompletionDate": "2016-05-27T22:00:00.000",
"logisticsCompletionDate": "2016-06-01T10:00:00.000",
"dispatchCutoff": "2016-05-27T10:00:00+0530",
"dispatchSlotDetails": [{
"source": "Purasawakkam_CHN_PL",
"logisticsType": "EKL",
"startTime": "2016-05-25T10:01:00.000",
"endTime": "2016-05-27T10:00:00.000",
"orderCutoffTime": "2016-05-27T09:55:00.000",
"availableCapacityDetails": [{
"sourceCapacity": 4246,
"sourceRunningCounter": 4244.65662,
"planCapacity": 4246,
"planRunningCounter": 3516.51828,
"priority": 1,
"distributionProfile": 0.8658,
"cutoff": "2016-05-26T10:00:00.000"
}, {
"sourceCapacity": 4246,
"sourceRunningCounter": 433.48614,
"planCapacity": 4246,
"planRunningCounter": 345.47411,
"priority": 1,
"distributionProfile": 0.1343,
"cutoff": "2016-05-27T10:00:00.000"
}]
}],
"sellerCapability": "REGULAR",
"dispatchServiceTier": "REGULAR"
}],
"holidays": [{
"reason": "SUNDAY",
"startTime": "2016-05-29T00:00:00.000",
"endTime": "2016-05-29T23:59:59.000",
"displayable": true,
"holidayType": "logistics"
}],
"codEnabled": true,
"prepaidEnabled": true
},
"eligibleSourcesDetails": []
}, {
"tier": "EXPRESS",
"ineligibleSourcesDetails": [{
"sourceType": "seller",
"warehouse": "all",
"sourcePincode": "600029",
"ineligibilityCode": "NOT_SERVICEABLE",
"availableQuantity": 21,
"effectiveQuantity": 21,
"sellerCapability": "REGULAR",
"dispatchServiceTier": "REGULAR"
}],
"promiseDetails": {
"promiseBeforeDate": "2016-05-25T23:59:59.000",
"cutoffDate": "2016-05-25T07:33:41.458",
"shippingCharges": 0,
"slotted": false,
"allottedSources": [],
"holidays": [],
"codEnabled": false,
"prepaidEnabled": false
}
}, {
"tier": "PREMIUM",
"ineligibleSourcesDetails": [{
"sourceType": "seller",
"warehouse": "all",
"sourcePincode": "600029",
"ineligibilityCode": "NOT_SERVICEABLE",
"availableQuantity": 21,
"effectiveQuantity": 21,
"sellerCapability": "REGULAR",
"dispatchServiceTier": "REGULAR"
}],
"promiseDetails": {
"promiseBeforeDate": "2016-05-25T23:59:59.000",
"cutoffDate": "2016-05-25T07:33:41.458",
"shippingCharges": 0,
"slotted": false,
"allottedSources": [],
"holidays": [],
"codEnabled": false,
"prepaidEnabled": false
}
}, {
"tier": "ECONOMY",
"ineligibleSourcesDetails": [{
"sourceType": "seller",
"warehouse": "all",
"sourcePincode": "600029",
"ineligibilityCode": "NOT_SERVICEABLE",
"availableQuantity": 21,
"effectiveQuantity": 21,
"sellerCapability": "REGULAR",
"dispatchServiceTier": "REGULAR"
}]
}]
}, {
"listingDetails": {
"listingId": "listingIdSix",
"categoryId": "20002",
"sellerId": "q2v9khunnht032ml",
"itemSize": "Small",
"sellingPrice": 823,
"quantity": 1,
"serviceProfile": "NON_FBF",
"itemType": "PHYSICAL",
"listingState": "current",
"deliveryOption": "delivery",
"supplyChainTypes": [],
"freebie": false
},
"sourcePromiseDetails": [{
"tier": "REGULAR",
"promiseDetails": {
"promiseBeforeDate": "2016-06-24T23:59:59.000",
"cutoffDate": "2016-06-17T10:00:00.000",
"shippingCharges": 0,
"slotted": false,
"allottedSources": [{
"sourcePincode": "110002",
"quantityAllotted": 1,
"epht": "2016-06-17T00:00:00.000",
"lpht": "2016-06-17T14:00:00.000",
"slas": [{
"sla": 6359,
"slaType": "Logistics"
}],
"shipmentMovementType": "inter_zone",
"zoneBuffer": 0,
"promiseDate": "2016-06-23T10:00:00.000",
"holidays": [{
"reason": "SUNDAY",
"startTime": "2016-06-19T00:00:00.000",
"endTime": "2016-06-19T23:59:59.000",
"displayable": true,
"holidayType": "logistics"
}],
"promiseSubType": "SELLER",
"source": {
"warehouse": "all",
"type": "seller",
"slas": [{
"sla": 0,
"slaType": "Warehouse"
}, {
"sla": 14,
"slaType": "Proc"
}],
"holidays": [{
"reason": "weekly holiday",
"startTime": "2016-06-12T00:00:00.000",
"endTime": "2016-06-12T23:59:59.000",
"displayable": false,
"holidayType": "seller"
}, {
"reason": "weekly holiday",
"startTime": "2016-06-05T00:00:00.000",
"endTime": "2016-06-05T23:59:59.000",
"displayable": false,
"holidayType": "seller"
}, {
"reason": "weekly holiday",
"startTime": "2016-05-29T00:00:00.000",
"endTime": "2016-05-29T23:59:59.000",
"displayable": false,
"holidayType": "seller"
}, {
"reason": "Holiday",
"startTime": "2016-06-05T00:00:00.000",
"endTime": "2016-06-05T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-05-29T00:00:00.000",
"endTime": "2016-05-29T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-06-12T00:00:00.000",
"endTime": "2016-06-12T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}],
"quantity": 5,
"atpThreshold": 0,
"softReservation": 0,
"oos": false,
"overrideThreshold": 0,
"sourcePincode": "110002",
"effectiveQuantity": 5
},
"pickupCompletionDate": "2016-06-17T23:59:00.000",
"logisticsCompletionDate": "2016-06-23T10:00:00.000",
"dispatchCutoff": "2016-06-17T10:00:00+0530",
"dispatchSlotDetails": [{
"source": "DaryaganjMPHub_DEL_PL",
"logisticsType": "EKL",
"startTime": "2016-05-25T10:01:00.000",
"endTime": "2016-06-17T10:00:00.000",
"orderCutoffTime": "2016-06-17T09:55:00.000",
"availableCapacityDetails": [{
"sourceCapacity": 3756,
"sourceRunningCounter": 2411.2875,
"planCapacity": 3756,
"planRunningCounter": 1590.36544,
"priority": 1,
"distributionProfile": 0.72,
"cutoff": "2016-05-26T10:00:00.000"
}, {
"sourceCapacity": 3756,
"sourceRunningCounter": 220.30718000000002,
"planCapacity": 3756,
"planRunningCounter": 135.65694,
"priority": 1,
"distributionProfile": 0.015,
"cutoff": "2016-05-27T10:00:00.000"
}, {
"sourceCapacity": 3756,
"sourceRunningCounter": 45.70171,
"planCapacity": 3756,
"planRunningCounter": 21.16598,
"priority": 1,
"distributionProfile": 1.0E-5,
"cutoff": "2016-05-28T10:00:00.000"
}, {
"sourceCapacity": 3756,
"sourceRunningCounter": 34.62073,
"planCapacity": 3756,
"planRunningCounter": 14.9912,
"priority": 1,
"distributionProfile": 0.005,
"cutoff": "2016-05-30T10:00:00.000"
}, {
"sourceCapacity": 3756,
"sourceRunningCounter": 27.83564,
"planCapacity": 3756,
"planRunningCounter": 11.89772,
"priority": 1,
"distributionProfile": 0.005,
"cutoff": "2016-05-31T10:00:00.000"
}, {
"sourceCapacity": 4000,
"sourceRunningCounter": 29.0272,
"planCapacity": 4000,
"planRunningCounter": 10.45496,
"priority": 1,
"distributionProfile": 0.005,
"cutoff": "2016-06-01T10:00:00.000"
}, {
"sourceCapacity": 4000,
"sourceRunningCounter": 22.75915,
"planCapacity": 4000,
"planRunningCounter": 9.31808,
"priority": 1,
"distributionProfile": 0.01,
"cutoff": "2016-06-02T10:00:00.000"
}, {
"sourceCapacity": 4000,
"sourceRunningCounter": 25.60043,
"planCapacity": 4000,
"planRunningCounter": 9.108460000000001,
"priority": 1,
"distributionProfile": 0.005,
"cutoff": "2016-06-03T10:00:00.000"
}, {
"sourceCapacity": 4000,
"sourceRunningCounter": 8.18304,
"planCapacity": 4000,
"planRunningCounter": 4.1803,
"priority": 1,
"distributionProfile": 0.01,
"cutoff": "2016-06-04T10:00:00.000"
}, {
"sourceCapacity": 4000,
"sourceRunningCounter": 15.93349,
"planCapacity": 4000,
"planRunningCounter": 6.75687,
"priority": 1,
"distributionProfile": 0.005,
"cutoff": "2016-06-06T10:00:00.000"
}, {
"sourceCapacity": 4000,
"sourceRunningCounter": 17.79964,
"planCapacity": 4000,
"planRunningCounter": 6.81158,
"priority": 1,
"distributionProfile": 1.0E-5,
"cutoff": "2016-06-07T10:00:00.000"
}, {
"sourceCapacity": 4000,
"sourceRunningCounter": 20.8316,
"planCapacity": 4000,
"planRunningCounter": 8.042910000000001,
"priority": 1,
"distributionProfile": 0.055,
"cutoff": "2016-06-08T10:00:00.000"
}, {
"sourceCapacity": 4000,
"sourceRunningCounter": 18.80584,
"planCapacity": 4000,
"planRunningCounter": 7.82493,
"priority": 1,
"distributionProfile": 0.035,
"cutoff": "2016-06-09T10:00:00.000"
}, {
"sourceCapacity": 4000,
"sourceRunningCounter": 21.19441,
"planCapacity": 4000,
"planRunningCounter": 7.20725,
"priority": 1,
"distributionProfile": 0.13,
"cutoff": "2016-06-10T10:00:00.000"
}, {
"sourceCapacity": 4000,
"sourceRunningCounter": 0.0796,
"planCapacity": 4000,
"planRunningCounter": 0.04704,
"priority": 1,
"distributionProfile": 1.0E-5,
"cutoff": "2016-06-11T10:00:00.000"
}, {
"sourceCapacity": 4000,
"sourceRunningCounter": 9.29997,
"planCapacity": 4000,
"planRunningCounter": 4.0268,
"priority": 1,
"distributionProfile": 1.0E-5,
"cutoff": "2016-06-13T10:00:00.000"
}, {
"sourceCapacity": 4000,
"sourceRunningCounter": 5.07437,
"planCapacity": 4000,
"planRunningCounter": 1.43169,
"priority": 1,
"distributionProfile": 1.0E-5,
"cutoff": "2016-06-14T10:00:00.000"
}, {
"sourceCapacity": 4000,
"sourceRunningCounter": 0.00423,
"planCapacity": 4000,
"planRunningCounter": 0.00157,
"priority": 1,
"distributionProfile": 1.0E-5,
"cutoff": "2016-06-15T10:00:00.000"
}, {
"sourceCapacity": 4000,
"sourceRunningCounter": 0.00343,
"planCapacity": 4000,
"planRunningCounter": 0.00127,
"priority": 1,
"distributionProfile": 1.0E-5,
"cutoff": "2016-06-16T10:00:00.000"
}, {
"sourceCapacity": 4000,
"sourceRunningCounter": 0.00273,
"planCapacity": 4000,
"planRunningCounter": 0.00102,
"priority": 1,
"distributionProfile": 1.0E-5,
"cutoff": "2016-06-17T10:00:00.000"
}]
}],
"sellerCapability": "REGULAR",
"dispatchServiceTier": "REGULAR"
}],
"holidays": [{
"reason": "SUNDAY",
"startTime": "2016-06-19T00:00:00.000",
"endTime": "2016-06-19T23:59:59.000",
"displayable": true,
"holidayType": "logistics"
}],
"codEnabled": true,
"prepaidEnabled": true
},
"eligibleSourcesDetails": []
}, {
"tier": "EXPRESS",
"ineligibleSourcesDetails": [{
"sourceType": "seller",
"warehouse": "all",
"sourcePincode": "110002",
"ineligibilityCode": "NOT_SERVICEABLE",
"availableQuantity": 5,
"effectiveQuantity": 5,
"sellerCapability": "REGULAR",
"dispatchServiceTier": "REGULAR"
}],
"promiseDetails": {
"promiseBeforeDate": "2016-05-25T23:59:59.000",
"cutoffDate": "2016-05-25T07:33:41.458",
"shippingCharges": 0,
"slotted": false,
"allottedSources": [],
"holidays": [],
"codEnabled": false,
"prepaidEnabled": false
}
}, {
"tier": "PREMIUM",
"ineligibleSourcesDetails": [{
"sourceType": "seller",
"warehouse": "all",
"sourcePincode": "110002",
"ineligibilityCode": "NOT_SERVICEABLE",
"availableQuantity": 5,
"effectiveQuantity": 5,
"sellerCapability": "REGULAR",
"dispatchServiceTier": "REGULAR"
}],
"promiseDetails": {
"promiseBeforeDate": "2016-05-25T23:59:59.000",
"cutoffDate": "2016-05-25T07:33:41.458",
"shippingCharges": 0,
"slotted": false,
"allottedSources": [],
"holidays": [],
"codEnabled": false,
"prepaidEnabled": false
}
}, {
"tier": "ECONOMY",
"eligibleSourcesDetails": [{
"epht": "2016-06-17T00:00:00.000",
"lpht": "2016-06-17T14:00:00.000",
"slas": [{
"sla": 7799,
"slaType": "Logistics"
}],
"shipmentMovementType": "inter_zone",
"zoneBuffer": 0,
"promiseDate": "2016-06-24T13:30:00.000",
"holidays": [{
"reason": "SUNDAY",
"startTime": "2016-06-19T00:00:00.000",
"endTime": "2016-06-19T23:59:59.000",
"displayable": true,
"holidayType": "logistics"
}],
"source": {
"warehouse": "all",
"type": "seller",
"slas": [{
"sla": 0,
"slaType": "Warehouse"
}, {
"sla": 14,
"slaType": "Proc"
}],
"holidays": [{
"reason": "weekly holiday",
"startTime": "2016-06-12T00:00:00.000",
"endTime": "2016-06-12T23:59:59.000",
"displayable": false,
"holidayType": "seller"
}, {
"reason": "weekly holiday",
"startTime": "2016-06-05T00:00:00.000",
"endTime": "2016-06-05T23:59:59.000",
"displayable": false,
"holidayType": "seller"
}, {
"reason": "weekly holiday",
"startTime": "2016-06-19T00:00:00.000",
"endTime": "2016-06-19T23:59:59.000",
"displayable": false,
"holidayType": "seller"
}, {
"reason": "weekly holiday",
"startTime": "2016-05-29T00:00:00.000",
"endTime": "2016-05-29T23:59:59.000",
"displayable": false,
"holidayType": "seller"
}, {
"reason": "Holiday",
"startTime": "2016-02-28T00:00:00.000",
"endTime": "2016-02-28T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-04-10T00:00:00.000",
"endTime": "2016-04-10T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-05-15T00:00:00.000",
"endTime": "2016-05-15T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-01-31T00:00:00.000",
"endTime": "2016-01-31T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-01-24T00:00:00.000",
"endTime": "2016-01-24T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-03-24T00:00:00.000",
"endTime": "2016-03-24T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-03-27T00:00:00.000",
"endTime": "2016-03-27T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-04-17T00:00:00.000",
"endTime": "2016-04-17T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-05-22T00:00:00.000",
"endTime": "2016-05-22T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-03-06T00:00:00.000",
"endTime": "2016-03-06T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-02-21T00:00:00.000",
"endTime": "2016-02-21T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-06-05T00:00:00.000",
"endTime": "2016-06-05T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-05-29T00:00:00.000",
"endTime": "2016-05-29T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-06-12T00:00:00.000",
"endTime": "2016-06-12T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-03-20T00:00:00.000",
"endTime": "2016-03-20T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-04-24T00:00:00.000",
"endTime": "2016-04-24T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-06-26T00:00:00.000",
"endTime": "2016-06-26T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-04-03T00:00:00.000",
"endTime": "2016-04-03T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-05-08T00:00:00.000",
"endTime": "2016-05-08T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-06-19T00:00:00.000",
"endTime": "2016-06-19T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-03-07T00:00:00.000",
"endTime": "2016-03-07T23:59:59.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-02-07T00:00:00.000",
"endTime": "2016-02-07T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-03-13T00:00:00.000",
"endTime": "2016-03-13T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-02-14T00:00:00.000",
"endTime": "2016-02-14T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-05-01T00:00:00.000",
"endTime": "2016-05-01T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}, {
"reason": "Holiday",
"startTime": "2016-01-26T00:00:00.000",
"endTime": "2016-01-26T23:59:00.000",
"displayable": true,
"holidayType": "pickupHub"
}],
"quantity": 5,
"atpThreshold": 0,
"softReservation": 0,
"oos": false,
"overrideThreshold": 0,
"sourcePincode": "110002",
"effectiveQuantity": 5
},
"promiseSubType": "SELLER",
"pickupCompletionDate": "2016-06-17T23:59:00.000",
"logisticsCompletionDate": "2016-06-24T13:30:00.000",
"dispatchCutoff": "2016-06-17T10:00:00+0530",
"dispatchSlotDetails": [{
"source": "DaryaganjMPHub_DEL_PL",
"logisticsType": "EKL",
"startTime": "2016-05-25T10:01:00.000",
"endTime": "2016-06-17T10:00:00.000",
"orderCutoffTime": "2016-06-17T10:00:00.000",
"availableCapacityDetails": [{
"sourceCapacity": 3756,
"sourceRunningCounter": 2411.2875,
"planCapacity": 3756,
"planRunningCounter": 820.92206,
"priority": 100,
"distributionProfile": 0.72,
"cutoff": "2016-05-26T10:00:00.000"
}, {
"sourceCapacity": 3756,
"sourceRunningCounter": 220.30718000000002,
"planCapacity": 3756,
"planRunningCounter": 84.65024,
"priority": 100,
"distributionProfile": 0.015,
"cutoff": "2016-05-27T10:00:00.000"
}, {
"sourceCapacity": 3756,
"sourceRunningCounter": 45.70171,
"planCapacity": 3756,
"planRunningCounter": 24.53573,
"priority": 100,
"distributionProfile": 1.0E-5,
"cutoff": "2016-05-28T10:00:00.000"
}, {
"sourceCapacity": 3756,
"sourceRunningCounter": 34.62073,
"planCapacity": 3756,
"planRunningCounter": 19.62953,
"priority": 100,
"distributionProfile": 0.005,
"cutoff": "2016-05-30T10:00:00.000"
}, {
"sourceCapacity": 3756,
"sourceRunningCounter": 27.83564,
"planCapacity": 3756,
"planRunningCounter": 15.93792,
"priority": 100,
"distributionProfile": 0.005,
"cutoff": "2016-05-31T10:00:00.000"
}, {
"sourceCapacity": 4000,
"sourceRunningCounter": 29.0272,
"planCapacity": 4000,
"planRunningCounter": 18.57224,
"priority": 100,
"distributionProfile": 0.005,
"cutoff": "2016-06-01T10:00:00.000"
}, {
"sourceCapacity": 4000,
"sourceRunningCounter": 22.75915,
"planCapacity": 4000,
"planRunningCounter": 13.44107,
"priority": 100,
"distributionProfile": 0.01,
"cutoff": "2016-06-02T10:00:00.000"
}, {
"sourceCapacity": 4000,
"sourceRunningCounter": 25.60043,
"planCapacity": 4000,
"planRunningCounter": 16.49197,
"priority": 100,
"distributionProfile": 0.005,
"cutoff": "2016-06-03T10:00:00.000"
}, {
"sourceCapacity": 4000,
"sourceRunningCounter": 8.18304,
"planCapacity": 4000,
"planRunningCounter": 4.00274,
"priority": 100,
"distributionProfile": 0.01,
"cutoff": "2016-06-04T10:00:00.000"
}, {
"sourceCapacity": 4000,
"sourceRunningCounter": 15.93349,
"planCapacity": 4000,
"planRunningCounter": 9.17662,
"priority": 100,
"distributionProfile": 0.005,
"cutoff": "2016-06-06T10:00:00.000"
}, {
"sourceCapacity": 4000,
"sourceRunningCounter": 17.79964,
"planCapacity": 4000,
"planRunningCounter": 10.98806,
"priority": 100,
"distributionProfile": 1.0E-5,
"cutoff": "2016-06-07T10:00:00.000"
}, {
"sourceCapacity": 4000,
"sourceRunningCounter": 20.8316,
"planCapacity": 4000,
"planRunningCounter": 12.78869,
"priority": 100,
"distributionProfile": 0.055,
"cutoff": "2016-06-08T10:00:00.000"
}, {
"sourceCapacity": 4000,
"sourceRunningCounter": 18.80584,
"planCapacity": 4000,
"planRunningCounter": 10.98091,
"priority": 100,
"distributionProfile": 0.035,
"cutoff": "2016-06-09T10:00:00.000"
}, {
"sourceCapacity": 4000,
"sourceRunningCounter": 21.19441,
"planCapacity": 4000,
"planRunningCounter": 13.98716,
"priority": 100,
"distributionProfile": 0.13,
"cutoff": "2016-06-10T10:00:00.000"
}, {
"sourceCapacity": 4000,
"sourceRunningCounter": 0.0796,
"planCapacity": 4000,
"planRunningCounter": 0.03256,
"priority": 100,
"distributionProfile": 1.0E-5,
"cutoff": "2016-06-11T10:00:00.000"
}, {
"sourceCapacity": 4000,
"sourceRunningCounter": 9.29997,
"planCapacity": 4000,
"planRunningCounter": 5.27317,
"priority": 100,
"distributionProfile": 1.0E-5,
"cutoff": "2016-06-13T10:00:00.000"
}, {
"sourceCapacity": 4000,
"sourceRunningCounter": 5.07437,
"planCapacity": 4000,
"planRunningCounter": 3.64268,
"priority": 100,
"distributionProfile": 1.0E-5,
"cutoff": "2016-06-14T10:00:00.000"
}, {
"sourceCapacity": 4000,
"sourceRunningCounter": 0.00423,
"planCapacity": 4000,
"planRunningCounter": 0.00266,
"priority": 100,
"distributionProfile": 1.0E-5,
"cutoff": "2016-06-15T10:00:00.000"
}, {
"sourceCapacity": 4000,
"sourceRunningCounter": 0.00343,
"planCapacity": 4000,
"planRunningCounter": 0.00216,
"priority": 100,
"distributionProfile": 1.0E-5,
"cutoff": "2016-06-16T10:00:00.000"
}, {
"sourceCapacity": 4000,
"sourceRunningCounter": 0.00273,
"planCapacity": 4000,
"planRunningCounter": 0.00171,
"priority": 100,
"distributionProfile": 1.0E-5,
"cutoff": "2016-06-17T10:00:00.000"
}]
}],
"sellerCapability": "REGULAR",
"dispatchServiceTier": "REGULAR"
}]
}]
}],
"messageToCustomer": [],
"flipkartFirst": false
},
"encodingType": "JSON",
"ingestedAt": 1464141821466,
"traceId": "625a997c-3e38-407a-8353-f7585a2daac2",
"test": null,
"parentId": null,
"parentVersion": null,
"seqId": "001464141821000000000",
"eventId": "0021ab96-f189-41d8-bb22-1f7f451fd884",
"eventTime": 1464141821000
}
We explode listingSourcePromiseDetails, then sourcepromisedetails,
then eligiblesourcesdetails, then
ineligiblesourcesdetails, PromiseDetails.allottedSources,
then PromiseDetails.allottedSources,
PromiseDetails.allottedSources.Source.holidays, then
PromiseDetails.allottedSources.Source.slas, then
PromiseDetails.allottedSources.DispatchSlotDetails, then
PromiseDetails.allottedSources.DispatchSlotDetails.availableCapacityDetails.
Also, any of these lists could be null or have zero entries in it. I was
able to exactly get correct number of outputs with my implementation for
the above object, but when I run the same on the whole data, it returns
erroneous results.
Thanks,
Karan.
On Thu, Jul 7, 2016 at 9:56 AM, Karan Verma (Tech - BLR) <
karan.verma@flipkart.com> wrote:
> Hi,
>
> I'm working on writing a custom Map Reduce job, which mimics a hive query.
> This query works on JSON type data and there are multiple nested lists,
> which are exploded. I have been struggling with writing an Exploder class
> which is very specific to the data. I just can't seem to get the number of
> outputs correct. I'll mail you the details, just let me know, if you'd be
> willing to help me on this.
>
> Thanks,
> Karan.
>
>
>
Re: Need help with hive's explode function.
Posted by Venkata Penikalapati <ma...@gmail.com>.
Hi Karan,
Your problem looks interesting, let me know more details will try to look into.
ThanksVenkata Karthik P
_____________________________
From: Karan Verma (Tech - BLR) <ka...@flipkart.com>
Sent: Wednesday, July 6, 2016 9:45 PM
Subject: Need help with hive's explode function.
To: <de...@hive.apache.org>
Hi,
I'm working on writing a custom Map Reduce job, which mimics a hive query.
This query works on JSON type data and there are multiple nested lists,
which are exploded. I have been struggling with writing an Exploder class
which is very specific to the data. I just can't seem to get the number of
outputs correct. I'll mail you the details, just let me know, if you'd be
willing to help me on this.
Thanks,
Karan.