convert xls to csv files and then load into hive or if your column valus contain "comma" then you may have to use a different column separator. But that means you will need to write some code
On Tue, Oct 23, 2012 at 4:45 PM, <yogesh.kuma...@wipro.com> wrote: > Hi All, > > How can we load .xls format files into Hive in form of table. > > Please suggest > > Thanks & Regards > Yogesh Kumar > > The information contained in this electronic message and any attachments to > this message are intended for the exclusive use of the addressee(s) and may > contain proprietary, confidential or privileged information. If you are not > the intended recipient, you should not disseminate, distribute or copy this > e-mail. Please notify the sender immediately and destroy all copies of this > message and any attachments. > > WARNING: Computer viruses can be transmitted via email. The recipient should > check this email and any attachments for the presence of viruses. The > company accepts no liability for any damage caused by any virus transmitted > by this email. > > www.wipro.com -- Nitin Pawar
