phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Taylor (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-2338) Couple of little tweaks in "Phoenix in 15 minutes or less"
Date Sun, 24 Jan 2016 19:31:39 GMT

    [ 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)

Mime
View raw message