【已解决】Arrow Flight SQL 连接doris 2.1.3 报错

Viewed 92
2.1 ingestion

doris-2.1.3-rc09

show frontends;
image.png
show backends;
image.png

python 版本 3.10

adbc：
image.png

import adbc_driver_manager
import adbc_driver_flightsql.dbapi as flight_sql

import pandas
from datetime import datetime

my_uri = "grpc://10.4.66.171:9090"
my_db_kwargs = {
    adbc_driver_manager.DatabaseOptions.USERNAME.value: "root",
    adbc_driver_manager.DatabaseOptions.PASSWORD.value: "",
}

conn = flight_sql.connect(uri=my_uri, db_kwargs=my_db_kwargs)

报错：

warnings.warn(
                    "Cannot disable autocommit; conn will not be DB-API 2.0 compliant",
                    category=Warning,
                )

image.png

____5
2 Answers

忽略这个warning，这是 ADBC 的问题，这不会影响查询

黄海军@SelectDB3718

conn = flight_sql.connect(uri=my_uri, db_kwargs=my_db_kwargs)
这段改为 conn = flight_sql.connect(uri=my_uri, db_kwargs=my_db_kwargs, autocommit=True)
就不会提示那个错误了

鲁汀9