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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
