Which one is optimal to use in hive ? distinct or group by ? may i know how both of the will be processed in the background ? ... View more

i am trying to get the list of tables and columns using a single query. may i know how can i do that ? I am looking for something like ex: 'select * from dbc.columns where tables like 'E%' How do we achive that in hive? ... View more