RE: Hive query to split one row into many rows such that Row 1 will have col 1 Name, col 1 Value and Row 2 will have col 2 Name and col 2 value

Another example (with first name and last name), same principal Dudu Given the following table: id, first_name,last_name __ 1,Dudu,Markovitz 2,Andrew,Sears select id,key,value from my_table lateral view explode (map('fname',first_name,'lname',last_name)) t; The result wil

Re: Hive query to split one row into many rows such that Row 1 will have col 1 Name, col 1 Value and Row 2 will have col 2 Name and col 2 value

try this -- populate table user_parameters with user_id values (unique)from user_details INSERT user_parameters SELECT user_id, null, null FROM user_details -- Update remaining columnsd UPDATE user_parameters SET param_name = t1.user_name param_value = t1.user_address FROM

RE: Hive query to split one row into many rows such that Row 1 will have col 1 Name, col 1 Value and Row 2 will have col 2 Name and col 2 value

Hi Mich, it seems the request was for unpivot. Dudu From: Mich Talebzadeh [mailto:mich.talebza...@gmail.com] Sent: Saturday, April 23, 2016 10:04 AM To: user Subject: Re: Hive query to split one row into many rows such that Row 1 will have col 1 Name, col 1 Value and Row 2 will have col 2 Name

Re: Hive query to split one row into many rows such that Row 1 will have col 1 Name, col 1 Value and Row 2 will have col 2 Name and col 2 value

thanks I may have missed something. Deepak might clarify. cheers Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw * http://talebzadehmich.wordpres

Hive UDF's in Spark DataFrame

Is it possible to call a Hive registered UDF in Spark dataframe? Thanks,w

Re: [VOTE] Bylaws change to allow some commits without review

-0 On Apr 22, 2016 4:04 PM, "Chao Sun" wrote: > +1 > > On Fri, Apr 22, 2016 at 3:45 PM, Edward Capriolo > wrote: > >> +1 >> >> >> On Friday, April 22, 2016, Lars Francke wrote: >> >>> Yet another update. I went through the PMC list. >>> >>> These seven have not been active (still the same list