try adding phoenix 3.0 jars to $HBASE_HOME/lib path, restart hbase and create tables via incubator-phoenix/bin/sqlline.py


On Tue, Mar 18, 2014 at 3:11 PM, Firas Khasawneh <Firas.Khasawneh@sas.com> wrote:

Thanks Alex.

 

Will this also fix the problem with visibility in HBase?

 

Regards,

Firas

 

From: alex kamil [mailto:alex.kamil@gmail.com]
Sent: Tuesday, March 18, 2014 3:07 PM


To: user@phoenix.incubator.apache.org
Subject: Re: tables are not showing in HBase & joins are not working

 

Firas, 

I believe join support was added in phoenix 3.0.0 (pending release)

 

try 

cd incubator-phoenix

mvn -DskipTests=true package

replace phoenix 2.2.3 jars in $HBASE_HOME/lib  with phoenix 3.0 jars

cp phoenix-core/target/phoenix-core-3.0.0-SNAPSHOT.jar $HBASE_HOME/lib/

 

 

 

 

 

 

 

On Tue, Mar 18, 2014 at 2:44 PM, Firas Khasawneh <Firas.Khasawneh@sas.com> wrote:

Hi Alex,

 

Phoenix 2.2.3

 

HBase 0.94.12 (Bigtop 0.7.0)

 

I am able to create tables, scan, etc in HBase

 

I am not getting any errors in hbase logs. Below are the create tables statements:

 

create table address(pid BIGINT not null primary key, personaddress varchar(100));

create table person(pid BIGINT not null primary key, firstname varchar(100), lastname varchar(100));

 

I am getting the following error when I run the query below:

 

select a.firstname, a.lastname, b.personaddress from person AS a INNER JOIN address AS b ON a.pid = b.pid

 

 

Error:

 

Error: ERROR 602 (42P00): Syntax error. Missing "EOF" at line 1, column 66. (state=42P00,code=602)

 

 

From: alex kamil [mailto:alex.kamil@gmail.com]
Sent: Tuesday, March 18, 2014 2:36 PM
To: user@phoenix.incubator.apache.org
Subject: Re: tables are not showing in HBase & joins are not working

 

Firas, this is strange, 

do you see errors in hbase logs? 

what hbase and phoenix versions are you using? 

if you create tables in hbase  directly (via hbase shell) do you see them?

are there any special characters, quotes in table names?

 

Alex

 

 

On Tue, Mar 18, 2014 at 12:51 PM, Firas Khasawneh <Firas.Khasawneh@sas.com> wrote:

Hi,

 

I downloaded and installed Phoenix. I able to connect to HBase and create tables but I am facing two issues:

  • I am not able to see the tables in HBase. When I run scan 'tablename', I get table does not exist
  • I am not able to query on two tables using equi inner joins

Any help is appreciated.

 

Regards,

Firas