From user-return-440-apmail-phoenix-user-archive=phoenix.apache.org@phoenix.incubator.apache.org Wed Apr 2 23:27:49 2014 Return-Path: X-Original-To: apmail-phoenix-user-archive@minotaur.apache.org Delivered-To: apmail-phoenix-user-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id DDB631019E for ; Wed, 2 Apr 2014 23:27:49 +0000 (UTC) Received: (qmail 67258 invoked by uid 500); 2 Apr 2014 23:27:49 -0000 Delivered-To: apmail-phoenix-user-archive@phoenix.apache.org Received: (qmail 67228 invoked by uid 500); 2 Apr 2014 23:27:48 -0000 Mailing-List: contact user-help@phoenix.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@phoenix.incubator.apache.org Delivered-To: mailing list user@phoenix.incubator.apache.org Received: (qmail 67218 invoked by uid 99); 2 Apr 2014 23:27:48 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 Apr 2014 23:27:48 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,NORMAL_HTTP_TO_IP,RCVD_IN_DNSWL_LOW,SPF_PASS,T_FRT_BELOW2,WEIRD_PORT X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of kleiton.contato@gmail.com designates 209.85.160.174 as permitted sender) Received: from [209.85.160.174] (HELO mail-yk0-f174.google.com) (209.85.160.174) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 Apr 2014 23:27:44 +0000 Received: by mail-yk0-f174.google.com with SMTP id 20so871018yks.33 for ; Wed, 02 Apr 2014 16:27:23 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=uWn+sUzenCfGYAt7sY5cmILlQ1MG95RQGAeA5ZTwX/w=; b=OpKEr0XDJuvAKgWUPTrOEhzc3c96YqmcqhnGroE1WNtMg/MQiC74439/iFNp0PAxJD L63mZBAJDgI2aiYmyQS40eC+yL1CoPY8y9W4nRojaK6QzLZLxKoMxnPxLHTqF3qe8G/0 Q2qHfyG5CF2huPPmxt/MFX9xLsQXdrWXcwQg2nKBG/69+rl8uqhMRcw4BynxqJcAiRHD gMzOWhWhnty7rhGzmrRhUlcoASpoPqHWjiCtJgMQ5LADlaNoCC/T29lERlxyTeBOAdJl gc+Lb20R+cPj/GTqhUt8CgxcVMOG1d4/cAlYYk/cdfzrUcRv7zEA3oAMxfI0UVUsWt66 XsiQ== MIME-Version: 1.0 X-Received: by 10.236.179.162 with SMTP id h22mr134852yhm.107.1396481243190; Wed, 02 Apr 2014 16:27:23 -0700 (PDT) Received: by 10.170.76.130 with HTTP; Wed, 2 Apr 2014 16:27:23 -0700 (PDT) In-Reply-To: References: Date: Wed, 2 Apr 2014 16:27:23 -0700 Message-ID: Subject: Re: Help to Connect via SQuirrel From: Kleiton Silva To: user@phoenix.incubator.apache.org Content-Type: multipart/alternative; boundary=bcaec52c68616fcf0604f617a0ce X-Virus-Checked: Checked by ClamAV on apache.org --bcaec52c68616fcf0604f617a0ce Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Ok Jeffrey i will read the link, but i still receive the follow error, do you have any ideal? 2014-04-02 20:22:45,119 [Thread-10-SendThread(oak:2181)] INFO org.apache.zookeeper.ClientCnxn - Opening socket connection to server oak= / 127.0.0.1:2181. Will not attempt to authenticate using SASL (java.lang.SecurityException: Unable to locate a login configuration) 2014-04-02 20:22:45,119 [Thread-10-SendThread(oak:2181)] WARN org.apache.zookeeper.ClientCnxn - Session 0x0 for server null, unexpected error, closing socket connection and attempting reconnect java.net.ConnectException: Connection refused at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method) at sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:599) at org.apache.zookeeper.ClientCnxnSocketNIO.doTransport(ClientCnxnSocketNIO.ja= va:361) at org.apache.zookeeper.ClientCnxn$SendThread.run(ClientCnxn.java:1081) 2014-04-02 20:22:45,148 [Thread-10-SendThread(oak:2181)] INFO org.apache.zookeeper.ClientCnxn - Opening socket connection to server oak= / 127.0.0.1:2181. Will not attempt to authenticate using SASL (java.lang.SecurityException: Unable to locate a login configuration) 2014-04-02 20:22:45,149 [Thread-10-SendThread(oak:2181)] WARN org.apache.zookeeper.ClientCnxn - Session 0x0 for server null, unexpected error, closing socket connection and attempting reconnect java.net.ConnectException: Connection refused at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method) at sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:599) at org.apache.zookeeper.ClientCnxnSocketNIO.doTransport(ClientCnxnSocketNIO.ja= va:361) at org.apache.zookeeper.ClientCnxn$SendThread.run(ClientCnxn.java:1081) *My host file is*: 127.0.0.1 localhost 127.0.0.1 oak 127.0.0.1 oak.local Any ideal? *My hbase log*: Qua 2 Abr 2014 20:10:55 PDT Starting master on OAK.local core file size (blocks, -c) 0 data seg size (kbytes, -d) unlimited file size (blocks, -f) unlimited max locked memory (kbytes, -l) unlimited max memory size (kbytes, -m) unlimited open files (-n) 256 pipe size (512 bytes, -p) 1 stack size (kbytes, -s) 8192 cpu time (seconds, -t) unlimited max user processes (-u) 266 virtual memory (kbytes, -v) unlimited 2014-04-02 20:10:56,131 INFO [main] util.VersionInfo: HBase 0.98.0-hadoop1 2014-04-02 20:10:56,132 INFO [main] util.VersionInfo: Subversion https://svn.apache.org/repos/asf/hbase/tags/0.98.0RC2 -r 1565492 2014-04-02 20:10:56,132 INFO [main] util.VersionInfo: Compiled by apurtell on Thu Feb 6 16:20:15 PST 2014 2014-04-02 20:10:56,620 INFO [main] server.ZooKeeperServer: Server environment:zookeeper.version=3D3.4.5--1, built on 10/05/2013 16:05 GMT 2014-04-02 20:10:56,620 INFO [main] server.ZooKeeperServer: Server environment:host.name=3Doak 2014-04-02 20:10:56,620 INFO [main] server.ZooKeeperServer: Server environment:java.version=3D1.6.0_65 2014-04-02 20:10:56,620 INFO [main] server.ZooKeeperServer: Server environment:java.vendor=3DApple Inc. 2014-04-02 20:10:56,620 INFO [main] server.ZooKeeperServer: Server environment:java.home=3D/System/Library/Java/JavaVirtualMachines/1.6.0.jdk/= Contents/Home 2014-04-02 20:10:56,621 INFO [main] server.ZooKeeperServer: Server environment:java.class.path=3D/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../co= nf:/Library/Java/Home/lib/tools.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin= /..:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/activation-1.1.jar:/usr/= lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/asm-3.1.jar:/usr/lib/hbase/hbase-= 0.98.0-hadoop1/bin/../lib/commons-beanutils-1.7.0.jar:/usr/lib/hbase/hbase-= 0.98.0-hadoop1/bin/../lib/commons-beanutils-core-1.8.0.jar:/usr/lib/hbase/h= base-0.98.0-hadoop1/bin/../lib/commons-cli-1.2.jar:/usr/lib/hbase/hbase-0.9= 8.0-hadoop1/bin/../lib/commons-codec-1.7.jar:/usr/lib/hbase/hbase-0.98.0-ha= doop1/bin/../lib/commons-collections-3.2.1.jar:/usr/lib/hbase/hbase-0.98.0-= hadoop1/bin/../lib/commons-configuration-1.6.jar:/usr/lib/hbase/hbase-0.98.= 0-hadoop1/bin/../lib/commons-digester-1.8.jar:/usr/lib/hbase/hbase-0.98.0-h= adoop1/bin/../lib/commons-el-1.0.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bi= n/../lib/commons-httpclient-3.1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin= /../lib/commons-io-2.4.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/c= ommons-lang-2.6.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/commons-= logging-1.1.1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/commons-ma= th-2.2.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/commons-net-1.4.1= .jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/core-3.1.1.jar:/usr/lib= /hbase/hbase-0.98.0-hadoop1/bin/../lib/findbugs-annotations-1.3.9-1.jar:/us= r/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/guava-12.0.1.jar:/usr/lib/hbase= /hbase-0.98.0-hadoop1/bin/../lib/hadoop-core-1.2.1.jar:/usr/lib/hbase/hbase= -0.98.0-hadoop1/bin/../lib/hamcrest-core-1.3.jar:/usr/lib/hbase/hbase-0.98.= 0-hadoop1/bin/../lib/hbase-client-0.98.0-hadoop1.jar:/usr/lib/hbase/hbase-0= .98.0-hadoop1/bin/../lib/hbase-common-0.98.0-hadoop1-tests.jar:/usr/lib/hba= se/hbase-0.98.0-hadoop1/bin/../lib/hbase-common-0.98.0-hadoop1.jar:/usr/lib= /hbase/hbase-0.98.0-hadoop1/bin/../lib/hbase-examples-0.98.0-hadoop1.jar:/u= sr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/hbase-hadoop-compat-0.98.0-had= oop1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/hbase-hadoop1-compa= t-0.98.0-hadoop1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/hbase-i= t-0.98.0-hadoop1-tests.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/h= base-it-0.98.0-hadoop1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/h= base-prefix-tree-0.98.0-hadoop1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin= /../lib/hbase-protocol-0.98.0-hadoop1.jar:/usr/lib/hbase/hbase-0.98.0-hadoo= p1/bin/../lib/hbase-server-0.98.0-hadoop1-tests.jar:/usr/lib/hbase/hbase-0.= 98.0-hadoop1/bin/../lib/hbase-server-0.98.0-hadoop1.jar:/usr/lib/hbase/hbas= e-0.98.0-hadoop1/bin/../lib/hbase-shell-0.98.0-hadoop1.jar:/usr/lib/hbase/h= base-0.98.0-hadoop1/bin/../lib/hbase-testing-util-0.98.0-hadoop1.jar:/usr/l= ib/hbase/hbase-0.98.0-hadoop1/bin/../lib/hbase-thrift-0.98.0-hadoop1.jar:/u= sr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/high-scale-lib-1.1.1.jar:/usr/= lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/htrace-core-2.04.jar:/usr/lib/hba= se/hbase-0.98.0-hadoop1/bin/../lib/httpclient-4.1.3.jar:/usr/lib/hbase/hbas= e-0.98.0-hadoop1/bin/../lib/httpcore-4.1.3.jar:/usr/lib/hbase/hbase-0.98.0-= hadoop1/bin/../lib/jackson-core-asl-1.8.8.jar:/usr/lib/hbase/hbase-0.98.0-h= adoop1/bin/../lib/jackson-jaxrs-1.8.8.jar:/usr/lib/hbase/hbase-0.98.0-hadoo= p1/bin/../lib/jackson-mapper-asl-1.8.8.jar:/usr/lib/hbase/hbase-0.98.0-hado= op1/bin/../lib/jackson-xc-1.8.8.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin= /../lib/jamon-runtime-2.3.1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../= lib/jasper-compiler-5.5.23.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../l= ib/jasper-runtime-5.5.23.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib= /jaxb-api-2.2.2.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/jaxb-imp= l-2.2.3-1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/jersey-core-1.= 8.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/jersey-json-1.8.jar:/u= sr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/jersey-server-1.8.jar:/usr/lib= /hbase/hbase-0.98.0-hadoop1/bin/../lib/jettison-1.3.1.jar:/usr/lib/hbase/hb= ase-0.98.0-hadoop1/bin/../lib/jetty-6.1.26.jar:/usr/lib/hbase/hbase-0.98.0-= hadoop1/bin/../lib/jetty-sslengine-6.1.26.jar:/usr/lib/hbase/hbase-0.98.0-h= adoop1/bin/../lib/jetty-util-6.1.26.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1= /bin/../lib/jruby-complete-1.6.8.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bi= n/../lib/jsp-2.1-6.1.14.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/= jsp-api-2.1-6.1.14.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/jsr30= 5-1.3.9.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/junit-4.11.jar:/= usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/libthrift-0.9.0.jar:/usr/lib/= hbase/hbase-0.98.0-hadoop1/bin/../lib/log4j-1.2.17.jar:/usr/lib/hbase/hbase= -0.98.0-hadoop1/bin/../lib/metrics-core-2.1.2.jar:/usr/lib/hbase/hbase-0.98= .0-hadoop1/bin/../lib/netty-3.6.6.Final.jar:/usr/lib/hbase/hbase-0.98.0-had= oop1/bin/../lib/phoenix-core-4.0.0-incubating.jar:/usr/lib/hbase/hbase-0.98= .0-hadoop1/bin/../lib/protobuf-java-2.5.0.jar:/usr/lib/hbase/hbase-0.98.0-h= adoop1/bin/../lib/servlet-api-2.5-6.1.14.jar:/usr/lib/hbase/hbase-0.98.0-ha= doop1/bin/../lib/slf4j-api-1.6.4.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bi= n/../lib/slf4j-log4j12-1.6.4.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/..= /lib/stax-api-1.0.1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/xmle= nc-0.52.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/zookeeper-3.4.5.= jar: 2014-04-02 20:10:56,622 INFO [main] server.ZooKeeperServer: Server environment:java.library.path=3D.:/Library/Java/Extensions:/System/Library/= Java/Extensions:/usr/lib/java 2014-04-02 20:10:56,622 INFO [main] server.ZooKeeperServer: Server environment:java.io.tmpdir=3D/var/folders/zz/zzzivhrRnAmviuee+++++++++++/-T= mp-/ 2014-04-02 20:10:56,623 INFO [main] server.ZooKeeperServer: Server environment:java.compiler=3D 2014-04-02 20:10:56,623 INFO [main] server.ZooKeeperServer: Server environment:os.name=3DMac OS X 2014-04-02 20:10:56,623 INFO [main] server.ZooKeeperServer: Server environment:os.arch=3Dx86_64 2014-04-02 20:10:56,623 INFO [main] server.ZooKeeperServer: Server environment:os.version=3D10.6.8 2014-04-02 20:10:56,623 INFO [main] server.ZooKeeperServer: Server environment:user.name=3Droot 2014-04-02 20:10:56,623 INFO [main] server.ZooKeeperServer: Server environment:user.home=3D/Users/eduardofilho 2014-04-02 20:10:56,623 INFO [main] server.ZooKeeperServer: Server environment:user.dir=3D/usr/lib/hbase/hbase-0.98.0-hadoop1/bin 2014-04-02 20:10:56,668 INFO [main] server.ZooKeeperServer: Created server with tickTime 2000 minSessionTimeout 4000 maxSessionTimeout 40000 datadir /usr/lib/hbase/hbase-0.98.0-hadoop1/data/zookeeper/zookeeper_0/version-2 snapdir /usr/lib/hbase/hbase-0.98.0-hadoop1/data/zookeeper/zookeeper_0/version-2 2014-04-02 20:10:56,705 INFO [main] server.NIOServerCnxnFactory: binding to port 0.0.0.0/0.0.0.0:54310 2014-04-02 20:10:56,718 INFO [main] persistence.FileTxnSnapLog: Snapshotting: 0x0 to /usr/lib/hbase/hbase-0.98.0-hadoop1/data/zookeeper/zookeeper_0/version-2/sn= apshot.0 On Wed, Apr 2, 2014 at 1:46 PM, Jeffrey Zhong wrote= : > > The zookeeper error should be a warning. If you already have a Hbase > table, you should follow > http://phoenix.incubator.apache.org/faq.html#How_I_map_Phoenix_table_to_a= n_existing_HBase_table to > re-create it in Phoenix. > > You can test if your env is good by either using ./sqlline to create a > table or ruing "./psql.py oak.local ../examples/WEB_STAT.sql > ../examples/WEB_STAT.csv ../examples/WEB_STAT_QUERIES.sql" to see if your > env can create WEB_STAT table, load data into it and query data from the > WEB_STAT table. > > > From: Kleiton Silva > Reply-To: > Date: Wednesday, April 2, 2014 1:10 PM > > To: > Subject: Re: Help to Connect via SQuirrel > > Hey Jeffrey, > > Now i face another error, i couldn't connect because it receive connectio= n > refuse, as shown below. > > My Hbase is ok, this is my hbase-site.xml (HBASE/conf): > > > > hbase.rootdir > hdfs://oak:54310/data/hbase > > > hbase.zookeeper.property.dataDir > /usr/lib/hbase/hbase-0.98.0-hadoop1/data/zookeeper > > > hbase.zookeeper.property.clientPort > 2181 > > > hbase.zookeeper.quorum > oak.local > > > > > My host file: > > 10.2.103.214 oak > 10.2.103.214 localhost > 10.2.103.214 oak.local > > > The error that i receive: > > 2014-04-02 17:03:27,034 [Thread-11-SendThread(oak:2811)] WARN > org.apache.zookeeper.ClientCnxn - Session 0x0 for server null, unexpect= ed > error, closing socket connection and attempting reconnect > java.net.ConnectException: Connection refused > at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method) > at sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:599) > at > org.apache.zookeeper.ClientCnxnSocketNIO.doTransport(ClientCnxnSocketNIO.= java:350) > at org.apache.zookeeper.ClientCnxn$SendThread.run(ClientCnxn.java:1068) > > > > > Doubt: > > My HBASE already have a table called 'test', this would be shown with the > !table command or not? > > Because i will use Phoenix with Sqoop to transfer data between from one > Hbase to another Hbase. > > Thank you. > > Kleiton > > > On Wed, Apr 2, 2014 at 10:48 AM, Jeffrey Zhong wr= ote: > >> >> Hey Kleiton, >> >> Just to make sure you are aware of that Phoenix 4.0 is supposed to >> running against Hbase 0.98.1. You need to create a table firstly in Phoe= nix >> in order to be seen from !table command from sqlline. >> >> Thanks, >> -Jeffrey >> >> From: Jeffrey Zhong >> Date: Wednesday, April 2, 2014 10:27 AM >> To: >> Subject: Re: Help to Connect via SQuirrel >> >> >> You can put the following configuration settings in hbase-site.xml under >> the bin folder and invoke the sqlline.py from bin folder OR you can set >> PHOENIX_LIB_DIR env variable such as export PHOENIX_LIB_DIR=3D> hbase-site.xml>: and then invoke sqlli= ne >> again. >> >> >> >> hbase.defaults.for.version.skip >> >> true >> >> >> >> >> From: Kleiton Silva >> Reply-To: >> Date: Wednesday, April 2, 2014 7:43 AM >> To: >> Subject: Help to Connect via SQuirrel >> >> I am trying to do the same configuration as in >> http://phoenix.incubator.apache.org/download.html#SQL-Client, to connect >> with Squirrel, but a receive the error bellow: >> >> *Environment*: >> >> HBASE: /usr/lib/hbase/hbase-0.98.0-hadoop1/bin >> PHOENIX: phoenix-4.0.0-incubating >> HADOOP: /usr/lib/hadoop/hadoop-1.2.1 >> >> HBase test(Commands): >> >> *OAK:bin eduardofilho$ ./hbase shell* >> HBase Shell; enter 'help' for list of supported commands. >> Type "exit" to leave the HBase Shell >> Version 0.98.0-hadoop1, r1565492, Thu Feb 6 16:20:15 PST 2014 >> >> *hbase(main):001:0> scan 'test'* >> SLF4J: Class path contains multiple SLF4J bindings. >> SLF4J: Found binding in >> [jar:file:/usr/lib/hbase/hbase-0.98.0-hadoop1/lib/slf4j-log4j12-1.6.4.ja= r!/org/slf4j/impl/StaticLoggerBinder.class] >> SLF4J: Found binding in >> [jar:file:/usr/lib/hadoop/hadoop-1.2.1/lib/slf4j-log4j12-1.4.3.jar!/org/= slf4j/impl/StaticLoggerBinder.class] >> SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an >> explanation. >> ROW COLUMN+CELL >> >> row1 column=3Dcf:a, timestamp=3D1396129288479, value=3D= value1 >> >> row2 column=3Dcf:b, timestamp=3D1396129295034, value=3D= value2 >> >> row3 column=3Dcf:c, timestamp=3D1396129303288, value=3D= value3 >> >> 3 row(s) in 0.1700 seconds >> >> *Phoenix Test(Commands)* >> >> OAK:bin eduardofilho$ ./sqlline.py oak.local >> Setting property: [isolation, TRANSACTION_READ_COMMITTED] >> issuing: !connect jdbc:phoenix:oak.local none none >> org.apache.phoenix.jdbc.PhoenixDriver >> Connecting to jdbc:phoenix:oak.local >> 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 >> sqlline version 1.1.2 >> 0: jdbc:phoenix:oak.local> !tables >> >> +------------+-------------+------------+------------+------------+-----= -------+ >> | TABLE_CAT | TABLE_SCHEM | TABLE_NAME | TABLE_TYPE | REMARKS | >> TYPE_NAME | >> >> +------------+-------------+------------+------------+------------+-----= -------+ >> | null | SYSTEM | CATALOG | SYSTEM TABLE | null | >> null | >> | null | SYSTEM | SEQUENCE | SYSTEM TABLE | null | >> null | >> >> +------------+-------------+------------+------------+------------+-----= -------+ >> 0: jdbc:phoenix:oak.local> >> >> >> This command not show my table 'test' >> >> *ERROR*: >> >> 2014-04-02 11:19:48,368 [Thread-8] ERROR >> net.sourceforge.squirrel_sql.client.gui.db.ConnectToAliasCallBack - >> Unexpected Error occured attempting to open an SQL connection. >> java.lang.RuntimeException: hbase-default.xml file seems to be for and >> old version of HBase (null), this version is 0.98.1-hadoop1 >> at >> org.apache.hadoop.hbase.HBaseConfiguration.checkDefaultsVersion(HBaseCon= figuration.java:70) >> at >> org.apache.hadoop.hbase.HBaseConfiguration.addHbaseResources(HBaseConfig= uration.java:102) >> at >> org.apache.hadoop.hbase.HBaseConfiguration.create(HBaseConfiguration.jav= a:113) >> at >> org.apache.phoenix.query.ConfigurationFactory$ConfigurationFactoryImpl.g= etConfiguration(ConfigurationFactory.java:41) >> at >> org.apache.phoenix.query.QueryServicesOptions.withDefaults(QueryServices= Options.java:146) >> at >> org.apache.phoenix.query.QueryServicesImpl.(QueryServicesImpl.java= :34) >> at >> org.apache.phoenix.jdbc.PhoenixDriver.getQueryServices(PhoenixDriver.jav= a:96) >> at >> org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(Phoenix= Driver.java:114) >> at >> org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDri= ver.java:112) >> at >> net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDr= iverManager.java:133) >> at >> net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionComma= nd.execute(OpenConnectionCommand.java:97) >> at >> net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasComma= nd$SheetHandler.run(ConnectToAliasCommand.java:280) >> at >> net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:= 82) >> at java.lang.Thread.run(Thread.java:695) >> >> >> >> I Would appreciate if someone could me help. >> >> Thanks. >> >> Kleiton >> >> >> >> CONFIDENTIALITY NOTICE >> NOTICE: This message is intended for the use of the individual or entity >> to which it is addressed and may contain information that is confidentia= l, >> privileged and exempt from disclosure under applicable law. If the reade= r >> of this message is not the intended recipient, you are hereby notified t= hat >> any printing, copying, dissemination, distribution, disclosure or >> forwarding of this communication is strictly prohibited. If you have >> received this communication in error, please contact the sender immediat= ely >> and delete it from your system. Thank You. >> > > > CONFIDENTIALITY NOTICE > NOTICE: This message is intended for the use of the individual or entity > to which it is addressed and may contain information that is confidential= , > privileged and exempt from disclosure under applicable law. If the reader > of this message is not the intended recipient, you are hereby notified th= at > any printing, copying, dissemination, distribution, disclosure or > forwarding of this communication is strictly prohibited. If you have > received this communication in error, please contact the sender immediate= ly > and delete it from your system. Thank You. > --bcaec52c68616fcf0604f617a0ce Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
Ok Jeffrey i will read the link, but i still receive the f= ollow error, do you have any ideal?

