twitter - Cloudera Twiiter Hive Query failure -


team,

curious know if succeeded in executing query twitter cloudera example?

i added mentioned serde jar in beewax file resources jar, still getting error query.

query:

select t.retweeted_screen_name, sum(retweets) total_retweets, count(*) tweet_count (select retweeted_status.user.screen_name retweeted_screen_name, retweeted_status.text, max(retweet_count) retweets tweets group retweeted_status.user.screen_name, retweeted_status.text) t group t.retweeted_screen_name order total_retweets desc limit 10; 

your query has following error(s):

error while processing statement: failed: execution error, return code 2 org.apache.hadoop.hive.ql.exec.mr.mapredtask

info : number of reduce tasks not specified. estimated input data size: 1 info : in order change average load reducer (in bytes): info : set hive.exec.reducers.bytes.per.reducer= info : in order limit maximum number of reducers: info : set hive.exec.reducers.max= info : in order set constant number of reducers: info : set mapreduce.job.reduces= warn : hadoop command-line option parsing not performed. implement tool interface , execute application toolrunner remedy this. info : number of splits:1 info : submitting tokens job: job_1432914212475_0002 info : url track job: http://quickstart.cloudera:8088/proxy/application_1432914212475_0002/ info : starting job = job_1432914212475_0002, tracking url = http://quickstart.cloudera:8088/proxy/application_1432914212475_0002/ info : kill command = /usr/lib/hadoop/bin/hadoop job -kill job_1432914212475_0002 info : hadoop job information stage-1: number of mappers: 1; number of reducers: 1 info : 2015-05-29 10:20:59,400 stage-1 map = 0%, reduce = 0% info : 2015-05-29 10:21:35,687 stage-1 map = 100%, reduce = 100% error : ended job = job_1432914212475_0002 errors 

resolved!

don't use prebuilt serde jar download. may outdated.

compile yourself!


Comments

Popular posts from this blog

Java 3D LWJGL collision -

spring - SubProtocolWebSocketHandler - No handlers -

methods - python can't use function in submodule -