PagedBytesIndexFieldData cannot be cast to IndexNumericFieldData


(VB) #1

Hello all,

I have a weird problem. When i try to run facet using following query I get
error that
PagedBytesIndexFieldData cannot be cast to
org.elasticsearch.index.fielddata.IndexNumericFieldData]

But my field is of long data type and I am not figure out why i am getting
error

This is the query

{
"query": {
"match_all": {}
},
"facets": {
"Id": {
"statistical": {
"field": "Id"
}
}
}
}

And these are my mappings

{
"contractsearch": {
"dynamic": "strict",
"properties": {
"TransactionIdList": {
"properties": {
"TransactionId": {
"type": "long",
"index": "not_analyzed",
"index_Name": "TransactionId"
}
},
"type": "nested"
},
"Id": {
"type": "long",
"index": "not_analyzed",
"index_Name": "Id"
},
"ExposureId": {
"type": "long",
"index": "not_analyzed",
"index_Name": "ExposureId"
},
"CreateUserId": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "CreateUserId"
},
"ExternalSourceName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ExternalSourceName",
"null_Value": "unasSigned"
},
"Name": {
"type": "string",
"index": "not_analyzed",
"index_Name": "Name"
},
"Description": {
"type": "string",
"index": "not_analyzed",
"index_Name": "Description"
},
"ExposureNumber": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ExposureNumber"
},
"ProgramName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ProgramName"
},
"ExposedPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ExposedPartyName",
"null_Value": "unasSigned"
},
"ContractTypeName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ContractTypeName",
"null_Value": "unasSigned"
},
"UserDefContractTypeName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "UserDefContractTypeName",
"null_Value": "unasSigned"
},
"LineofBusinessName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "LineofBusinessName",
"null_Value": "unasSigned"
},
"ContractStatusName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ContractStatusName",
"null_Value": "unasSigned"
},
"InsuredPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "InsuredPartyName",
"null_Value": "unasSigned"
},
"InsurerPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "InsurerPartyName",
"null_Value": "unasSigned"
},
"BrokerPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "BrokerPartyName",
"null_Value": "unasSigned"
},
"UnderwriterPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "UnderwriterPartyName",
"null_Value": "unasSigned"
},
"ProducerPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ProducerPartyName",
"null_Value": "unasSigned"
},
"AgentPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "AgentPartyName",
"null_Value": "unasSigned"
},
"UnderwritingAccountPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "UnderwritingAccountPartyName",
"null_Value": "unasSigned"
},
"BranchPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "BranchPartyName",
"null_Value": "unasSigned"
},
"AccountingOrganizationPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "AccountingOrganizationPartyName",
"null_Value": "unasSigned"
},
"LegalEntityPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "LegalEntityPartyName",
"null_Value": "unasSigned"
},
"CostCenterPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "CostCenterPartyName",
"null_Value": "unasSigned"
},
"HubPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "HubPartyName",
"null_Value": "unasSigned"
},
"OfficePartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "OfficePartyName",
"null_Value": "unasSigned"
},
"MarketChannelName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "MarketChannelName",
"null_Value": "unasSigned"
},
"InceptionDate": {
"type": "Date",
"index": "not_analyzed",
"index_Name": "InceptionDate"
},
"ExpirationDate": {
"type": "Date",
"index": "not_analyzed",
"index_Name": "ExpirationDate"
},
"AttachmentBasisName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "AttachmentBasisName",
"null_Value": "unasSigned"
},
"AttachmentLevelName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "AttachmentLevelName",
"null_Value": "unasSigned"
},
"ClaimAdjustmentDeductibleName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ClaimAdjustmentDeductibleName",
"null_Value": "unasSigned"
},
"ClaimAdjustmentSubmitName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ClaimAdjustmentSubmitName",
"null_Value": "unasSigned"
},
"ClaimAdjustmentSublimitName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ClaimAdjustmentSublimitName",
"null_Value": "unasSigned"
},
"Premium": {
"type": "double",
"index": "not_analyzed",
"index_Name": "Premium"
},
"PaidReinstatement": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "PaidReinstatement"
},
"FreeReinstatement": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "FreeReinstatement"
},
"ReinstatementsPercentCharge": {
"type": "double",
"index": "not_analyzed",
"index_Name": "ReinstatementsPercentCharge"
},
"ReinstatementsPremium": {
"type": "double",
"index": "not_analyzed",
"index_Name": "ReinstatementsPremium"
},
"IsProRataTemporis": {
"type": "boolean",
"index": "not_analyzed",
"index_Name": "IsProRataTemporis"
},
"ProductName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ProductName"
},
"PrimaryAccordOccupancyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "PrimaryAccordOccupancyName",
"null_Value": "unasSigned"
},
"CurrencyCode": {
"type": "string",
"index": "not_analyzed",
"index_Name": "CurrencyCode",
"null_Value": "usd"
},
"RenewalDate": {
"type": "Date",
"index": "not_analyzed",
"index_Name": "RenewalDate"
},
"ExpectedShares": {
"type": "double",
"index": "not_analyzed",
"index_Name": "ExpectedShares"
},
"SignedShares": {
"type": "double",
"index": "not_analyzed",
"index_Name": "SignedShares"
},
"WrittenShares": {
"type": "double",
"index": "not_analyzed",
"index_Name": "WrittenShares"
},
"WhatIfName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "WhatIfName",
"null_Value": "main"
},
"ClonedExposureId": {
"type": "long",
"index": "not_analyzed",
"index_Name": "ClonedExposureId"
},
"CloneTypeId": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "CloneTypeId"
},
"ContractTypeIsInsurance": {
"type": "boolean",
"index": "not_analyzed",
"index_Name": "ContractTypeIsInsurance"
},
"SourceId": {
"type": "string",
"index": "not_analyzed",
"index_Name": "SourceId"
},
"IsRenewal": {
"type": "boolean",
"index": "not_analyzed",
"index_Name": "IsRenewal"
},
"ProductAsOfDate": {
"type": "Date",
"index": "not_analyzed",
"index_Name": "ProductAsOfDate"
},
"Jurisdiction": {
"type": "string",
"index": "not_analyzed",
"index_Name": "Jurisdiction"
},
"IsCedantContract": {
"type": "boolean",
"index": "not_analyzed",
"index_Name": "IsCedantContract"
},
"CalculatedTIV": {
"type": "double",
"index": "not_analyzed",
"index_Name": "CalculatedTIV"
},
"CalculatedBuildingTIV": {
"type": "double",
"index": "not_analyzed",
"index_Name": "CalculatedBuildingTIV"
},
"CalculatedContentsTIV": {
"type": "double",
"index": "not_analyzed",
"index_Name": "CalculatedContentsTIV"
},
"CalculatedBITIV": {
"type": "double",
"index": "not_analyzed",
"index_Name": "CalculatedBITIV"
},
"RiskItemCount": {
"type": "long",
"index": "not_analyzed",
"index_Name": "RiskItemCount"
},
"ACLTag": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ACLTag"
},
"ImportSetId": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "ImportSetId"
}
}
}
}

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/ec1e384b-318a-43e8-9a94-05ecdf5f0e4a%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


(VB) #2

It is even happening with other type.

query

{
"from": 0,
"size": 50,
"query": {
"match_all": {}
},
"facets": {
"Id": {
"statistical": {
"fields": [
"Id"
]
}
}
}
}

mapping

