phoenix实时数据可视化预览报错

错误代码:62400001The SQL : { select "T_94FBDE"."id" "PA_0" from (select * from "school") "T_94FBDE" limit 1000 } is wrong, please check!ERROR 1001 (42I01): Undefined column family. familyName=T_94FBDE.null

FineBI 用户R9502024 发布于 2023-3-12 15:40

1min目标场景问卷

立即参与

回答问题关注问题

悬赏：4 F币 + 添加悬赏

提示：增加悬赏、完善问题、追问等操作，可使您的问题被置顶，并向所有关注者发送通知

共2回答

最佳回答

CD20160914Lv8专家互助
发布于2023-3-12 16:04

为什么用双引号把这个临时表引起来？你是什么数据库

改成下面看一下

select

T_94FBDE.*

from (select * from "school") T_94FBDE

limit 1000

举报收起评论(3)

用户R9502024(提问者) FineBI在数据预览时报的错，语句是系统生成的。是phoenix映射HBase表数据查询语句，表名和字段都是双引号

2023-03-12 16:09

CD20160914 回复用户R9502024(提问者) 你用我上面的改一下测试看看

2023-03-12 16:10

用户R9502024(提问者) 回复 CD20160914 Error: ERROR 1001 (42I01): Undefined column family. familyName=T_94FBDE.null (state=42I01,code=1001) org.apache.phoenix.schema.ColumnFamilyNotFoundException: ERROR 1001 (42I01): Undefined column family. familyName=T_94FBDE.null at org.apache.phoenix.schema.PTableImpl.getColumnFamily(PTableImpl.java:787) at org.apache.phoenix.compile.ProjectionCompiler.projectTableColumnFamily(ProjectionCompiler.java:262) at org.apache.phoenix.compile.ProjectionCompiler.compile(ProjectionCompiler.java:393) at org.apache.phoenix.compile.QueryCompiler.compileSingleFlatQuery(QueryCompiler.java:538) at org.apache.phoenix.compile.QueryCompiler.compileSingleQuery(QueryCompiler.java:489) at org.apache.phoenix.compile.QueryCompiler.compileSelect(QueryCompiler.java:201) at org.apache.phoenix.compile.QueryCompiler.compile(QueryCompiler.java:158) at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(PhoenixStatement.java:381) at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(PhoenixStatement.java:355) at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:261) at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:256) at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) at org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:255) at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1436) at sqlline.Commands.execute(Commands.java:822) at sqlline.Commands.sql(Commands.java:732) at sqlline.SqlLine.dispatch(SqlLine.java:808) at sqlline.SqlLine.begin(SqlLine.java:681) at sqlline.SqlLine.start(SqlLine.java:398) at sqlline.SqlLine.main(SqlLine.java:292)

2023-03-12 16:16