2014-04-02 20:2= 2:45,119 [Thread-10-SendThread(oak:2181)] INFO =A0org.apache.zookeeper.Clie= ntCnxn =A0- Opening socket connection to server oak/127.0.0.1:2181. Will not attempt to authenticate using SASL = (java.lang.SecurityException: Unable to locate a login configuration)
2014-04-02 20:22:45,119 [Thread-10-SendThread(oak:2181)] WARN =A0org.a= pache.zookeeper.ClientCnxn =A0- Session 0x0 for server null, unexpected err= or, closing socket connection and attempting reconnect
java.net.C= onnectException: Connection refused
at sun.nio.ch.Socke= tChannelImpl.checkConnect(Native Method)
at sun.nio.ch.SocketChannelImpl.finishConnect(= SocketChannelImpl.java:599)
at org.apache.zooke= eper.ClientCnxnSocketNIO.doTransport(ClientCnxnSocketNIO.java:361)
at org.apache.zookeepe= r.ClientCnxn$SendThread.run(ClientCnxn.java:1081)
2014-04-02 20:22:45,148 [Thread-10-SendThread(oak:2181)] INFO =A0org.a= pache.zookeeper.ClientCnxn =A0- Opening socket connection to server oak/127.0.0.1:2181. Will not attempt to auth= enticate using SASL (java.lang.SecurityException: Unable to locate a login = configuration)
2014-04-02 20:22:45,149 [Thread-10-SendThread(oak:2181)] WARN =A0org.a= pache.zookeeper.ClientCnxn =A0- Session 0x0 for server null, unexpected err= or, closing socket connection and attempting reconnect
java.net.C= onnectException: Connection refused
at sun.nio.ch.Socke= tChannelImpl.checkConnect(Native Method)
at sun.nio.ch.SocketChannelImpl.finishConnect(= SocketChannelImpl.java:599)
at org.apache.zooke= eper.ClientCnxnSocketNIO.doTransport(ClientCnxnSocketNIO.java:361)
at org.apache.zookeepe= r.ClientCnxn$SendThread.run(ClientCnxn.java:1081)


