[
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
