[ 
https://issues.apache.org/jira/browse/TAJO-1453?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14383240#comment-14383240
 ] 

Hyunsik Choi commented on TAJO-1453:
------------------------------------

Regarding compatibility policy, Tajo should support at least features of 
PostgreSQL for compatibility. What Tajo supports SQL features beyond PostgreSQL 
would be nice in my opinion.

I'm not sure what a single table with parentheses means. But, PostgreSQL also 
supports explicit join order. Please refer to 
http://www.postgresql.org/docs/8.2/static/explicit-joins.html.

> sql parse error occured with join query
> ---------------------------------------
>
>                 Key: TAJO-1453
>                 URL: https://issues.apache.org/jira/browse/TAJO-1453
>             Project: Tajo
>          Issue Type: Bug
>          Components: parser
>    Affects Versions: 0.10.0
>            Reporter: Jungryong Lee
>            Priority: Minor
>
> It is simple parse error.
> I am testing Tajo with BI solution, Birst.
> Birst usually generate join query like following:
> select table1.* from table1 inner join (table2) on (table1.id = table2.id);
> If "table2" has parenthesis, Tajo displays follwing error:
> ERROR: syntax error at or near 'table2'
> I didn't check ANSI SQL doesn't allow parenthesis in this case.
> But Almost databases I evaluated support this case.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to