{
"portfoliosearch": {
"dynamic": "strict",
"properties": {
"TransactionIdList": {
"properties": {
"transactionId": {
"type": "long",
"index": "not_analyzed",
"index_Name": "transactionId"
}
},
"type": "nested"
},
"Id": {
"type": "long",
"index": "not_analyzed",
"index_Name": "Id"
},
"ExposureId": {
"type": "long",
"index": "not_analyzed",
"index_Name": "ExposureId"
},
"Name": {
"type": "string",
"index": "not_analyzed",
"index_Name": "Name"
},
"Description": {
"type": "string",
"index": "not_analyzed",
"index_Name": "Description"
},
"ExposureNumber": {
"type": "string",
"index": "analyzed",
"index_Name": "ExposureNumber"
},
"ExposedPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ExposedPartyName"
},
"CreateUserId": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "CreateUserId"
},
"IsDynamic": {
"type": "boolean",
"index": "not_analyzed",
"index_Name": "IsDynamic"
},
"ClonedExposureId": {
"type": "long",
"index": "not_analyzed",
"index_Name": "ClonedExposureId"
},
"CloneTypeId": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "CloneTypeId"
},
"IsReference": {
"type": "boolean",
"index": "not_analyzed",
"index_Name": "IsReference"
},
"CollExposureWhatIfTagName": {
"type": "string",
"index": "analyzed",
"index_Name": "CollExposureWhatIfTagName"
},
"SourceId": {
"type": "string",
"index": "not_analyzed",
"index_Name": "SourceId"
},
"CalculatedTIV": {
"type": "double",
"index": "not_analyzed",
"index_Name": "CalculatedTIV"
},
"CalculatedBuildingTIV": {
"type": "double",
"index": "not_analyzed",
"index_Name": "CalculatedBuildingTIV"
},
"CalculatedContentsTIV": {
"type": "double",
"index": "not_analyzed",
"index_Name": "CalculatedContentsTIV"
},
"CalculatedBITIV": {
"type": "double",
"index": "not_analyzed",
"index_Name": "CalculatedBITIV"
},
"RiskItemCount": {
"type": "long",
"index": "not_analyzed",
"index_Name": "RiskItemCount"
},
"ContractCount": {
"type": "long",
"index": "not_analyzed",
"index_Name": "ContractCount"
},
"ACLTag": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ACLTag"
}
},
"_routing": {
"required": true
},
"_parent": {
"type": "importsetsearch"
}
}
}

data only 4 records

{

  • took: 0
  • timed_out: false
  • _shards: {
    • total: 50
    • successful: 50
    • failed: 0
      }
  • hits: {
    • total: 4
    • max_score: 1
    • hits: [
      • {
        • _index: 4_exposureindex
        • _type: portfoliosearch
        • _id: 398103
        • _score: 1
        • _source: {
          • CollExposureWhatIfTagName: null
          • Name: Fast Food US
          • Description: 3 Accounts, ? Locations
          • ExposureNumber: Fast Food US
          • CreateUserId: 10
          • SourceId: 8
          • IsDynamic: false
          • CloneTypeId: 0
          • IsReference: false
          • ExposedPartyName: CompanyC
          • Id: 398103
          • CalculatedTIV: 2687668209
          • CalculatedBuildingTIV: 2687668209
          • CalculatedContentsTIV: 0
          • CalculatedBITIV: 0
          • RiskItemCount: 13701
          • ContractCount: 3
          • ACLTag: null
            }
            }
      • {
        • _index: 4_exposureindex
        • _type: portfoliosearch
        • _id: 19320
        • _score: 1
        • _source: {
          • CollExposureWhatIfTagName: null
          • Name: ABC Commercial
          • Description: null
          • ExposureNumber: 3
          • CreateUserId: 10
          • SourceId: 1
          • IsDynamic: false
          • CloneTypeId: 0
          • IsReference: false
          • ExposedPartyName: CompanyC
          • Id: 19320
          • CalculatedTIV: 6176278530
          • CalculatedBuildingTIV: 4717779630
          • CalculatedContentsTIV: 964260300
          • CalculatedBITIV: 494238600
          • RiskItemCount: 1199
          • ContractCount: 40
          • ACLTag: null
            }
            }
      • {
        • _index: 4_exposureindex
        • _type: portfoliosearch
        • _id: 13174
        • _score: 1
        • _source: {
          • CollExposureWhatIfTagName: null
          • Name: RES_EQ_CA
          • Description: California
          • ExposureNumber: RES_EQ_CA
          • CreateUserId: 10
          • SourceId: 1
          • IsDynamic: false
          • CloneTypeId: 0
          • IsReference: false
          • ExposedPartyName: CompanyC
          • Id: 13174
          • CalculatedTIV: 1640804972
          • CalculatedBuildingTIV: 864306702
          • CalculatedContentsTIV: 531364533
          • CalculatedBITIV: 245133737
          • RiskItemCount: 3013
          • ContractCount: 3013
          • ACLTag: null
            }
            }
      • {
        • _index: 4_exposureindex
        • _type: portfoliosearch
        • _id: 980704
        • _score: 1
        • _source: {
          • CollExposureWhatIfTagName: null
          • Name: ABC Commercial
          • Description: null
          • ExposureNumber: 3
          • CreateUserId: 10
          • SourceId: 1
          • IsDynamic: false
          • CloneTypeId: 0
          • IsReference: false
          • ExposedPartyName: CompanyC
          • Id: 980704
          • CalculatedTIV: 6199310530
          • CalculatedBuildingTIV: 4711419630
          • CalculatedContentsTIV: 969644300
          • CalculatedBITIV: 518246600
          • RiskItemCount: 1199
          • ContractCount: 40
          • ACLTag: null
            }
            }
            ]
            }

}

On Monday, 13 January 2014 14:34:38 UTC-8, VB wrote:

Hello all,

I have a weird problem. When i try to run facet using following query I
get error that
PagedBytesIndexFieldData cannot be cast to
org.elasticsearch.index.fielddata.IndexNumericFieldData]

But my field is of long data type and I am not figure out why i am getting
error

This is the query

{
"query": {
"match_all": {}
},
"facets": {
"Id": {
"statistical": {
"field": "Id"
}
}
}
}

And these are my mappings

