[
https://issues.apache.org/jira/browse/BIGTOP-1285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14039686#comment-14039686
]
YoungWoo Kim commented on BIGTOP-1285:
--------------------------------------
Sorry for the late reply I've been very busy for a while.
1. To pass the Phoenix itests, I need to specify the snappy version. without
that, I got following test failures:
{noformat}
Tests run: 73, Failures: 2, Errors: 0, Skipped: 0, Time elapsed: 4,152.158 sec
<<< FAILURE!
Results :
Failed tests:
testHashJoin(org.apache.bigtop.itest.phoenix.smoke.TestPhoenixSmoke):
org.apache.phoenix.end2end.HashJoinIT failed
testTenantSpecificTablesDML(org.apache.bigtop.itest.phoenix.smoke.TestPhoenixSmoke):
org.apache.phoenix.end2end.TenantSpecificTablesDMLIT failed
Tests run: 73, Failures: 2, Errors: 0, Skipped: 0
{noformat}
2. I did simple tests for the Phoenix client using included examples. It works
fine for me. please check following outputs:
{noformat}
# cd /usr/lib/phoenix/bin
# export PHOENIX_LIB_DIR=/usr/lib/phoenix
# ./sqlline.py localhost /usr/share/doc/phoenix-4.0.0/examples/STOCK_SYMBOL.sql
Setting property: [isolation, TRANSACTION_READ_COMMITTED]
Setting property: [run, /usr/share/doc/phoenix-4.0.0/examples/STOCK_SYMBOL.sql]
issuing: !connect jdbc:phoenix:localhost none none
org.apache.phoenix.jdbc.PhoenixDriver
Connecting to jdbc:phoenix:localhost
14/06/21 13:05:59 WARN util.NativeCodeLoader: Unable to load native-hadoop
library for your platform... using builtin-java classes where applicable
Connected to: Phoenix (version 4.0)
Driver: org.apache.phoenix.jdbc.PhoenixDriver (version 4.0)
Autocommit status: true
Transaction isolation: TRANSACTION_READ_COMMITTED
Building list of tables and columns for tab-completion (set fastconnect to true
to skip)...
53/53 (100%) Done
Done
...
-- creates stock table with single row
CREATE TABLE IF NOT EXISTS STOCK_SYMBOL (SYMBOL VARCHAR NOT NULL PRIMARY KEY,
COMPANY VARCHAR);
No rows affected (0.357 seconds)
3/5 UPSERT INTO STOCK_SYMBOL VALUES ('CRM','SalesForce.com');
1 row affected (0.076 seconds)
4/5 SELECT * FROM STOCK_SYMBOL;
+------------+------------+
| SYMBOL | COMPANY |
+------------+------------+
| CRM | SalesForce.com |
+------------+------------+
1 row selected (0.049 seconds)
5/5
Closing: org.apache.phoenix.jdbc.PhoenixConnection
sqlline version 1.1.2
# ./psql.py localhost /usr/share/doc/phoenix-4.0.0/examples/STOCK_SYMBOL.csv
/usr/share/doc/phoenix-4.0.0/examples/STOCK_SYMBOL.sql
14/06/21 13:11:34 WARN util.NativeCodeLoader: Unable to load native-hadoop
library for your platform... using builtin-java classes where applicable
csv columns from database.
CSV Upsert complete. 9 rows upserted
Time: 0.062 sec(s)
no rows upserted
Time: 0.134 sec(s)
1 row upserted
Time: 0.007 sec(s)
SYMBOL COMPANY
---------- ----------
AAPL APPLE Inc.
CRM SalesForce.com
GOOG Google
HOG Harlet-Davidson Inc.
HPQ Hewlett Packard
INTC Intel
MSFT Microsoft
WAG Walgreens
WMT Walmart
Time: 0.02 sec(s)
{noformat}
3. I'll update the Phoenix's project URL and then I'll upload a new patch.
> Bump version of Phoenix to 4.0
> ------------------------------
>
> Key: BIGTOP-1285
> URL: https://issues.apache.org/jira/browse/BIGTOP-1285
> Project: Bigtop
> Issue Type: Sub-task
> Components: General
> Reporter: Andrew Purtell
> Assignee: YoungWoo Kim
> Fix For: 0.8.0
>
> Attachments: BIGTOP-1285.1.patch, BIGTOP-1285.2.patch,
> BIGTOP-1285.patch
>
>
> After BIGTOP-1281, we should bump the shipped version of Apache Phoenix to
> the 4.x release line, currently 4.0.0.
> Phoenix 4.x is meant to run on HBase 0.98. Phoenix 3.x is meant to run on
> HBase 0.96. Phoenix 2.x is meant to run on HBase 0.94.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
