Re: Column alias are ignored when Storage Plugin is enabled

[Jinfeng Ni]

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 
wrote:

> Created DRILL-5577 
>
> On Thu, Jun 8, 2017 at 7:34 PM, Kunal Khatua  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 
> > 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

[Rahul Raj]

Created DRILL-5577 

On Thu, Jun 8, 2017 at 7:34 PM, Kunal Khatua  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 
> 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

[Kunal Khatua]

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 
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.