Ottomata has uploaded a new change for review.
https://gerrit.wikimedia.org/r/150962
Change subject: Use tsv format when outputting webrequest faulty hosts files
......................................................................
Use tsv format when outputting webrequest faulty hosts files
It is currently difficult to read these files, as they are terminated by ^A.
This change makes it easier to read these files.
Change-Id: Ic61339add474f3a3008c5cc3408df3648bf1b061
---
M oozie/webrequest/partition/add/extract_faulty_hosts.hql
1 file changed, 2 insertions(+), 0 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/refinery
refs/changes/62/150962/1
diff --git a/oozie/webrequest/partition/add/extract_faulty_hosts.hql
b/oozie/webrequest/partition/add/extract_faulty_hosts.hql
index edab600..7b56ce3 100644
--- a/oozie/webrequest/partition/add/extract_faulty_hosts.hql
+++ b/oozie/webrequest/partition/add/extract_faulty_hosts.hql
@@ -44,6 +44,8 @@
INSERT OVERWRITE DIRECTORY '${target}'
+ROW FORMAT DELIMITED
+FIELDS TERMINATED BY '\t'
SELECT * FROM ${table} WHERE
(
count_duplicate != 0 -- Host has duplicates
--
To view, visit https://gerrit.wikimedia.org/r/150962
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Ic61339add474f3a3008c5cc3408df3648bf1b061
Gerrit-PatchSet: 1
Gerrit-Project: analytics/refinery
Gerrit-Branch: master
Gerrit-Owner: Ottomata <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
