secondary indexes for timestamp

Norman Khine norman at khine.net
Thu Mar 1 08:35:33 EST 2012


Hi Ryan,
Thanks for the reply.
 I will need to go an learn more before i take up any more of your time.

On Thu, Mar 1, 2012 at 1:44 PM, Ryan Zezeski <rzezeski at basho.com> wrote:
> Hi Norman,
>
> I see a couple of things potentially confusing you here.  The first thing to
> understand is that Riak currently provides two methods for indexing/querying
> your data: Search and secondary indices (2i).  They are not the same and are
> not compatible with each other.  I'm going to assume you know which one you
> want to use (or you can actually use both if you really want to but Search
> can do everything 2i can and more) and make some comments inline...
>
> On Thu, Mar 1, 2012 at 4:56 AM, Norman Khine <norman at khine.net> wrote:
>>
>>
>> <html><head><title>500 Internal Server
>> Error</title></head><body><h1>Internal Server Error</h1>The server
>> encountered an error while processing this
>>
>> request:<br><pre>{error,{error,{indexes_not_supported,riak_kv_bitcask_backend}}}</pre><P><HR><ADDRESS>mochiweb+webmachine
>> web server</ADDRESS></body></html>%
>
>
> This is telling you that 2i indexes are not supported because you are using
> a backend that doesn't support them.  If you didn't already know Riak
> supports multiple backends and 2i is only compatible with the
> `riak_kv_eleveldb_backend` [1].
>
>
>>
>>
>> curl http://localhost:8098/solr/users/select?q=timestamp:1330593323542
>>
>> <response>
>> <lst name="responseHeader">
>> <int name="status">0</int>
>> <int name="QTime">4</int>
>> <lst name="params">
>> <str name="indent">on</str>
>> <str name="start">0</str>
>> <str name="q">timestamp:1330593323542</str>
>> <str name="q.op">or</str>
>> <str name="filter"/>
>> <str name="df">value</str>
>> <str name="wt">standard</str>
>> <str name="version">1.1</str>
>> <str name="rows">0</str>
>> </lst>
>> </lst>
>> <result name="response" numFound="0" start="0" maxScore="0.0"></result>
>> </response>
>>
>>
>
> In this case you are running a query against Search.  This will only return
> results if you a) have search enabled [2], b) you install the search hook on
> the 'users' bucket [3], and c) you have the schema setup correctly [4].  I
> realize this isn't entirely straightforward and am willing to help if you
> decide you want to use the search functionality.
>
> -Ryan
>
> [1]: http://wiki.basho.com/Secondary-Indexes.html#Configuration
>
> [2]: https://github.com/basho/riak_search/blob/master/README.org
>
> [3]: http://wiki.basho.com/Riak-Search---Indexing-and-Querying-Riak-KV-Data.html#Setting-up-Indexing
>
> [4]: http://wiki.basho.com/Riak-Search---Schema.html
>



-- 
%>>> "".join( [ {'*':'@','^':'.'}.get(c,None) or
chr(97+(ord(c)-83)%26) for c in ",adym,*)&uzq^zqf" ] )




More information about the riak-users mailing list