RE: Table count is more than File count after loading in hive

2017-05-30 Thread balajee venkatesh
*”. *From:* shakti singh Shekhawat [mailto:shaktisingh.shekhawa...@gmail.com] *Sent:* 30 May 2017 10:02 *To:* user@hive.apache.org *Subject:* Re: Table count is more than File count after loading in hive Hi Balajee, The best way will be to clean the file in Unix(or perl or python) before loading

RE: Table count is more than File count after loading in hive

2017-05-29 Thread JP gupta
@hive.apache.org Subject: Re: Table count is more than File count after loading in hive Hi Balajee, The best way will be to clean the file in Unix(or perl or python) before loading the file in HIVE. The root cause should be most probably carriage return(occurs as mostly the files generated

Re: Table count is more than File count after loading in hive

2017-05-29 Thread shakti singh Shekhawat
Hi Balajee, The best way will be to clean the file in Unix(or perl or python) before loading the file in HIVE. The root cause should be most probably carriage return(occurs as mostly the files generated on Microsoft platform consists of ^M characters in file). To identify whether carriage return