Skip to content

bug: NotImplementedError on DatabaseTable while compiling ClickHouse plan #1312

@WangTaoTheTonic

Description

@WangTaoTheTonic

What happened?

Image

I tried to connect to my local clickhouse instance and compile plan for a query reading from a TPC-H table.
The codes are listed:

import ibis
con = ibis.clickhouse.connect(user="default", password="your_password", host="[fdbd:dc00:b009:28::230]", port=30266, secure=True, database = "tpch_001")
lineitem = con.table("lineitem")
l_filter = lineitem.filter(lineitem.l_shipdate <= ibis.timestamp("1998-12-01") - ibis.interval(90, 'days'))
ibis.to_sql(l_filter)
from ibis_substrait.compiler.core import SubstraitCompiler
compiler = SubstraitCompiler()
expr = compiler.compile(l_filter)

but found error in the above image.
After take a look at translate.py, there seems no DatabaseTable registeration also. Did i miss something? Any help would be appreciated.

What version of ibis-substrait are you using?

4.0.1

Image

What substrait consumer(s) are you using, if any?

ClickHouse

Relevant log output

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    Status

    backlog

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions