[
https://issues.apache.org/jira/browse/CASSANDRA-2474?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13171111#comment-13171111
]
Jonathan Ellis commented on CASSANDRA-2474:
-------------------------------------------
Robin Schumacher notes that Oracle supports a related concept of "nested
tables": http://www.orafaq.com/wiki/NESTED_TABLE. The important syntax is:
- {{TYPE x IS OBJECT (foo, bar, ...)}}: declares a "row" object type
- {{TYPE y is TABLE (baz, zep, ...)}}: declares a "table" object type
- Above can be combined: {{INSERT into parent_table ('subtable') VALUES (y(x(a,
b), x(c, d), ...)}}
- Nested table creation is done using the TABLE type and NESTED TABLE keywords:
{{CREATE TABLE parent_table(i int, subtable y) NESTED TABLE y STORE AS y_tab}}
(unclear to me what STORE AS does, if anything; none of the examples I saw have
involved that other than as a necessary part of the declaration)
- SELECT also requires the TABLE keyword: {{select p.i, s.* FROM parent_table
p, TABLE(p.y) s}}
See
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:8135488196597
and
http://www.databasejournal.com/features/oracle/article.php/3788331/So-what-is-an-Oracle-Nested-Table.htm
> CQL support for compound columns
> --------------------------------
>
> Key: CASSANDRA-2474
> URL: https://issues.apache.org/jira/browse/CASSANDRA-2474
> Project: Cassandra
> Issue Type: New Feature
> Components: API, Core
> Reporter: Eric Evans
> Assignee: Pavel Yaskevich
> Labels: cql
> Fix For: 1.1
>
> Attachments: screenshot-1.jpg, screenshot-2.jpg
>
>
> For the most part, this boils down to supporting the specification of
> compound column names (the CQL syntax is colon-delimted terms), and then
> teaching the decoders (drivers) to create structures from the results.
--
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