{
"contractsearch": {
"dynamic": "strict",
"properties": {
"TransactionIdList": {
"properties": {
"TransactionId": {
"type": "long",
"index": "not_analyzed",
"index_Name": "TransactionId"
}
},
"type": "nested"
},
"Id": {
"type": "long",
"index": "not_analyzed",
"index_Name": "Id"
},
"ExposureId": {
"type": "long",
"index": "not_analyzed",
"index_Name": "ExposureId"
},
"CreateUserId": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "CreateUserId"
},
"ExternalSourceName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ExternalSourceName",
"null_Value": "unasSigned"
},
"Name": {
"type": "string",
"index": "not_analyzed",
"index_Name": "Name"
},
"Description": {
"type": "string",
"index": "not_analyzed",
"index_Name": "Description"
},
"ExposureNumber": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ExposureNumber"
},
"ProgramName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ProgramName"
},
"ExposedPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ExposedPartyName",
"null_Value": "unasSigned"
},
"ContractTypeName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ContractTypeName",
"null_Value": "unasSigned"
},
"UserDefContractTypeName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "UserDefContractTypeName",
"null_Value": "unasSigned"
},
"LineofBusinessName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "LineofBusinessName",
"null_Value": "unasSigned"
},
"ContractStatusName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ContractStatusName",
"null_Value": "unasSigned"
},
"InsuredPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "InsuredPartyName",
"null_Value": "unasSigned"
},
"InsurerPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "InsurerPartyName",
"null_Value": "unasSigned"
},
"BrokerPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "BrokerPartyName",
"null_Value": "unasSigned"
},
"UnderwriterPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "UnderwriterPartyName",
"null_Value": "unasSigned"
},
"ProducerPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ProducerPartyName",
"null_Value": "unasSigned"
},
"AgentPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "AgentPartyName",
"null_Value": "unasSigned"
},
"UnderwritingAccountPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "UnderwritingAccountPartyName",
"null_Value": "unasSigned"
},
"BranchPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "BranchPartyName",
"null_Value": "unasSigned"
},
"AccountingOrganizationPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "AccountingOrganizationPartyName",
"null_Value": "unasSigned"
},
"LegalEntityPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "LegalEntityPartyName",
"null_Value": "unasSigned"
},
"CostCenterPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "CostCenterPartyName",
"null_Value": "unasSigned"
},
"HubPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "HubPartyName",
"null_Value": "unasSigned"
},
"OfficePartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "OfficePartyName",
"null_Value": "unasSigned"
},
"MarketChannelName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "MarketChannelName",
"null_Value": "unasSigned"
},
"InceptionDate": {
"type": "Date",
"index": "not_analyzed",
"index_Name": "InceptionDate"
},
"ExpirationDate": {
"type": "Date",
"index": "not_analyzed",
"index_Name": "ExpirationDate"
},
"AttachmentBasisName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "AttachmentBasisName",
"null_Value": "unasSigned"
},
"AttachmentLevelName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "AttachmentLevelName",
"null_Value": "unasSigned"
},
"ClaimAdjustmentDeductibleName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ClaimAdjustmentDeductibleName",
"null_Value": "unasSigned"
},
"ClaimAdjustmentSubmitName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ClaimAdjustmentSubmitName",
"null_Value": "unasSigned"
},
"ClaimAdjustmentSublimitName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ClaimAdjustmentSublimitName",
"null_Value": "unasSigned"
},
"Premium": {
"type": "double",
"index": "not_analyzed",
"index_Name": "Premium"
},
"PaidReinstatement": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "PaidReinstatement"
},
"FreeReinstatement": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "FreeReinstatement"
},
"ReinstatementsPercentCharge": {
"type": "double",
"index": "not_analyzed",
"index_Name": "ReinstatementsPercentCharge"
},
"ReinstatementsPremium": {
"type": "double",
"index": "not_analyzed",
"index_Name": "ReinstatementsPremium"
},
"IsProRataTemporis": {
"type": "boolean",
"index": "not_analyzed",
"index_Name": "IsProRataTemporis"
},
"ProductName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ProductName"
},
"PrimaryAccordOccupancyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "PrimaryAccordOccupancyName",
"null_Value": "unasSigned"
},
"CurrencyCode": {
"type": "string",
"index": "not_analyzed",
"index_Name": "CurrencyCode",
"null_Value": "usd"
},
"RenewalDate": {
"type": "Date",
"index": "not_analyzed",
"index_Name": "RenewalDate"
},
"ExpectedShares": {
"type": "double",
"index": "not_analyzed",
"index_Name": "ExpectedShares"
},
"SignedShares": {
"type": "double",
"index": "not_analyzed",
"index_Name": "SignedShares"
},
"WrittenShares": {
"type": "double",
"index": "not_analyzed",
"index_Name": "WrittenShares"
},
"WhatIfName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "WhatIfName",
"null_Value": "main"
},
"ClonedExposureId": {
"type": "long",
"index": "not_analyzed",
"index_Name": "ClonedExposureId"
},
"CloneTypeId": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "CloneTypeId"
},
"ContractTypeIsInsurance": {
"type": "boolean",
"index": "not_analyzed",
"index_Name": "ContractTypeIsInsurance"
},
"SourceId": {
"type": "string",
"index": "not_analyzed",
"index_Name": "SourceId"
},
"IsRenewal": {
"type": "boolean",
"index": "not_analyzed",
"index_Name": "IsRenewal"
},
"ProductAsOfDate": {
"type": "Date",
"index": "not_analyzed",
"index_Name": "ProductAsOfDate"
},
"Jurisdiction": {
"type": "string",
"index": "not_analyzed",
"index_Name": "Jurisdiction"
},
"IsCedantContract": {
"type": "boolean",
"index": "not_analyzed",
"index_Name": "IsCedantContract"
},
"CalculatedTIV": {
"type": "double",
"index": "not_analyzed",
"index_Name": "CalculatedTIV"
},
"CalculatedBuildingTIV": {
"type": "double",
"index": "not_analyzed",
"index_Name": "CalculatedBuildingTIV"
},
"CalculatedContentsTIV": {
"type": "double",
"index": "not_analyzed",
"index_Name": "CalculatedContentsTIV"
},
"CalculatedBITIV": {
"type": "double",
"index": "not_analyzed",
"index_Name": "CalculatedBITIV"
},
"RiskItemCount": {
"type": "long",
"index": "not_analyzed",
"index_Name": "RiskItemCount"
},
"ACLTag": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ACLTag"
},
"ImportSetId": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "ImportSetId"
}
}
}
}

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/50cc0fed-030f-4bdc-b095-83e645e75573%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


(VB) #3

It even happens when there is only single record matches query criteria and
only happens with this ("Id") field. Does has to do with name of the field?

Is there something internal logic with id field.?

On Monday, 13 January 2014 14:34:38 UTC-8, VB wrote:

Hello all,

I have a weird problem. When i try to run facet using following query I
get error that
PagedBytesIndexFieldData cannot be cast to
org.elasticsearch.index.fielddata.IndexNumericFieldData]

But my field is of long data type and I am not figure out why i am getting
error

This is the query

{
"query": {
"match_all": {}
},
"facets": {
"Id": {
"statistical": {
"field": "Id"
}
}
}
}

And these are my mappings

{
"contractsearch": {
"dynamic": "strict",
"properties": {
"TransactionIdList": {
"properties": {
"TransactionId": {
"type": "long",
"index": "not_analyzed",
"index_Name": "TransactionId"
}
},
"type": "nested"
},
"Id": {
"type": "long",
"index": "not_analyzed",
"index_Name": "Id"
},
"ExposureId": {
"type": "long",
"index": "not_analyzed",
"index_Name": "ExposureId"
},
"CreateUserId": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "CreateUserId"
},
"ExternalSourceName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ExternalSourceName",
"null_Value": "unasSigned"
},
"Name": {
"type": "string",
"index": "not_analyzed",
"index_Name": "Name"
},
"Description": {
"type": "string",
"index": "not_analyzed",
"index_Name": "Description"
},
"ExposureNumber": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ExposureNumber"
},
"ProgramName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ProgramName"
},
"ExposedPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ExposedPartyName",
"null_Value": "unasSigned"
},
"ContractTypeName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ContractTypeName",
"null_Value": "unasSigned"
},
"UserDefContractTypeName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "UserDefContractTypeName",
"null_Value": "unasSigned"
},
"LineofBusinessName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "LineofBusinessName",
"null_Value": "unasSigned"
},
"ContractStatusName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ContractStatusName",
"null_Value": "unasSigned"
},
"InsuredPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "InsuredPartyName",
"null_Value": "unasSigned"
},
"InsurerPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "InsurerPartyName",
"null_Value": "unasSigned"
},
"BrokerPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "BrokerPartyName",
"null_Value": "unasSigned"
},
"UnderwriterPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "UnderwriterPartyName",
"null_Value": "unasSigned"
},
"ProducerPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ProducerPartyName",
"null_Value": "unasSigned"
},
"AgentPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "AgentPartyName",
"null_Value": "unasSigned"
},
"UnderwritingAccountPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "UnderwritingAccountPartyName",
"null_Value": "unasSigned"
},
"BranchPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "BranchPartyName",
"null_Value": "unasSigned"
},
"AccountingOrganizationPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "AccountingOrganizationPartyName",
"null_Value": "unasSigned"
},
"LegalEntityPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "LegalEntityPartyName",
"null_Value": "unasSigned"
},
"CostCenterPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "CostCenterPartyName",
"null_Value": "unasSigned"
},
"HubPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "HubPartyName",
"null_Value": "unasSigned"
},
"OfficePartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "OfficePartyName",
"null_Value": "unasSigned"
},
"MarketChannelName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "MarketChannelName",
"null_Value": "unasSigned"
},
"InceptionDate": {
"type": "Date",
"index": "not_analyzed",
"index_Name": "InceptionDate"
},
"ExpirationDate": {
"type": "Date",
"index": "not_analyzed",
"index_Name": "ExpirationDate"
},
"AttachmentBasisName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "AttachmentBasisName",
"null_Value": "unasSigned"
},
"AttachmentLevelName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "AttachmentLevelName",
"null_Value": "unasSigned"
},
"ClaimAdjustmentDeductibleName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ClaimAdjustmentDeductibleName",
"null_Value": "unasSigned"
},
"ClaimAdjustmentSubmitName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ClaimAdjustmentSubmitName",
"null_Value": "unasSigned"
},
"ClaimAdjustmentSublimitName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ClaimAdjustmentSublimitName",
"null_Value": "unasSigned"
},
"Premium": {
"type": "double",
"index": "not_analyzed",
"index_Name": "Premium"
},
"PaidReinstatement": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "PaidReinstatement"
},
"FreeReinstatement": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "FreeReinstatement"
},
"ReinstatementsPercentCharge": {
"type": "double",
"index": "not_analyzed",
"index_Name": "ReinstatementsPercentCharge"
},
"ReinstatementsPremium": {
"type": "double",
"index": "not_analyzed",
"index_Name": "ReinstatementsPremium"
},
"IsProRataTemporis": {
"type": "boolean",
"index": "not_analyzed",
"index_Name": "IsProRataTemporis"
},
"ProductName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ProductName"
},
"PrimaryAccordOccupancyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "PrimaryAccordOccupancyName",
"null_Value": "unasSigned"
},
"CurrencyCode": {
"type": "string",
"index": "not_analyzed",
"index_Name": "CurrencyCode",
"null_Value": "usd"
},
"RenewalDate": {
"type": "Date",
"index": "not_analyzed",
"index_Name": "RenewalDate"
},
"ExpectedShares": {
"type": "double",
"index": "not_analyzed",
"index_Name": "ExpectedShares"
},
"SignedShares": {
"type": "double",
"index": "not_analyzed",
"index_Name": "SignedShares"
},
"WrittenShares": {
"type": "double",
"index": "not_analyzed",
"index_Name": "WrittenShares"
},
"WhatIfName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "WhatIfName",
"null_Value": "main"
},
"ClonedExposureId": {
"type": "long",
"index": "not_analyzed",
"index_Name": "ClonedExposureId"
},
"CloneTypeId": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "CloneTypeId"
},
"ContractTypeIsInsurance": {
"type": "boolean",
"index": "not_analyzed",
"index_Name": "ContractTypeIsInsurance"
},
"SourceId": {
"type": "string",
"index": "not_analyzed",
"index_Name": "SourceId"
},
"IsRenewal": {
"type": "boolean",
"index": "not_analyzed",
"index_Name": "IsRenewal"
},
"ProductAsOfDate": {
"type": "Date",
"index": "not_analyzed",
"index_Name": "ProductAsOfDate"
},
"Jurisdiction": {
"type": "string",
"index": "not_analyzed",
"index_Name": "Jurisdiction"
},
"IsCedantContract": {
"type": "boolean",
"index": "not_analyzed",
"index_Name": "IsCedantContract"
},
"CalculatedTIV": {
"type": "double",
"index": "not_analyzed",
"index_Name": "CalculatedTIV"
},
"CalculatedBuildingTIV": {
"type": "double",
"index": "not_analyzed",
"index_Name": "CalculatedBuildingTIV"
},
"CalculatedContentsTIV": {
"type": "double",
"index": "not_analyzed",
"index_Name": "CalculatedContentsTIV"
},
"CalculatedBITIV": {
"type": "double",
"index": "not_analyzed",
"index_Name": "CalculatedBITIV"
},
"RiskItemCount": {
"type": "long",
"index": "not_analyzed",
"index_Name": "RiskItemCount"
},
"ACLTag": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ACLTag"
},
"ImportSetId": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "ImportSetId"
}
}
}
}

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/fdc98724-bfac-4893-9630-750ca7f43857%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


