[
https://issues.apache.org/jira/browse/DRILL-2361?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14345809#comment-14345809
]
Jacques Nadeau commented on DRILL-2361:
---------------------------------------
None in particular. Just thinking that trying some joins, aggregates, limits
etc using complex fields might be good. Maybe you could just add one or two
more queries here and if things look good we go as is. If not, we can file a
separate JIRA that tracks the needs for better QA coverage in this realm.
> Column aliases cannot include dots
> ----------------------------------
>
> Key: DRILL-2361
> URL: https://issues.apache.org/jira/browse/DRILL-2361
> Project: Apache Drill
> Issue Type: Bug
> Components: SQL Parser
> Affects Versions: 0.7.0, 0.8.0
> Reporter: Adam Gilmore
> Priority: Minor
> Attachments: DRILL-2361.1.patch.txt
>
>
> The Drill query engine rejects column aliases for aggregates or group by
> fields where the alias includes a dot.
> For example:
> {code}select count(*) as `test.field` from cp.`employee.json`;{code}
> 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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
