[CALCITE-785] Add "Piglet", a subset of Pig Latin on top of Calcite algebra

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.5.0
• Assignee: Julian Hyde
• Reporter: Julian Hyde
• Created: 05/Jul/15 07:15
• Updated: 27/Feb/24 22:24
• Resolved: 07/Oct/15 19:35

Description

Implement a subset of Pig Latin on top of Calcite, mapping it onto Calcite algebra (via RelBuilder) that can then be optimized and executed on any back-end.

This serves several purposes:

• Illustrate how to implement a data language on Calcite
• Clear technical roadblocks so that the real Pig can be implemented on Calcite
• Strengthen Calcite's support for nested collections and related operations such as cogroup

Issue Links

• is related to: DRILL-82 Pig Latin to logical language parser and converter
• is related to: PIG-4107 Calcite for query optimization
• relates to: CALCITE-869 Add VALUES command to Piglet
• relates to: CALCITE-4569 Add support for providing custom properties to PigConverter
• relates to: CALCITE-4571 Conversion of PIG script with multiple store causing the merging of multiple sql statements
• relates to: CALCITE-4572 Conversion of Pig Latin scripts that contain RANK and FILTER operators fails
• relates to: CALCITE-4579 Piglet throws ClassCastException if Pig Latin script contains FLATTEN or STRSPLIT operators
• relates to: CALCITE-3470 Add a RelOptRule-based text DSL