cassandra-commits mailing list archives

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

    [ https://issues.apache.org/jira/browse/CASSANDRA-3647?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13293579#comment-13293579
] 

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 groups.name.

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: https://issues.apache.org/jira/browse/CASSANDRA-3647
>             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: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message