Hello Ottomata,
I'd like you to do a code review. Please visit
https://gerrit.wikimedia.org/r/148647
to review the following change.
Change subject: Drop leading 0s for partitions in sample HiveQL
......................................................................
Drop leading 0s for partitions in sample HiveQL
Although the leading 0s would work here, they give the impression that
we zero pad month etc. in partitions. To avoid this wrong impression,
we drop the leading zeros.
Change-Id: I238db806342c019834e7f3e2e3d2559c22ae1667
---
M hive/webrequest/sequence_stats.hql
1 file changed, 2 insertions(+), 2 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/refinery
refs/changes/47/148647/1
diff --git a/hive/webrequest/sequence_stats.hql
b/hive/webrequest/sequence_stats.hql
index b322d0c..137fc36 100644
--- a/hive/webrequest/sequence_stats.hql
+++ b/hive/webrequest/sequence_stats.hql
@@ -25,9 +25,9 @@
-- -d source_table=wmf_raw.webrequest \
-- -d destination_table=wmf.webrequest_sequence_stats \
-- -d year=2014 \
--- -d month=05 \
+-- -d month=5 \
-- -d day=12 \
--- -d hour=01
+-- -d hour=1
INSERT INTO TABLE ${destination_table}
SELECT
--
To view, visit https://gerrit.wikimedia.org/r/148647
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I238db806342c019834e7f3e2e3d2559c22ae1667
Gerrit-PatchSet: 1
Gerrit-Project: analytics/refinery
Gerrit-Branch: master
Gerrit-Owner: QChris <[email protected]>
Gerrit-Reviewer: Ottomata <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
