phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: tables are not showing in HBase & joins are not working
Date Tue, 18 Mar 2014 20:08:45 GMT
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
<Firas.Khasawneh@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 <Firas.Khasawneh@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 <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
>
> 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 <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
>
>
>
>
>
>
>
>
>
>
>

Mime
View raw message