[DRILL-2361] Column aliases cannot include dots

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 0.7.0, 0.8.0
• Fix Version/s: 1.2.0
• Component/s: Query Planning & Optimization
• Assignee: Adam Gilmore
• Reporter: Adam Gilmore
• Created: 03/Mar/15 02:16
• Updated: 05/Jul/17 14:15
• Resolved: 02/Oct/15 21:09

Description

The Drill query engine rejects column aliases for aggregates or group by fields where the alias includes a dot.

For example:

select count(*) as `test.field` from cp.`employee.json`;

throws an error with "Field references must be singular names."

Having reviewed the code, I can't quite see a reason for it, and when using FieldReference.getWithQuotedRef instead in AggPrelBase, the issue is alleviated with no visible side effects.

I'm sure there was a reason for this code in FieldReference, but I can't seem to work out why, and it seems entirely reasonable to allow a dot in a column alias.

Issue Links

• is related to: DRILL-3885 Column alias "`f.c`" rejected if number of regions is > 1 in HBase unit tests
• relates to: DRILL-4264 Allow field names to include dots