Hi, all I'm learning phoenix, when trying to create table with the sql below, I met a ColumnNotFoundException, which probably be a issue of phoenix. Please correct me if I'm wrong. :)
SQL: CREATE TABLE TEST ( a BIGINT NOT NULL DEFAULT 0, b CHAR(10) DEFAULT "abc", cf.c INTEGER DEFAULT 1 CONSTRAINT pk PRIMARY KEY (a ASC, b ASC) ); Exeption: Error: ERROR 504 (42703): Undefined column. columnName=abc (state=42703,code=504) org.apache.phoenix.schema.ColumnNotFoundException: ERROR 504 (42703): Undefined column. columnName=abc at org.apache.phoenix.compile.FromCompiler$1.resolveColumn(FromCompiler.java:129) at org.apache.phoenix.compile.ExpressionCompiler.resolveColumn(ExpressionCompiler.java:372) at org.apache.phoenix.compile.ExpressionCompiler.visit(ExpressionCompiler.java:408) at org.apache.phoenix.compile.ExpressionCompiler.visit(ExpressionCompiler.java:146) at org.apache.phoenix.parse.ColumnParseNode.accept(ColumnParseNode.java:56) at org.apache.phoenix.parse.ColumnDef.validateDefault(ColumnDef.java:246) at org.apache.phoenix.compile.CreateTableCompiler.compile(CreateTableCompiler.java:108) at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableCreateTableStatement.compilePlan(PhoenixStatement.java:788) at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableCreateTableStatement.compilePlan(PhoenixStatement.java:777) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:387) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:377) at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:375) at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:364) at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1738) at sqlline.Commands.execute(Commands.java:822) at sqlline.Commands.sql(Commands.java:732) at sqlline.SqlLine.dispatch(SqlLine.java:813) at sqlline.SqlLine.begin(SqlLine.java:686) at sqlline.SqlLine.start(SqlLine.java:398) at sqlline.SqlLine.main(SqlLine.java:291) I'm using phoenix4.13.1 and hbase1.2.5.
