cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lior Golan (JIRA)" <>
Subject [jira] [Commented] (CASSANDRA-3647) Support set and map value types in CQL
Date Tue, 12 Jun 2012 12:46:43 GMT


Lior Golan commented on CASSANDRA-3647:

Talking about Hive - a question about how you envision Lists/Sets/Maps and Hive integration:
Will it be possible to perform a hive query that "joins" against any/all values in a List/Set/Map?

For example let's say I have the following column families:

1. Users CF - with row key = user id and a "groups" column for the Set of groups the user
belongs to
2. Groups CF - with row key = group id and a "name" column for group name

And let's say I want to have a query for the number of users per group (name). In a relational
database this would be supported by factoring the relationship between users and groups to
a 3rd table ("users_groups"), and performing an inner join between groups and users_groups,
grouping by

How will this be supported in Hive (over Cassandra) if the mapping between users and groups
is stored as a single "Set" column in the users CF?
> Support set and map value types in CQL
> --------------------------------------
>                 Key: CASSANDRA-3647
>                 URL:
>             Project: Cassandra
>          Issue Type: New Feature
>          Components: API, Core
>            Reporter: Jonathan Ellis
>            Assignee: Sylvain Lebresne
>              Labels: cql
>             Fix For: 1.2
> Composite columns introduce the ability to have arbitrarily nested data in a Cassandra
row.  We should expose this through CQL.

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:!default.jspa
For more information on JIRA, see:


View raw message