Re: Hive Query - Issue

2013-09-02 Thread manish dunani
d types everything is same but here it says > some difference. The same query works fine without having any partitions in > all the three tables but getting error while executing with partitions. > > > please help. > > > > Thanks > Manickam P > -- Regards *Manish Dunani* *Contact No* : +91 9408329137 *skype id* : manish.dunani* *

Re: Hive - external (dynamically) partitioned table

2013-07-26 Thread manish dunani
; > Time taken: 0.599 seconds > > > > > > select count(1) from nas_comps; > > returns 0 records > > How do I create an external Hive table with dynamic partitions?**** > > > > > > > > > > Regards, > > Omkar Joshi > > > > ** ** > -- > > The contents of this e-mail and any attachment(s) may contain confidential > or privileged information for the intended recipient(s). Unintended > recipients are prohibited from taking action on the basis of information in > this e-mail and using or disseminating the information, and must notify the > sender and delete it from their system. L&T Infotech will not accept > responsibility or liability for the accuracy or completeness of, or the > presence of any virus or disabling code in this e-mail" > > > > > > ** ** > > -- > Dean Wampler, Ph.D. > @deanwampler > http://polyglotprogramming.com > -- MANISH DUNANI -THANX +91 9426881954,+91 8460656443 manishd...@gmail.com

Re: Need help in joining 2 tables

2013-07-26 Thread manish dunani
DR.Country > from EMP_MASTER MAST, EMP_ADDRESS ADDR > where > MAST.row_create_date = (select max(row_create_date) from EMP_MASTER where > Emp_Id = MAST.Emp_Id) > and ADDR.row_create_date = (select max(row_create_date) from EMP_ADDRESS > where Emp_Id = ADDR.Emp_Id) > > > regards, > Rams > -- MANISH DUNANI -THANX +91 9426881954,+91 8460656443 manishd...@gmail.com