When I have two Tables A(id, name) and B(id, age) I want to join. through: SELECT * FROM A INNER JOIN B ON A.id=B.id and also through: SELECT * FROM A INNER JOIN B USING(id) in both ways, I get a table with duplicate key columns "id" from both previous tables: (id, name, id, age)   What I want is (id, name, age), so the key columns should merge.   EDIT: I know I could do it through "SELECT A.id, name, age..." instead of "SELECT * ...", but I have many columns, that I don't want to go this workaround. ... View more

Hi guys,   I am working with cloudera and Hue for a few days for my job and want to create a Coordinator, which is triggered, when there is a new file in a specific folder. I can create Coordinators with periodic frequencies, but not with event-triggers. I want to create this Coordinator using the Hue User interface (so my workmates can use it, too), but I don't know how to configure it. Can you explain to me, how to do this?   Btw: I tried to search for this, but I have found neither results answering my questions, nor good tutorials explaining everything from scratch.   Thanks for the help ... View more