My host file is:
=
127.0.0.1 =A0 =A0 =A0 localhost
127.0.0.1 =A0= =A0 =A0 oak
127.0.0.1 =A0 =A0 =A0 oak.local

=

Any ideal?

My hbase log:

Qua =A02 Abr 2014 20:10:55 PDT Starting master on OA= K.local
core file size =A0 =A0 =A0 =A0 =A0(blocks, -c) 0
data seg size =A0 =A0 =A0 =A0 =A0 (kbytes, -d) unlimited
file size =A0 =A0 =A0 =A0 =A0 =A0 =A0 (blocks, -f) unlimited
max locked memory =A0 =A0 =A0 (kbytes, -l) unlimited
max memory = size =A0 =A0 =A0 =A0 (kbytes, -m) unlimited
open files =A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0(-n) 256
pipe size =A0 =A0 =A0 =A0 =A0 =A0(512 bytes, -p) 1
stack siz= e =A0 =A0 =A0 =A0 =A0 =A0 =A0(kbytes, -s) 8192
cpu time =A0 =A0 = =A0 =A0 =A0 =A0 =A0 (seconds, -t) unlimited
max user processes = =A0 =A0 =A0 =A0 =A0 =A0 =A0(-u) 266
virtual memory =A0 =A0 =A0 = =A0 =A0(kbytes, -v) unlimited
2014-04-02 20:10:56,131 INFO =A0[main] util.VersionInfo: HBase 0.98.0-= hadoop1
2014-04-02 20:10:56,132 INFO =A0[main] util.VersionInfo: = Subversion https://svn.apache.org/repos/asf/hbase/tags/0.98.0RC2 -r 1565492
2014-04-02 20:10:56,132 INFO =A0[main] util.VersionInfo: Compiled by a= purtell on Thu Feb =A06 16:20:15 PST 2014
2014-04-02 20:10:56,620= INFO =A0[main] server.ZooKeeperServer: Server environment:zookeeper.versio= n=3D3.4.5--1, built on 10/05/2013 16:05 GMT
2014-04-02 20:10:56,620 INFO =A0[main] server.ZooKeeperServer: Server = environment:host.name=3Doak
2014= -04-02 20:10:56,620 INFO =A0[main] server.ZooKeeperServer: Server environme= nt:java.version=3D1.6.0_65
2014-04-02 20:10:56,620 INFO =A0[main] server.ZooKeeperServer: Server = environment:java.vendor=3DApple Inc.
2014-04-02 20:10:56,620 INFO= =A0[main] server.ZooKeeperServer: Server environment:java.home=3D/System/L= ibrary/Java/JavaVirtualMachines/1.6.0.jdk/Contents/Home
2014-04-02 20:10:56,621 INFO =A0[main] server.ZooKeeperServer: Server = environment:java.class.path=3D/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../co= nf:/Library/Java/Home/lib/tools.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin= /..:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/activation-1.1.jar:/usr/= lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/asm-3.1.jar:/usr/lib/hbase/hbase-= 0.98.0-hadoop1/bin/../lib/commons-beanutils-1.7.0.jar:/usr/lib/hbase/hbase-= 0.98.0-hadoop1/bin/../lib/commons-beanutils-core-1.8.0.jar:/usr/lib/hbase/h= base-0.98.0-hadoop1/bin/../lib/commons-cli-1.2.jar:/usr/lib/hbase/hbase-0.9= 8.0-hadoop1/bin/../lib/commons-codec-1.7.jar:/usr/lib/hbase/hbase-0.98.0-ha= doop1/bin/../lib/commons-collections-3.2.1.jar:/usr/lib/hbase/hbase-0.98.0-= hadoop1/bin/../lib/commons-configuration-1.6.jar:/usr/lib/hbase/hbase-0.98.= 0-hadoop1/bin/../lib/commons-digester-1.8.jar:/usr/lib/hbase/hbase-0.98.0-h= adoop1/bin/../lib/commons-el-1.0.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bi= n/../lib/commons-httpclient-3.1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin= /../lib/commons-io-2.4.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/c= ommons-lang-2.6.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/commons-= logging-1.1.1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/commons-ma= th-2.2.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/commons-net-1.4.1= .jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/core-3.1.1.jar:/usr/lib= /hbase/hbase-0.98.0-hadoop1/bin/../lib/findbugs-annotations-1.3.9-1.jar:/us= r/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/guava-12.0.1.jar:/usr/lib/hbase= /hbase-0.98.0-hadoop1/bin/../lib/hadoop-core-1.2.1.jar:/usr/lib/hbase/hbase= -0.98.0-hadoop1/bin/../lib/hamcrest-core-1.3.jar:/usr/lib/hbase/hbase-0.98.= 0-hadoop1/bin/../lib/hbase-client-0.98.0-hadoop1.jar:/usr/lib/hbase/hbase-0= .98.0-hadoop1/bin/../lib/hbase-common-0.98.0-hadoop1-tests.jar:/usr/lib/hba= se/hbase-0.98.0-hadoop1/bin/../lib/hbase-common-0.98.0-hadoop1.jar:/usr/lib= /hbase/hbase-0.98.0-hadoop1/bin/../lib/hbase-examples-0.98.0-hadoop1.jar:/u= sr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/hbase-hadoop-compat-0.98.0-had= oop1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/hbase-hadoop1-compa= t-0.98.0-hadoop1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/hbase-i= t-0.98.0-hadoop1-tests.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/h= base-it-0.98.0-hadoop1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/h= base-prefix-tree-0.98.0-hadoop1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin= /../lib/hbase-protocol-0.98.0-hadoop1.jar:/usr/lib/hbase/hbase-0.98.0-hadoo= p1/bin/../lib/hbase-server-0.98.0-hadoop1-tests.jar:/usr/lib/hbase/hbase-0.= 98.0-hadoop1/bin/../lib/hbase-server-0.98.0-hadoop1.jar:/usr/lib/hbase/hbas= e-0.98.0-hadoop1/bin/../lib/hbase-shell-0.98.0-hadoop1.jar:/usr/lib/hbase/h= base-0.98.0-hadoop1/bin/../lib/hbase-testing-util-0.98.0-hadoop1.jar:/usr/l= ib/hbase/hbase-0.98.0-hadoop1/bin/../lib/hbase-thrift-0.98.0-hadoop1.jar:/u= sr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/high-scale-lib-1.1.1.jar:/usr/= lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/htrace-core-2.04.jar:/usr/lib/hba= se/hbase-0.98.0-hadoop1/bin/../lib/httpclient-4.1.3.jar:/usr/lib/hbase/hbas= e-0.98.0-hadoop1/bin/../lib/httpcore-4.1.3.jar:/usr/lib/hbase/hbase-0.98.0-= hadoop1/bin/../lib/jackson-core-asl-1.8.8.jar:/usr/lib/hbase/hbase-0.98.0-h= adoop1/bin/../lib/jackson-jaxrs-1.8.8.jar:/usr/lib/hbase/hbase-0.98.0-hadoo= p1/bin/../lib/jackson-mapper-asl-1.8.8.jar:/usr/lib/hbase/hbase-0.98.0-hado= op1/bin/../lib/jackson-xc-1.8.8.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin= /../lib/jamon-runtime-2.3.1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../= lib/jasper-compiler-5.5.23.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../l= ib/jasper-runtime-5.5.23.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib= /jaxb-api-2.2.2.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/jaxb-imp= l-2.2.3-1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/jersey-core-1.= 8.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/jersey-json-1.8.jar:/u= sr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/jersey-server-1.8.jar:/usr/lib= /hbase/hbase-0.98.0-hadoop1/bin/../lib/jettison-1.3.1.jar:/usr/lib/hbase/hb= ase-0.98.0-hadoop1/bin/../lib/jetty-6.1.26.jar:/usr/lib/hbase/hbase-0.98.0-= hadoop1/bin/../lib/jetty-sslengine-6.1.26.jar:/usr/lib/hbase/hbase-0.98.0-h= adoop1/bin/../lib/jetty-util-6.1.26.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1= /bin/../lib/jruby-complete-1.6.8.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bi= n/../lib/jsp-2.1-6.1.14.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/= jsp-api-2.1-6.1.14.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/jsr30= 5-1.3.9.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/junit-4.11.jar:/= usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/libthrift-0.9.0.jar:/usr/lib/= hbase/hbase-0.98.0-hadoop1/bin/../lib/log4j-1.2.17.jar:/usr/lib/hbase/hbase= -0.98.0-hadoop1/bin/../lib/metrics-core-2.1.2.jar:/usr/lib/hbase/hbase-0.98= .0-hadoop1/bin/../lib/netty-3.6.6.Final.jar:/usr/lib/hbase/hbase-0.98.0-had= oop1/bin/../lib/phoenix-core-4.0.0-incubating.jar:/usr/lib/hbase/hbase-0.98= .0-hadoop1/bin/../lib/protobuf-java-2.5.0.jar:/usr/lib/hbase/hbase-0.98.0-h= adoop1/bin/../lib/servlet-api-2.5-6.1.14.jar:/usr/lib/hbase/hbase-0.98.0-ha= doop1/bin/../lib/slf4j-api-1.6.4.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bi= n/../lib/slf4j-log4j12-1.6.4.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/..= /lib/stax-api-1.0.1.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/xmle= nc-0.52.jar:/usr/lib/hbase/hbase-0.98.0-hadoop1/bin/../lib/zookeeper-3.4.5.= jar:
2014-04-02 20:10:56,622 INFO =A0[main] server.ZooKeeperServer: Server = environment:java.library.path=3D.:/Library/Java/Extensions:/System/Library/= Java/Extensions:/usr/lib/java
2014-04-02 20:10:56,622 INFO =A0[ma= in] server.ZooKeeperServer: Server environment:java.io.tmpdir=3D/var/folder= s/zz/zzzivhrRnAmviuee+++++++++++/-Tmp-/
2014-04-02 20:10:56,623 INFO =A0[main] server.ZooKeeperServer: Server = environment:java.compiler=3D<NA>
2014-04-02 20:10:56,623 IN= FO =A0[main] server.ZooKeeperServer: Server environment:os.name=3DMac OS X
2014-04-02 20:10:56,623 INFO =A0[main] server.ZooKeeperServer: Server = environment:os.arch=3Dx86_64
2014-04-02 20:10:56,623 INFO =A0[mai= n] server.ZooKeeperServer: Server environment:os.version=3D10.6.8
2014-04-02 20:10:56,623 INFO =A0[main] server.ZooKeeperServer: Server envi= ronment:user.name=3Droot
2014-04-02 20:10:56,623 INFO =A0[main] server.ZooKeeperServer: Server = environment:user.home=3D/Users/eduardofilho
2014-04-02 20:10:56,6= 23 INFO =A0[main] server.ZooKeeperServer: Server environment:user.dir=3D/us= r/lib/hbase/hbase-0.98.0-hadoop1/bin
2014-04-02 20:10:56,668 INFO =A0[main] server.ZooKeeperServer: Created= server with tickTime 2000 minSessionTimeout 4000 maxSessionTimeout 40000 d= atadir /usr/lib/hbase/hbase-0.98.0-hadoop1/data/zookeeper/zookeeper_0/versi= on-2 snapdir /usr/lib/hbase/hbase-0.98.0-hadoop1/data/zookeeper/zookeeper_0= /version-2
2014-04-02 20:10:56,705 INFO =A0[main] server.NIOServerCnxnFactory: bi= nding to port 0.0.0.0/0.0.0.0:5431= 0
2014-04-02 20:10:56,718 INFO =A0[main] persistence.FileTxnS= napLog: Snapshotting: 0x0 to /usr/lib/hbase/hbase-0.98.0-hadoop1/data/zooke= eper/zookeeper_0/version-2/snapshot.0



