Stado

can‘t use left join command

Asked by tomas

when i use “left join” ，it report error as ：
etl_ods=> select a.col1, b.col1 from tab1 a left outer join tab2 b on a.col2 = b.col2;
ERROR: syntax error at or near ""tab2""
but ”inner join “ is all right:
etl_ods=> select a.col1, b.col1 from tab1 a inner join tab2 b on a.col2 = b.col2;
 col1 | col1
------+------
    1 | 1
    1 | 1
(2 rows)

what is wrong with my config file?

Question information

Language:
English Edit question
Status:
Solved
For:
Stado Edit question
Assignee:
No assignee Edit question
Solved by:
tomas
Solved:
Last query:
Last reply:
Revision history for this message
Alvin Peng (pengalvin) said : 		#1

Hi, you must be using Stado version 2.5.

The latest codes of Stado does not have such error.

You can try build from the latest codes of Stado and try again.

Here is the link:

http://bazaar.launchpad.net/~sgdg/stado/stado/tarball/109

Run "ant builddist" and you will get "stado_2.5.tar.gz" in the dist folder.

Revision history for this message
tomas (ts-zhangyang) said : 		#2

Thanks a lot,Alavin Peng,
I successfully installed the lastest code after following two steps:
1、install jdk 1.6 by "yum install java" in rhel 5.4,it failed to run ""ant builddist"" with jdk1.7
2、install xmlto by "yum install xmlto" else it will report errors
and then i could use "left join"