There are no limits to the syntax. Pherf just send whatever is in the files it reads directly to phx client. Can you post exact file you are using?
Also, a couple of pointers. -Use a different file than the ones provided. Just put it in the config directory created in the installation. Pherf will pick any new files up automatically. -Use a different namespace and table as to avoid conflicts. On Wed, Jun 10, 2015 at 9:41 AM, Perko, Ralph J <ralph.pe...@pnnl.gov> wrote: > 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 >