You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Rahul Raj <ra...@option3consulting.com> on 2017/06/08 07:12:47 UTC
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.****
Re: Column alias are ignored when Storage Plugin is enabled
Posted by Jinfeng Ni <jn...@apache.org>.
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 <ra...@option3consulting.com>
wrote:
> Created DRILL-5577 <https://issues.apache.org/jira/browse/DRILL-5577>
>
> On Thu, Jun 8, 2017 at 7:34 PM, Kunal Khatua <kk...@mapr.com> 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 <ra...@option3consulting.com>
> > Sent: Thursday, June 8, 2017 12:12:47 AM
> > To: user@drill.apache.org
> > 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.****
>
Re: Column alias are ignored when Storage Plugin is enabled
Posted by Rahul Raj <ra...@option3consulting.com>.
Created DRILL-5577 <https://issues.apache.org/jira/browse/DRILL-5577>
On Thu, Jun 8, 2017 at 7:34 PM, Kunal Khatua <kk...@mapr.com> 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 <ra...@option3consulting.com>
> Sent: Thursday, June 8, 2017 12:12:47 AM
> To: user@drill.apache.org
> 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.****
Re: Column alias are ignored when Storage Plugin is enabled
Posted by Kunal Khatua <kk...@mapr.com>.
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 <ra...@option3consulting.com>
Sent: Thursday, June 8, 2017 12:12:47 AM
To: user@drill.apache.org
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.****