They are functionally equivalent, but INNER JOIN can be a bit clearer to read, especially if the query has other join types (i.e. LEFT or RIGHT or CROSS) included in it.
Regards Vikas Srivastava On 12 Feb 2017, 12:02 PM +0800, Divya Gehlot <divya.htco...@gmail.com>, wrote: > Hi , > What's the difference between" join " and "inner join" in hive ? > > Thanks , > Divya >
