如何删除VerticaPy创建的临时表-错误表“v_temp_schema”。“train”已经存在。

Question

我想使用csv - https://www.vertica.com/python/documentation_last/utilities/read_csv/读取一个https://www.vertica.com/python/documentation_last/utilities/read_csv/文件。

我正在使用笔记本电脑上的Vertica映像运行Docker。

Jupyter代码是

import sys
!{sys.executable} -m pip install vertica-python
!{sys.executable} -m pip install verticapy

from verticapy import *
conn_info = {'host': '127.0.0.1',
             'port': 5433,
             'user': 'dbadmin',
             'password': '',
             'database': 'kaggle_titanic'}
train = read_csv("train.csv")
train

代码在第一次运行时运行良好，但是当我再次运行它时，会出现错误。

NameError                                 Traceback (most recent call last)
~\AppData\Local\Temp/ipykernel_8344/783506563.py in <module>
     23 #    cur.execute("drop table kaggle_titanic.v_temp_schema.train")
     24 
---> 25 train = read_csv("train.csv")
     26 train
     27 #iris2

~\Anaconda3\lib\site-packages\verticapy\utilities.py in read_csv(path, cursor, schema, table_name, sep, header, header_names, dtype, na_rep, quotechar, escape, genSQL, parse_n_lines, insert, temporary_table, temporary_local_table, ingest_local)
    918     result = cursor.fetchall()
    919     if (result != []) and not (insert):
--> 920         raise NameError(
    921             'The table "{}"."{}" already exists !'.format(schema, table_name)
    922         )

NameError: The table "v_temp_schema"."train" already exists !

看起来VerticaPy在第一次运行时就创建了一个临时表。我怎么删除它？

我试着添加这段代码

with vertica_python.connect(**conn_info) as conn:
    cur = conn.cursor()
    cur.execute("drop table kaggle_titanic.v_temp_schema.train")

但犯了错误

MissingSchema: Severity: ROLLBACK, Message: Schema "v_temp_schema" does not exist, Sqlstate: 3F000, Routine: RangeVarGetObjid, File: /data/jenkins/workspace/RE-ReleaseBuilds/RE-Jackhammer_3/server/vertica/Catalog/Namespace.cpp, Line: 281, Error Code: 4650, SQL: 'drop table kaggle_titanic.v_temp_schema.train'

我不得不停止/启动数据库(从docker映像)来运行代码，但显然这不是正确的方法。

如何删除v_temp_schema.train

Answer 1

我在Github上回答了这个请求：https://github.com/vertica/VerticaPy/issues/285