calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ptr.bojko@gmail.com" <ptr.bo...@gmail.com>
Subject Re: problem with lateral join
Date Fri, 03 Aug 2018 14:38:02 GMT
I have created https://issues.apache.org/jira/browse/CALCITE-2446 with a
reproduction test case.

Any hints how to solve this appreciated :)

On Thu, Aug 2, 2018 at 9:39 PM Julian Hyde <jhyde@apache.org> wrote:

> Sounds like an interesting bug in view expansion. Can you log a bug
> please. If possible create a test case in ServerTest (since I presume that
> it needs CREATE VIEW followed by a query).
>
> Julian
>
>
> > On Aug 2, 2018, at 4:50 AM, ptr.bojko@gmail.com wrote:
> >
> > Hello,
> >
> > I struggling with a strange case. Following query works for me:
> > SELECT *
> > FROM CORE.FILTERS F
> > CROSS JOIN LATERAL TABLE(AUX.TBLFUNCTION('somestring, F.aCOLLUMN)) tblfn
> >
> > But when it is placed as a view under a schema EXAMPLES with name
> > EXAMPLECOLLATERAL, following query won't work
> > SELECT * FROM EXAMPLES.EXAMPLECOLLATERAL
> >
> > It produces:
> >
> >> org.apache.calcite.runtime.CalciteContextException: At line 3, column
> 51:
> >> Table 'F' not found
> >>  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> Method)
> >>  at
> >>
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
> >>  at
> >>
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> >>  at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
> >>  at
> >>
> org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:463)
> >>  at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:783)
> >>  at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:768)
> >>  at
> >>
> org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:4779)
> >>  at
> >>
> org.apache.calcite.sql.validate.DelegatingScope.fullyQualify(DelegatingScope.java:330)
> >>  at
> >>
> org.apache.calcite.sql.validate.SqlValidatorImpl$DeriveTypeVisitor.visit(SqlValidatorImpl.java:5527)
> >>  at
> >>
> org.apache.calcite.sql.validate.SqlValidatorImpl$DeriveTypeVisitor.visit(SqlValidatorImpl.java:5490)
> >>  at org.apache.calcite.sql.SqlIdentifier.accept(SqlIdentifier.java:334)
> >>  at
> >>
> org.apache.calcite.sql.validate.SqlValidatorImpl.deriveTypeImpl(SqlValidatorImpl.java:1627)
> >>  at
> >>
> org.apache.calcite.sql.validate.SqlValidatorImpl.deriveType(SqlValidatorImpl.java:1612)
> >>  at
> >>
> org.apache.calcite.sql.SqlOperator.constructArgTypeList(SqlOperator.java:584)
> >>  at org.apache.calcite.sql.SqlFunction.deriveType(SqlFunction.java:233)
> >>  at org.apache.calcite.sql.SqlFunction.deriveType(SqlFunction.java:215)
> >>  at
> >>
> org.apache.calcite.sql.validate.SqlValidatorImpl$DeriveTypeVisitor.visit(SqlValidatorImpl.java:5503)
> >>  at
> >>
> org.apache.calcite.sql.validate.SqlValidatorImpl$DeriveTypeVisitor.visit(SqlValidatorImpl.java:5490)
> >>  at org.apache.calcite.sql.SqlCall.accept(SqlCall.java:138)
> >>  at
> >>
> org.apache.calcite.sql.validate.SqlValidatorImpl.deriveTypeImpl(SqlValidatorImpl.java:1627)
> >>  at
> >>
> org.apache.calcite.sql.validate.ProcedureNamespace.validateImpl(ProcedureNamespace.java:53)
> >>  at
> >>
> org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
> >>  at
> >>
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:965)
> >>  at
> >>
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:944)
> >>  at
> >>
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3027)
> >>  at
> >>
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3012)
> >>  at
> >>
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateJoin(SqlValidatorImpl.java:3064)
> >>  at
> >>
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3021)
> >>  at
> >>
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:3271)
> >>  at
> >>
> org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
> >>  at
> >>
> org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
> >>  at
> >>
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:965)
> >>  at
> >>
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:944)
> >>  at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:225)
> >>  at
> >>
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:919)
> >>  at
> >>
> org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:629)
> >>  at
> >>
> org.apache.calcite.prepare.CalcitePrepareImpl.parse_(CalcitePrepareImpl.java:292)
> >
> >
> > I am willing to patch this if this is a bug - just need a point to the
> > right direction.
> >
> > Thanx!
> > --
> > Piotr Bojko
> > http://about.me/ptr.bojko
>
>

-- 
Piotr Bojko
http://about.me/ptr.bojko

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message