cancel
Showing results for 
Search instead for 
Did you mean: 

Full Join in Calculation View

Former Member
0 Kudos

I'm trying to use *full* outer join in my Calcultion View based SQL Script. For code excerpt, please see below.

It passes validation and activation, but when executing, it gives the following error:

"Cannot iterate over result set rows: SAP DBTech JDBC: [259]: invalid table name:

[259]: invalid table name: _$_firsttable_2_$: line 1 col 1975 (at pos 1974) at

ptime/query/checker/check_id.cc:427"

It's rather strange, because in the SQL Editor, outside the calculation view, this full outer *works properly*

Additionally, when I use left outer instead of full, the calculation view works.

I'm well aware that I can replace the full join with union between two left joins.

Any ideas would be appreciated.

Thanks in advance

Code Excerpt:

firsttable = select ... (etc.)

secondtable = select ... (etc.)

var_out = select :firsttable.name as name, :secondtable.name as name2

from :firsttable full join :secondtable on :firsttable.name =  :secondtable.name

order by :firsttable.name;

Message was edited by: Tom Flanagan

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member182302
Active Contributor
0 Kudos

Hi Hayim,

I don't think full outer join is supported in any of the HANA models. And as you mentioned you may want to go with UNION.

Do have a look on the below:

Regards,

Krishna Tangudu