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.