[
https://issues.apache.org/jira/browse/CASSANDRA-3647?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13293581#comment-13293581
]
Jonathan Ellis commented on CASSANDRA-3647:
-------------------------------------------
https://cwiki.apache.org/confluence/display/Hive/Tutorial#Tutorial-ArrayOperations
and
https://cwiki.apache.org/confluence/display/Hive/Tutorial#Tutorial-ComplexTypes
says that Hive is okay with using the [] operator in SELECT. (Presumably also
for UPDATE? this is not explicitly shown.)
Hive does not appear to have a collection literal syntax, we might need to add
quotes to ours to make it happy with that.
Hive adds a size(collection) method, which makes sense.
Hive does not support Sets.
Hive's syntax for CREATEing is the same as ours, except that Hive uses "array"
instead of "list."
PostgreSQL's is different
(http://www.postgresql.org/docs/9.1/static/arrays.html) and closer to the SQL
standard (http://farrago.sourceforge.net/design/CollectionTypes.html) which
however requires specifying an array size up front. There doesn't seem to be
any precedent here for Maps, and the Multiset [set of tuples] syntax is
terrible.
Personally I'd lean towards keeping the <> syntax for all types. Ambivalent on
renaming list to array for better Hive compatibility; I think "list" is better,
but maybe not enough better to justify the incompatibility.
> 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
