lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abhijit Pawar <apa...@ibizsoftinc.com>
Subject Re: Fieldtype json supported in SOLR 5.4.0 or 5.4.1
Date Mon, 03 Apr 2017 01:02:16 GMT
Hi Edwin,
​​

I had to replace <<IP Address>> value with <<HOSTNAME>> in <dataSource
name="mongod" type="JdbcDataSource" driver="com.mongodb.jdbc.MongoDriver"
url="mongodb://<<>IP-Address>:27017/<<DB-NAME>>"/>

in my data-source-config file and was able to index the data.

​However w​
ith IP address it is still not working.
In solr-config.xml I am not seeing anywhere to mention schema.xml or
managed-schema.xml.

​Meanwhile going back to my original question - what fieldtype to use for
JSON field in mongoDB ?

Currently for field "pricing" in my data-source-config file​
​
​ I am using String Array as a datatype :

​
data-source-config file​
​
​ :
​

​<field column="pricing" name="pricing"/>​

​managed-schema.xml (for SOLR 6.0) /schema.xml(for older version of SOLR)​ :

<field name="pricing" type="string" indexed="true" stored="true"
​ multiValued="true"​

​/>

However it just shows and empty array when data is indexed.Any idea how to
define field of type JSON ?​
​

Best Regards,
<http://www.ibizsoftinc.com/>
<http://www.ibizsoftinc.com/>
Abhijit Pawar
Office : +1 (469) 287 2005 x 110



Follow us on:





On Sat, Apr 1, 2017 at 10:12 AM, Zheng Lin Edwin Yeo <edwinyeozl@gmail.com>
wrote:

> Did you upgrade your solrconfig.xml to the Solr 6.0 version too?
> There are some difference in Solr 6.0 version which requires setting to
> determine whether to use managed-schema or classic schema (the physical
> schema.xml file)
>
> Regards,
> Edwin
>
> On 1 April 2017 at 01:27, Abhijit Pawar <abhijit.ibizsoft@gmail.com>
> wrote:
>
> > Hi Rick,
> >
> > I tried installing SOLR 6.0 since SOLR 6.0 has managed-schema and tried
> > index the data from mongoDB :
> >
> >
> > <dataConfig>
> > <dataSource name="mongod" type="JdbcDataSource"
> > driver="com.mongodb.jdbc.MongoDriver" url="mongodb://
> > ​<<>IP-Address>​
> > :27017/
> > ​<<DB-NAME>>
> > "/>
> > <document name="products">
> > <entity name="products"
> > dataSource="mongod"
> > transformer="TemplateTransformer,ProdsCatsFieldTransformer"
> > onError="continue"
> > pk="uuid"
> > query="SELECT
> > orgidStr,idStr,name,code,description,price,images,
> > categoriesStr,enddate_solar,begin_date_solar,status_solar,
> > current_stock_solar,retprice_solar,distprice_solar,
> > listprice_solar,mfgprice_solar,out_of_stock_solar,hide_
> > product_solar,saleprice_solar,metakey_solar,sales_enabled,
> > new_product,has_sku,configurable,rating,updatedAt,comparable,hide_price
> > FROM products"
> > deltaImportQuery="SELECT
> > orgidStr,idStr,name,code,description,price,images,
> > categoriesStr,enddate_solar,begin_date_solar,status_solar,
> > current_stock_solar,retprice_solar,distprice_solar,
> > listprice_solar,mfgprice_solar,out_of_stock_solar,hide_
> > product_solar,saleprice_solar,metakey_solar,sales_enabled,
> > new_product,has_sku,configurable,rating,updatedAt,comparable,hide_price
> > FROM products WHERE orgidStr = '${dataimporter.request.orgid}' AND
> idStr =
> > '${dataimporter.delta.idStr}'"
> > deltaQuery="SELECT idStr FROM products WHERE idStr =
> > '${dataimporter.request.prodidStr}' AND orgidStr =
> > '${dataimporter.request.orgid}'"
> > >
> > <field column="orgidStr" name="prod_orgidStr"/>
> > <field column="idStr" name="prod_idStr"/>
> > <field column="uuid" name="uuid"
> > template="org-${products.orgidStr}-prod-${products.idStr}"/>
> > <field column="name" name="prod_name"/>
> > <field column="code" name="prod_code"/>
> > <field column="description" name="description"/>
> > <field column="price" name="price"/>
> >
> >
> > ​This is the error I get :
> >
> > getNext() failed for query 'SELECT
> > orgidStr,idStr,name,code,description,price,images,
> > categoriesStr,enddate_solar,begin_date_solar,status_solar,
> > current_stock_solar,retprice_solar,distprice_solar,
> > listprice_solar,mfgprice_solar,out_of_stock_solar,hide_
> > product_solar,saleprice_solar,metakey_solar,sales_enabled,
> > new_product,has_sku,configurable,rating,updatedAt,comparable,hide_price
> > FROM products'
> >
> > :com.mongodb.MongoException$Network: can't call something : /
> > ​<<IP ADDRESS>>
> > :27017/
> > ​<<DB NAME>>
> >
> >
> >
> > Caused by: java.io.IOException: couldn't connect to [/
> > ​
> > ​<<IP ADDRESS>>:27017] bc:java.net.SocketTimeoutException: connect
timed
> > out
> >
> > ​Have anyone else gone through this kind of issue ?
> >
> >
> >
> >
> > On Tue, Mar 28, 2017 at 6:20 PM, Rick Leir <rleir@leirtech.com> wrote:
> >
> > > Abhijit
> > > In Mongo you probably have one JSON record per document. You can post
> > that
> > > JSON record to Solr, and the JSON fields get indexed. The github
> project
> > > you mention does just that. If you use the Solr managed schema then
> Solr
> > > will automatically define fields based on what it receives. Otherwise
> you
> > > will need to carefully design a schema.xml.
> > > Cheers -- Rick
> > >
> > > On March 28, 2017 6:08:40 PM EDT, Abhijit Pawar <
> > > abhijit.ibizsoft@gmail.com> wrote:
> > > >Hello All,
> > > >
> > > >I am working on a requirement to index field of type JSON (in mongoDB
> > > >collection) in SOLR 5.4.0.
> > > >
> > > >I am using mongo-jdbc-dih which I found on GitHub :
> > > >
> > > >https://github.com/hrishik/solr-mongodb-dih
> > > >
> > > >However I could not find a fieldtype on Apache SOLR wiki page which
> > > >would
> > > >support JSON datatype in mongoDB.
> > > >
> > > >Can someone please recommend a way to include datatype / fieldtype in
> > > >SOLR
> > > >schema to support or index JSON data field from mongoDB.
> > > >Thanks.
> > > >
> > > >R​egards,
> > > >
> > > >Abhijit​
> > >
> > > --
> > > Sent from my Android device with K-9 Mail. Please excuse my brevity.
> >
>

Mime
  • Unnamed multipart/related (inline, None, 0 bytes)
View raw message