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 19:43:47 GMT
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