[GitHub] [bigtop] yamasakisua commented on pull request #988: BIGTOP-3787. Add docs in Phoenix .deb package

[GitBox <gi...@apache.org>]

yamasakisua commented on PR #988:
URL: https://github.com/apache/bigtop/pull/988#issuecomment-1229222971

   I could test  Phoenix with STOCK_SYMBOL.sql.
   
   ```
   $  ./docker-hadoop.sh -C config_debian-10.yaml -c 3 -k "zookeeper, hdfs, hbase"  -L -G
   $ ./docker-hadoop.sh --exec 1 bash
   
   root@9fb115917682:/# apt-get install -y phoenix python3
   root@9fb115917682:/# ln -s /usr/lib/phoenix/phoenix-server.jar /usr/lib/hbase/lib/phoenix-server.jar
   root@9fb115917682:/# systemctl restart hbase-master hbase-regionserver
   
   root@9fb115917682:/#  python3 /usr/lib/phoenix/bin/psql.py /usr/share/doc/phoenix/examples/STOCK_SYMBOL.sql /usr/share/doc/phoenix/examples/STOCK_SYMBOL.csv
   
   root@9fb115917682:/# python3 /usr/lib/phoenix/bin/sqlline.py
   Setting property: [incremental, false]
   Setting property: [isolation, TRANSACTION_READ_COMMITTED]
   issuing: !connect -p driver org.apache.phoenix.jdbc.PhoenixDriver -p user "none" -p password "none" "jdbc:phoenix:"
   SLF4J: Class path contains multiple SLF4J bindings.
   SLF4J: Found binding in [jar:file:/usr/lib/phoenix/phoenix-client-hbase-2.4-5.1.2.jar!/org/slf4j/impl/StaticLoggerBinder.class]
   SLF4J: Found binding in [jar:file:/usr/lib/hadoop/lib/slf4j-reload4j-1.7.36.jar!/org/slf4j/impl/StaticLoggerBinder.class]
   SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
   SLF4J: Actual binding is of type [org.slf4j.impl.Reload4jLoggerFactory]
   Connecting to jdbc:phoenix:
   22/08/27 16:26:39 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable
   Connected to: Phoenix (version 5.1)
   Driver: PhoenixEmbeddedDriver (version 5.1)
   Autocommit status: true
   Transaction isolation: TRANSACTION_READ_COMMITTED
   sqlline version 1.9.0
   0: jdbc:phoenix:> SELECT * FROM stock_symbol;
   +--------+----------------------+
   | SYMBOL |       COMPANY        |
   +--------+----------------------+
   | AAPL   | APPLE Inc.           |
   | CRM    | SALESFORCE           |
   | GOOG   | Google               |
   | HOG    | Harlet-Davidson Inc. |
   | HPQ    | Hewlett Packard      |
   | INTC   | Intel                |
   | MSFT   | Microsoft            |
   | WAG    | Walgreens            |
   | WMT    | Walmart              |
   +--------+----------------------+
   9 rows selected (0.097 seconds)
   0: jdbc:phoenix:>


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@bigtop.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org