[
https://issues.apache.org/jira/browse/AMBARI-8945?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14260442#comment-14260442
]
Ted Yu commented on AMBARI-8945:
--------------------------------
This is how I tested using sqlline.py:
{code}
# ./sqlline.py localhost:2181:/hbase-unsecure
Setting property: [isolation, TRANSACTION_READ_COMMITTED]
issuing: !connect jdbc:phoenix:localhost:2181:/hbase-unsecure none none
org.apache.phoenix.jdbc.PhoenixDriver
Connecting to jdbc:phoenix:localhost:2181:/hbase-unsecure
14/12/29 20:58:27 WARN impl.MetricsConfig: Cannot locate configuration: tried
hadoop-metrics2-phoenix.properties,hadoop-metrics2.properties
Connected to: Phoenix (version 4.2)
Driver: PhoenixEmbeddedDriver (version 4.2)
Autocommit status: true
Transaction isolation: TRANSACTION_READ_COMMITTED
Building list of tables and columns for tab-completion (set fastconnect to true
to skip)...
68/68 (100%) Done
Done
sqlline version 1.1.2
...
0: jdbc:phoenix:localhost:2181:/hbase-unsecur> CREATE TABLE IF NOT EXISTS
STOCK_SYMBOL (SYMBOL VARCHAR NOT NULL PRIMARY KEY, COMPANY VARCHAR);
No rows affected (0.35 seconds)
0: jdbc:phoenix:localhost:2181:/hbase-unsecur> UPSERT INTO STOCK_SYMBOL VALUES
('CRM','SalesForce.com');
1 row affected (0.078 seconds)
0: jdbc:phoenix:localhost:2181:/hbase-unsecur> SELECT * FROM STOCK_SYMBOL;
+------------+------------+
| SYMBOL | COMPANY |
+------------+------------+
| CRM | SalesForce.com |
+------------+------------+
1 row selected (0.089 seconds)
{code}
> Enhance the HBase Stack Definition to layout the Phoenix server jar
> -------------------------------------------------------------------
>
> Key: AMBARI-8945
> URL: https://issues.apache.org/jira/browse/AMBARI-8945
> Project: Ambari
> Issue Type: Task
> Reporter: Ted Yu
> Assignee: Ted Yu
> Fix For: 2.0.0
>
> Attachments: AMBARI-8945.patch
>
>
> This task is to deploy Phoenix server jar along with HBase.
> It would facilitate fast enablement of Phoenix for HBase deployment.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
