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 <[email protected]> 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 <[email protected]> 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 [email protected]. >> 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 > [email protected]. > 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 [email protected]. 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.
