Re: [sqlite] Sqlite FTS retrieve inverted index

[Mario Annau]

Hi Alexey,
tha

Am 12. März 2012 22:14 schrieb Alexey Pechnikov :

> See
> http://www.sqlite.org/draft/fts3.html#fts4aux
>
>
have already tried the fts4aux table. however, I would also need
the number of occurrences of each term in each document.

Therefore, like in the docs, not only

*-- The following query returns this data:**--**-- apple   |
*  |  1  |  1**-- apple   |  0  |  1  |  1**-- banana
|  *  |  2  |  2**-- banana  |  0  |  2  |  2**-- cherry
   |  *  |  3  |  3**-- cherry  |  0  |  1  |  1**--
cherry  |  1  |  2  |  2**-- date|  *  |  1  |  2**--
   date|  0  |  1  |  2**-- elderberry  |  *  |  1  |
2**-- elderberry  |  1  |  1  |  1**-- elderberry  |  1  |  1
|  1*

but a result table like this:

   Term|col  |docid| occurences
--
-- apple   |  0  |  1  |  1
-- banana  |  0  |  2  |  1
-- cherry  |  0  |  3  |  1
-- cherry  |  1  |  1  |  1
-- cherry  |  1  |  2  |  1
-- date|  0  |  2  |  2
-- elderberry  |  0  |  3  |  1
-- elderberry  |  1  |  3  |  1

Best,
mario


> 2012/3/13 Mario Annau :
> > Hello,
> >
> > unfortunately I have already posted this question on
> > stackoverflow<
> http://stackoverflow.com/questions/9657016/get-inverted-index-from-sqlite-fts-table
> >,
> > hope that this mailing list is right address.
> >
> > After I have implemented a full text search function in my application
> > using Sqlite and FTS tables I would be interested
> > in a (performant) way of retrieving the FULL inverted index (or large
> part)
> > out of my FTS (sub-)table.
> >
> > In effect - I would need a result table including the terms, docid's and
> > number of occurences.
> >
> > I am actually searching for some basic code/examples to read the segdir /
> > segments table (where the actual index is stored ) and construct my
> > desired result table (in effect - the inverted index). But any solution
> > which could retrieve the full (or large part of) my inverted index using
> > queries including MATCH, MATCHINFO , etc. (sorry, I'm no Sqlite export)
> > would be highly appreciated!
> >
> > Best,
> > mario
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
>
> --
> Best regards, Alexey Pechnikov.
> http://pechnikov.tel/
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sqlite FTS retrieve inverted index

[Alexey Pechnikov]

See
http://www.sqlite.org/draft/fts3.html#fts4aux

2012/3/13 Mario Annau :
> Hello,
>
> unfortunately I have already posted this question on
> stackoverflow,
> hope that this mailing list is right address.
>
> After I have implemented a full text search function in my application
> using Sqlite and FTS tables I would be interested
> in a (performant) way of retrieving the FULL inverted index (or large part)
> out of my FTS (sub-)table.
>
> In effect - I would need a result table including the terms, docid's and
> number of occurences.
>
> I am actually searching for some basic code/examples to read the segdir /
> segments table (where the actual index is stored ) and construct my
> desired result table (in effect - the inverted index). But any solution
> which could retrieve the full (or large part of) my inverted index using
> queries including MATCH, MATCHINFO , etc. (sorry, I'm no Sqlite export)
> would be highly appreciated!
>
> Best,
> mario
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



-- 
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Sqlite FTS retrieve inverted index

[Mario Annau]

Hello,

unfortunately I have already posted this question on
stackoverflow,
hope that this mailing list is right address.

After I have implemented a full text search function in my application
using Sqlite and FTS tables I would be interested
in a (performant) way of retrieving the FULL inverted index (or large part)
out of my FTS (sub-)table.

In effect - I would need a result table including the terms, docid's and
number of occurences.

I am actually searching for some basic code/examples to read the segdir /
segments table (where the actual index is stored ) and construct my
desired result table (in effect - the inverted index). But any solution
which could retrieve the full (or large part of) my inverted index using
queries including MATCH, MATCHINFO , etc. (sorry, I'm no Sqlite export)
would be highly appreciated!

Best,
mario
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users