Help wanted!
The following content of this documentation page has been machine-translated. But unlike other websites, it is not done on the fly. This translated text lives on GitHub repository alongside main ClickHouse codebase and waits for fellow native speakers to make it more human-readable. You can also use the original English version as a reference.
URL
url(URL, format, structure)
- retourne une table créée à partir du URL
avec le
format
et structure
.
URL-adresse du serveur HTTP ou HTTPS, qui peut accepter GET
et/ou POST
demande.
format - format des données.
structure - structure de table dans 'UserID UInt64, Name String'
format. Détermine les noms et les types de colonnes.
Exemple
-- getting the first 3 lines of a table that contains columns of String and UInt32 type from HTTP-server which answers in CSV format.
SELECT * FROM url('http://127.0.0.1:12345/', CSV, 'column1 String, column2 UInt32') LIMIT 3