You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "James Taylor (JIRA)" <ji...@apache.org> on 2016/01/24 20:31:39 UTC
[jira] [Commented] (PHOENIX-2338) Couple of little tweaks in
"Phoenix in 15 minutes or less"
[ https://issues.apache.org/jira/browse/PHOENIX-2338?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15114480#comment-15114480 ]
James Taylor commented on PHOENIX-2338:
---------------------------------------
Would you mind reviewing/committing, [~tdsilva]?
> 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
> Assignee: Thomas D'Silva
> Priority: Trivial
> Labels: documentation
> Fix For: 4.8.0
>
> Attachments: PHOENIX-2338.patch
>
>
> 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)