When i first wanted to apply the LOAD DATA INFILE, my server said:
|
1 2 3 |
Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement |
Google Trends Table Cheat Sheet
What did people search in Google? You can get the answer in google trends.
If you want to compare your own data a little more advanced with the google trands data, you need an archive with a certain time and space resolution. This is what the tables gtrends_time and gtrends_region of the datacoll database provide.
rss posts cheat sheets
Newspaper (or TV program or events from a city) are often published as rss feeds and are dumped in the rss_posts table. You can ask simple question like “Was my Organization mentioned reasonly?” or “How often is the keyword used”. (technical preview, dynamic data update will be implemented this year)
Gdelt GKG 2.1 Cheat Sheet
Short field description of the Gdelt table gkg v 2.1 (taken from the original paper). Not every column is copied in the datacoll table, note field InDatacoll: 1 = yes, 0 = no. Currently i have no regular updates for this table. I plan to have the last 3 weeks accessible.
GKGRECORDID used as primary key and for monthly partitioning.