hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Kerzner <mark.kerz...@shmsoft.com>
Subject Command works inside hive but not outside
Date Wed, 28 Sep 2011 22:55:41 GMT
Hi, experts,

the same command words in hive shell

add jar WebLogAnalyzer-1.0-SNAPSHOT-jar-with-dependencies.jar; create
temporary function get_browser as "com.shmsoft.webloganalyzer.GetBrowser";
SELECT get_browser(user_agent),  COUNT(get_browser(user_agent)) AS
NumOccurrences FROM apache_logs GROUP BY get_browser(user_agent);

but outside,

hive -e 'add jar WebLogAnalyzer-1.0-SNAPSHOT-jar-with-dependencies.jar;
create temporary function get_browser as
"com.shmsoft.webloganalyzer.GetBrowser"; SELECT get_browser(user_agent),
COUNT(get_browser(user_agent)) AS NumOccurrences FROM apache_logs GROUP BY
get_browser(user_agent);'

it gives me an error

FAILED: Error in semantic analysis: Unable to fetch table apache_logs

Thank you,
Mark

Mime
View raw message