(VB) #4

Can someone please help here. We are stuck at this point.

On Monday, 13 January 2014 15:31:49 UTC-8, VB wrote:

It even happens when there is only single record matches query criteria
and only happens with this ("Id") field. Does has to do with name of the
field?

Is there something internal logic with id field.?

On Monday, 13 January 2014 14:34:38 UTC-8, VB wrote:

Hello all,

I have a weird problem. When i try to run facet using following query I
get error that
PagedBytesIndexFieldData cannot be cast to
org.elasticsearch.index.fielddata.IndexNumericFieldData]

But my field is of long data type and I am not figure out why i am
getting error

This is the query

{
"query": {
"match_all": {}
},
"facets": {
"Id": {
"statistical": {
"field": "Id"
}
}
}
}

And these are my mappings

{
"contractsearch": {
"dynamic": "strict",
"properties": {
"TransactionIdList": {
"properties": {
"TransactionId": {
"type": "long",
"index": "not_analyzed",
"index_Name": "TransactionId"
}
},
"type": "nested"
},
"Id": {
"type": "long",
"index": "not_analyzed",
"index_Name": "Id"
},
"ExposureId": {
"type": "long",
"index": "not_analyzed",
"index_Name": "ExposureId"
},
"CreateUserId": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "CreateUserId"
},
"ExternalSourceName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ExternalSourceName",
"null_Value": "unasSigned"
},
"Name": {
"type": "string",
"index": "not_analyzed",
"index_Name": "Name"
},
"Description": {
"type": "string",
"index": "not_analyzed",
"index_Name": "Description"
},
"ExposureNumber": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ExposureNumber"
},
"ProgramName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ProgramName"
},
"ExposedPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ExposedPartyName",
"null_Value": "unasSigned"
},
"ContractTypeName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ContractTypeName",
"null_Value": "unasSigned"
},
"UserDefContractTypeName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "UserDefContractTypeName",
"null_Value": "unasSigned"
},
"LineofBusinessName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "LineofBusinessName",
"null_Value": "unasSigned"
},
"ContractStatusName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ContractStatusName",
"null_Value": "unasSigned"
},
"InsuredPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "InsuredPartyName",
"null_Value": "unasSigned"
},
"InsurerPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "InsurerPartyName",
"null_Value": "unasSigned"
},
"BrokerPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "BrokerPartyName",
"null_Value": "unasSigned"
},
"UnderwriterPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "UnderwriterPartyName",
"null_Value": "unasSigned"
},
"ProducerPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ProducerPartyName",
"null_Value": "unasSigned"
},
"AgentPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "AgentPartyName",
"null_Value": "unasSigned"
},
"UnderwritingAccountPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "UnderwritingAccountPartyName",
"null_Value": "unasSigned"
},
"BranchPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "BranchPartyName",
"null_Value": "unasSigned"
},
"AccountingOrganizationPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "AccountingOrganizationPartyName",
"null_Value": "unasSigned"
},
"LegalEntityPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "LegalEntityPartyName",
"null_Value": "unasSigned"
},
"CostCenterPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "CostCenterPartyName",
"null_Value": "unasSigned"
},
"HubPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "HubPartyName",
"null_Value": "unasSigned"
},
"OfficePartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "OfficePartyName",
"null_Value": "unasSigned"
},
"MarketChannelName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "MarketChannelName",
"null_Value": "unasSigned"
},
"InceptionDate": {
"type": "Date",
"index": "not_analyzed",
"index_Name": "InceptionDate"
},
"ExpirationDate": {
"type": "Date",
"index": "not_analyzed",
"index_Name": "ExpirationDate"
},
"AttachmentBasisName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "AttachmentBasisName",
"null_Value": "unasSigned"
},
"AttachmentLevelName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "AttachmentLevelName",
"null_Value": "unasSigned"
},
"ClaimAdjustmentDeductibleName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ClaimAdjustmentDeductibleName",
"null_Value": "unasSigned"
},
"ClaimAdjustmentSubmitName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ClaimAdjustmentSubmitName",
"null_Value": "unasSigned"
},
"ClaimAdjustmentSublimitName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ClaimAdjustmentSublimitName",
"null_Value": "unasSigned"
},
"Premium": {
"type": "double",
"index": "not_analyzed",
"index_Name": "Premium"
},
"PaidReinstatement": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "PaidReinstatement"
},
"FreeReinstatement": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "FreeReinstatement"
},
"ReinstatementsPercentCharge": {
"type": "double",
"index": "not_analyzed",
"index_Name": "ReinstatementsPercentCharge"
},
"ReinstatementsPremium": {
"type": "double",
"index": "not_analyzed",
"index_Name": "ReinstatementsPremium"
},
"IsProRataTemporis": {
"type": "boolean",
"index": "not_analyzed",
"index_Name": "IsProRataTemporis"
},
"ProductName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ProductName"
},
"PrimaryAccordOccupancyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "PrimaryAccordOccupancyName",
"null_Value": "unasSigned"
},
"CurrencyCode": {
"type": "string",
"index": "not_analyzed",
"index_Name": "CurrencyCode",
"null_Value": "usd"
},
"RenewalDate": {
"type": "Date",
"index": "not_analyzed",
"index_Name": "RenewalDate"
},
"ExpectedShares": {
"type": "double",
"index": "not_analyzed",
"index_Name": "ExpectedShares"
},
"SignedShares": {
"type": "double",
"index": "not_analyzed",
"index_Name": "SignedShares"
},
"WrittenShares": {
"type": "double",
"index": "not_analyzed",
"index_Name": "WrittenShares"
},
"WhatIfName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "WhatIfName",
"null_Value": "main"
},
"ClonedExposureId": {
"type": "long",
"index": "not_analyzed",
"index_Name": "ClonedExposureId"
},
"CloneTypeId": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "CloneTypeId"
},
"ContractTypeIsInsurance": {
"type": "boolean",
"index": "not_analyzed",
"index_Name": "ContractTypeIsInsurance"
},
"SourceId": {
"type": "string",
"index": "not_analyzed",
"index_Name": "SourceId"
},
"IsRenewal": {
"type": "boolean",
"index": "not_analyzed",
"index_Name": "IsRenewal"
},
"ProductAsOfDate": {
"type": "Date",
"index": "not_analyzed",
"index_Name": "ProductAsOfDate"
},
"Jurisdiction": {
"type": "string",
"index": "not_analyzed",
"index_Name": "Jurisdiction"
},
"IsCedantContract": {
"type": "boolean",
"index": "not_analyzed",
"index_Name": "IsCedantContract"
},
"CalculatedTIV": {
"type": "double",
"index": "not_analyzed",
"index_Name": "CalculatedTIV"
},
"CalculatedBuildingTIV": {
"type": "double",
"index": "not_analyzed",
"index_Name": "CalculatedBuildingTIV"
},
"CalculatedContentsTIV": {
"type": "double",
"index": "not_analyzed",
"index_Name": "CalculatedContentsTIV"
},
"CalculatedBITIV": {
"type": "double",
"index": "not_analyzed",
"index_Name": "CalculatedBITIV"
},
"RiskItemCount": {
"type": "long",
"index": "not_analyzed",
"index_Name": "RiskItemCount"
},
"ACLTag": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ACLTag"
},
"ImportSetId": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "ImportSetId"
}
}
}
}

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/3fc55f5f-332b-4975-8ac4-f6747a2333c0%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


