Re: Drill selects column with the same name of a different table

2017-08-30 Thread Timothy Farkas
unless someone else is available to fix it sooner 😊 Thanks, Tim From: Hielke Hoeve Sent: Wednesday, August 30, 2017 5:08:24 AM To: user@drill.apache.org Subject: Re: Drill selects column with the same name of a different table Hi all, Apologies for the late

Re: Drill selects column with the same name of a different table

2017-08-30 Thread Hielke Hoeve
gives me the correct results !!! :-) | name | salary | name0 | |-|--|---| | U | 100 | A | | V |75| A | | W |12 | A | Regards, Hielke > From: Hielke Hoeve > Subject: Drill selects column with the same name

Re: Drill selects column with the same name of a different table

2017-08-22 Thread Divya Gehlot
You dont have to go ding into Drill config just run the select * query on the joined data instead of selecting individual column. Thanks, Divya On 22 August 2017 at 19:18, Hielke Hoeve wrote: > Hi everyone, > > Sorry for not responding but I am not receiving your replies in my > mailbox. Lucki

Re: Drill selects column with the same name of a different table

2017-08-22 Thread Julian Hyde
You are not receiving replies because you have not subscribed to the user@drill list. Please do that. I moderated your message through last time and this time, which is why there was a delay in the messages appearing on the list. On 2017-08-22 04:18, Hielke Hoeve wrote: > Hi everyone, > > So

Re: Drill selects column with the same name of a different table

2017-08-22 Thread Hielke Hoeve
Hi everyone, Sorry for not responding but I am not receiving your replies in my mailbox. Luckily I have viewed the Archive on the website. Thanks for all your replies. I will get back to you asap, I don’t have full access to all Drill config so need someone else to do it for me :) Regards, Hi

Re: Drill selects column with the same name of a different table

2017-08-21 Thread Divya Gehlot
Hi, At times if during the join if the columns names are same the drill suffix zero for second column name . like in your case it could be name ,name0, > Can you please do a select * on join tables and check the column headers ? Thanks, Divya On 21 August 2017 at 22:04, Hielke Hoeve wrote: >

Re: Drill selects column with the same name of a different table

2017-08-21 Thread Timothy Farkas
_ From: Kunal Khatua Sent: Monday, August 21, 2017 3:22:29 PM To: user@drill.apache.org Subject: RE: Drill selects column with the same name of a different table Could you share the profile ( *.sys.drill file or the http://:8047/profiles/.json ) ? This might be a bug w

Re: Drill selects column with the same name of a different table

2017-08-21 Thread Zelaine Fong
hich you should file a JIRA. -Original Message- From: Hielke Hoeve [mailto:hielke.ho...@topicus.nl] Sent: Monday, August 21, 2017 7:05 AM To: user@drill.apache.org Subject: Drill selects column with the same name of a different table Hi everyone.

RE: Drill selects column with the same name of a different table

2017-08-21 Thread Kunal Khatua
it is most likely a storage plugin bug, for which you should file a JIRA. -Original Message- From: Hielke Hoeve [mailto:hielke.ho...@topicus.nl] Sent: Monday, August 21, 2017 7:05 AM To: user@drill.apache.org Subject: Drill selects column with the same name of a different table Hi eve

Drill selects column with the same name of a different table

2017-08-21 Thread Hielke Hoeve
Hi everyone. I just started using Drill/Zeppelin and I’m facing a strange problem. I have a PostgreSQL database linked to a Drill instance. Whenever I am trying to join 2 tables which both have a column name and whenever I want to select this name Drill selects the wrong name column. What am I d