Ottomata has submitted this change and it was merged.
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(-)
Approvals:
Ottomata: Verified; Looks good to me, approved
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: merged
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