(Alexander Reelsen) #5

Hey,

is it possible, that your query spans several indices, where one of this
indices is actually having an id field mapping to something else than a
number?
Can you limit your query to one index only and retry?
Can you otherwise create a gist to reproduce it locally?

--Alex

On Tue, Jan 14, 2014 at 1:40 AM, VB vishal.batghare@gmail.com wrote:

Can someone please help here. We are stuck at this point.

On Monday, 13 January 2014 15:31:49 UTC-8, VB wrote:

It even happens when there is only single record matches query criteria
and only happens with this ("Id") field. Does has to do with name of the
field?

Is there something internal logic with id field.?

On Monday, 13 January 2014 14:34:38 UTC-8, VB wrote:

Hello all,

I have a weird problem. When i try to run facet using following query I
get error that
PagedBytesIndexFieldData cannot be cast to org.elasticsearch.index.
fielddata.IndexNumericFieldData]

But my field is of long data type and I am not figure out why i am
getting error

This is the query

{
"query": {
"match_all": {}
},
"facets": {
"Id": {
"statistical": {
"field": "Id"
}
}
}
}

And these are my mappings

{
"contractsearch": {
"dynamic": "strict",
"properties": {
"TransactionIdList": {
"properties": {
"TransactionId": {
"type": "long",
"index": "not_analyzed",
"index_Name": "TransactionId"
}
},
"type": "nested"
},
"Id": {
"type": "long",
"index": "not_analyzed",
"index_Name": "Id"
},
"ExposureId": {
"type": "long",
"index": "not_analyzed",
"index_Name": "ExposureId"
},
"CreateUserId": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "CreateUserId"
},
"ExternalSourceName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ExternalSourceName",
"null_Value": "unasSigned"
},
"Name": {
"type": "string",
"index": "not_analyzed",
"index_Name": "Name"
},
"Description": {
"type": "string",
"index": "not_analyzed",
"index_Name": "Description"
},
"ExposureNumber": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ExposureNumber"
},
"ProgramName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ProgramName"
},
"ExposedPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ExposedPartyName",
"null_Value": "unasSigned"
},
"ContractTypeName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ContractTypeName",
"null_Value": "unasSigned"
},
"UserDefContractTypeName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "UserDefContractTypeName",
"null_Value": "unasSigned"
},
"LineofBusinessName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "LineofBusinessName",
"null_Value": "unasSigned"
},
"ContractStatusName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ContractStatusName",
"null_Value": "unasSigned"
},
"InsuredPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "InsuredPartyName",
"null_Value": "unasSigned"
},
"InsurerPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "InsurerPartyName",
"null_Value": "unasSigned"
},
"BrokerPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "BrokerPartyName",
"null_Value": "unasSigned"
},
"UnderwriterPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "UnderwriterPartyName",
"null_Value": "unasSigned"
},
"ProducerPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ProducerPartyName",
"null_Value": "unasSigned"
},
"AgentPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "AgentPartyName",
"null_Value": "unasSigned"
},
"UnderwritingAccountPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "UnderwritingAccountPartyName",
"null_Value": "unasSigned"
},
"BranchPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "BranchPartyName",
"null_Value": "unasSigned"
},
"AccountingOrganizationPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "AccountingOrganizationPartyName",
"null_Value": "unasSigned"
},
"LegalEntityPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "LegalEntityPartyName",
"null_Value": "unasSigned"
},
"CostCenterPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "CostCenterPartyName",
"null_Value": "unasSigned"
},
"HubPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "HubPartyName",
"null_Value": "unasSigned"
},
"OfficePartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "OfficePartyName",
"null_Value": "unasSigned"
},
"MarketChannelName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "MarketChannelName",
"null_Value": "unasSigned"
},
"InceptionDate": {
"type": "Date",
"index": "not_analyzed",
"index_Name": "InceptionDate"
},
"ExpirationDate": {
"type": "Date",
"index": "not_analyzed",
"index_Name": "ExpirationDate"
},
"AttachmentBasisName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "AttachmentBasisName",
"null_Value": "unasSigned"
},
"AttachmentLevelName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "AttachmentLevelName",
"null_Value": "unasSigned"
},
"ClaimAdjustmentDeductibleName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ClaimAdjustmentDeductibleName",
"null_Value": "unasSigned"
},
"ClaimAdjustmentSubmitName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ClaimAdjustmentSubmitName",
"null_Value": "unasSigned"
},
"ClaimAdjustmentSublimitName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ClaimAdjustmentSublimitName",
"null_Value": "unasSigned"
},
"Premium": {
"type": "double",
"index": "not_analyzed",
"index_Name": "Premium"
},
"PaidReinstatement": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "PaidReinstatement"
},
"FreeReinstatement": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "FreeReinstatement"
},
"ReinstatementsPercentCharge": {
"type": "double",
"index": "not_analyzed",
"index_Name": "ReinstatementsPercentCharge"
},
"ReinstatementsPremium": {
"type": "double",
"index": "not_analyzed",
"index_Name": "ReinstatementsPremium"
},
"IsProRataTemporis": {
"type": "boolean",
"index": "not_analyzed",
"index_Name": "IsProRataTemporis"
},
"ProductName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ProductName"
},
"PrimaryAccordOccupancyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "PrimaryAccordOccupancyName",
"null_Value": "unasSigned"
},
"CurrencyCode": {
"type": "string",
"index": "not_analyzed",
"index_Name": "CurrencyCode",
"null_Value": "usd"
},
"RenewalDate": {
"type": "Date",
"index": "not_analyzed",
"index_Name": "RenewalDate"
},
"ExpectedShares": {
"type": "double",
"index": "not_analyzed",
"index_Name": "ExpectedShares"
},
"SignedShares": {
"type": "double",
"index": "not_analyzed",
"index_Name": "SignedShares"
},
"WrittenShares": {
"type": "double",
"index": "not_analyzed",
"index_Name": "WrittenShares"
},
"WhatIfName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "WhatIfName",
"null_Value": "main"
},
"ClonedExposureId": {
"type": "long",
"index": "not_analyzed",
"index_Name": "ClonedExposureId"
},
"CloneTypeId": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "CloneTypeId"
},
"ContractTypeIsInsurance": {
"type": "boolean",
"index": "not_analyzed",
"index_Name": "ContractTypeIsInsurance"
},
"SourceId": {
"type": "string",
"index": "not_analyzed",
"index_Name": "SourceId"
},
"IsRenewal": {
"type": "boolean",
"index": "not_analyzed",
"index_Name": "IsRenewal"
},
"ProductAsOfDate": {
"type": "Date",
"index": "not_analyzed",
"index_Name": "ProductAsOfDate"
},
"Jurisdiction": {
"type": "string",
"index": "not_analyzed",
"index_Name": "Jurisdiction"
},
"IsCedantContract": {
"type": "boolean",
"index": "not_analyzed",
"index_Name": "IsCedantContract"
},
"CalculatedTIV": {
"type": "double",
"index": "not_analyzed",
"index_Name": "CalculatedTIV"
},
"CalculatedBuildingTIV": {
"type": "double",
"index": "not_analyzed",
"index_Name": "CalculatedBuildingTIV"
},
"CalculatedContentsTIV": {
"type": "double",
"index": "not_analyzed",
"index_Name": "CalculatedContentsTIV"
},
"CalculatedBITIV": {
"type": "double",
"index": "not_analyzed",
"index_Name": "CalculatedBITIV"
},
"RiskItemCount": {
"type": "long",
"index": "not_analyzed",
"index_Name": "RiskItemCount"
},
"ACLTag": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ACLTag"
},
"ImportSetId": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "ImportSetId"
}
}
}
}

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/3fc55f5f-332b-4975-8ac4-f6747a2333c0%40googlegroups.com
.

