lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ahmet Arslan <iori...@yahoo.com>
Subject Re: Empty facets on Solr with MySQL
Date Thu, 02 Jan 2014 19:00:53 GMT
Hi Peter,

I think you meant faceting on cat_name_raw field.
facet=true&facet.field=cat_name_raw

Second check if that field is actually popupated. Below URL or at Schema Browser link.
q=*:*&fl=cat_name* 

Ahmet

On Thursday, January 2, 2014 8:45 PM, PeterKerk <vetteparty@hotmail.com> wrote:
I've set up Solr with MySQL.
My data import is succesful:
http://localhost:8983/solr/wordpress/dataimport?command=full-import

However, when trying to get the cat_name facets all facets are empty: 
http://localhost:8983/solr/wordpress/select/?indent=on&facet=true&sort=post_modified%20desc&q=*:*&start=0&rows=10&fl=id,post_title&facet.field=cat_name&facet.mincount=1

**data-config.xml**
    <dataConfig>
    <dataSource type="JdbcDataSource" driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/wordp" user="***" password="***" />
        <document name="articles">
            <entity pk="ID" name="article" query="SELECT p.*, ( SELECT guid FROM
wp_posts WHERE id = m.meta_value ) AS imgurl 
    FROM wp_posts p
    LEFT JOIN  wp_postmeta m ON(p.id = m.post_id AND m.meta_key = 
'_thumbnail_id' )
    WHERE p.post_type =  'post'
    AND p.post_status =  'publish';">
            
                <entity name="post_categories" query="select wt.name as
cat_name,wt.slug,wtr.term_taxonomy_id,wtt.term_id,wtt.taxonomy from 
    wp_term_relationships wtr
    INNER JOIN wp_term_taxonomy wtt ON
wtt.term_taxonomy_id=wtr.term_taxonomy_id AND wtt.taxonomy='category'
    INNER JOIN wp_terms wt ON wt.term_id=wtt.term_taxonomy_id
    where wtr.object_id='${article.id}';">
                </entity>    
            </entity>
        </document>
    </dataConfig>


**schema.xml**

    <field name="cat_name" type="text" indexed="true" stored="true"
multiValued="true"  />    
    <field name="cat_name_raw" type="string" indexed="true" stored="true"
multiValued="true" />
    <copyField source="cat_name" dest="cat_name_raw"/>

What am I missing?

    
    



--
View this message in context: http://lucene.472066.n3.nabble.com/Empty-facets-on-Solr-with-MySQL-tp4109170.html
Sent from the Solr - User mailing list archive at Nabble.com.


Mime
View raw message