Milimetric has uploaded a new change for review. (
https://gerrit.wikimedia.org/r/403946 )
Change subject: Correct the column order
......................................................................
Correct the column order
The interlanguage_navigation table had current and previous columns in
an order different from the insert/select statement that updates the
table. This should have worked because the columns in the select are
labeled but apparently hive doesn't work like that, so I corrected the
data manually and this commit makes the table agree with the insert
statement (it's easier this way, because it doesn't require re-starting
or re-running any jobs).
Change-Id: Ida44ca3bab93d73fd10cdb97b776fdc047807da2
---
M hive/interlanguage/create_interlanguage_navigation_table.hql
1 file changed, 1 insertion(+), 1 deletion(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/refinery
refs/changes/46/403946/1
diff --git a/hive/interlanguage/create_interlanguage_navigation_table.hql
b/hive/interlanguage/create_interlanguage_navigation_table.hql
index a54629d..03678a0 100644
--- a/hive/interlanguage/create_interlanguage_navigation_table.hql
+++ b/hive/interlanguage/create_interlanguage_navigation_table.hql
@@ -10,8 +10,8 @@
CREATE EXTERNAL TABLE IF NOT EXISTS `wmf.interlanguage_navigation` (
`project_family` string COMMENT 'The project family to aggregate on',
- `previous_project` string COMMENT 'The project (language) found in the
referers of this group of requests',
`current_project` string COMMENT 'The project (language) of this group
of requests',
+ `previous_project` string COMMENT 'The project (language) found in the
referers of this group of requests',
`navigation_count` bigint COMMENT 'The number of times a user navigated
from the previous to the current project'
)
PARTITIONED BY (
--
To view, visit https://gerrit.wikimedia.org/r/403946
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Ida44ca3bab93d73fd10cdb97b776fdc047807da2
Gerrit-PatchSet: 1
Gerrit-Project: analytics/refinery
Gerrit-Branch: master
Gerrit-Owner: Milimetric <dandree...@wikimedia.org>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
