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 <[email protected]>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:[email protected]] > *Sent:* Tuesday, March 18, 2014 3:44 PM > > *To:* [email protected] > *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 <[email protected]> > 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:[email protected]] > *Sent:* Tuesday, March 18, 2014 3:20 PM > > > *To:* [email protected] > *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 <[email protected]> > wrote: > > Thanks Alex. > > > > Will this also fix the problem with visibility in HBase? > > > > Regards, > > Firas > > > > *From:* alex kamil [mailto:[email protected]] > *Sent:* Tuesday, March 18, 2014 3:07 PM > > > *To:* [email protected] > *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 <[email protected]> > 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:[email protected]] > *Sent:* Tuesday, March 18, 2014 2:36 PM > *To:* [email protected] > *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 <[email protected]> > 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 > > > > > > > > > > >
