以编程方式使用文档

Kinetica 是一个数据库，内置支持向量相似性搜索。

本笔记本介绍如何从 Kinetica 加载文档

pip install -qU langchain-kinetica

您必须在以下环境变量中设置数据库连接。如果您使用虚拟环境，可以在项目的 .env 文件中设置它们：

  • * KINETICA_URL：数据库连接 URL（例如 http://localhost:9191)
  • * KINETICA_USER：数据库用户
  • * KINETICA_PASSWD：安全密码。
from gpudb import GPUdb

kdbc = GPUdb.get_connection()
2026-02-02 20:54:50.972 INFO     [GPUdb] Connected to Kinetica! (host=http://localhost:19191 api=7.2.3.3 server=7.2.3.5)

以下 QUERY 是一个不会运行的示例；此 需要替换为有效的 QUERY 才能返回 数据，且 SCHEMA.TABLE 组合必须存在于 Kinetica 中。

from langchain_kinetica import KineticaLoader

QUERY = """select
    oid,
    object_name as text,
    creation_time
from ki_catalog.ki_objects
where schema_name = 'information_schema'
limit 10"""

kinetica_loader = KineticaLoader(
    kdbc=kdbc,
    query=QUERY,
    metadata_columns=["creation_time"],
)

kinetica_documents = kinetica_loader.load()
display(kinetica_documents)
[Document(metadata={'creation_time': 1769036399161}, page_content='oid: -263809000193198488\ntext: KEY_COLUMN_USAGE\ncreation_time: 1769036399161'),
    Document(metadata={'creation_time': 1769036399260}, page_content='oid: -6302080570668733378\ntext: KI_PERIODIC_OBJECTS\ncreation_time: 1769036399260'),
    Document(metadata={'creation_time': 1769036399402}, page_content='oid: 8620184385195410035\ntext: OBJECT_PRIVILEGES\ncreation_time: 1769036399402'),
    Document(metadata={'creation_time': 1769036399219}, page_content='oid: -582966432601743881\ntext: KI_HA_CONSUMERS\ncreation_time: 1769036399219'),
    Document(metadata={'creation_time': 1769036398744}, page_content='oid: -745341673129057292\ntext: COLUMNS\ncreation_time: 1769036398744'),
    Document(metadata={'creation_time': 1769036399143}, page_content='oid: 7168154014071633303\ntext: INFORMATION_SCHEMA_CATALOG_NAME\ncreation_time: 1769036399143'),
    Document(metadata={'creation_time': 1769036399352}, page_content='oid: 2994153253665268119\ntext: KI_QUERY_SPAN_METRICS_BY_SQL_STEP\ncreation_time: 1769036399352'),
    Document(metadata={'creation_time': 1769036399098}, page_content='oid: 2689064758811356754\ntext: INDEXES\ncreation_time: 1769036399098'),
    Document(metadata={'creation_time': 1769036398543}, page_content='oid: -7679099635043663749\ntext: APPLICABLE_ROLES\ncreation_time: 1769036398543'),
    Document(metadata={'creation_time': 1769036399434}, page_content='oid: 909900969452802786\ntext: ROLE_TABLE_GRANTS\ncreation_time: 1769036399434')]