[
https://issues.apache.org/jira/browse/PHOENIX-2338?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Taylor updated PHOENIX-2338:
----------------------------------
Fix Version/s: 4.8.0
> 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: James Stanier
> 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)
