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

2017-05-29 Thread JP gupta
Assuming that special characters have been added by Windows platform as mentioned by Shakti Singh, one easy way to cleanup the file is using the command “dos2unix filename”. From: shakti singh Shekhawat [mailto:shaktisingh.shekhawa...@gmail.com] Sent: 30 May 2017 10:02 To:

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

Fwd: Error deploying LLAP using Apache Slider

2017-05-29 Thread Fabio
Hi everyone, I'm trying to deploy LLAP using Slider but the containers fail to start due to this error: Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/commons/logging/LogFactory at org.apache.hadoop.service.AbstractService.(AbstractService.java:43) Caused by:

Table count is more than File count after loading in hive

2017-05-29 Thread balajee venkatesh
Hi, Table count should be equal to the the number of records in in the source file but in my case it is more than the file count. Suppose the input file is having 1000 records but when I load this file data in the newly created table it becomes 1018. The table is having 80 columns so it is very

Drilldown link for running queries hiveserver2 UI

2017-05-29 Thread Vlad Gudikov
Hi, While clicking on Drilldow link in hiveserver2 UI for running queries I get a 500 ERROR. Is it an expected behavior? Copying error log: HTTP ERROR 500 Problem accessing /query_page. Reason: Server Error Caused by: java.lang.NullPointerException at