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.

Help ClickHouse documentation by editing this page

url

url(URL, format, structure) -返回从创建的表 URL 与给定
format 和 structure.

URL-HTTP或HTTPS服务器地址，它可以接受 GET 和/或 POST 请求。

格式 - 格式 的数据。

结构-表结构 'UserID UInt64, Name String' 格式。 确定列名称和类型。

示例

  1. -- getting the first 3 lines of a table that contains columns of String and UInt32 type from HTTP-server which answers in CSV format.
  2. SELECT * FROM url('http://127.0.0.1:12345/', CSV, 'column1 String, column2 UInt32') LIMIT 3

原始文章