phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dominic Egger <>
Subject Odd Syntax Error during Index creation on View
Date Mon, 05 Mar 2018 09:33:24 GMT
Hi Phoenix Users
So I have a somewhat baffling errors. I have create a view on the follwoing
HBase Table:

create 'xx:yy', {NAME => 'columns', COMPRESSION => 'SNAPPY'} , {SPLITS =>
['1', '2', '3', '4', '5', '6', '7', '8', '9', 'a', 'b', 'c', 'd', 'e', 'f']

So far this worked very well. But when I want to create an Index on this
view I get the following error:

 create index crea_dat_load_idx on PADASA.SENDUNGSDACH_3M_SNAP
Error: ERROR 601 (42P00): Syntax error. Encountered "columns" at line 1,
column 104. (state=42P00,code=601)
org.apache.phoenix.exception.PhoenixParserException: ERROR 601 (42P00):
Syntax error. Encountered "columns" at line 1, column 104.
        at org.apache.phoenix.exception.PhoenixParserException.newException(
        at org.apache.phoenix.parse.SQLParser.parseStatement(
        at org.apache.phoenix.jdbc.PhoenixStatement$PhoenixStatementParser.
        at org.apache.phoenix.jdbc.PhoenixStatement.parseStatement(
        at org.apache.phoenix.jdbc.PhoenixStatement.compileMutation(
        at org.apache.phoenix.compile.PostIndexDDLCompiler.compile(
        at org.apache.phoenix.schema.MetaDataClient.buildIndex(
        at org.apache.phoenix.schema.MetaDataClient.createIndex(
        at org.apache.phoenix.compile.CreateIndexCompiler$1.execute(
        at org.apache.phoenix.jdbc.PhoenixStatement$
        at org.apache.phoenix.jdbc.PhoenixStatement$
        at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(
        at org.apache.phoenix.jdbc.PhoenixStatement.execute(
        at sqlline.Commands.execute(
        at sqlline.Commands.sql(
        at sqlline.SqlLine.dispatch(
        at sqlline.SqlLine.begin(
        at sqlline.SqlLine.start(
        at sqlline.SqlLine.main(
Caused by: NoViableAltException(27@[])
        at org.apache.phoenix.parse.PhoenixSQLParser.select_list(
        at org.apache.phoenix.parse.PhoenixSQLParser.single_
        at org.apache.phoenix.parse.PhoenixSQLParser.unioned_
        at org.apache.phoenix.parse.PhoenixSQLParser.select_node(
        at org.apache.phoenix.parse.PhoenixSQLParser.upsert_node(
        at org.apache.phoenix.parse.PhoenixSQLParser.oneStatement(
        at org.apache.phoenix.parse.PhoenixSQLParser.statement(
        at org.apache.phoenix.parse.SQLParser.parseStatement(
        ... 18 more

When using !tables the index shows up as perpetually "building"

Does phoenix create some more SQL statements when a create index is
executed? It seems the column family name is throwing it off somehow. Has
anyone encountered this before?

Environment info:
CDH 5.9.0
Phoenix 4.7.0

All the best and thanks!
Best Dominic Egger

View raw message