On Wed, Apr 2, 2014 at 1:46 PM, Jeffrey Zhong <jzhong@h= ortonworks.com> wrote:

The zookeeper err= or should be a warning. If you already have a Hbase table, you should follo= w=A0http://phoenix.incub= ator.apache.org/faq.html#How_I_map_Phoenix_table_to_an_existing_HBase_table= =A0to re-create it in Phoenix.=A0

You can test if your env is good by either using ./sqll= ine to create a table or ruing "./psql.py=A0oak.local=A0../examples/WE= B_STAT.sql ../examples/WEB_STAT.csv ../examples/WEB_STAT_QUERIES.sql" = to see if your env can create WEB_STAT table, load data into it and query d= ata from the WEB_STAT table.


From: Kleiton Silv= a <kleito= n.contato@gmail.com>
Reply-To: <= /span> <user@phoenix.incubator.apache.org>
Date: Wednesday, April 2, 20= 14 1:10 PM

To: <= /span> <user@phoenix.incubator.apache.org>
Subject: Re: Help to Connect via S= Quirrel

Hey Jeffrey,=A0

Now i face another error, i cou= ldn't connect because it receive connection refuse, as shown below.

My Hbase is ok, this is my hbase-site.xml (HBASE/conf):=

<configuration>
=A0 <prop= erty>
=A0 =A0 <name>hbase.rootdir</name>
=A0 =A0 <value>hdfs://oak:54310/data/hbase</value>
=A0 </property>
=A0 <property>
=A0 =A0= <name>hbase.zookeeper.property.dataDir</name>
=A0 = =A0 <value>/usr/lib/hbase/hbase-0.98.0-hadoop1/data/zookeeper</val= ue>
=A0 </property>
=A0 <property>
=A0 =A0= <name>hbase.zookeeper.property.clientPort</name>
=A0= =A0 <value>2181</value>
=A0 </property>
<= div>=A0 <property>
=A0 =A0 <name>hbase.zookeeper.quorum</name>
=A0 = =A0 <value>oak.local</value>
=A0</property>
</configuration>


