#1: Simple Count query not working on Hive

tadbuhman reported 2014-04-21T19:33:54Z · last modified 2014-04-21T19:33:54Z

Dev
QA

Priority	Blocker
Complexity	Unknown

Component	r
Version	Version1

I can run a simple select query

select * from haps_log where createddate> '1/1/2014' limit 1000

However, if I just change it slightly to return the count

select count(*) from haps_log where createddate>'1/1/2014' limit 1000

I get an error:

>[Error] Script lines: 1-6 --------------------------

Query returned non-zero code: 1, cause: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MapRedTask

[Executed: 4/21/2014 12:17:19 PM] [Execution: 0ms]

Both queries run fine in the native Hue UI.

All Comments (0) Change History