[TAJO-1359] Add nested field projector and language extension to project nested record

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.11.0
• Component/s: Physical Operator, Planner/Optimizer, SQL Parser
• Assignee: Hyunsik Choi
• Reporter: Hyunsik Choi
• Created: 26/Feb/15 00:22
• Updated: 11/May/15 22:06
• Resolved: 11/May/15 21:37

Description

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:

SELECT employee.age, employee.name.lastname, employee.name.firstname FROM ...