22.1 is our first release in the new year. It includes 2,599 new commits from 133 contributors, including 44 new contributors: 13DaGGeR, Adri Fernande

What's New in ClickHouse 22.1

submited by
Style Pass
2022-01-27 18:00:05

22.1 is our first release in the new year. It includes 2,599 new commits from 133 contributors, including 44 new contributors:

13DaGGeR, Adri Fernandez, Alexey Gusev, Anselmo D. Adams, Antonio Andelic, Ben, Boris Kuschel, Christoph Wurm, Chun-Sheng, Li, Dao, DimaAmega, Dmitrii Mokhnatkin, Harry-Lee, Justin Hilliard, MaxTheHuman, Meena-Renganathan, Mojtaba Yaghoobzadeh, N. Kolotov, Niek, Orkhan Zeynalli, Rajkumar, Ryad ZENINE, Sergei Trifonov, Suzy Wang, TABLUM.IO, Vitaly Artemyev, Xin Wang, Yatian Xu, Youenn Lebras, dalei2019, fanzhou, gulige, lgbo-ustc, minhthucdao, mreddy017, msirm, olevino, peter279k, save-my-heart, tekeri, usurai, zhoubintao, 李扬.

In this query we are importing data with the url table function. Data is posted on an HTTP server in a .native.xz file. The most annoying part of this query is that we have to specify the data structure and the format of this file.

Firstly, we detect the data format automatically from the file extension. Here it is .native.xz, so we know that the data is compressed by xz (LZMA2) compression and is represented in Native format. The Native format already contains all information about the types and names of the columns, and we just read and use it.

Leave a Comment