phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Divya Gehlot <divya.htco...@gmail.com>
Subject Re: List of keywords/Tokens not allowed in Phoenix
Date Thu, 28 Jul 2016 10:11:26 GMT
https://phoenix.apache.org/language/

On 28 July 2016 at 14:19, Dharmesh Guna <dguna@vmware.com> wrote:

> Dear All,
>
>
>
> While running below query to create a table I encountered an error. Is
> there any list of tokens/keywords that we cannot use as column name in
> Phoenix?
>
> CREATE TABLE TTEST (ACTIVE BIGINT PRIMARY KEY, AC VARCHAR);
>
>
>
> Error Message:
>
>
>
> Error: Error -1 (00000) : Error while executing SQL "create table ttest
> (Active BIGINT PRIMARY KEY, AC VARCHAR)": Remote driver error:
> RuntimeException: org.apache.phoenix.exception.PhoenixParserException:
> ERROR 601 (42P00): Syntax error. Encountered "Active" at line 1, column 21.
> -> PhoenixParserException: ERROR 601 (42P00): Syntax error. Encountered
> "Active" at line 1, column 21. -> NoViableAltException: (null exception
> message) (state=00000,code=-1)
>
> org.apache.calcite.avatica.AvaticaSqlException: Error -1 (00000) : Error
> while executing SQL "create table ttest (Active BIGINT PRIMARY KEY, AC
> VARCHAR)": Remote driver error: RuntimeException:
> org.apache.phoenix.exception.PhoenixParserException: ERROR 601 (42P00):
> Syntax error. Encountered "Active" at line 1, column 21. ->
> PhoenixParserException: ERROR 601 (42P00): Syntax error. Encountered
> "Active" at line 1, column 21. -> NoViableAltException: (null exception
> message)
>
>         at
> org.apache.calcite.avatica.Helper.createException(Helper.java:53)
>
>         at
> org.apache.calcite.avatica.Helper.createException(Helper.java:41)
>
>         at
> org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:143)
>
>         at
> org.apache.calcite.avatica.AvaticaStatement.execute(AvaticaStatement.java:177)
>
>         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)
>
> java.lang.RuntimeException:
> org.apache.phoenix.exception.PhoenixParserException: ERROR 601 (42P00):
> Syntax error. Encountered "Active" at line 1, column 21.
>
>         at
> org.apache.calcite.avatica.jdbc.JdbcMeta.propagate(JdbcMeta.java:651)
>
>         at
> org.apache.calcite.avatica.jdbc.JdbcMeta.prepareAndExecute(JdbcMeta.java:715)
>
>         at
> org.apache.calcite.avatica.remote.LocalService.apply(LocalService.java:186)
>
>         at
> org.apache.calcite.avatica.remote.Service$PrepareAndExecuteRequest.accept(Service.java:868)
>
>         at
> org.apache.calcite.avatica.remote.Service$PrepareAndExecuteRequest.accept(Service.java:842)
>
>         at
> org.apache.calcite.avatica.remote.AbstractHandler.apply(AbstractHandler.java:102)
>
>         at
> org.apache.calcite.avatica.remote.ProtobufHandler.apply(ProtobufHandler.java:38)
>
>         at
> org.apache.calcite.avatica.server.AvaticaProtobufHandler.handle(AvaticaProtobufHandler.java:68)
>
>         at
> org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)
>
>         at
> org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
>
>         at org.eclipse.jetty.server.Server.handle(Server.java:497)
>
>         at
> org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
>
>         at
> org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:245)
>
>         at
> org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
>
>         at
> org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
>
>         at
> org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
>
>         at java.lang.Thread.run(Thread.java:745)
>
> Caused by: org.apache.phoenix.exception.PhoenixParserException: ERROR 601
> (42P00): Syntax error. Encountered "Active" at line 1, column 21.
>
>         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:1185)
>
>         at
> org.apache.phoenix.jdbc.PhoenixStatement.parseStatement(PhoenixStatement.java:1268)
>
>         at
> org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1339)
>
>         at
> org.apache.calcite.avatica.jdbc.JdbcMeta.prepareAndExecute(JdbcMeta.java:695)
>
>         ... 15 more
>
> Caused by: NoViableAltException(4@[])
>
>         at
> org.apache.phoenix.parse.PhoenixSQLParser.column_name(PhoenixSQLParser.java:2448)
>
>         at
> org.apache.phoenix.parse.PhoenixSQLParser.column_def(PhoenixSQLParser.java:3758)
>
>         at
> org.apache.phoenix.parse.PhoenixSQLParser.column_defs(PhoenixSQLParser.java:3682)
>
>         at
> org.apache.phoenix.parse.PhoenixSQLParser.create_table_node(PhoenixSQLParser.java:1054)
>
>         at
> org.apache.phoenix.parse.PhoenixSQLParser.oneStatement(PhoenixSQLParser.java:793)
>
>         at
> org.apache.phoenix.parse.PhoenixSQLParser.statement(PhoenixSQLParser.java:500)
>
>         at
> org.apache.phoenix.parse.SQLParser.parseStatement(SQLParser.java:108)
>
>         ... 19 more
>
>
>
> Thank you!!
>
>
>
> Regards,
>
> *:: Dharmesh Guna*
>
> :: Development | Custom Reports
> *:: Contact | *961.199.87.52 |  *Ext. | *130 3264
>
>
>

Mime
View raw message