[DRILL-4264] Allow field names to include dots

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.12.0
• Component/s: Execution - Codegen
• Labels: doc-impacting ready-to-commit
• Assignee: Vova Vysotskyi
• Reporter: Alex
• Reviewer: Paul Rogers
• Created: 12/Jan/16 09:40
• Updated: 28/Aug/24 15:09
• Resolved: 05/Sep/17 04:43

Description

If you have some json data like this...

    {
      "0.0.1":{
        "version":"0.0.1",
        "date_created":"2014-03-15"
      },
      "0.1.2":{
        "version":"0.1.2",
        "date_created":"2014-05-21"
      }
    }

... there is no way to select any of the rows since their identifiers contain dots and when trying to select them, Drill throws the following error:

Error: SYSTEM ERROR: UnsupportedOperationException: Unhandled field reference "0.0.1"; a field reference identifier must not have the form of a qualified name

This must be fixed since there are many json data files containing dots in some of the keys (e.g. when specifying version numbers etc)

Issue Links

• causes: DRILL-8507 Missing parquet columns quoted with backticks conflict with existing ones
• is related to: DRILL-2361 Column aliases cannot include dots
• links to: GitHub Pull Request #909

Sub-Tasks

• Document support for dots in field names: Resolved