My host file:

10.2.103.214 =A0 =A0oak
10.2.103.214 =A0= =A0localhost
10.2.103.214 =A0 =A0oak.local

<= /div>

The error that i receive:

2014-04-02 17:03:27,034 [Thread-11-SendThread(oak:2811)] WARN =A0org.= apache.zookeeper.ClientCnxn =A0- Session 0x0 for server null, unexpected er= ror, closing socket connection and attempting reconnect
java.net.ConnectException: Connection refused
at sun.nio.ch.SocketChannelImpl.checkConnect= (Native Method)
at s= un.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:599)
at org.apache.zookeeper.C= lientCnxnSocketNIO.doTransport(ClientCnxnSocketNIO.java:350)
at org.apache.zookeeper.ClientCnxn= $SendThread.run(ClientCnxn.java:1068)




Doubt:=A0

My HBASE already have a table called &#= 39;test', this would be shown with the !table =A0command or not?
<= div>
Because i will use Phoenix with Sqoop to transfer data betwe= en from one Hbase to another Hbase.

Thank you.

Kleiton


On Wed, Apr 2, 2014 at 10:48 AM, Jeffrey= Zhong <jzhong@hortonworks.com> wrote:

Hey=A0Kleiton,

Just to = make sure you are aware of that Phoenix 4.0 is supposed to running against = Hbase 0.98.1. You need to create a table firstly in Phoenix in order to be = seen from !table command from sqlline.

