Reply
Highlighted
Expert Contributor
Posts: 131
Registered: ‎08-08-2013

Index field contains: "ERROR:SCHEMA-INDEX-MISMATCH,stringValue=466148866"

Hello,

 

I have a problem putting a HBase table into SOLR appropriately. In the meantime the HBaseMapReduceImporter (at least) runs successfully and imports one single row, but the SOLR index contains two fields with value "ERROR:SCHEMA-INDEX-MISMATCH,stringValue=...", see below:

 

"response": {
    "numFound": 1,
    "start": 0,
    "docs": [
      {
        "txt1": "",
        "txt2": "784875741847",
        "code1": "",
        "snd_id": "ERROR:SCHEMA-INDEX-MISMATCH,stringValue=466148866",
        "id": "0000008b139703fda9eafb21474f2cb0d3a77e03",
        "code2": "ERROR:SCHEMA-INDEX-MISMATCH,stringValue=993610973100067865",
        "_version_": 1559315297701200000
      }
    ]
  }

Both fiels are defined as "text_general" in schema.xml, e.g.

<field name="snd_id" type="text_general" indexed="True" stored="True" required="True" />
  

If I modify above field to type "long", the HBaseMRIndexer fails with error message:

Caused by: org.apache.solr.common.SolrException: Invalid Number: MA147LL/A
        at org.apache.solr.schema.TrieField.readableToIndexed(TrieField.java:409)
        at org.apache.solr.schema.TrieField.readableToIndexed(TrieField.java:379)
        at org.apache.solr.handler.component.QueryElevationComponent$ElevationObj.<init>(QueryElevationComponent.java:151)
        at org.apache.solr.handler.component.QueryElevationComponent.loadElevationMap(QueryElevationComponent.java:324)
        at org.apache.solr.handler.component.QueryElevationComponent.inform(QueryElevationComponent.java:238)

I am a bit confused, because this "Invalid Number" doesn't correspond to a value of the "SCHEMA-INDEX-MISMATCH" values....

...and I am just importing/indexing one single row from HBase (yes, always the same row ;) ).

 

Any hints ?

 

Thanks in advance...