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