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