hadoop - Distinct in hive -

i want use distinct in hive query.so query looks like

insert overwrite table tablename select distinct a.id id , a.id sid left join b on a.id = b.id;  

so in above query want insert same value 2 different column.with distinct query doesn't work ,otherwise works.