Hi Stamatis,
Sorry for not replying earlier.
So when querying on views (and using order by) I am able to map expression
(`EXPR$1`) and original column name (`a`) using rowType (from converter).
```sql
create view as select _MAP['a'] as a, _MAP['b'] as b from elastic;
select * from view order by
Hi Andrei,
I have not played around with map types so I am not familiar with how it
works.
On the other hand, I am not sure I understand what names are missing in the
example you posted.
I suppose that instead of EXPR$1, EXPR$2, EXPR$3 you are expecting
something different.
Can you provide an
Hi Stamatis,
Thanks for your reply. It makes more sense now.
I have one more question though. Do you know what is recommended way to
retrieve original projection names (in converter) when using map types :
```sql
select _MAP['a'], _MAP['b'] from table order by _MAP['c']
```
Hi Andrei,
As you correctly noticed the extra projection column comes from the ORDER
BY clause.
In order to understand why have a look at the Javadoc of RelRoot class (
Unfortunately I don't have an answer, but just a minor point that when you
post links to specific lines of code, it's helpful if that link is to a
specific revision. You can press the "y" shortcut to get this link (pasted
below).
Hello,
I would like to understand how exactly generic map type (_MAP) works
with select
* expression. Say I have the following query (on document database) :
-- first query: 2 projectionsselect * from elastic.zips order by
_MAP['state'] -- second query: single projectionselect _MAP['state']