James Stanier created PHOENIX-2338:
--------------------------------------
Summary: Couple of little tweaks in "Phoenix in 15 minutes or less"
Key: PHOENIX-2338
URL: https://issues.apache.org/jira/browse/PHOENIX-2338
Project: Phoenix
Issue Type: Bug
Environment: On the website.
Reporter: James Stanier
Priority: Trivial
There's a couple of little things I'd like to fix in the "Phoenix in 15 minutes
or less" page, based on my experience of running through the instructions
myself. Just wanted to register them before I put in a patch...
1. When copying and pasting the us_population.sql queries, the Microsoft-style
smart quotes lead to parsing errors when running with psql.py:
{code}
org.apache.phoenix.exception.PhoenixParserException: ERROR 601 (42P00): Syntax
error. Unexpected char: '“'
at
org.apache.phoenix.exception.PhoenixParserException.newException(PhoenixParserException.java:33)
at org.apache.phoenix.parse.SQLParser.nextStatement(SQLParser.java:98)
at
org.apache.phoenix.jdbc.PhoenixStatement$PhoenixStatementParser.nextStatement(PhoenixStatement.java:1278)
at
org.apache.phoenix.jdbc.PhoenixPreparedStatement.<init>(PhoenixPreparedStatement.java:84)
at
org.apache.phoenix.jdbc.PhoenixConnection.executeStatements(PhoenixConnection.java:312)
at
org.apache.phoenix.util.PhoenixRuntime.executeStatements(PhoenixRuntime.java:277)
at org.apache.phoenix.util.PhoenixRuntime.main(PhoenixRuntime.java:222)
Caused by: java.lang.RuntimeException: Unexpected char: '“'
at
org.apache.phoenix.parse.PhoenixSQLLexer.mOTHER(PhoenixSQLLexer.java:4169)
at
org.apache.phoenix.parse.PhoenixSQLLexer.mTokens(PhoenixSQLLexer.java:5226)
at org.antlr.runtime.Lexer.nextToken(Lexer.java:85)
at
org.antlr.runtime.BufferedTokenStream.fetch(BufferedTokenStream.java:143)
at
org.antlr.runtime.BufferedTokenStream.sync(BufferedTokenStream.java:137)
at
org.antlr.runtime.CommonTokenStream.consume(CommonTokenStream.java:71)
at org.antlr.runtime.BaseRecognizer.match(BaseRecognizer.java:106)
at
org.apache.phoenix.parse.PhoenixSQLParser.parseAlias(PhoenixSQLParser.java:6106)
at
org.apache.phoenix.parse.PhoenixSQLParser.selectable(PhoenixSQLParser.java:5223)
at
org.apache.phoenix.parse.PhoenixSQLParser.select_list(PhoenixSQLParser.java:5050)
at
org.apache.phoenix.parse.PhoenixSQLParser.single_select(PhoenixSQLParser.java:4315)
at
org.apache.phoenix.parse.PhoenixSQLParser.unioned_selects(PhoenixSQLParser.java:4432)
at
org.apache.phoenix.parse.PhoenixSQLParser.select_node(PhoenixSQLParser.java:4497)
at
org.apache.phoenix.parse.PhoenixSQLParser.oneStatement(PhoenixSQLParser.java:765)
at
org.apache.phoenix.parse.PhoenixSQLParser.nextStatement(PhoenixSQLParser.java:450)
at org.apache.phoenix.parse.SQLParser.nextStatement(SQLParser.java:88)
... 5 more
{code}
2. Similarly the CSV data provided does not have line breaks after each line,
which when copy and pasting it gives an error:
{code}
15/10/20 10:50:45 ERROR util.CSVCommonsLoader: Error upserting record [NY, New
York, 8143197 CA, Los Angeles, 3844829 IL, Chicago, 2842518 TX, Houston,
2016582 PA, Philadelphia, 1463281 AZ, Phoenix, 1461575 TX, San Antonio, 1256509
CA, San Diego, 1255540 TX, Dallas, 1213825 CA, San Jose, 912332 ]:
java.sql.SQLException: ERROR 201 (22000): Illegal data.
{code}
3. Just for clarity, I'd like to change the bullet-point "copy the phoenix jar
into the HBase lib directory of every region server" to "copy the phoenix
/server/ jar into the HBase lib directory of every region server"
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
