v2.0.4

What's Changed

• Add: support azure blob storage by @nmreadelf in #266

Full Changelog: v2.0.3...v2.0.4

v2.0.3

What's Changed

• Fix CmakeLists comment by @DemoYeti in #257
• Try to fix gpt example by @xinhuitian in #263
• Fix arrow types handling by @auxten in #264

New Contributors

• @DemoYeti made their first contribution in #257
• @xinhuitian made their first contribution in #263

Full Changelog: v2.0.2...v2.0.3

v2.0.2

What's Changed

• Fix global import dataframe by @auxten in #259

Full Changelog: v2.0.1...v2.0.2

v2.0.1

What's Changed

• Patchset-5 before v2.0.0 by @auxten in #250
• Performace tuning of pipeline running by @auxten in #256
• Better handling of numpy.NaN and complex Python types in Pandas Dataframe @auxten in #256

Full Changelog: v2.0.0b1...v2.0.1

v2.0.0b1

What's Changed

• Fix build on macOS x86 and Linux aarch64 by @auxten in #239
• Build on main updated by @auxten in #240
• Fix float point type pattern by @auxten in #241
• Fix Date and Date32 handling by @auxten in #242

Special thanks to @mneedham!

Full Changelog: v2.0.0b0...v2.0.0b1

v2.0.0b0

Highlight

• 🚀 87x performance boost query on Pandas DataFrame, See Benchmark

• ⬆️ Upgrade ClickHouse engine to 24.5

• 🐍 Query on Pandas DataFrame, ArrowTable, Dict or Any Python object Directly!

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()

• For more: test_query_py.py.

Changes

• Use in-process instead of embedded by @auxten in #222
• 226 crash on mergetree background task cleanup by @auxten in #227
• Replace icu with utf8proc by @auxten in #228
• Start agg step stream according to agg_col_cost and group_by_keys_cost by @auxten in #230
• Fix various issues like 190, 229 by @auxten in #231
• Before 2.0 release Patch #1 by @auxten in #232
• Fix python version check in CMakeLists.txt by @auxten in #233
• Fix mistake config.h by @auxten in #234
• Add tests on query python objects by @auxten in #235
• Add docs for Python Table Engine by @auxten in #238

Full Changelog: v1.4.1...v2.0.0b0

v1.4.1

What's Changed

• Disable ICU on macOS by @auxten in #221
• Enable H3 functions by @auxten in #218
• Alias sql method to query by @auxten in #219

Full Changelog: v1.3.0...v1.4.1

v1.4.0

What's Changed

• Enable H3 functions by @auxten in #218
• Alias sql method to query by @auxten in #219

Full Changelog: v1.3.0...v1.4.0

v1.3.0

What's Changed

• Add show for result by @auxten in #194

  # You do not need something like
  # ret = chdb.query("SELECT 123")
  # print(ret)
  # just
  chdb.query("SELECT 123").show()

• Allow path in dbapi connect by @nevinpuri in #176

  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)

• Now, SET clause will work through chdb session! by @auxten in #207

  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()

• Add test cases for materialize view by @auxten in #201
• Fix DB-API test rerun issue by @auxten in #208

New Contributors

• @nevinpuri made their first contribution in #176

Full Changelog: v1.2.1...v1.3.0

v1.2.1

What's Changed

• Fix macOS v2 symbol export table by @auxten in #183
• Upload libchdb.tar.gz to artifact by @Daniel-Robbins in #184
• Fix export warning by @auxten in #191
• Fix query_stable_v2 might return nullptr by @auxten in #192

Full Changelog: v1.2.0...v1.2.1