it's like having a table (sha256 blob primary key, id timeuuid, data1
text, ....., )

So both, sha256 and id are unique.
I would like to query *either* with sha256 *or* with id.

I thought this can be done with a sasi index, but it has to be done with
a second table (manual way) or with a mv with id as partition key.

On 16.02.2017 15:11, Benjamin Roth wrote:
> No matter what has to be indexed here, the preferrable way is most
> probably denormalization instead of another index.

it's rather manual inserting the data with another partition key or make
a mv for with the other key.

Reply via email to