For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAGCwEM87p8C-1eDs5O%3DtiFMbkQM0D2881Vt5ATtRWhDWTdpbsA%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.


(VB) #6

Actually it is not.

I tried with another type which only 4 records and it was still giving same error.

Sent from my iPhone

On Jan 14, 2014, at 4:09 AM, Alexander Reelsen alr@spinscale.de wrote:

Hey,

is it possible, that your query spans several indices, where one of this indices is actually having an id field mapping to something else than a number?
Can you limit your query to one index only and retry?
Can you otherwise create a gist to reproduce it locally?

--Alex

On Tue, Jan 14, 2014 at 1:40 AM, VB vishal.batghare@gmail.com wrote:
Can someone please help here. We are stuck at this point.

On Monday, 13 January 2014 15:31:49 UTC-8, VB wrote:
It even happens when there is only single record matches query criteria and only happens with this ("Id") field. Does has to do with name of the field?

Is there something internal logic with id field.?

On Monday, 13 January 2014 14:34:38 UTC-8, VB wrote:
Hello all,

I have a weird problem. When i try to run facet using following query I get error that
PagedBytesIndexFieldData cannot be cast to org.elasticsearch.index.fielddata.IndexNumericFieldData]

But my field is of long data type and I am not figure out why i am getting error

This is the query

{
"query": {
"match_all": {}
},
"facets": {
"Id": {
"statistical": {
"field": "Id"
}
}
}
}

And these are my mappings

{
"contractsearch": {
"dynamic": "strict",
"properties": {
"TransactionIdList": {
"properties": {
"TransactionId": {
"type": "long",
"index": "not_analyzed",
"index_Name": "TransactionId"
}
},
"type": "nested"
},
"Id": {
"type": "long",
"index": "not_analyzed",
"index_Name": "Id"
},
"ExposureId": {
"type": "long",
"index": "not_analyzed",
"index_Name": "ExposureId"
},
"CreateUserId": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "CreateUserId"
},
"ExternalSourceName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ExternalSourceName",
"null_Value": "unasSigned"
},
"Name": {
"type": "string",
"index": "not_analyzed",
"index_Name": "Name"
},
"Description": {
"type": "string",
"index": "not_analyzed",
"index_Name": "Description"
},
"ExposureNumber": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ExposureNumber"
},
"ProgramName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ProgramName"
},
"ExposedPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ExposedPartyName",
"null_Value": "unasSigned"
},
"ContractTypeName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ContractTypeName",
"null_Value": "unasSigned"
},
"UserDefContractTypeName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "UserDefContractTypeName",
"null_Value": "unasSigned"
},
"LineofBusinessName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "LineofBusinessName",
"null_Value": "unasSigned"
},
"ContractStatusName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ContractStatusName",
"null_Value": "unasSigned"
},
"InsuredPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "InsuredPartyName",
"null_Value": "unasSigned"
},
"InsurerPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "InsurerPartyName",
"null_Value": "unasSigned"
},
"BrokerPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "BrokerPartyName",
"null_Value": "unasSigned"
},
"UnderwriterPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "UnderwriterPartyName",
"null_Value": "unasSigned"
},
"ProducerPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ProducerPartyName",
"null_Value": "unasSigned"
},
"AgentPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "AgentPartyName",
"null_Value": "unasSigned"
},
"UnderwritingAccountPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "UnderwritingAccountPartyName",
"null_Value": "unasSigned"
},
"BranchPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "BranchPartyName",
"null_Value": "unasSigned"
},
"AccountingOrganizationPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "AccountingOrganizationPartyName",
"null_Value": "unasSigned"
},
"LegalEntityPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "LegalEntityPartyName",
"null_Value": "unasSigned"
},
"CostCenterPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "CostCenterPartyName",
"null_Value": "unasSigned"
},
"HubPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "HubPartyName",
"null_Value": "unasSigned"
},
"OfficePartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "OfficePartyName",
"null_Value": "unasSigned"
},
"MarketChannelName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "MarketChannelName",
"null_Value": "unasSigned"
},
"InceptionDate": {
"type": "Date",
"index": "not_analyzed",
"index_Name": "InceptionDate"
},
"ExpirationDate": {
"type": "Date",
"index": "not_analyzed",
"index_Name": "ExpirationDate"
},
"AttachmentBasisName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "AttachmentBasisName",
"null_Value": "unasSigned"
},
"AttachmentLevelName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "AttachmentLevelName",
"null_Value": "unasSigned"
},
"ClaimAdjustmentDeductibleName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ClaimAdjustmentDeductibleName",
"null_Value": "unasSigned"
},
"ClaimAdjustmentSubmitName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ClaimAdjustmentSubmitName",
"null_Value": "unasSigned"
},
"ClaimAdjustmentSublimitName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ClaimAdjustmentSublimitName",
"null_Value": "unasSigned"
},
"Premium": {
"type": "double",
"index": "not_analyzed",
"index_Name": "Premium"
},
"PaidReinstatement": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "PaidReinstatement"
},
"FreeReinstatement": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "FreeReinstatement"
},
"ReinstatementsPercentCharge": {
"type": "double",
"index": "not_analyzed",
"index_Name": "ReinstatementsPercentCharge"
},
"ReinstatementsPremium": {
"type": "double",
"index": "not_analyzed",
"index_Name": "ReinstatementsPremium"
},
"IsProRataTemporis": {
"type": "boolean",
"index": "not_analyzed",
"index_Name": "IsProRataTemporis"
},
"ProductName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ProductName"
},
"PrimaryAccordOccupancyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "PrimaryAccordOccupancyName",
"null_Value": "unasSigned"
},
"CurrencyCode": {
"type": "string",
"index": "not_analyzed",
"index_Name": "CurrencyCode",
"null_Value": "usd"
},
"RenewalDate": {
"type": "Date",
"index": "not_analyzed",
"index_Name": "RenewalDate"
},
"ExpectedShares": {
"type": "double",
"index": "not_analyzed",
"index_Name": "ExpectedShares"
},
"SignedShares": {
"type": "double",
"index": "not_analyzed",
"index_Name": "SignedShares"
},
"WrittenShares": {
"type": "double",
"index": "not_analyzed",
"index_Name": "WrittenShares"
},
"WhatIfName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "WhatIfName",
"null_Value": "main"
},
"ClonedExposureId": {
"type": "long",
"index": "not_analyzed",
"index_Name": "ClonedExposureId"
},
"CloneTypeId": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "CloneTypeId"
},
"ContractTypeIsInsurance": {
"type": "boolean",
"index": "not_analyzed",
"index_Name": "ContractTypeIsInsurance"
},
"SourceId": {
"type": "string",
"index": "not_analyzed",
"index_Name": "SourceId"
},
"IsRenewal": {
"type": "boolean",
"index": "not_analyzed",
"index_Name": "IsRenewal"
},
"ProductAsOfDate": {
"type": "Date",
"index": "not_analyzed",
"index_Name": "ProductAsOfDate"
},
"Jurisdiction": {
"type": "string",
"index": "not_analyzed",
"index_Name": "Jurisdiction"
},
"IsCedantContract": {
"type": "boolean",
"index": "not_analyzed",
"index_Name": "IsCedantContract"
},
"CalculatedTIV": {
"type": "double",
"index": "not_analyzed",
"index_Name": "CalculatedTIV"
},
"CalculatedBuildingTIV": {
"type": "double",
"index": "not_analyzed",
"index_Name": "CalculatedBuildingTIV"
},
"CalculatedContentsTIV": {
"type": "double",
"index": "not_analyzed",
"index_Name": "CalculatedContentsTIV"
},
"CalculatedBITIV": {
"type": "double",
"index": "not_analyzed",
"index_Name": "CalculatedBITIV"
},
"RiskItemCount": {
"type": "long",
"index": "not_analyzed",
"index_Name": "RiskItemCount"
},
"ACLTag": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ACLTag"
},
"ImportSetId": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "ImportSetId"
}
}
}
}

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/3fc55f5f-332b-4975-8ac4-f6747a2333c0%40googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to a topic in the Google Groups "elasticsearch" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/elasticsearch/QOnRAd4X_AE/unsubscribe.
To unsubscribe from this group and all its topics, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAGCwEM87p8C-1eDs5O%3DtiFMbkQM0D2881Vt5ATtRWhDWTdpbsA%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/AFAE777A-2797-41CF-972C-2F332B4842FD%40gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.


