Skip to content

Clickhouse: Table schema.ibis_clickhouse_metadata_randomcode doesn't exist. (UNKNOWN_TABLE) #1189

Open
@rara011088

Description

@rara011088

Original Issue here: #1596

Workaround:

  1. Create a new file __init__.py in path ibis-server/app/custom_ibis/backends/clickhouse and add the imports
    from ibis import util
    from ibis.backends.clickhouse import Backend
  2. Create a custom function custom_get_schema_using_query to replace ibis-project function _get_schema_using_query
  3. Modify the original raw_sql with "ON CLUSTER 'cluster_name'" for both CREATE and DROP statements
  4. Add the line Backend._get_schema_using_query = custom_get_schema_using_query
  5. Modify the file clickhouse.py by adding import
    import types
    from app.custom_ibis_backends.clickhouse import custom_get_schema_using_query
  6. Edit __init__ function by adding line
    self.connection._get_shcema_using_query = types.MethodType(custom_get_schema_using_query , self.connection)

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions