global_query: global SQL queries for analytics-store.eqiad.wmnet
In wikimedia-research/WMUtils: Utilities for Wikimedia staffers
Description
Usage
Arguments
Author(s)
See Also
Description
global_query is a simple wrapper around RMySQL that allows a useR to send a query to all production
dbs on analytics-store.eqiad.wmnet, joining the results from each query into a single object.
Usage
1
global_query(query, project_type = "all", dt = TRUE)
Arguments
query
the SQL query you want to run
project_type
what class of wiki (wikisource, wiktionary..) you want to run against. Set to "all" by default.
dt
whether to return the results as a data.table or not
Author(s)
Oliver Keyes <okeyes@wikimedia.org>
See Also
mysql_query for querying an individual db, mw_strptime
for converting MediaWiki timestamps into POSIXlt timestamps.
wikimedia-research/WMUtils documentation built on May 4, 2019, 5:23 a.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Description Usage Arguments Author(s) See Also
Description
global_query is a simple wrapper around RMySQL that allows a useR to send a query to all production
dbs on analytics-store.eqiad.wmnet, joining the results from each query into a single object.
Usage
1 | global_query(query, project_type = "all", dt = TRUE)
|
Arguments
query |
the SQL query you want to run |
project_type |
what class of wiki (wikisource, wiktionary..) you want to run against. Set to "all" by default. |
dt |
whether to return the results as a data.table or not |
Author(s)
Oliver Keyes <okeyes@wikimedia.org>
See Also
mysql_query for querying an individual db, mw_strptime
for converting MediaWiki timestamps into POSIXlt timestamps.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.