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 <[email protected]> wrote: > 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, > > Hielke > > > > > On 21 Aug 2017, at 16:04, Hielke Hoeve <[email protected]> wrote: > > > > 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 doing wrong? > > > > Given the following 2 tables: > > > > Department > > | id | name | > > |----|------| > > | 1 | A | > > | 2 | B | > > > > Employee > > | id | name | dept | salary | > > |----|------|------|--------| > > | 1 | U | 1 | 100 | > > | 2 | V | 1 | 75 | > > | 3 | W | 1 | 120 | > > | 4 | X | 2 | 95 | > > | 5 | Y | 2 | 140 | > > | 6 | Z | 2 | 55 | > > > > Running > > > > select employee.name, employee.salary > > from employee > > inner join department on employee.dept = department.id > > where department.name = 'A' > > > > returns > > > > | name | salary | > > |------|--------| > > | A | 100 | > > | A | 75 | > > | A | 120 | > > > > Running > > > > select dept.name, employee.salary > > from employee > > inner join department on employee.dept = department.id > > where department.name = 'A' > > > > returns > > > > | name | salary | > > |------|--------| > > | null | 100 | > > | null | 75 | > > | null | 120 | > > > > > > What does work, but seems very silly to me, is: > > > > select dept.name, employee.salary > > from employee > > inner join (select id, name as deptname from department) as department > on employee.dept = department.id > > where department.deptname = 'A' > > > > > >
