secondary indexes for timestamp

Norman Khine norman at khine.net
Thu Mar 1 08:47:01 EST 2012


OK, i got it, i did not enable in the conf file the backend

☺  curl http://localhost:8098/buckets/mybucket/index/field1_bin/val1
{"keys":["mykey1"]}%

                                  ☺  curl
http://localhost:8098/buckets/mybucket/index/field2_int/1001
{"keys":["mykey1"]}%

                                  ☺

thanks for your help and time

On Thu, Mar 1, 2012 at 2:35 PM, Norman Khine <norman at khine.net> wrote:
> 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" ] )



-- 
%>>> "".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