Hackernews#
The connection to Hackernews is based on the Algolia Hackernews API.
Dependency#
requests
Parameters#
Required:
query
is the search query for getting the results.
Optional:
tags
is the tag used for filtering the query results. Check available tags to see a list of available filter tags.
Create Connection#
CREATE DATABASE hackernews_data WITH ENGINE = 'hackernews', PARAMETERS = {
"query": "EVADB",
"tags": "story"
};
Supported Tables#
search_results
: Lists the search query results. Check table_column_info.py for all the available columns in the table.
SELECT * FROM hackernews_data.search_results LIMIT 3;
Note
Looking for another table from Hackernews? Please raise a Feature Request.