hive query

Dear Friends, I have a hive table with column name Keyword,Hour,TotalTweets. for example, I have the date for three keyword as below. *KeywordHourTotalCount* iphone 11 500 iphone 12 1000 Samsung 11 300 Samsung 12 600 Nokia

if else condition in hive

Hi friends, INSERT,UPDATE,DELETE commands are working fine in my Hive environment after changing the configuration and all. Now, I have to execute a query like below sql in hive. If exists(select * from tablename where columnname=something) update table set column1=something where columnname=s

insert query in hive

Hi Friends, I have to insert the data into hive table from Java program. Insert query will work in Hive directly? like below sql command insert into tablename values(value1,value2) Thanks Raj

Re: alter partitions on hive external table

> > > > Hi Raj > > > > 1. I don’t understand the reason for this change, can you please > elaborate? > > > > 2. External table is just an interface. Instructions for how to > read existing data. > > Partitions of external table are just a logical

Re: alter partitions on hive external table

/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw > <https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* > > > > http://talebzadehmich.wordpress.com > > > > On 6 June 2016 at 04:02, raj hive wrote: > >> Hi friends, >> >> I ha

alter partitions on hive external table

Hi friends, I have created partitions on hive external tables. partitions on datetime/userid/customerId. now i have to change the order of the partitions for the existing data for all the dates. order of the partition is custerid/userid/datetime. Anyone can help me, how to alter the partitions