[DRILL-4372] Drill Operators and Functions should correctly expose their types within Calcite

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.7.0
• Component/s: Query Planning & Optimization
• Assignee: Sean Hsuan-Yi Chu
• Reporter: Sean Hsuan-Yi Chu
• Created: 08/Feb/16 21:34
• Updated: 20/Mar/16 04:20
• Resolved: 20/Mar/16 04:20

Description

Currently, for most operators / functions, Drill would always claim the return types being nullable-any.

However, in many cases (such as Hive, View, etc.), the types of input columns are known. So, along with resolving to the correct operators / functions, we can infer the output types at planning.

Having this mechanism can help speed up many applications, especially where schemas alone are sufficient (e.g., Limit-0).

Issue Links

• contains: DRILL-4507 TO_TIMESTAMP does not generate TIMESTAMP data type in metadata