chDB is an embedded OLAP SQL Engine 🚀 powered by ClickHouse
APACHE-2.0 License
Bot releases are hidden (Show)
Full Changelog: https://github.com/chdb-io/chdb/compare/v2.0.3...v2.0.4
Published by auxten about 1 month ago
Full Changelog: https://github.com/chdb-io/chdb/compare/v2.0.2...v2.0.3
Published by auxten about 2 months ago
Full Changelog: https://github.com/chdb-io/chdb/compare/v2.0.1...v2.0.2
Published by auxten about 2 months ago
Full Changelog: https://github.com/chdb-io/chdb/compare/v2.0.0b1...v2.0.1
Published by auxten 4 months ago
Special thanks to @mneedham!
Full Changelog: https://github.com/chdb-io/chdb/compare/v2.0.0b0...v2.0.0b1
Published by auxten 4 months ago
import chdb
import pandas as pd
df = pd.DataFrame(
{
"a": [1, 2, 3, 4, 5, 6],
"b": ["tom", "jerry", "auxten", "tom", "jerry", "auxten"],
}
)
chdb.query("SELECT b, sum(a) FROM Python(df) GROUP BY b ORDER BY b").show()
Full Changelog: https://github.com/chdb-io/chdb/compare/v1.4.1...v2.0.0b0
Published by auxten 5 months ago
Full Changelog: https://github.com/chdb-io/chdb/compare/v1.3.0...v1.4.1
Published by auxten 5 months ago
Full Changelog: https://github.com/chdb-io/chdb/compare/v1.3.0...v1.4.0
Published by auxten 7 months ago
# You do not need something like
# ret = chdb.query("SELECT 123")
# print(ret)
# just
chdb.query("SELECT 123").show()
from chdb import dbapi
conn = dbapi.connect(path=test_state_dir)
cur = conn.cursor()
cur.execute("CREATE DATABASE e ENGINE = Atomic;")
cur.execute(
"CREATE TABLE e.hi (a String primary key, b Int32) Engine = MergeTree ORDER BY a;"
)
cur.execute("INSERT INTO e.hi (a, b) VALUES (%s, %s);", ["he", 32])
cur.close()
conn.close()
conn2 = dbapi.connect(path=test_state_dir)
cur2 = conn2.cursor()
cur2.execute("SELECT * FROM e.hi;")
row = cur2.fetchone()
self.assertEqual(("he", 32), row)
from chdb import session as chs
se = chs.Session()
se.query("SET input_format_csv_skip_first_lines = 1")
se.query("SELECT * FROM `some dirty csv`").show()
Full Changelog: https://github.com/chdb-io/chdb/compare/v1.2.1...v1.3.0
Published by auxten 9 months ago
Full Changelog: https://github.com/chdb-io/chdb/compare/v1.2.0...v1.2.1
Published by auxten 9 months ago
Full Changelog: https://github.com/chdb-io/chdb/compare/v1.1.0...v1.2.0
Published by auxten 10 months ago
Full Changelog: https://github.com/chdb-io/chdb/compare/v1.0.2...v1.1.0
Published by auxten 10 months ago
Full Changelog: https://github.com/chdb-io/chdb/compare/v1.0.1...v1.0.2
Published by auxten 10 months ago
Full Changelog: https://github.com/chdb-io/chdb/commits/v1.0.1
Published by lmangani 11 months ago
Celebrating the work of @auxten @lmangani @laodouya @nmreadelf and all the community members supporting the project ❤️
Published by auxten 11 months ago
Full Changelog: https://github.com/chdb-io/chdb/compare/v1.0.0rc2...v1.0.0rc3
Published by auxten 11 months ago
Full Changelog: https://github.com/chdb-io/chdb/compare/v1.0.0rc1...v1.0.0rc2
Published by auxten 11 months ago
Full Changelog: https://github.com/chdb-io/chdb/compare/v0.16.0rc2...v1.0.0rc1
Published by auxten 11 months ago
Full Changelog: https://github.com/chdb-io/chdb/compare/v0.16.0rc1...v0.16.0rc2
Published by auxten 11 months ago
chdb 0.16 based on clickhouse 23.10
Vector Addition:
python3 -m chdb "SELECT [1, 2, 3] + [4, 5, 6]"
.Omit file() Function:
python3 -m chdb "SELECT * from '/home/Clickhouse/bench/hits_0.parquet' limit 10"
.NumPy as Input Format:
SELECT * FROM 'data.npy'
.Parquet Optimizations:
Condition Pushdown for ORC:
ORC
, similarly to Parquet
.PRQL Support:
PRQL
as a query language.urlCluster Function:
urlCluster
table function.arrayFold
for applying a lambda function to multiple arrays.jsonMergePatch
for merging JSON strings.arrayRandomSample
for sampling elements from an input array.SYSTEM DROP SCHEMA FORMAT CACHE [FOR Protobuf]
.force_optimize_projection_name
checks that a projection is used in the query.lttb
using the Largest-Triangle-Three-Buckets algorithm for downsampling data.CHECK TABLE
query has better performance and usability, supporting checking particular parts.byteSwap
for reversing the bytes of unsigned integers.formatQuery
and formatQuerySingleLine
for formatted SQL query output.SHOW SETTING setting_name
as a simpler version of SHOW SETTINGS
.substreams
and filenames
to the system.parts_columns
table.create_table_empty_primary_key_by_default
for default ORDER BY ()
.query_plan_preserve_num_streams_after_window_functions
to preserve the number of streams after evaluating window functions.IN
when set element type doesn't match column type.dictionary_use_async_executor
.AggregateFunctionTopKGenericData
.