You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@tajo.apache.org by "Hyunsik Choi (JIRA)" <ji...@apache.org> on 2015/02/26 01:23:06 UTC

[jira] [Created] (TAJO-1359) Add nested field projector and language extension to project nested record

Hyunsik Choi created TAJO-1359:
----------------------------------

             Summary: Add nested field projector and language extension to project nested record
                 Key: TAJO-1359
                 URL: https://issues.apache.org/jira/browse/TAJO-1359
             Project: Tajo
          Issue Type: Sub-task
          Components: parser, physical operator, planner/optimizer
            Reporter: Hyunsik Choi
            Assignee: Hyunsik Choi
             Fix For: 0.11


We need to improve Projector class to get nested record fields, and we also add some language extension to specify certain nested records in table schema. Both works should be done together. Otherwise, we need to test an entire work process.

Using dot '.' would be good for the syntax to specify nested fields. Many systems (Hive, Google BigQuery, and Drill) already use this syntax. Probably, many users are familiar with this form.

For example, if *employee* is a root nested record field and it includes *age* and *name* fields, consisting two fields lastname and firstname, we can specify them individually as follows:

{code}
SELECT employee.age, employee.name.lastname, employee.name.firstname FROM ...
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)