3 .A reference application for users looking to learn how to use
Cassandra and DataStax Enterprise with their programming
language of choice.
https://killrvideo.github.io/
4 . The video catalog service
is essentially a product
catalog where videos are
our product. How do we
make it searchable?
4
5 . A basic, Cassandra only solution
5
6 . When users add videos,
they add tags describing
the video's content. Tags
are just keywords that
describe the content.
6
7 . CREATE TABLE videos_by_tag (
tag text,
What about searching for
videoid uuid, keywords in the title or
added_date timestamp,
userid uuid,
description? Users expect
name text, more from search.
preview_image_location text,
tagged_date timestamp,
PRIMARY KEY (tag, videoid)
);
SELECT * FROM videos_by_tag
WHERE tag = 'cassandra';
7
8 . With DSE Search, we can
search on our Cassandra
data without complicating
things by introducing other
pieces infrastructure.
8
9 . A comprehensive solution with DataStax Enterprise Search
9
10 .<?xml version="1.0"?> DSE Search is based on
<schema name="videoSchema">
<types> Solr, so you may be
... expecting lots of manual
</types> setup with ugly XML to
<fields>
... define the schema and
</fields> configuration.
</schema>
11 . In reality, enabling basic SELECT * FROM videos
search functionality on a WHERE solr_query =
'description:cassandra';
table in DataStax Enterprise
is a simple command line
instruction.
> dsetool create_core killrvideo.videos generateResources=true
11
12 . You've also got all the
power of Solr for more
complex queries and can
customize those XML
resources for more
complicated features.
{ "q": "{!edismax qf='name^2 tags^1 description'} cassandra" }
12
13 . But wait, there’s more! Some key improvements in
DSE 5.1 (just released!) has DSE Search 5.1 include:
a ton of Search • Solr has been upgraded
improvements. from 4.10 to 6.0.1
• Core management can
be done using CQL
CREATE SEARCH INDEX ON killrvideo.videos;
13
热门城市
