https://bugzilla.wikimedia.org/show_bug.cgi?id=65420
Bug ID: 65420
Summary: Hive queries inconsistently failing
Product: Analytics
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: critical
Priority: Unprioritized
Component: Kraken
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected], [email protected],
[email protected], [email protected],
[email protected], [email protected]
Web browser: ---
Mobile Platform: ---
(yes, another of Those issues)
A set of unrelated queries[0] are inconsistently failing on hive. This isn't a
tremendous problem, or wouldn't be if, the task view page wasn't seemingly
deleted WHEN the query failed; it just 404s out. Dan thinks it might be a
problem with the transfer to a single, unified table.
[0] set hive.mapred.mode = nonstrict;
ADD JAR /usr/lib/hcatalog/share/hcatalog/hcatalog-core-0.5.0-cdh4.3.1.jar;
SELECT *
FROM (
SELECT dt,ip AS IP FROM wmf.webrequest_text
WHERE year = 2014
AND month = 05
AND content_type RLIKE('text/html')
AND ip NOT RLIKE(':')
ORDER BY rand()) dtretrieve
LIMIT 5000000;
and
SELECT uri_path,uri_host,uri_query FROM webrequest WHERE year = 2014 AND month
= 04 LIMIT 1;
--
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
