Hi Udara,
I have deployed your toolbox and check. Actually, custom index are getting
created properly. Following are the corresponding IndexCF for the custom
index properties you have defined.
867513878
489450871
But there is a problem with secondary index creation. It's because there
are dots('.') in attribute names. Following logs prints in console when
deploying the toolbox.
[2014-03-17 18:52:27,935] WARN
{org.wso2.carbon.databridge.persistence.cassandra.datastore.CassandraConnector}
- Secondary Index creation is not successful...
me.prettyprint.hector.api.exceptions.HInvalidRequestException:
InvalidRequestException(why:Illegal index name payload_actor.id_index).
Actually, if you want to create secondary indexes, you can directly use
'Cassandra Keyspace' UI in management console too. But because you have
dots in your column keys you are not allowed to do that in there too. I
think it's better to use underscore instead of dot since those attributes
are used as column keys.
On Mon, Mar 17, 2014 at 6:47 PM, Udara Rathnayake <[email protected]> wrote:
>
>
>
> On Mon, Mar 17, 2014 at 11:09 PM, Inosh Goonewardena <[email protected]>wrote:
>
>> On Mon, Mar 17, 2014 at 6:15 PM, Udara Rathnayake <[email protected]>wrote:
>>
>>>
>>> Hi Inosh,
>>>
>>> On Mon, Mar 17, 2014 at 9:04 PM, Inosh Goonewardena <[email protected]>wrote:
>>>
>>>> On Mon, Mar 17, 2014 at 4:13 PM, Udara Rathnayake <[email protected]>wrote:
>>>>
>>>>> Hi Inosh/Maninda,
>>>>>
>>>>> As per the chat I had with Maninda I have deployed a toolbox with the
>>>>> following content.
>>>>>
>>>>> *wso2_social_data_publisher_def*
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> *{ 'streamId':'org.wso2.social.activity:4.0.0',
>>>>> 'name':'org.wso2.social.activity', 'version':'4.0.0', 'description':
>>>>> 'store json object and mete-data describing each activity',
>>>>> 'tags':['social', 'activity'], 'metaData':[ ],
>>>>> 'correlationData':[ ], 'payloadData':[
>>>>> {'name':'id','type':'STRING'}, {'name':'context.id
>>>>> <http://context.id>','type':'STRING'}, {'name':'actor.id
>>>>> <http://actor.id>','type':'STRING'}, {'name':'tenant.id
>>>>> <http://tenant.id>','type':'STRING'},
>>>>> {'name':'body','type':'STRING'} ]}*
>>>>>
>>>>> *streams.properties*
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> *streams.definitions=defn1streams.definitions.defn1.filename=wso2_social_data_publisher_def
>>>>> streams.definitions.defn1.username=adminstreams.definitions.defn1.password=adminstreams.definitions.defn1.description=This
>>>>> is the datastream published from wso2
>>>>> socialstreams.definitions.defn1.secondaryindexes=context.id
>>>>> <http://context.id>,actor.id <http://actor.id>,tenant.id
>>>>> <http://tenant.id>
>>>>> streams.definitions.defn1.customindexes=context.id <http://context.id>,id*
>>>>>
>>>>> Then I have published few activities using a simple client.
>>>>> Everything(key-space creation, publishing activities) work perfectly
>>>>> but I don't see any indexes when I browse the column family though admin
>>>>> console.
>>>>>
>>>>
>>>> In which keyspace did u check? IndexCF name is a random generated
>>>> number and getting created in EVENT_INDEX_KEYSPACE.
>>>>
>>>
>>> I checked column family information ( EVENT_KS >
>>> org_wso2_social_activity) where we display Column Name, Validator Type,
>>> Index Name, Actions details. For every colum index name value is "--NOT
>>> INDEXED--".
>>>
>>> Yes. This is the correct place to check whether secondary indexes have
>> been created. In your case it seems they are not created.
>>
>>>
>>> Now I checked key-space information EVENT_INDEX_KS, still I don't see
>>> any index related information there.
>>>
>>
>> Here you have the Custom Index CFs. According to the current
>> implementation separate CF created per index property.
>>
>> Can you share your toolbox with me so that I can have a look.
>>
>
> Find the attached toolbox.
>
>>
>>> Thanks for looking into this.
>>>
>>>>
>>>>> I have used WSO2 BAM 2.4.1 alpha pack for this.
>>>>>
>>>>> What am I doing wrong here?
>>>>>
>>>>> Regards,
>>>>> UdaraR
>>>>> --
>>>>> *Udara Rathnayake*
>>>>> Software Engineer
>>>>> WSO2 Inc. : http://wso2.com
>>>>>
>>>>> Mobile : +94 772207239
>>>>> Twitter : http://twitter.com/udarakr
>>>>> Blog : http://udarakr.blogspot.com
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Regards,
>>>>
>>>> Inosh Goonewardena
>>>> Associate Technical Lead- WSO2 Inc.
>>>> Mobile: +94779966317
>>>>
>>>
>>>
>>>
>>> --
>>> *Udara Rathnayake*
>>> Software Engineer
>>> WSO2 Inc. : http://wso2.com
>>>
>>> Mobile : +94 772207239
>>> Twitter : http://twitter.com/udarakr
>>> Blog : http://udarakr.blogspot.com
>>>
>>>
>>
>>
>> --
>> Regards,
>>
>> Inosh Goonewardena
>> Associate Technical Lead- WSO2 Inc.
>> Mobile: +94779966317
>>
>
>
>
> --
> *Udara Rathnayake*
> Software Engineer
> WSO2 Inc. : http://wso2.com
>
> Mobile : +94 772207239
> Twitter : http://twitter.com/udarakr
> Blog : http://udarakr.blogspot.com
>
>
--
Regards,
Inosh Goonewardena
Associate Technical Lead- WSO2 Inc.
Mobile: +94779966317
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
