Parser exception: extraneous input 'SHOW' expecting {ALTER, ATTACH, BEGIN, CALL,...
🚨 错误信息
kuzu> SHOW node tables;
Error: Parser exception: extraneous input 'SHOW' expecting {ALTER, ATTACH, BEGIN, CALL, CHECKPOINT, COMMENT, COMMIT, COPY, CREATE, DELETE, DETACH, DROP, EXPLAIN, EXPORT, FORCE, IMPORT, INSTALL, LOAD, MATCH, MERGE, OPTIONAL, PROFILE, RETURN, ROLLBACK, SET, UNWIND, UNINSTALL, UPDATE, USE, WITH, SP} (line: 1, offset: 0)
"SHOW node tables;"
^^^^
🤖 AI解决方案
Error: Parser exception: extraneous input 'SHOW' expecting {ALTER, ATTACH, BEGIN, CALL, CHECKPOINT, COMMENT, COMMIT, COPY, CREATE, DELETE, DETACH, DROP, EXPLAIN, EXPORT, FORCE, IMPORT, INSTALL, LOAD, MATCH, MERGE, OPTIONAL, PROFILE, RETURN, ROLLBACK, SET, UNWIND, UNINSTALL, UPDATE, USE, WITH, SP} (line: 1, offset: 0)
"SHOW node tables;"
^^^^
错误翻译:
解析器异常:多余的输入“SHOW”,期望的是 {ALTER, ATTACH, BEGIN, CALL, CHECKPOINT, COMMENT, COMMIT, COPY, CREATE, DELETE, DETACH, DROP, EXPLAIN, EXPORT, FORCE, IMPORT, INSTALL, LOAD, MATCH, MERGE, OPTIONAL, PROFILE, RETURN, ROLLBACK, SET, UNWIND, UNINSTALL, UPDATE, USE, WITH, SP}(行:1,偏移量:0)
原因分析:
Kuzu 数据库不支持 SHOW node tables; 这种语法。SHOW 命令在 Kuzu 中的可用子句不包含 node tables。
解决方案:
使用 CALL db.tables() 来查看所有表(包括节点表和边表):
CALL db.tables();
预防措施:
- 在使用 Kuzu 或其他数据库时,查阅其官方文档以了解支持的命令和语法。
- 在执行不确定的 SQL 命令前,先在 Kuzu 的交互式 shell 中尝试,或使用
HELP命令(如果支持)来探索可用功能。