Re: LzoCodec for hadoop 0.20.x

On Fri, Oct 8, 2010 at 6:34 PM, Ted Yu wrote: > Hi, > I am using hive trunk with default setting along with cdh3b2. > I encounter the following exception: > > Caused by: java.lang.IllegalArgumentException: Compression codec > com.hadoop.compression.lzo.LzoCodec not found. >     at > org.apache

Re: Can hive sql do the same job like this?

join_table: table_reference JOIN table_factor [join_condition] | table_reference {LEFT|RIGHT|FULL} [OUTER] JOIN table_reference join_condition | table_reference LEFT SEMI JOIN table_reference join_condition table_reference: table_factor | join_table table_factor: tbl_name [alias