|
|
You're in the
sql server full text search
group:Too many full-text columns or the full-text query is too complex
sql server full text search:
Too many full-text columns or the full-text query is too complex to be executed. HI When I search for that in FTS I got this error select * from Table1 where contains (a,b,c),'"n*"' ) but if I seach for a*, b* or z* all its ok just n* cause problem I try to reorganize the catalog with alter fulltext catalog ftcatalog reorganize and alter fulltext catalog ftcatalog rebuild but the probleme appear again could you help me ?
Im run under SQL Server 2005 sp2
[quoted text, click to view] "OLAPFOREVER" wrote:
> Msg 9937, Level 16, State 5, Line 1 > Too many full-text columns or the full-text query is too complex to be > executed. > > HI > > When I search for that in FTS I got this error > select * from Table1 where contains (a,b,c),'"n*"' ) > but if I seach for a*, b* or z* all its ok just n* cause problem > > I try to reorganize the catalog with alter fulltext catalog ftcatalog > reorganize > and alter fulltext catalog ftcatalog rebuild but the probleme appear again > > could you help me ?
Hmmm is that the right query?
Doesn't look right, try: For One search... SELECT * FROM Table1 WHERE CONTAINS(FTSField, ' "N*" '); Multi-Search ... SELECT * FROM Table1 WHERE CONTAINS(FTSField, ' "A*" OR "N*" '); -- Mohit K. Gupta B.Sc. CS, Minor Japanese MCTS: SQL Server 2005 [quoted text, click to view] "OLAPFOREVER" wrote:
> Msg 9937, Level 16, State 5, Line 1 > Too many full-text columns or the full-text query is too complex to be > executed. > > HI > > When I search for that in FTS I got this error > select * from Table1 where contains (a,b,c),'"n*"' ) > but if I seach for a*, b* or z* all its ok just n* cause problem > > I try to reorganize the catalog with alter fulltext catalog ftcatalog > reorganize > and alter fulltext catalog ftcatalog rebuild but the probleme appear again > > could you help me ?
select * from Table1 where contains ((Col1,Col2,Col3),'"n*"' ) Col1, Col2 , and Col3 are the Fts Indexed Columns and I search for N* is it must clear ? [quoted text, click to view] "Mohit K. Gupta" wrote:
> Hmmm is that the right query? > > Doesn't look right, try: > > For One search... > > SELECT * > FROM Table1 > WHERE CONTAINS(FTSField, ' "N*" '); > > Multi-Search ... > > SELECT * > FROM Table1 > WHERE CONTAINS(FTSField, ' "A*" OR "N*" '); > > -- > Mohit K. Gupta > B.Sc. CS, Minor Japanese > MCTS: SQL Server 2005 > > > "OLAPFOREVER" wrote: > > > Msg 9937, Level 16, State 5, Line 1 > > Too many full-text columns or the full-text query is too complex to be > > executed. > > > > HI > > > > When I search for that in FTS I got this error > > select * from Table1 where contains (a,b,c),'"n*"' ) > > but if I seach for a*, b* or z* all its ok just n* cause problem > > > > I try to reorganize the catalog with alter fulltext catalog ftcatalog > > reorganize > > and alter fulltext catalog ftcatalog rebuild but the probleme appear again > > > > could you help me ?
I am sorry. Anyhow, are you trying to find words like 'Anything' or words
like 'Nothing'. N* will not catch Anything because it is not a prefixed, it will only catch Nothing. I couldn't get it to ignore 'Nothing'. I highly douht it but you can check the noise world list. -- Mohit K. Gupta B.Sc. CS, Minor Japanese MCTS: SQL Server 2005 [quoted text, click to view] "OLAPFOREVER" wrote:
> > select * from Table1 where contains ((Col1,Col2,Col3),'"n*"' ) > Col1, Col2 , and Col3 are the Fts Indexed Columns and I search for N* > is it must clear ? > > > > "Mohit K. Gupta" wrote: > > > Hmmm is that the right query? > > > > Doesn't look right, try: > > > > For One search... > > > > SELECT * > > FROM Table1 > > WHERE CONTAINS(FTSField, ' "N*" '); > > > > Multi-Search ... > > > > SELECT * > > FROM Table1 > > WHERE CONTAINS(FTSField, ' "A*" OR "N*" '); > > > > -- > > Mohit K. Gupta > > B.Sc. CS, Minor Japanese > > MCTS: SQL Server 2005 > > > > > > "OLAPFOREVER" wrote: > > > > > Msg 9937, Level 16, State 5, Line 1 > > > Too many full-text columns or the full-text query is too complex to be > > > executed. > > > > > > HI > > > > > > When I search for that in FTS I got this error > > > select * from Table1 where contains (a,b,c),'"n*"' ) > > > but if I seach for a*, b* or z* all its ok just n* cause problem > > > > > > I try to reorganize the catalog with alter fulltext catalog ftcatalog > > > reorganize > > > and alter fulltext catalog ftcatalog rebuild but the probleme appear again > > > > > > could you help me ?
the problem is not de noise world list because
all other letter work well I seach for all words begin by N all others tests with A* B* C* ... Z* returns results or nothing (no row) but N* retrurn the Msg 9937 Error message [quoted text, click to view] "Mohit K. Gupta" wrote:
> I am sorry. Anyhow, are you trying to find words like 'Anything' or words > like 'Nothing'. > > N* will not catch Anything because it is not a prefixed, it will only catch > Nothing. I couldn't get it to ignore 'Nothing'. > > I highly douht it but you can check the noise world list. > -- > Mohit K. Gupta > B.Sc. CS, Minor Japanese > MCTS: SQL Server 2005 > > > "OLAPFOREVER" wrote: > > > > > select * from Table1 where contains ((Col1,Col2,Col3),'"n*"' ) > > Col1, Col2 , and Col3 are the Fts Indexed Columns and I search for N* > > is it must clear ? > > > > > > > > "Mohit K. Gupta" wrote: > > > > > Hmmm is that the right query? > > > > > > Doesn't look right, try: > > > > > > For One search... > > > > > > SELECT * > > > FROM Table1 > > > WHERE CONTAINS(FTSField, ' "N*" '); > > > > > > Multi-Search ... > > > > > > SELECT * > > > FROM Table1 > > > WHERE CONTAINS(FTSField, ' "A*" OR "N*" '); > > > > > > -- > > > Mohit K. Gupta > > > B.Sc. CS, Minor Japanese > > > MCTS: SQL Server 2005 > > > > > > > > > "OLAPFOREVER" wrote: > > > > > > > Msg 9937, Level 16, State 5, Line 1 > > > > Too many full-text columns or the full-text query is too complex to be > > > > executed. > > > > > > > > HI > > > > > > > > When I search for that in FTS I got this error > > > > select * from Table1 where contains (a,b,c),'"n*"' ) > > > > but if I seach for a*, b* or z* all its ok just n* cause problem > > > > > > > > I try to reorganize the catalog with alter fulltext catalog ftcatalog > > > > reorganize > > > > and alter fulltext catalog ftcatalog rebuild but the probleme appear again > > > > > > > > could you help me ?
I am some what lost, would you mind posting the table struction, and the
index creation scripts here. I can try to help you troubleshoot from there, in my thinking only reason you should be getting that is if you have more then 16 columns in the full index. Sorry haven't been much help. -- Mohit K. Gupta B.Sc. CS, Minor Japanese
Its true Hilary
I have 3,000,000 words began by N but How can I search for N* ? Its a FTS bug ? a resource problem ? [quoted text, click to view] "Hilary Cotter" wrote:
> The problem is there are too many words beginning with n. To get results for > such a query you should try to restrict the search somewhat, ie na*, or nb*, > etc. > > -- > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > Looking for a FAQ on Indexing Services/SQL FTS > http://www.indexserverfaq.com > "OLAPFOREVER" <OLAPFOREVER@discussions.microsoft.com> wrote in message > news:653EADB0-5A82-4342-A12D-6B6278F43114@microsoft.com... > > the problem is not de noise world list because > > all other letter work well > > > > I seach for all words begin by N > > all others tests with A* B* C* ... Z* returns results or nothing (no > > row) > > but N* retrurn the Msg 9937 Error message > > > > "Mohit K. Gupta" wrote: > > > >> I am sorry. Anyhow, are you trying to find words like 'Anything' or > >> words > >> like 'Nothing'. > >> > >> N* will not catch Anything because it is not a prefixed, it will only > >> catch > >> Nothing. I couldn't get it to ignore 'Nothing'. > >> > >> I highly douht it but you can check the noise world list. > >> -- > >> Mohit K. Gupta > >> B.Sc. CS, Minor Japanese > >> MCTS: SQL Server 2005 > >> > >> > >> "OLAPFOREVER" wrote: > >> > >> > > >> > select * from Table1 where contains ((Col1,Col2,Col3),'"n*"' ) > >> > Col1, Col2 , and Col3 are the Fts Indexed Columns and I search for N* > >> > is it must clear ? > >> > > >> > > >> > > >> > "Mohit K. Gupta" wrote: > >> > > >> > > Hmmm is that the right query? > >> > > > >> > > Doesn't look right, try: > >> > > > >> > > For One search... > >> > > > >> > > SELECT * > >> > > FROM Table1 > >> > > WHERE CONTAINS(FTSField, ' "N*" '); > >> > > > >> > > Multi-Search ... > >> > > > >> > > SELECT * > >> > > FROM Table1 > >> > > WHERE CONTAINS(FTSField, ' "A*" OR "N*" '); > >> > > > >> > > -- > >> > > Mohit K. Gupta > >> > > B.Sc. CS, Minor Japanese > >> > > MCTS: SQL Server 2005 > >> > > > >> > > > >> > > "OLAPFOREVER" wrote: > >> > > > >> > > > Msg 9937, Level 16, State 5, Line 1 > >> > > > Too many full-text columns or the full-text query is too complex to > >> > > > be > >> > > > executed. > >> > > > > >> > > > HI > >> > > > > >> > > > When I search for that in FTS I got this error > >> > > > select * from Table1 where contains (a,b,c),'"n*"' ) > >> > > > but if I seach for a*, b* or z* all its ok just n* cause > >> > > > problem > >> > > > > >> > > > I try to reorganize the catalog with alter fulltext catalog > >> > > > ftcatalog > >> > > > reorganize > >> > > > and alter fulltext catalog ftcatalog rebuild but the probleme > >> > > > appear again > >> > > > > >> > > > could you help me ? > >> > > > > >
The problem is there are too many words beginning with n. To get results for
such a query you should try to restrict the search somewhat, ie na*, or nb*, etc. -- Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com [quoted text, click to view] "OLAPFOREVER" <OLAPFOREVER@discussions.microsoft.com> wrote in message news:653EADB0-5A82-4342-A12D-6B6278F43114@microsoft.com... > the problem is not de noise world list because > all other letter work well > > I seach for all words begin by N > all others tests with A* B* C* ... Z* returns results or nothing (no > row) > but N* retrurn the Msg 9937 Error message > > "Mohit K. Gupta" wrote: > >> I am sorry. Anyhow, are you trying to find words like 'Anything' or >> words >> like 'Nothing'. >> >> N* will not catch Anything because it is not a prefixed, it will only >> catch >> Nothing. I couldn't get it to ignore 'Nothing'. >> >> I highly douht it but you can check the noise world list. >> -- >> Mohit K. Gupta >> B.Sc. CS, Minor Japanese >> MCTS: SQL Server 2005 >> >> >> "OLAPFOREVER" wrote: >> >> > >> > select * from Table1 where contains ((Col1,Col2,Col3),'"n*"' ) >> > Col1, Col2 , and Col3 are the Fts Indexed Columns and I search for N* >> > is it must clear ? >> > >> > >> > >> > "Mohit K. Gupta" wrote: >> > >> > > Hmmm is that the right query? >> > > >> > > Doesn't look right, try: >> > > >> > > For One search... >> > > >> > > SELECT * >> > > FROM Table1 >> > > WHERE CONTAINS(FTSField, ' "N*" '); >> > > >> > > Multi-Search ... >> > > >> > > SELECT * >> > > FROM Table1 >> > > WHERE CONTAINS(FTSField, ' "A*" OR "N*" '); >> > > >> > > -- >> > > Mohit K. Gupta >> > > B.Sc. CS, Minor Japanese >> > > MCTS: SQL Server 2005 >> > > >> > > >> > > "OLAPFOREVER" wrote: >> > > >> > > > Msg 9937, Level 16, State 5, Line 1 >> > > > Too many full-text columns or the full-text query is too complex to >> > > > be >> > > > executed. >> > > > >> > > > HI >> > > > >> > > > When I search for that in FTS I got this error >> > > > select * from Table1 where contains (a,b,c),'"n*"' ) >> > > > but if I seach for a*, b* or z* all its ok just n* cause >> > > > problem >> > > > >> > > > I try to reorganize the catalog with alter fulltext catalog >> > > > ftcatalog >> > > > reorganize >> > > > and alter fulltext catalog ftcatalog rebuild but the probleme >> > > > appear again >> > > > >> > > > could you help me ? >> > > >
Hi!
do you have another solution for me ? How Can I search for N* in this case This is a FTS bug ? [quoted text, click to view] "OLAPFOREVER" wrote:
> Its true Hilary > I have 3,000,000 words began by N > but How can I search for N* ? > Its a FTS bug ? a resource problem ? > > "Hilary Cotter" wrote: > > > The problem is there are too many words beginning with n. To get results for > > such a query you should try to restrict the search somewhat, ie na*, or nb*, > > etc. > > > > -- > > Looking for a SQL Server replication book? > > http://www.nwsu.com/0974973602.html > > > > Looking for a FAQ on Indexing Services/SQL FTS > > http://www.indexserverfaq.com > > "OLAPFOREVER" <OLAPFOREVER@discussions.microsoft.com> wrote in message > > news:653EADB0-5A82-4342-A12D-6B6278F43114@microsoft.com... > > > the problem is not de noise world list because > > > all other letter work well > > > > > > I seach for all words begin by N > > > all others tests with A* B* C* ... Z* returns results or nothing (no > > > row) > > > but N* retrurn the Msg 9937 Error message > > > > > > "Mohit K. Gupta" wrote: > > > > > >> I am sorry. Anyhow, are you trying to find words like 'Anything' or > > >> words > > >> like 'Nothing'. > > >> > > >> N* will not catch Anything because it is not a prefixed, it will only > > >> catch > > >> Nothing. I couldn't get it to ignore 'Nothing'. > > >> > > >> I highly douht it but you can check the noise world list. > > >> -- > > >> Mohit K. Gupta > > >> B.Sc. CS, Minor Japanese > > >> MCTS: SQL Server 2005 > > >> > > >> > > >> "OLAPFOREVER" wrote: > > >> > > >> > > > >> > select * from Table1 where contains ((Col1,Col2,Col3),'"n*"' ) > > >> > Col1, Col2 , and Col3 are the Fts Indexed Columns and I search for N* > > >> > is it must clear ? > > >> > > > >> > > > >> > > > >> > "Mohit K. Gupta" wrote: > > >> > > > >> > > Hmmm is that the right query? > > >> > > > > >> > > Doesn't look right, try: > > >> > > > > >> > > For One search... > > >> > > > > >> > > SELECT * > > >> > > FROM Table1 > > >> > > WHERE CONTAINS(FTSField, ' "N*" '); > > >> > > > > >> > > Multi-Search ... > > >> > > > > >> > > SELECT * > > >> > > FROM Table1 > > >> > > WHERE CONTAINS(FTSField, ' "A*" OR "N*" '); > > >> > > > > >> > > -- > > >> > > Mohit K. Gupta > > >> > > B.Sc. CS, Minor Japanese > > >> > > MCTS: SQL Server 2005 > > >> > > > > >> > > > > >> > > "OLAPFOREVER" wrote: > > >> > > > > >> > > > Msg 9937, Level 16, State 5, Line 1 > > >> > > > Too many full-text columns or the full-text query is too complex to > > >> > > > be > > >> > > > executed. > > >> > > > > > >> > > > HI > > >> > > > > > >> > > > When I search for that in FTS I got this error > > >> > > > select * from Table1 where contains (a,b,c),'"n*"' ) > > >> > > > but if I seach for a*, b* or z* all its ok just n* cause > > >> > > > problem > > >> > > > > > >> > > > I try to reorganize the catalog with alter fulltext catalog > > >> > > > ftcatalog > > >> > > > reorganize > > >> > > > and alter fulltext catalog ftcatalog rebuild but the probleme > > >> > > > appear again > > >> > > > > > >> > > > could you help me ? > > >> > > > > > > >
thanks for this reply but I need to use N* not Na* or Nb* etc [quoted text, click to view] "Hilary Cotter" wrote:
> try na* or nb* or nc* > > etc. This is not a good option for SQL FTS. > > -- > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > Looking for a FAQ on Indexing Services/SQL FTS > http://www.indexserverfaq.com > "OLAPFOREVER" <OLAPFOREVER@discussions.microsoft.com> wrote in message > news:9413538C-1367-4F05-92D0-85D1C9B69843@microsoft.com... > > Hi! > > > > do you have another solution for me ? > > How Can I search for N* in this case > > This is a FTS bug ? > > > > "OLAPFOREVER" wrote: > > > >> Its true Hilary > >> I have 3,000,000 words began by N > >> but How can I search for N* ? > >> Its a FTS bug ? a resource problem ? > >> > >> "Hilary Cotter" wrote: > >> > >> > The problem is there are too many words beginning with n. To get > >> > results for > >> > such a query you should try to restrict the search somewhat, ie na*, or > >> > nb*, > >> > etc. > >> > > >> > -- > >> > Looking for a SQL Server replication book? > >> > http://www.nwsu.com/0974973602.html > >> > > >> > Looking for a FAQ on Indexing Services/SQL FTS > >> > http://www.indexserverfaq.com > >> > "OLAPFOREVER" <OLAPFOREVER@discussions.microsoft.com> wrote in message > >> > news:653EADB0-5A82-4342-A12D-6B6278F43114@microsoft.com... > >> > > the problem is not de noise world list because > >> > > all other letter work well > >> > > > >> > > I seach for all words begin by N > >> > > all others tests with A* B* C* ... Z* returns results or nothing > >> > > (no > >> > > row) > >> > > but N* retrurn the Msg 9937 Error message > >> > > > >> > > "Mohit K. Gupta" wrote: > >> > > > >> > >> I am sorry. Anyhow, are you trying to find words like 'Anything' or > >> > >> words > >> > >> like 'Nothing'. > >> > >> > >> > >> N* will not catch Anything because it is not a prefixed, it will > >> > >> only > >> > >> catch > >> > >> Nothing. I couldn't get it to ignore 'Nothing'. > >> > >> > >> > >> I highly douht it but you can check the noise world list. > >> > >> -- > >> > >> Mohit K. Gupta > >> > >> B.Sc. CS, Minor Japanese > >> > >> MCTS: SQL Server 2005 > >> > >> > >> > >> > >> > >> "OLAPFOREVER" wrote: > >> > >> > >> > >> > > >> > >> > select * from Table1 where contains ((Col1,Col2,Col3),'"n*"' ) > >> > >> > Col1, Col2 , and Col3 are the Fts Indexed Columns and I search > >> > >> > for N* > >> > >> > is it must clear ? > >> > >> > > >> > >> > > >> > >> > > >> > >> > "Mohit K. Gupta" wrote: > >> > >> > > >> > >> > > Hmmm is that the right query? > >> > >> > > > >> > >> > > Doesn't look right, try: > >> > >> > > > >> > >> > > For One search... > >> > >> > > > >> > >> > > SELECT * > >> > >> > > FROM Table1 > >> > >> > > WHERE CONTAINS(FTSField, ' "N*" '); > >> > >> > > > >> > >> > > Multi-Search ... > >> > >> > > > >> > >> > > SELECT * > >> > >> > > FROM Table1 > >> > >> > > WHERE CONTAINS(FTSField, ' "A*" OR "N*" '); > >> > >> > > > >> > >> > > -- > >> > >> > > Mohit K. Gupta > >> > >> > > B.Sc. CS, Minor Japanese > >> > >> > > MCTS: SQL Server 2005 > >> > >> > > > >> > >> > > > >> > >> > > "OLAPFOREVER" wrote: > >> > >> > > > >> > >> > > > Msg 9937, Level 16, State 5, Line 1 > >> > >> > > > Too many full-text columns or the full-text query is too > >> > >> > > > complex to > >> > >> > > > be > >> > >> > > > executed. > >> > >> > > > > >> > >> > > > HI > >> > >> > > > > >> > >> > > > When I search for that in FTS I got this error > >> > >> > > > select * from Table1 where contains (a,b,c),'"n*"' ) > >> > >> > > > but if I seach for a*, b* or z* all its ok just n* cause > >> > >> > > > problem > >> > >> > > > > >> > >> > > > I try to reorganize the catalog with alter fulltext catalog > >> > >> > > > ftcatalog > >> > >> > > > reorganize > >> > >> > > > and alter fulltext catalog ftcatalog rebuild but the > >> > >> > > > probleme > >> > >> > > > appear again > >> > >> > > > > >> > >> > > > could you help me ? > >> > >> > > > > >> > > >> > > >> > > >
try na* or nb* or nc*
etc. This is not a good option for SQL FTS. -- Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com [quoted text, click to view] "OLAPFOREVER" <OLAPFOREVER@discussions.microsoft.com> wrote in message news:9413538C-1367-4F05-92D0-85D1C9B69843@microsoft.com... > Hi! > > do you have another solution for me ? > How Can I search for N* in this case > This is a FTS bug ? > > "OLAPFOREVER" wrote: > >> Its true Hilary >> I have 3,000,000 words began by N >> but How can I search for N* ? >> Its a FTS bug ? a resource problem ? >> >> "Hilary Cotter" wrote: >> >> > The problem is there are too many words beginning with n. To get >> > results for >> > such a query you should try to restrict the search somewhat, ie na*, or >> > nb*, >> > etc. >> > >> > -- >> > Looking for a SQL Server replication book? >> > http://www.nwsu.com/0974973602.html >> > >> > Looking for a FAQ on Indexing Services/SQL FTS >> > http://www.indexserverfaq.com >> > "OLAPFOREVER" <OLAPFOREVER@discussions.microsoft.com> wrote in message >> > news:653EADB0-5A82-4342-A12D-6B6278F43114@microsoft.com... >> > > the problem is not de noise world list because >> > > all other letter work well >> > > >> > > I seach for all words begin by N >> > > all others tests with A* B* C* ... Z* returns results or nothing >> > > (no >> > > row) >> > > but N* retrurn the Msg 9937 Error message >> > > >> > > "Mohit K. Gupta" wrote: >> > > >> > >> I am sorry. Anyhow, are you trying to find words like 'Anything' or >> > >> words >> > >> like 'Nothing'. >> > >> >> > >> N* will not catch Anything because it is not a prefixed, it will >> > >> only >> > >> catch >> > >> Nothing. I couldn't get it to ignore 'Nothing'. >> > >> >> > >> I highly douht it but you can check the noise world list. >> > >> -- >> > >> Mohit K. Gupta >> > >> B.Sc. CS, Minor Japanese >> > >> MCTS: SQL Server 2005 >> > >> >> > >> >> > >> "OLAPFOREVER" wrote: >> > >> >> > >> > >> > >> > select * from Table1 where contains ((Col1,Col2,Col3),'"n*"' ) >> > >> > Col1, Col2 , and Col3 are the Fts Indexed Columns and I search >> > >> > for N* >> > >> > is it must clear ? >> > >> > >> > >> > >> > >> > >> > >> > "Mohit K. Gupta" wrote: >> > >> > >> > >> > > Hmmm is that the right query? >> > >> > > >> > >> > > Doesn't look right, try: >> > >> > > >> > >> > > For One search... >> > >> > > >> > >> > > SELECT * >> > >> > > FROM Table1 >> > >> > > WHERE CONTAINS(FTSField, ' "N*" '); >> > >> > > >> > >> > > Multi-Search ... >> > >> > > >> > >> > > SELECT * >> > >> > > FROM Table1 >> > >> > > WHERE CONTAINS(FTSField, ' "A*" OR "N*" '); >> > >> > > >> > >> > > -- >> > >> > > Mohit K. Gupta >> > >> > > B.Sc. CS, Minor Japanese >> > >> > > MCTS: SQL Server 2005 >> > >> > > >> > >> > > >> > >> > > "OLAPFOREVER" wrote: >> > >> > > >> > >> > > > Msg 9937, Level 16, State 5, Line 1 >> > >> > > > Too many full-text columns or the full-text query is too >> > >> > > > complex to >> > >> > > > be >> > >> > > > executed. >> > >> > > > >> > >> > > > HI >> > >> > > > >> > >> > > > When I search for that in FTS I got this error >> > >> > > > select * from Table1 where contains (a,b,c),'"n*"' ) >> > >> > > > but if I seach for a*, b* or z* all its ok just n* cause >> > >> > > > problem >> > >> > > > >> > >> > > > I try to reorganize the catalog with alter fulltext catalog >> > >> > > > ftcatalog >> > >> > > > reorganize >> > >> > > > and alter fulltext catalog ftcatalog rebuild but the >> > >> > > > probleme >> > >> > > > appear again >> > >> > > > >> > >> > > > could you help me ? >> > >> > > > >> > >> > >> >
On 16 Jul., 19:16, OLAPFOREVER <OLAPFORE...@discussions.microsoft.com>
[quoted text, click to view] wrote: > thanks for this reply but I need to use N* not Na* or Nb* etc > > > > "Hilary Cotter" wrote: > > try na* or nb* or nc* > > > etc. This is not a good option for SQL FTS. > > > -- > > Looking for a SQL Server replication book? > >http://www.nwsu.com/0974973602.html > > > Looking for a FAQ on Indexing Services/SQL FTS > >http://www.indexserverfaq.com > > "OLAPFOREVER" <OLAPFORE...@discussions.microsoft.com> wrote in message > >news:9413538C-1367-4F05-92D0-85D1C9B69843@microsoft.com... > > > Hi! > > > > do you have another solution for me ? > > > How Can I search for N* in this case > > > This is a FTS bug ? > > > > "OLAPFOREVER" wrote: > > > >> Its true Hilary > > >> I have 3,000,000 words began by N > > >> but How can I search for N* ? > > >> Its a FTS bug ? a resource problem ? > > > >> "Hilary Cotter" wrote: > > > >> > The problem is there are too many words beginning with n. To get > > >> > results for > > >> > such a query you should try to restrict the search somewhat, ie na*, or > > >> > nb*, > > >> > etc. > > > >> > -- > > >> > Looking for a SQL Server replication book? > > >> >http://www.nwsu.com/0974973602.html > > > >> > Looking for a FAQ on Indexing Services/SQL FTS > > >> >http://www.indexserverfaq.com > > >> > "OLAPFOREVER" <OLAPFORE...@discussions.microsoft.com> wrote in message > > >> >news:653EADB0-5A82-4342-A12D-6B6278F43114@microsoft.com... > > >> > > the problem is not de noise world list because > > >> > > all other letter work well > > > >> > > I seach for all words begin by N > > >> > > all others tests with A* B* C* ... Z* returns results or nothing > > >> > > (no > > >> > > row) > > >> > > but N* retrurn the Msg9937Error message > > > >> > > "Mohit K. Gupta" wrote: > > > >> > >> I am sorry. Anyhow, are you trying to find words like 'Anything' or > > >> > >> words > > >> > >> like 'Nothing'. > > > >> > >> N* will not catch Anything because it is not a prefixed, it will > > >> > >> only > > >> > >> catch > > >> > >> Nothing. I couldn't get it to ignore 'Nothing'. > > > >> > >> I highly douht it but you can check the noise world list. > > >> > >> -- > > >> > >> Mohit K. Gupta > > >> > >> B.Sc. CS, Minor Japanese > > >> > >> MCTS: SQL Server 2005 > > > >> > >> "OLAPFOREVER" wrote: > > > >> > >> > select * from Table1 where contains ((Col1,Col2,Col3),'"n*"' ) > > >> > >> > Col1, Col2 , and Col3 are the Fts Indexed Columns and I search > > >> > >> > for N* > > >> > >> > is it must clear ? > > > >> > >> > "Mohit K. Gupta" wrote: > > > >> > >> > > Hmmm is that the right query? > > > >> > >> > > Doesn't look right, try: > > > >> > >> > > For One search... > > > >> > >> > > SELECT * > > >> > >> > > FROM Table1 > > >> > >> > > WHERE CONTAINS(FTSField, ' "N*" '); > > > >> > >> > > Multi-Search ... > > > >> > >> > > SELECT * > > >> > >> > > FROM Table1 > > >> > >> > > WHERE CONTAINS(FTSField, ' "A*" OR "N*" '); > > > >> > >> > > -- > > >> > >> > > Mohit K. Gupta > > >> > >> > > B.Sc. CS, Minor Japanese > > >> > >> > > MCTS: SQL Server 2005 > > > >> > >> > > "OLAPFOREVER" wrote: > > > >> > >> > > > Msg9937, Level 16, State 5, Line 1 > > >> > >> > > > Too many full-text columns or the full-text query is too > > >> > >> > > > complex to > > >> > >> > > > be > > >> > >> > > > executed. > > > >> > >> > > > HI > > > >> > >> > > > When I search for that in FTS I got this error > > >> > >> > > > select * from Table1 where contains (a,b,c),'"n*"' ) > > >> > >> > > > but if I seach for a*, b* or z* all its ok just n* cause > > >> > >> > > > problem > > > >> > >> > > > I try to reorganize the catalog with alter fulltext catalog > > >> > >> > > > ftcatalog > > >> > >> > > > reorganize > > >> > >> > > > and alter fulltext catalog ftcatalog rebuild but the > > >> > >> > > > probleme > > >> > >> > > > appear again > > > >> > >> > > > could you help me ?- Zitierten Text ausblenden - > > - Zitierten Text anzeigen - Hi, I have a similar problem: "CONTAINS(expression, ' "de*" ')" results in error 9937. "de*" and some other two letter expressions do produce a lot of hits, but how I am supposed to know that in advance? Often searches like CONTAINS(expression, ' "nokia*" AND "de*" ') are being used. Fails with 9937 also, although the number of total results would be much smaller. If I add "de" to the noise word list, the only result is that "de" will have zero hits while "de*" still fails with 9937. BTW: ' "nokia*" and "de" ' also results in zero hits, which only makes sense if one ignores what the end user expects. So the only chance I am seeing is to log the searches that fail with 9937 and manually build a list of strings that are being substracted from the search phrase before it is being passed to the ft search. Any better ideas would be great! I think FT index in 2005 has still not grown up. The gatherer has become really quick but other than that I see hardly any advances to the 2000 version. Regards DC
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |