Hi, I am experimenting with the Pherf utility and had some questions. Running the utility with the provided scenario and data model works really well. However when I try to add parameters to the create table statement or do something else like add a secondary index I get what appears to be syntax type errors. Is there a limit on the SQL syntax I can use with Pherf?
Thanks, Ralph File resourceList Loaded: [/home/perko/pherf-4.4.1-HBase-0.98-SNAPSHOT-standalone/config/datamodel/user_defined_schema.sql, /datamodel/create_prod_test_unsalted.sql] org.apache.phoenix.exception.PhoenixParserException: ERROR 602 (42P00): Syntax error. Missing "EOF" at line 1, column 1032. at org.apache.phoenix.exception.PhoenixParserException.newException(PhoenixParserException.java:33) at org.apache.phoenix.parse.SQLParser.parseStatement(SQLParser.java:111) at org.apache.phoenix.jdbc.PhoenixStatement$PhoenixStatementParser.parseStatement(PhoenixStatement.java:1041) at org.apache.phoenix.jdbc.PhoenixStatement.parseStatement(PhoenixStatement.java:1122) at org.apache.phoenix.jdbc.PhoenixPreparedStatement.<init>(PhoenixPreparedStatement.java:95) at org.apache.phoenix.jdbc.PhoenixConnection.prepareStatement(PhoenixConnection.java:613) at org.apache.phoenix.pherf.util.PhoenixUtil.executeStatement(PhoenixUtil.java:91) at org.apache.phoenix.pherf.schema.SchemaReader.applySchema(SchemaReader.java:68) at org.apache.phoenix.pherf.Pherf.run(Pherf.java:170) at org.apache.phoenix.pherf.Pherf.main(Pherf.java:123) Caused by: MissingTokenException(inserted [@-1,0:0='<missing EOF>',<-1>,1:1031] at CREATE) at org.apache.phoenix.parse.PhoenixSQLParser.recoverFromMismatchedToken(PhoenixSQLParser.java:343) at org.antlr.runtime.BaseRecognizer.match(BaseRecognizer.java:115) at org.apache.phoenix.parse.PhoenixSQLParser.statement(PhoenixSQLParser.java:503) at org.apache.phoenix.parse.SQLParser.parseStatement(SQLParser.java:108) ... 8 more
