Re: Date,table name as config parameter from command prompt in Hive queries

2012-01-11 Thread Bejoy Ks
. Hope it helps!.. Regards Bejoy.K.S From: Praveen Kumar To: user@hive.apache.org Sent: Wednesday, January 11, 2012 3:44 PM Subject: Re: Date,table name as config parameter from command prompt in Hive queries I found one way of doing it but, faili

Re: Date,table name as config parameter from command prompt in Hive queries

2012-01-11 Thread Praveen Kumar
I found one way of doing it but, failing in that. hive_query.hql -- use db_name; select * from ( select * from '${hiveconf:tab_name1}' union all select * from '${hiveconf: tab_name2}') t1 where sdate > '${hiveconf: curr_date1}' and edate < '${hiveconf: curr_date2}'; hive_tri.sh --