<p>Hello,</p>
<p> </p>
<p>I am stuck in a problem with BIRT conencted to Hive.</p>
<p> </p>
<p>Earlier I had a table in HIVE "testcpuinfo" where all data I had put in one file and uploaded on HIVE Table</p>
<p>At that time my aggregate functions were working fine.</p>
<p> </p>
<p>example:</p>
<p>select min(usercpu),reportname from testcpuinfo group by reportname;</p>
<p> </p>
<p>Later, I found that its possible to upload data from difefrent files in same table in HIVE. So now my data in HIVE table consists of following files:</p>
<p> </p>
<p>hduser@ubuntu:~/hive/examples/icc_load$ hadoop fs -ls /user/hive/warehouse/testcpuinfo<br>
15/10/22 20:39:30 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable<br>
Found 4 items<br>
-rwxr-xr-x 1 hduser supergroup 32535 2015-10-22 07:13 /user/hive/warehouse/testcpuinfo/Report_11082015-040236_cpu.csv<br>
-rwxr-xr-x 1 hduser supergroup 14549 2015-10-22 07:13 /user/hive/warehouse/testcpuinfo/Report_20062015-093441_cpu.csv<br>
-rwxr-xr-x 1 hduser supergroup 14432 2015-10-22 07:13 /user/hive/warehouse/testcpuinfo/Report_22062015-092203_cpu.csv<br>
-rwxr-xr-x 1 hduser supergroup 33652 2015-10-22 07:16 /user/hive/warehouse/testcpuinfo/Report_22092015_025040_cpu.csv<br>
</p>
<p> </p>
<p>But then I have realised that now my aggregate functions query are not able to return any data.</p>
<p>example:-</p>
<p>0: jdbc:hive2://192.168.108.133:10000> select min(usercpu),reportname from testcpuinfo group by reportname;<br>
INFO : Number of reduce tasks not specified. Estimated from input data size: 1<br>
INFO : In order to change the average load for a reducer (in bytes):<br>
INFO : set hive.exec.reducers.bytes.per.reducer=<number><br>
INFO : In order to limit the maximum number of reducers:<br>
INFO : set hive.exec.reducers.max=<number><br>
INFO : In order to set a constant number of reducers:<br>
INFO : set mapreduce.job.reduces=<number><br>
WARN : Hadoop command-line option parsing not performed. Implement the Tool interface and execute your application with ToolRunner to remedy this.<br>
INFO : number of splits:1<br>
INFO : Submitting tokens for job: job_local1932765430_0315<br>
INFO : The url to track the job: <a data-ipb='nomediaparse' href='
http://localhost:8080/'>http://localhost:8080/</a><br>
INFO : Job running in-process (local Hadoop)<br>
INFO : 2015-10-22 20:36:20,601 Stage-1 map = 100%, reduce = 100%<br>
INFO : Ended Job = job_local1932765430_0315<br>
+
+
+--+<br>
| c0 | reportname |<br>
+
+
+--+<br>
+
+
+--+<br>
No rows selected (1.451 seconds)<br>
0: jdbc:hive2://192.168.108.133:10000><br>
</p>
<p> </p>
<p>Can you please help, why its happening like that ?</p>
