You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by Sudheer Shinde <su...@gmail.com> on 2018/10/08 15:59:19 UTC
not able to use deleteDocByQuery: please provide detailed example
my schema:
id is primary key here:
<field name="id" type="string" indexed="true" stored="true"
required="true" multiValued="false"/>
<field indexed="true" multiValued="false" docValues="true"
name="TC_0Y0_ItemRevision_0Y0_awp0Item_item_id" required="false"
stored="false" type="string"/>
<field indexed="true" multiValued="false" docValues="true"
name="TC_0Y0_Item_uid" required="false" stored="false" type="string"/>
<field indexed="true" multiValued="false" docValues="true"
name="TC_0Y0_ProductScope_0Y0_product_uid" required="false" stored="true"
type="string"/>
I want to delete using field TC_0Y0_ProductScope_0Y0_product_uid:
my db-data config file:
<entity name="onlydeleteByQuery" pk="pproduct"
transformer="TemplateTransformer"
query="Select pproduct from PQSEARCHINDEXEDPRODUCT t1 where t1.pis_deleted
= 1" >
<field column="${deleteDocByQuery}"
template="TC_0Y0_ProductScope_0Y0_product_uid:${onlydeleteByQuery.pproduct}"/>
<field column="ID" name="id" />
<field column="ITEMID" name="TC_0Y0_ItemRevision_0Y0_awp0Item_item_id" />
<field column="POBJECT" name="TC_0Y0_Item_uid" />
<field column="PEND_ITEM" name="TC_0Y0_ProductScope_0Y0_product_uid" />
</entity>
Re: not able to use deleteDocByQuery: please provide detailed example
Posted by Erick Erickson <er...@gmail.com>.
Chris:
Please follow the instructions here:
http://lucene.apache.org/solr/community.html#mailing-lists-irc. You
must use the _exact_ same e-mail as you used to subscribe.
If the initial try doesn't work and following the suggestions at the
"problems" link doesn't work for you, let us know. But note you need
to show us the _entire_ return header to allow anyone to diagnose the
problem.
Best,
Erick
On Mon, Oct 8, 2018 at 2:48 PM Chris Gerke <ch...@gmail.com> wrote:
>
> UNSUBSCRIBE
>
> On Tue, 9 Oct 2018 at 4:36 am, Sudheer Shinde <su...@gmail.com>
> wrote:
>
> > solr 6.2.1:
> >
> > my schema:
> >
> > id is primary key here:
> >
> > <field name="id" type="string" indexed="true" stored="true"
> > required="true" multiValued="false"/>
> > <field indexed="true" multiValued="false" docValues="true"
> > name="TC_0Y0_ItemRevision_0Y0_awp0Item_item_id" required="false"
> > stored="false" type="string"/>
> > <field indexed="true" multiValued="false" docValues="true"
> > name="TC_0Y0_Item_uid" required="false" stored="false" type="string"/>
> > <field indexed="true" multiValued="false" docValues="true"
> > name="TC_0Y0_ProductScope_0Y0_product_uid" required="false" stored="true"
> > type="string"/>
> >
> >
> >
> > I want to delete using field TC_0Y0_ProductScope_0Y0_product_uid:
> >
> > my db-data config file:
> > <entity name="onlydeleteByQuery" pk="pproduct"
> > transformer="TemplateTransformer"
> > query="Select pproduct from PQSEARCHINDEXEDPRODUCT t1 where t1.pis_deleted
> > = 1" >
> > <field column="${deleteDocByQuery}"
> >
> > template="TC_0Y0_ProductScope_0Y0_product_uid:${onlydeleteByQuery.pproduct}"/>
> > <field column="ID" name="id" />
> > <field column="ITEMID" name="TC_0Y0_ItemRevision_0Y0_awp0Item_item_id" />
> > <field column="POBJECT" name="TC_0Y0_Item_uid" />
> > <field column="PEND_ITEM" name="TC_0Y0_ProductScope_0Y0_product_uid" />
> > </entity>
> >
Re: not able to use deleteDocByQuery: please provide detailed example
Posted by Chris Gerke <ch...@gmail.com>.
UNSUBSCRIBE
On Tue, 9 Oct 2018 at 4:36 am, Sudheer Shinde <su...@gmail.com>
wrote:
> solr 6.2.1:
>
> my schema:
>
> id is primary key here:
>
> <field name="id" type="string" indexed="true" stored="true"
> required="true" multiValued="false"/>
> <field indexed="true" multiValued="false" docValues="true"
> name="TC_0Y0_ItemRevision_0Y0_awp0Item_item_id" required="false"
> stored="false" type="string"/>
> <field indexed="true" multiValued="false" docValues="true"
> name="TC_0Y0_Item_uid" required="false" stored="false" type="string"/>
> <field indexed="true" multiValued="false" docValues="true"
> name="TC_0Y0_ProductScope_0Y0_product_uid" required="false" stored="true"
> type="string"/>
>
>
>
> I want to delete using field TC_0Y0_ProductScope_0Y0_product_uid:
>
> my db-data config file:
> <entity name="onlydeleteByQuery" pk="pproduct"
> transformer="TemplateTransformer"
> query="Select pproduct from PQSEARCHINDEXEDPRODUCT t1 where t1.pis_deleted
> = 1" >
> <field column="${deleteDocByQuery}"
>
> template="TC_0Y0_ProductScope_0Y0_product_uid:${onlydeleteByQuery.pproduct}"/>
> <field column="ID" name="id" />
> <field column="ITEMID" name="TC_0Y0_ItemRevision_0Y0_awp0Item_item_id" />
> <field column="POBJECT" name="TC_0Y0_Item_uid" />
> <field column="PEND_ITEM" name="TC_0Y0_ProductScope_0Y0_product_uid" />
> </entity>
>
not able to use deleteDocByQuery: please provide detailed example
Posted by Sudheer Shinde <su...@gmail.com>.
solr 6.2.1:
my schema:
id is primary key here:
<field name="id" type="string" indexed="true" stored="true"
required="true" multiValued="false"/>
<field indexed="true" multiValued="false" docValues="true"
name="TC_0Y0_ItemRevision_0Y0_awp0Item_item_id" required="false"
stored="false" type="string"/>
<field indexed="true" multiValued="false" docValues="true"
name="TC_0Y0_Item_uid" required="false" stored="false" type="string"/>
<field indexed="true" multiValued="false" docValues="true"
name="TC_0Y0_ProductScope_0Y0_product_uid" required="false" stored="true"
type="string"/>
I want to delete using field TC_0Y0_ProductScope_0Y0_product_uid:
my db-data config file:
<entity name="onlydeleteByQuery" pk="pproduct"
transformer="TemplateTransformer"
query="Select pproduct from PQSEARCHINDEXEDPRODUCT t1 where t1.pis_deleted
= 1" >
<field column="${deleteDocByQuery}"
template="TC_0Y0_ProductScope_0Y0_product_uid:${onlydeleteByQuery.pproduct}"/>
<field column="ID" name="id" />
<field column="ITEMID" name="TC_0Y0_ItemRevision_0Y0_awp0Item_item_id" />
<field column="POBJECT" name="TC_0Y0_Item_uid" />
<field column="PEND_ITEM" name="TC_0Y0_ProductScope_0Y0_product_uid" />
</entity>
Re: not able to use deleteDocByQuery: please provide detailed example
Posted by Sudheer Shinde <su...@gmail.com>.
Thanks!
Sudheer
On Mon 8 Oct, 2018, 10:14 PM Steve Rowe, <sa...@gmail.com> wrote:
> Hi Sudheer,
>
> As Erick mentioned on SOLR-12841, you should post your question to the
> solr-user mailing list, rather than to this list (the Lucene/Solr
> development list).
>
> --
> Steve
> www.lucidworks.com
>
> > On Oct 8, 2018, at 12:02 PM, Sudheer Shinde <su...@gmail.com>
> wrote:
> >
> > Solr version 6.2.1:
> > my schema:
> > id is primary key here:
> > <field name="id" type="string" indexed="true" stored="true"
> required="true" multiValued="false"/>
> > <field indexed="true" multiValued="false" docValues="true"
> name="TC_0Y0_ItemRevision_0Y0_awp0Item_item_id" required="false"
> stored="false" type="string"/>
> > <field indexed="true" multiValued="false" docValues="true"
> name="TC_0Y0_Item_uid" required="false" stored="false" type="string"/>
> > <field indexed="true" multiValued="false" docValues="true"
> name="TC_0Y0_ProductScope_0Y0_product_uid" required="false" stored="true"
> type="string"/>
> >
> > I want to delete using field TC_0Y0_ProductScope_0Y0_product_uid:
> > my db-data config file:
> > <entity name="onlydeleteByQuery" pk="pproduct"
> transformer="TemplateTransformer"
> > query="Select pproduct from PQSEARCHINDEXEDPRODUCT t1 where
> t1.pis_deleted = 1" >
> > <field column="${deleteDocByQuery}"
> template="TC_0Y0_ProductScope_0Y0_product_uid:${onlydeleteByQuery.pproduct}"/>
> > <field column="ID" name="id" />
> > <field column="ITEMID" name="TC_0Y0_ItemRevision_0Y0_awp0Item_item_id" />
> > <field column="POBJECT" name="TC_0Y0_Item_uid" />
> > <field column="PEND_ITEM" name="TC_0Y0_ProductScope_0Y0_product_uid" />
> > </entity>
>
>
Re: not able to use deleteDocByQuery: please provide detailed example
Posted by Steve Rowe <sa...@gmail.com>.
Hi Sudheer,
As Erick mentioned on SOLR-12841, you should post your question to the solr-user mailing list, rather than to this list (the Lucene/Solr development list).
--
Steve
www.lucidworks.com
> On Oct 8, 2018, at 12:02 PM, Sudheer Shinde <su...@gmail.com> wrote:
>
> Solr version 6.2.1:
> my schema:
> id is primary key here:
> <field name="id" type="string" indexed="true" stored="true" required="true" multiValued="false"/>
> <field indexed="true" multiValued="false" docValues="true" name="TC_0Y0_ItemRevision_0Y0_awp0Item_item_id" required="false" stored="false" type="string"/>
> <field indexed="true" multiValued="false" docValues="true" name="TC_0Y0_Item_uid" required="false" stored="false" type="string"/>
> <field indexed="true" multiValued="false" docValues="true" name="TC_0Y0_ProductScope_0Y0_product_uid" required="false" stored="true" type="string"/>
>
> I want to delete using field TC_0Y0_ProductScope_0Y0_product_uid:
> my db-data config file:
> <entity name="onlydeleteByQuery" pk="pproduct" transformer="TemplateTransformer"
> query="Select pproduct from PQSEARCHINDEXEDPRODUCT t1 where t1.pis_deleted = 1" >
> <field column="${deleteDocByQuery}" template="TC_0Y0_ProductScope_0Y0_product_uid:${onlydeleteByQuery.pproduct}"/>
> <field column="ID" name="id" />
> <field column="ITEMID" name="TC_0Y0_ItemRevision_0Y0_awp0Item_item_id" />
> <field column="POBJECT" name="TC_0Y0_Item_uid" />
> <field column="PEND_ITEM" name="TC_0Y0_ProductScope_0Y0_product_uid" />
> </entity>
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org
not able to use deleteDocByQuery: please provide detailed example
Posted by Sudheer Shinde <su...@gmail.com>.
Solr version 6.2.1:
my schema:
id is primary key here:
<field name="id" type="string" indexed="true" stored="true"
required="true" multiValued="false"/>
<field indexed="true" multiValued="false" docValues="true"
name="TC_0Y0_ItemRevision_0Y0_awp0Item_item_id" required="false"
stored="false" type="string"/>
<field indexed="true" multiValued="false" docValues="true"
name="TC_0Y0_Item_uid" required="false" stored="false" type="string"/>
<field indexed="true" multiValued="false" docValues="true"
name="TC_0Y0_ProductScope_0Y0_product_uid" required="false" stored="true"
type="string"/>
I want to delete using field TC_0Y0_ProductScope_0Y0_product_uid:
my db-data config file:
<entity name="onlydeleteByQuery" pk="pproduct"
transformer="TemplateTransformer"
query="Select pproduct from PQSEARCHINDEXEDPRODUCT t1 where t1.pis_deleted
= 1" >
<field column="${deleteDocByQuery}"
template="TC_0Y0_ProductScope_0Y0_product_uid:${onlydeleteByQuery.pproduct}"/>
<field column="ID" name="id" />
<field column="ITEMID" name="TC_0Y0_ItemRevision_0Y0_awp0Item_item_id" />
<field column="POBJECT" name="TC_0Y0_Item_uid" />
<field column="PEND_ITEM" name="TC_0Y0_ProductScope_0Y0_product_uid" />
</entity>