You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by alex kamil <al...@gmail.com> on 2014/03/18 19:35:59 UTC
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
<Fi...@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
>
>
>
RE: tables are not showing in HBase & joins are not working
Posted by Firas Khasawneh <Fi...@sas.com>.
Thanks Samarth!
From: Samarth Jain [mailto:samarth.jain@gmail.com]
Sent: Tuesday, March 18, 2014 3:04 PM
To: user@phoenix.incubator.apache.org
Subject: RE: tables are not showing in HBase & joins are not working
Hi Firas,
Support for joins in Phoenix is available starting 3.0.
-Samarth
On Mar 18, 2014 11:44 AM, "Firas Khasawneh" <Fi...@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<ma...@gmail.com>]
Sent: Tuesday, March 18, 2014 2:36 PM
To: user@phoenix.incubator.apache.org<ma...@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 <Fi...@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
RE: tables are not showing in HBase & joins are not working
Posted by Samarth Jain <sa...@gmail.com>.
Hi Firas,
Support for joins in Phoenix is available starting 3.0.
-Samarth
On Mar 18, 2014 11:44 AM, "Firas Khasawneh" <Fi...@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 <Fi...@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
>
>
>
>
>
RE: tables are not showing in HBase & joins are not working
Posted by Firas Khasawneh <Fi...@sas.com>.
Hi Alex,
The join worked like a charm! Thanks!
I am still not able to see the tables in HBase though. Below is the error I am getting when I try to scan one of these tables:
hbase(main):001:0> scan 'person'
ROW COLUMN+CELL
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/usr/lib/hadoop/lib/slf4j-log4j12-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/usr/lib/zookeeper/lib/slf4j-log4j12-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
ERROR: Unknown table person!
Thanks,
Firas
From: alex kamil [mailto:alex.kamil@gmail.com]
Sent: Tuesday, March 18, 2014 3:20 PM
To: user@phoenix.incubator.apache.org
Subject: Re: tables are not showing in HBase & joins are not working
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 <Fi...@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<ma...@gmail.com>]
Sent: Tuesday, March 18, 2014 3:07 PM
To: user@phoenix.incubator.apache.org<ma...@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
git clone -b 3.0 https://github.com/apache/incubator-phoenix.git
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 <Fi...@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<ma...@gmail.com>]
Sent: Tuesday, March 18, 2014 2:36 PM
To: user@phoenix.incubator.apache.org<ma...@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 <Fi...@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
Re: tables are not showing in HBase & joins are not working
Posted by James Taylor <ja...@apache.org>.
No, no map-reduce runs when any sql statements are executed. We have a bulk
csv loader that uses map-reduce.
Thanks,
James
On Tue, Mar 18, 2014 at 1:13 PM, Firas Khasawneh <Fi...@sas.com>wrote:
> Hi James,
>
>
>
> Makes sense. Thanks a lot for your help. Thanks also to Alex and Samarth
> for all the help. This is way better than Hive.
>
> One more question James, does Phoenix run map/reduce when running upsert
> or select? I think it does not since it is way faster to be running MR for
> simple queries.
>
>
>
> Regards,
>
> Firas
>
>
>
> *From:* James Taylor [mailto:jamestaylor@apache.org]
> *Sent:* Tuesday, March 18, 2014 4:09 PM
>
> *To:* user@phoenix.incubator.apache.org
> *Subject:* Re: tables are not showing in HBase & joins are not working
>
>
>
> Hi Firas,
>
> You only see it in Phoenix if you do a CREATE TABLE against an existing
> HBase table. We won't show you all HBase tables.
>
> Thanks,
>
> James
>
>
>
> On Tue, Mar 18, 2014 at 12:48 PM, Firas Khasawneh <Fi...@sas.com>
> wrote:
>
> Hi James,
>
>
>
> That was it for visibility (Phoenix -> Hbase). I did not create them with
> double quotes so they were all capital.
>
> Should I be able to see a table I created in HBase from Phoenix?
>
>
>
> Thanks,
> Firas
>
>
>
> *From:* James Taylor [mailto:jamestaylor@apache.org]
> *Sent:* Tuesday, March 18, 2014 3:44 PM
>
>
> *To:* user@phoenix.incubator.apache.org
> *Subject:* Re: tables are not showing in HBase & joins are not working
>
>
>
> Hi Firas,
>
> Table and column names are upper cased unless you put them in double
> quotes when you create them. Also, the table name will be the full table
> name: <schema name>.<table name> if you're using a schema name.
>
> Thanks,
> James
>
>
>
> On Tue, Mar 18, 2014 at 12:36 PM, Firas Khasawneh <Fi...@sas.com>
> wrote:
>
> Alex,
>
>
>
> I tried also the other way. I created table in hbase (create 'test','cf').
> When I try to access it from sqlline in phoenix, I get the following error:
>
>
>
> 0: jdbc:phoenix:localhost> select * from test;
>
> Error: ERROR 1012 (42M03): Table undefined. tableName=TEST
> (state=42M03,code=1012)
>
>
>
> Thanks,
>
> Firas
>
>
>
> *From:* alex kamil [mailto:alex.kamil@gmail.com]
> *Sent:* Tuesday, March 18, 2014 3:20 PM
>
>
> *To:* user@phoenix.incubator.apache.org
> *Subject:* Re: tables are not showing in HBase & joins are not working
>
>
>
> 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 <Fi...@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
>
> git clone -b 3.0 https://github.com/apache/incubator-phoenix.git
>
> 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 <Fi...@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 <Fi...@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
>
>
>
>
>
>
>
>
>
>
>
>
>
RE: tables are not showing in HBase & joins are not working
Posted by Firas Khasawneh <Fi...@sas.com>.
Hi James,
Makes sense. Thanks a lot for your help. Thanks also to Alex and Samarth for all the help. This is way better than Hive.
One more question James, does Phoenix run map/reduce when running upsert or select? I think it does not since it is way faster to be running MR for simple queries.
Regards,
Firas
From: James Taylor [mailto:jamestaylor@apache.org]
Sent: Tuesday, March 18, 2014 4:09 PM
To: user@phoenix.incubator.apache.org
Subject: Re: tables are not showing in HBase & joins are not working
Hi Firas,
You only see it in Phoenix if you do a CREATE TABLE against an existing HBase table. We won't show you all HBase tables.
Thanks,
James
On Tue, Mar 18, 2014 at 12:48 PM, Firas Khasawneh <Fi...@sas.com>> wrote:
Hi James,
That was it for visibility (Phoenix -> Hbase). I did not create them with double quotes so they were all capital.
Should I be able to see a table I created in HBase from Phoenix?
Thanks,
Firas
From: James Taylor [mailto:jamestaylor@apache.org<ma...@apache.org>]
Sent: Tuesday, March 18, 2014 3:44 PM
To: user@phoenix.incubator.apache.org<ma...@phoenix.incubator.apache.org>
Subject: Re: tables are not showing in HBase & joins are not working
Hi Firas,
Table and column names are upper cased unless you put them in double quotes when you create them. Also, the table name will be the full table name: <schema name>.<table name> if you're using a schema name.
Thanks,
James
On Tue, Mar 18, 2014 at 12:36 PM, Firas Khasawneh <Fi...@sas.com>> wrote:
Alex,
I tried also the other way. I created table in hbase (create 'test','cf'). When I try to access it from sqlline in phoenix, I get the following error:
0: jdbc:phoenix:localhost> select * from test;
Error: ERROR 1012 (42M03): Table undefined. tableName=TEST (state=42M03,code=1012)
Thanks,
Firas
From: alex kamil [mailto:alex.kamil@gmail.com<ma...@gmail.com>]
Sent: Tuesday, March 18, 2014 3:20 PM
To: user@phoenix.incubator.apache.org<ma...@phoenix.incubator.apache.org>
Subject: Re: tables are not showing in HBase & joins are not working
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 <Fi...@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<ma...@gmail.com>]
Sent: Tuesday, March 18, 2014 3:07 PM
To: user@phoenix.incubator.apache.org<ma...@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
git clone -b 3.0 https://github.com/apache/incubator-phoenix.git
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 <Fi...@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<ma...@gmail.com>]
Sent: Tuesday, March 18, 2014 2:36 PM
To: user@phoenix.incubator.apache.org<ma...@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 <Fi...@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
Re: tables are not showing in HBase & joins are not working
Posted by James Taylor <ja...@apache.org>.
Hi Firas,
You only see it in Phoenix if you do a CREATE TABLE against an existing
HBase table. We won't show you all HBase tables.
Thanks,
James
On Tue, Mar 18, 2014 at 12:48 PM, Firas Khasawneh
<Fi...@sas.com>wrote:
> Hi James,
>
>
>
> That was it for visibility (Phoenix -> Hbase). I did not create them with
> double quotes so they were all capital.
>
> Should I be able to see a table I created in HBase from Phoenix?
>
>
>
> Thanks,
> Firas
>
>
>
> *From:* James Taylor [mailto:jamestaylor@apache.org]
> *Sent:* Tuesday, March 18, 2014 3:44 PM
>
> *To:* user@phoenix.incubator.apache.org
> *Subject:* Re: tables are not showing in HBase & joins are not working
>
>
>
> Hi Firas,
>
> Table and column names are upper cased unless you put them in double
> quotes when you create them. Also, the table name will be the full table
> name: <schema name>.<table name> if you're using a schema name.
>
> Thanks,
> James
>
>
>
> On Tue, Mar 18, 2014 at 12:36 PM, Firas Khasawneh <Fi...@sas.com>
> wrote:
>
> Alex,
>
>
>
> I tried also the other way. I created table in hbase (create 'test','cf').
> When I try to access it from sqlline in phoenix, I get the following error:
>
>
>
> 0: jdbc:phoenix:localhost> select * from test;
>
> Error: ERROR 1012 (42M03): Table undefined. tableName=TEST
> (state=42M03,code=1012)
>
>
>
> Thanks,
>
> Firas
>
>
>
> *From:* alex kamil [mailto:alex.kamil@gmail.com]
> *Sent:* Tuesday, March 18, 2014 3:20 PM
>
>
> *To:* user@phoenix.incubator.apache.org
> *Subject:* Re: tables are not showing in HBase & joins are not working
>
>
>
> 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 <Fi...@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
>
> git clone -b 3.0 https://github.com/apache/incubator-phoenix.git
>
> 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 <Fi...@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 <Fi...@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
>
>
>
>
>
>
>
>
>
>
>
RE: tables are not showing in HBase & joins are not working
Posted by Firas Khasawneh <Fi...@sas.com>.
Hi James,
That was it for visibility (Phoenix -> Hbase). I did not create them with double quotes so they were all capital.
Should I be able to see a table I created in HBase from Phoenix?
Thanks,
Firas
From: James Taylor [mailto:jamestaylor@apache.org]
Sent: Tuesday, March 18, 2014 3:44 PM
To: user@phoenix.incubator.apache.org
Subject: Re: tables are not showing in HBase & joins are not working
Hi Firas,
Table and column names are upper cased unless you put them in double quotes when you create them. Also, the table name will be the full table name: <schema name>.<table name> if you're using a schema name.
Thanks,
James
On Tue, Mar 18, 2014 at 12:36 PM, Firas Khasawneh <Fi...@sas.com>> wrote:
Alex,
I tried also the other way. I created table in hbase (create 'test','cf'). When I try to access it from sqlline in phoenix, I get the following error:
0: jdbc:phoenix:localhost> select * from test;
Error: ERROR 1012 (42M03): Table undefined. tableName=TEST (state=42M03,code=1012)
Thanks,
Firas
From: alex kamil [mailto:alex.kamil@gmail.com<ma...@gmail.com>]
Sent: Tuesday, March 18, 2014 3:20 PM
To: user@phoenix.incubator.apache.org<ma...@phoenix.incubator.apache.org>
Subject: Re: tables are not showing in HBase & joins are not working
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 <Fi...@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<ma...@gmail.com>]
Sent: Tuesday, March 18, 2014 3:07 PM
To: user@phoenix.incubator.apache.org<ma...@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
git clone -b 3.0 https://github.com/apache/incubator-phoenix.git
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 <Fi...@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<ma...@gmail.com>]
Sent: Tuesday, March 18, 2014 2:36 PM
To: user@phoenix.incubator.apache.org<ma...@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 <Fi...@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
Re: tables are not showing in HBase & joins are not working
Posted by James Taylor <ja...@apache.org>.
Hi Firas,
Table and column names are upper cased unless you put them in double quotes
when you create them. Also, the table name will be the full table name:
<schema name>.<table name> if you're using a schema name.
Thanks,
James
On Tue, Mar 18, 2014 at 12:36 PM, Firas Khasawneh
<Fi...@sas.com>wrote:
> Alex,
>
>
>
> I tried also the other way. I created table in hbase (create 'test','cf').
> When I try to access it from sqlline in phoenix, I get the following error:
>
>
>
> 0: jdbc:phoenix:localhost> select * from test;
>
> Error: ERROR 1012 (42M03): Table undefined. tableName=TEST
> (state=42M03,code=1012)
>
>
>
> Thanks,
>
> Firas
>
>
>
> *From:* alex kamil [mailto:alex.kamil@gmail.com]
> *Sent:* Tuesday, March 18, 2014 3:20 PM
>
> *To:* user@phoenix.incubator.apache.org
> *Subject:* Re: tables are not showing in HBase & joins are not working
>
>
>
> 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 <Fi...@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
>
> git clone -b 3.0 https://github.com/apache/incubator-phoenix.git
>
> 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 <Fi...@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 <Fi...@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
>
>
>
>
>
>
>
>
>
RE: tables are not showing in HBase & joins are not working
Posted by Firas Khasawneh <Fi...@sas.com>.
Alex,
I tried also the other way. I created table in hbase (create 'test','cf'). When I try to access it from sqlline in phoenix, I get the following error:
0: jdbc:phoenix:localhost> select * from test;
Error: ERROR 1012 (42M03): Table undefined. tableName=TEST (state=42M03,code=1012)
Thanks,
Firas
From: alex kamil [mailto:alex.kamil@gmail.com]
Sent: Tuesday, March 18, 2014 3:20 PM
To: user@phoenix.incubator.apache.org
Subject: Re: tables are not showing in HBase & joins are not working
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 <Fi...@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<ma...@gmail.com>]
Sent: Tuesday, March 18, 2014 3:07 PM
To: user@phoenix.incubator.apache.org<ma...@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
git clone -b 3.0 https://github.com/apache/incubator-phoenix.git
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 <Fi...@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<ma...@gmail.com>]
Sent: Tuesday, March 18, 2014 2:36 PM
To: user@phoenix.incubator.apache.org<ma...@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 <Fi...@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
Re: tables are not showing in HBase & joins are not working
Posted by alex kamil <al...@gmail.com>.
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 <Fi...@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
>
> git clone -b 3.0 https://github.com/apache/incubator-phoenix.git
>
> 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 <Fi...@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 <Fi...@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
>
>
>
>
>
>
>
RE: tables are not showing in HBase & joins are not working
Posted by Firas Khasawneh <Fi...@sas.com>.
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
git clone -b 3.0 https://github.com/apache/incubator-phoenix.git
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 <Fi...@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<ma...@gmail.com>]
Sent: Tuesday, March 18, 2014 2:36 PM
To: user@phoenix.incubator.apache.org<ma...@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 <Fi...@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
Re: tables are not showing in HBase & joins are not working
Posted by alex kamil <al...@gmail.com>.
Firas,
I believe join support was added in phoenix 3.0.0 (pending release)
try
git clone -b 3.0 https://github.com/apache/incubator-phoenix.git
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 <Fi...@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 <Fi...@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
>
>
>
>
>
RE: tables are not showing in HBase & joins are not working
Posted by Firas Khasawneh <Fi...@sas.com>.
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 <Fi...@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