Thanks,
-Jeffrey

From: Jeffrey Zhong <jzhong@hortonworks.com>
Date: Wednesday, April 2,= 2014 10:27 AM
To: <user@phoenix.incubator.apache.= org>
Subject: Re: Help t= o Connect via SQuirrel


You can put = the following configuration settings in hbase-site.xml under the bin folder= and invoke the sqlline.py from bin folder OR you can set PHOENIX_LIB_DIR e= nv variable such as =A0export=A0PHOENIX_LIB_DIR=3D<path to the hbase-sit= e.xml>:<path to your phoenix home folder> and then invoke sqlline = again.

=A0=A0<property>

=A0=A0 =A0 =A0 <name>hbase.defaults.for.version.ski= p</name>

=A0 =A0 =A0 = =A0 <value>true</value>

=A0 </property>



From: Kleiton Silva <kleiton.contato@gmail.= com>
Reply-To: <user@phoe= nix.incubator.apache.org>
Date: Wednesday, April 2, 2014 7:4= 3 AM
To: <user@phoenix.incubator= .apache.org>
Subject: Help to Connect via SQuir= rel

I am trying to do the same con= figuration as in=A0http://phoenix.incubator.apache.org/down= load.html#SQL-Client, to connect with Squirrel, but a receive the error= bellow:

Environment:

HBASE:=A0/usr/l= ib/hbase/hbase-0.98.0-hadoop1/bin
PHOENIX:=A0phoenix-4.0.0-incuba= ting
HADOOP:=A0/usr/lib/hadoop/hadoop-1.2.1

<= div> HBase test(Commands):=A0

OAK:bin eduardofi= lho$ ./hbase shell
HBase Shell; enter 'help<RETURN>= ' for list of supported commands.
Type "exit<RETURN&g= t;" to leave the HBase Shell
Version 0.98.0-hadoop1, r1565492, Thu Feb =A06 16:20:15 PST 2014
=

hbase(main):001:0> scan 'test'
<= div>SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Fo= und binding in [jar:file:/usr/lib/hbase/hbase-0.98.0-hadoop1/lib/slf4j-log4= j12-1.6.4.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/usr/lib/hadoop/hadoop-1.2.1/lib/slf= 4j-log4j12-1.4.3.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SL= F4J: See http://www.slf4j.org/codes.html#multiple_bindings for an = explanation.
ROW =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 COLUMN+CELL =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0= =A0
=A0row1 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 column=3Dcf:a, timest= amp=3D1396129288479, value=3Dvalue1 =A0 =A0 =A0 =A0
=A0row2 =A0 = =A0 =A0 =A0 =A0 =A0 =A0 =A0 column=3Dcf:b, timestamp=3D1396129295034, value= =3Dvalue2 =A0 =A0 =A0 =A0
=A0row3 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 column=3Dcf:c, timestamp=3D139= 6129303288, value=3Dvalue3 =A0 =A0 =A0 =A0
3 row(s) in 0.1700 sec= onds

Phoenix Test(Commands)

OAK:bin eduardofilho$ ./sqlline.py oak.local
Setting property: [isolation, TRANSACTION_READ_COMMITTED]
is= suing: !connect jdbc:phoenix:oak.local none none org.apache.phoenix.jdbc.Ph= oenixDriver
Connecting to jdbc:phoenix:oak.local
Connec= ted to: Phoenix (version 4.0)
Driver: org.apache.phoenix.jdbc.PhoenixDriver (version 4.0)
= Autocommit status: true
Transaction isolation: TRANSACTION_READ_C= OMMITTED
Building list of tables and columns for tab-completion (= set fastconnect to true to skip)...
53/53 (100%) Done
Done
sqlline version 1.1.2
=
0: jdbc:phoenix:oak.local> !tables
+------------+--------= -----+------------+------------+------------+------------+
| TABL= E_CAT =A0| TABLE_SCHEM | TABLE_NAME | TABLE_TYPE | =A0REMARKS =A0 | TYPE_NA= ME =A0|
+------------+-------------+------------+------------+------------+---= ---------+
| null =A0 =A0 =A0 | SYSTEM =A0 =A0 =A0| CATALOG =A0 = =A0| SYSTEM TABLE | null =A0 =A0 =A0 | null =A0 =A0 |
| null =A0 = =A0 =A0 | SYSTEM =A0 =A0 =A0| SEQUENCE =A0 | SYSTEM TABLE | null =A0 =A0 = =A0 | null =A0 =A0 |
+------------+-------------+------------+------------+------------+---= ---------+
0: jdbc:phoenix:oak.local>=A0

<= /div>

This command not show my table 'test'

ERROR:

2014-04-02 11= :19:48,368 [Thread-8] ERROR net.sourceforge.squirrel_sql.client.gui.db.Conn= ectToAliasCallBack =A0- Unexpected Error occured attempting to open an SQL = connection.
java.lang.RuntimeException: hbase-default.xml file seems to be for and= old version of HBase (null), this version is 0.98.1-hadoop1
at org.apache.hadoop.hbase.HBaseCo= nfiguration.checkDefaultsVersion(HBaseConfiguration.java:70)
at org.apache.hadoop.hbas= e.HBaseConfiguration.addHbaseResources(HBaseConfiguration.java:102)
at org.apache.hadoop.hbase.= HBaseConfiguration.create(HBaseConfiguration.java:113)
at org.apache.phoenix.que= ry.ConfigurationFactory$ConfigurationFactoryImpl.getConfiguration(Configura= tionFactory.java:41)
at org.apache.phoenix.query.QueryServicesOptions.withDefaults(QueryService= sOptions.java:146)
at org.apache.phoenix.que= ry.QueryServicesImpl.<init>(QueryServicesImpl.java:34)
at org.apache.phoenix.jdbc.Phoenix= Driver.getQueryServices(PhoenixDriver.java:96)
at org.apache.phoenix.jdb= c.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:114)
at org.apache.phoenix.jdbc.P= hoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:112)
at net.sourceforge.squirr= el_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)
at net.sourceforge.squi= rrel_sql.client.mainframe.action.OpenConnectionCommand.execute(OpenConnecti= onCommand.java:97)
at net.sourceforge.squirr= el_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.run(Conne= ctToAliasCommand.java:280)
= at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecute= r.java:82)
at java.lang.Thread.run(T= hread.java:695)



I Wo= uld appreciate if someone could me help.

Thanks.

Kleiton


=

CON= FIDENTIALITY NOTICE
NOTICE: This message is intended for the use of the individual or e= ntity to which it is addressed and may contain information that is confiden= tial, privileged and exempt from disclosure under applicable law. If the re= ader of this message is not the intended recipient, you are hereby notified= that any printing, copying, dissemination, distribution, disclosure or for= warding of this communication is strictly prohibited. If you have received = this communication in error, please contact the sender immediately and dele= te it from your system. Thank You.


CONFIDENTIALITY NOTICE
NOTICE: This message is = intended for the use of the individual or entity to which it is addressed a= nd may contain information that is confidential, privileged and exempt from= disclosure under applicable law. If the reader of this message is not the = intended recipient, you are hereby notified that any printing, copying, dis= semination, distribution, disclosure or forwarding of this communication is= strictly prohibited. If you have received this communication in error, ple= ase contact the sender immediately and delete it from your system. Thank Yo= u.

--bcaec52c68616fcf0604f617a0ce--