(VB) #7

we are still facing this issue on and off.

can someone please help.

On Monday, 13 January 2014 14:34:38 UTC-8, VB wrote:

Hello all,

I have a weird problem. When i try to run facet using following query I
get error that
PagedBytesIndexFieldData cannot be cast to
org.elasticsearch.index.fielddata.IndexNumericFieldData]

But my field is of long data type and I am not figure out why i am getting
error

This is the query

{
"query": {
"match_all": {}
},
"facets": {
"Id": {
"statistical": {
"field": "Id"
}
}
}
}

And these are my mappings

{
"contractsearch": {
"dynamic": "strict",
"properties": {
"TransactionIdList": {
"properties": {
"TransactionId": {
"type": "long",
"index": "not_analyzed",
"index_Name": "TransactionId"
}
},
"type": "nested"
},
"Id": {
"type": "long",
"index": "not_analyzed",
"index_Name": "Id"
},
"ExposureId": {
"type": "long",
"index": "not_analyzed",
"index_Name": "ExposureId"
},
"CreateUserId": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "CreateUserId"
},
"ExternalSourceName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ExternalSourceName",
"null_Value": "unasSigned"
},
"Name": {
"type": "string",
"index": "not_analyzed",
"index_Name": "Name"
},
"Description": {
"type": "string",
"index": "not_analyzed",
"index_Name": "Description"
},
"ExposureNumber": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ExposureNumber"
},
"ProgramName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ProgramName"
},
"ExposedPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ExposedPartyName",
"null_Value": "unasSigned"
},
"ContractTypeName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ContractTypeName",
"null_Value": "unasSigned"
},
"UserDefContractTypeName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "UserDefContractTypeName",
"null_Value": "unasSigned"
},
"LineofBusinessName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "LineofBusinessName",
"null_Value": "unasSigned"
},
"ContractStatusName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ContractStatusName",
"null_Value": "unasSigned"
},
"InsuredPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "InsuredPartyName",
"null_Value": "unasSigned"
},
"InsurerPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "InsurerPartyName",
"null_Value": "unasSigned"
},
"BrokerPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "BrokerPartyName",
"null_Value": "unasSigned"
},
"UnderwriterPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "UnderwriterPartyName",
"null_Value": "unasSigned"
},
"ProducerPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ProducerPartyName",
"null_Value": "unasSigned"
},
"AgentPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "AgentPartyName",
"null_Value": "unasSigned"
},
"UnderwritingAccountPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "UnderwritingAccountPartyName",
"null_Value": "unasSigned"
},
"BranchPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "BranchPartyName",
"null_Value": "unasSigned"
},
"AccountingOrganizationPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "AccountingOrganizationPartyName",
"null_Value": "unasSigned"
},
"LegalEntityPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "LegalEntityPartyName",
"null_Value": "unasSigned"
},
"CostCenterPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "CostCenterPartyName",
"null_Value": "unasSigned"
},
"HubPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "HubPartyName",
"null_Value": "unasSigned"
},
"OfficePartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "OfficePartyName",
"null_Value": "unasSigned"
},
"MarketChannelName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "MarketChannelName",
"null_Value": "unasSigned"
},
"InceptionDate": {
"type": "Date",
"index": "not_analyzed",
"index_Name": "InceptionDate"
},
"ExpirationDate": {
"type": "Date",
"index": "not_analyzed",
"index_Name": "ExpirationDate"
},
"AttachmentBasisName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "AttachmentBasisName",
"null_Value": "unasSigned"
},
"AttachmentLevelName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "AttachmentLevelName",
"null_Value": "unasSigned"
},
"ClaimAdjustmentDeductibleName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ClaimAdjustmentDeductibleName",
"null_Value": "unasSigned"
},
"ClaimAdjustmentSubmitName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ClaimAdjustmentSubmitName",
"null_Value": "unasSigned"
},
"ClaimAdjustmentSublimitName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ClaimAdjustmentSublimitName",
"null_Value": "unasSigned"
},
"Premium": {
"type": "double",
"index": "not_analyzed",
"index_Name": "Premium"
},
"PaidReinstatement": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "PaidReinstatement"
},
"FreeReinstatement": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "FreeReinstatement"
},
"ReinstatementsPercentCharge": {
"type": "double",
"index": "not_analyzed",
"index_Name": "ReinstatementsPercentCharge"
},
"ReinstatementsPremium": {
"type": "double",
"index": "not_analyzed",
"index_Name": "ReinstatementsPremium"
},
"IsProRataTemporis": {
"type": "boolean",
"index": "not_analyzed",
"index_Name": "IsProRataTemporis"
},
"ProductName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ProductName"
},
"PrimaryAccordOccupancyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "PrimaryAccordOccupancyName",
"null_Value": "unasSigned"
},
"CurrencyCode": {
"type": "string",
"index": "not_analyzed",
"index_Name": "CurrencyCode",
"null_Value": "usd"
},
"RenewalDate": {
"type": "Date",
"index": "not_analyzed",
"index_Name": "RenewalDate"
},
"ExpectedShares": {
"type": "double",
"index": "not_analyzed",
"index_Name": "ExpectedShares"
},
"SignedShares": {
"type": "double",
"index": "not_analyzed",
"index_Name": "SignedShares"
},
"WrittenShares": {
"type": "double",
"index": "not_analyzed",
"index_Name": "WrittenShares"
},
"WhatIfName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "WhatIfName",
"null_Value": "main"
},
"ClonedExposureId": {
"type": "long",
"index": "not_analyzed",
"index_Name": "ClonedExposureId"
},
"CloneTypeId": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "CloneTypeId"
},
"ContractTypeIsInsurance": {
"type": "boolean",
"index": "not_analyzed",
"index_Name": "ContractTypeIsInsurance"
},
"SourceId": {
"type": "string",
"index": "not_analyzed",
"index_Name": "SourceId"
},
"IsRenewal": {
"type": "boolean",
"index": "not_analyzed",
"index_Name": "IsRenewal"
},
"ProductAsOfDate": {
"type": "Date",
"index": "not_analyzed",
"index_Name": "ProductAsOfDate"
},
"Jurisdiction": {
"type": "string",
"index": "not_analyzed",
"index_Name": "Jurisdiction"
},
"IsCedantContract": {
"type": "boolean",
"index": "not_analyzed",
"index_Name": "IsCedantContract"
},
"CalculatedTIV": {
"type": "double",
"index": "not_analyzed",
"index_Name": "CalculatedTIV"
},
"CalculatedBuildingTIV": {
"type": "double",
"index": "not_analyzed",
"index_Name": "CalculatedBuildingTIV"
},
"CalculatedContentsTIV": {
"type": "double",
"index": "not_analyzed",
"index_Name": "CalculatedContentsTIV"
},
"CalculatedBITIV": {
"type": "double",
"index": "not_analyzed",
"index_Name": "CalculatedBITIV"
},
"RiskItemCount": {
"type": "long",
"index": "not_analyzed",
"index_Name": "RiskItemCount"
},
"ACLTag": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ACLTag"
},
"ImportSetId": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "ImportSetId"
}
}
}
}

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/296c39dc-1ad3-43e6-85e7-6f6ed3e34eee%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


(Alexander Reelsen) #8

Hey,

again, can you create a gist, so other people can reproduce it locally (a
minimal example, so please strip out everything as needed, but still show
the error)? See http://www.elasticsearch.org/help
The more information you give, the more likely you will get help. Thanks!

--Alex

On Fri, Jan 17, 2014 at 6:47 PM, VB vishal.batghare@gmail.com wrote:

we are still facing this issue on and off.

can someone please help.

On Monday, 13 January 2014 14:34:38 UTC-8, VB wrote:

Hello all,

