[
https://issues.apache.org/jira/browse/PHOENIX-2799?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Taylor resolved PHOENIX-2799.
-----------------------------------
Resolution: Not A Problem
Looking at the documentation, this *is* how it's documented:
http://phoenix.apache.org/language/index.html#aliased_table_ref
> dynamic column can not be used with "AS" alias in join
> ------------------------------------------------------
>
> Key: PHOENIX-2799
> URL: https://issues.apache.org/jira/browse/PHOENIX-2799
> Project: Phoenix
> Issue Type: Bug
> Reporter: Powpow Shen
>
> Join can be performed on dynamic columns, ex:
> Say we have 2 tables created like this
> {quote}
> create table test1 ( id integer not null primary key, field1 varchar, field2
> varchar);
> create table test2 ( id integer not null primary key, field1 varchar, field2
> varchar);
> {quote}
> Join 2 tables on dynamic colums can be done like this:
> {quote}
> select test1.id from test1(dynamic varchar) join test2(dynamic varchar) on
> test1.dynamic = test2.dynamic;
> {quote}
> But syntax errors occur when alias is given to table name:
> {quote}
> select L.id from test1(dynamic varchar) as L join test2(dynamic varchar) as
> R on L.dynamic = R.dynamic;
> Error: ERROR 602 (42P00): Syntax error. Missing "EOF" at line 1, column 41.
> (state=42P00,code=602)
> {quote}
> And in some cases, alias is required. for example: self join:
> {quote}
> select L.id from test1 as L join test1 as R on L.field1 = R.field2;
> {quote}
> works
> {quote}
> select L.id from test1(dynamic varchar) as L join test1(dynamic varchar) as R
> on L.dynamic = R.dynamic;
> {quote}
> doesn't work
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
