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<RETURN>' for list of supported commands.
Type "exit<RETURN>" 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.jar!/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]
ROW COLUMN+CELL
row1 column=cf:a, timestamp=1396129288479, value=value1
row2 column=cf:b, timestamp=1396129295034, value=value2
row3 column=cf:c, timestamp=1396129303288, value=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(HBaseConfiguration.java:70)
at org.apache.hadoop.hbase.HBaseConfiguration.addHbaseResources(HBaseConfiguration.java:102)
at org.apache.hadoop.hbase.HBaseConfiguration.create(HBaseConfiguration.java:113)
at org.apache.phoenix.query.ConfigurationFactory$ConfigurationFactoryImpl.getConfiguration(ConfigurationFactory.java:41)
at org.apache.phoenix.query.QueryServicesOptions.withDefaults(QueryServicesOptions.java:146)
at org.apache.phoenix.query.QueryServicesImpl.<init>(QueryServicesImpl.java:34)
at org.apache.phoenix.jdbc.PhoenixDriver.getQueryServices(PhoenixDriver.java:96)
at org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:114)
at org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:112)
at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.execute(OpenConnectionCommand.java:97)
at net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$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