I have a weird problem. When i try to run facet using following query I
get error that
PagedBytesIndexFieldData cannot be cast to org.elasticsearch.index.
fielddata.IndexNumericFieldData]

But my field is of long data type and I am not figure out why i am
getting error

This is the query

{
"query": {
"match_all": {}
},
"facets": {
"Id": {
"statistical": {
"field": "Id"
}
}
}
}

And these are my mappings

{
"contractsearch": {
"dynamic": "strict",
"properties": {
"TransactionIdList": {
"properties": {
"TransactionId": {
"type": "long",
"index": "not_analyzed",
"index_Name": "TransactionId"
}
},
"type": "nested"
},
"Id": {
"type": "long",
"index": "not_analyzed",
"index_Name": "Id"
},
"ExposureId": {
"type": "long",
"index": "not_analyzed",
"index_Name": "ExposureId"
},
"CreateUserId": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "CreateUserId"
},
"ExternalSourceName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ExternalSourceName",
"null_Value": "unasSigned"
},
"Name": {
"type": "string",
"index": "not_analyzed",
"index_Name": "Name"
},
"Description": {
"type": "string",
"index": "not_analyzed",
"index_Name": "Description"
},
"ExposureNumber": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ExposureNumber"
},
"ProgramName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ProgramName"
},
"ExposedPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ExposedPartyName",
"null_Value": "unasSigned"
},
"ContractTypeName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ContractTypeName",
"null_Value": "unasSigned"
},
"UserDefContractTypeName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "UserDefContractTypeName",
"null_Value": "unasSigned"
},
"LineofBusinessName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "LineofBusinessName",
"null_Value": "unasSigned"
},
"ContractStatusName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ContractStatusName",
"null_Value": "unasSigned"
},
"InsuredPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "InsuredPartyName",
"null_Value": "unasSigned"
},
"InsurerPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "InsurerPartyName",
"null_Value": "unasSigned"
},
"BrokerPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "BrokerPartyName",
"null_Value": "unasSigned"
},
"UnderwriterPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "UnderwriterPartyName",
"null_Value": "unasSigned"
},
"ProducerPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ProducerPartyName",
"null_Value": "unasSigned"
},
"AgentPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "AgentPartyName",
"null_Value": "unasSigned"
},
"UnderwritingAccountPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "UnderwritingAccountPartyName",
"null_Value": "unasSigned"
},
"BranchPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "BranchPartyName",
"null_Value": "unasSigned"
},
"AccountingOrganizationPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "AccountingOrganizationPartyName",
"null_Value": "unasSigned"
},
"LegalEntityPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "LegalEntityPartyName",
"null_Value": "unasSigned"
},
"CostCenterPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "CostCenterPartyName",
"null_Value": "unasSigned"
},
"HubPartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "HubPartyName",
"null_Value": "unasSigned"
},
"OfficePartyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "OfficePartyName",
"null_Value": "unasSigned"
},
"MarketChannelName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "MarketChannelName",
"null_Value": "unasSigned"
},
"InceptionDate": {
"type": "Date",
"index": "not_analyzed",
"index_Name": "InceptionDate"
},
"ExpirationDate": {
"type": "Date",
"index": "not_analyzed",
"index_Name": "ExpirationDate"
},
"AttachmentBasisName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "AttachmentBasisName",
"null_Value": "unasSigned"
},
"AttachmentLevelName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "AttachmentLevelName",
"null_Value": "unasSigned"
},
"ClaimAdjustmentDeductibleName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ClaimAdjustmentDeductibleName",
"null_Value": "unasSigned"
},
"ClaimAdjustmentSubmitName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ClaimAdjustmentSubmitName",
"null_Value": "unasSigned"
},
"ClaimAdjustmentSublimitName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ClaimAdjustmentSublimitName",
"null_Value": "unasSigned"
},
"Premium": {
"type": "double",
"index": "not_analyzed",
"index_Name": "Premium"
},
"PaidReinstatement": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "PaidReinstatement"
},
"FreeReinstatement": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "FreeReinstatement"
},
"ReinstatementsPercentCharge": {
"type": "double",
"index": "not_analyzed",
"index_Name": "ReinstatementsPercentCharge"
},
"ReinstatementsPremium": {
"type": "double",
"index": "not_analyzed",
"index_Name": "ReinstatementsPremium"
},
"IsProRataTemporis": {
"type": "boolean",
"index": "not_analyzed",
"index_Name": "IsProRataTemporis"
},
"ProductName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ProductName"
},
"PrimaryAccordOccupancyName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "PrimaryAccordOccupancyName",
"null_Value": "unasSigned"
},
"CurrencyCode": {
"type": "string",
"index": "not_analyzed",
"index_Name": "CurrencyCode",
"null_Value": "usd"
},
"RenewalDate": {
"type": "Date",
"index": "not_analyzed",
"index_Name": "RenewalDate"
},
"ExpectedShares": {
"type": "double",
"index": "not_analyzed",
"index_Name": "ExpectedShares"
},
"SignedShares": {
"type": "double",
"index": "not_analyzed",
"index_Name": "SignedShares"
},
"WrittenShares": {
"type": "double",
"index": "not_analyzed",
"index_Name": "WrittenShares"
},
"WhatIfName": {
"type": "string",
"index": "not_analyzed",
"index_Name": "WhatIfName",
"null_Value": "main"
},
"ClonedExposureId": {
"type": "long",
"index": "not_analyzed",
"index_Name": "ClonedExposureId"
},
"CloneTypeId": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "CloneTypeId"
},
"ContractTypeIsInsurance": {
"type": "boolean",
"index": "not_analyzed",
"index_Name": "ContractTypeIsInsurance"
},
"SourceId": {
"type": "string",
"index": "not_analyzed",
"index_Name": "SourceId"
},
"IsRenewal": {
"type": "boolean",
"index": "not_analyzed",
"index_Name": "IsRenewal"
},
"ProductAsOfDate": {
"type": "Date",
"index": "not_analyzed",
"index_Name": "ProductAsOfDate"
},
"Jurisdiction": {
"type": "string",
"index": "not_analyzed",
"index_Name": "Jurisdiction"
},
"IsCedantContract": {
"type": "boolean",
"index": "not_analyzed",
"index_Name": "IsCedantContract"
},
"CalculatedTIV": {
"type": "double",
"index": "not_analyzed",
"index_Name": "CalculatedTIV"
},
"CalculatedBuildingTIV": {
"type": "double",
"index": "not_analyzed",
"index_Name": "CalculatedBuildingTIV"
},
"CalculatedContentsTIV": {
"type": "double",
"index": "not_analyzed",
"index_Name": "CalculatedContentsTIV"
},
"CalculatedBITIV": {
"type": "double",
"index": "not_analyzed",
"index_Name": "CalculatedBITIV"
},
"RiskItemCount": {
"type": "long",
"index": "not_analyzed",
"index_Name": "RiskItemCount"
},
"ACLTag": {
"type": "string",
"index": "not_analyzed",
"index_Name": "ACLTag"
},
"ImportSetId": {
"type": "integer",
"index": "not_analyzed",
"index_Name": "ImportSetId"
}
}
}
}

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/296c39dc-1ad3-43e6-85e7-6f6ed3e34eee%40googlegroups.com
.

For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAGCwEM-Ui3TuUvMNbJvXLTF9xfBwp3NSOT9oSRf1cAwakR6uOA%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.


(VB) #9

Sure thing here are the detail.

We have type with following mapping with "dynamic": "strict" so other
datatype data can let go in. Note, it has a field "Id" with long datatype.

When we try to get statistical facet on Id it gives error* PagedBytesIndexFieldData
cannot be cast to org.elasticsearch.index.fielddata.IndexNumericFieldData]*

And it happens randomly, once I wipe out index and create it again, it
works for some time and then all of a sudden it start giving error.

{
"portfoliosearch": {
"dynamic": "strict",
"properties": {
"Id": {
"type": "long",
"index": "not_analyzed",
"index_Name": "Id"
}
"Name": {
"type": "string",
"index": "not_analyzed",
"index_Name": "Name"
}
},
"_routing": {
"required": true
},
"_parent": {
"type": "importsetsearch"
}
}
}

statistical query

{
"query": {
"match_all": {}
},
"facets": {
"Id": {
"statistical": {
"field": "Id"
}
}
}
}

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/fe471294-43c7-48b8-ab6a-0248f8c1d6a0%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


(system) #10