I feel DRILL-5577 is more likely to be related to DRILL-5538. The cause is an optimizer rule ProjectRemoveRule, which is added to query planner by JDBC storage plugin if enabled. I believe Arina is looking for a fix.
On Fri, Jun 9, 2017 at 2:22 AM, Rahul Raj <[email protected]> wrote: > Created DRILL-5577 <https://issues.apache.org/jira/browse/DRILL-5577> > > On Thu, Jun 8, 2017 at 7:34 PM, Kunal Khatua <[email protected]> wrote: > > > It could be related to these as well: > > > > https://issues.apache.org/jira/browse/DRILL-5537 > > > > https://issues.apache.org/jira/browse/DRILL-5538 > > > > > > Please go ahead and file a bug. If it is related, they'll be linked and > > resolved together. > > > > > > ~ Kunal > > > > ________________________________ > > From: Rahul Raj <[email protected]> > > Sent: Thursday, June 8, 2017 12:12:47 AM > > To: [email protected] > > Subject: Column alias are ignored when Storage Plugin is enabled > > > > Drill ignores column aliases when a JDBC storage plugin is enabled. > > > > If I execute 'select destination as x from ...some.csv' the column name > > appears as 'destination' instead of 'x' while JDBC storage plugin is > > enabled. On disabling the storage plugin, drill returns the results with > > aliased name 'x'. > > > > This could be related to https://issues.apache.org/ > jira/browse/DRILL-4903, > > where results return the implicit columns(fqn,filepath etc..) as well. > > > > Should I go ahead and raise a JIRA on this? > > > > Regards, > > Rahul > > > > -- > > **** This email and any files transmitted with it are confidential and > > intended solely for the use of the individual or entity to whom it is > > addressed. If you are not the named addressee then you should not > > disseminate, distribute or copy this e-mail. Please notify the sender > > immediately and delete this e-mail from your system.**** > > > > -- > **** This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom it is > addressed. If you are not the named addressee then you should not > disseminate, distribute or copy this e-mail. Please notify the sender > immediately and delete this e-mail from your system.**** >
