FAQ
Hi, all!
Continue my previous post:

I have another question want to ask:

When i run a query of "select max(start_date_time) from gb_xdr" in
impala-shell on the table data stored as TEXTFILE, it gave
me incorrect result with unreadable code, Here is output in impala-shell:

[cloudera-host3:21000] > select max(start_date_time) from mpos_gb.gb_xdr;
Query: select max(start_date_time) from mpos_gb.gb_xdr
Query finished, fetching results ...
àh‘?r
Returned 1 row(s) in 257.07s
[cloudera-host3:21000] >
--------------------------------------------------------------------------------------
And when i run the same query in Hive, I get the incorrect result too:

hive> select max(start_date_time) from mpos_gb.gb_xdr;
Total MapReduce jobs = 1
Launching Job 1 out of 1
Number of reduce tasks determined at compile time: 1
In order to change the average load for a reducer (in bytes):
set hive.exec.reducers.bytes.per.reducer=<number>
In order to limit the maximum number of reducers:
set hive.exec.reducers.max=<number>
In order to set a constant number of reducers:
set mapred.reduce.tasks=<number>
Starting Job = job_local2039285382_0001, Tracking URL =
http://localhost:8080/
Kill Command = /usr/lib/hadoop/bin/hadoop job -kill
job_local2039285382_0001
Hadoop job information for Stage-1: number of mappers: 0; number of
reducers: 0
2013-03-20 15:25:45,684 Stage-1 map = 0%, reduce = 0%
2013-03-20 15:25:50,896 Stage-1 map = 1%, reduce = 0%
2013-03-20 15:26:01,324 Stage-1 map = 2%, reduce = 0%
2013-03-20 15:26:10,438 Stage-1 map = 3%, reduce = 0%
......
2013-03-20 15:37:28,796 Stage-1 map = 99%, reduce = 0%
2013-03-20 15:37:32,946 Stage-1 map = 100%, reduce = 100%
Ended Job = job_local2039285382_0001
MapReduce Jobs Launched:
Job 0: HDFS Read: 5482000526779 HDFS Write: 31296012 SUCCESS
Total MapReduce CPU Time Spent: 0 msec
OK
?h??r
Time taken: 714.878 seconds
hive>
--------------------------------------------------------------------------------------
the result i expect is like: 2012-09-05 16:54:55.100000


Why is it not right?

Thanks!

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupimpala-user @
categorieshadoop
postedMar 20, '13 at 7:51a
activeMar 20, '13 at 7:51a
posts1
users1
websitecloudera.com
irc#hadoop

1 user in discussion

Zjp...: 1 post

People

Translate

site design / logo © 2022 Grokbase