admin管理员组

文章数量:1026989

I have created a CH client using a session_id but it seems my temporary tables disappear after a few minutes (whilst I interactively explore in an iPython session).

session_id =  str(uuid.uuid4())
client = clickhouse_connect.get_client(
    host=HOST, 
    port=PORT, 
    username=USERNAME, 
    password=PASSWORD,
    database=DATABASE,
    interface='https' ,
    ca_cert=CA_CERT,
    server_host_name=HOST,
    session_id = session_id,
    # 
    settings={"join_use_nulls": 1}
)

I can create a temporary table like this:

clientmand("""
CREATE TEMPORARY TABLE T
AS SELECT
    uep_id, ...

but after a few minutes (while still in iPython), any queries on this table lead to a "table does not exist" error.

I have created a CH client using a session_id but it seems my temporary tables disappear after a few minutes (whilst I interactively explore in an iPython session).

session_id =  str(uuid.uuid4())
client = clickhouse_connect.get_client(
    host=HOST, 
    port=PORT, 
    username=USERNAME, 
    password=PASSWORD,
    database=DATABASE,
    interface='https' ,
    ca_cert=CA_CERT,
    server_host_name=HOST,
    session_id = session_id,
    # 
    settings={"join_use_nulls": 1}
)

I can create a temporary table like this:

clientmand("""
CREATE TEMPORARY TABLE T
AS SELECT
    uep_id, ...

but after a few minutes (while still in iPython), any queries on this table lead to a "table does not exist" error.

本文标签： clickhousePython and disappearing temporary tablesStack Overflow

版权声明：本文标题：Clickhouse, Python and disappearing temporary tables - Stack Overflow 内容由热心网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://it.en369.cn/questions/1741150265a1837544.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。