Details

    • Type: Improvement
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Environment:

      HDP 2.3.4 with Phoenix 4.4.0 on Calcite 1.5; also Phoenix 4.6.0 on Calcite 1.3

      Description

      select e.first_name from emp e, addr a where e.first_name in (a.first_name)
      8org.apache.calcite.avatica.proto.Responses$ErrorResponseÆ
      ëjava.lang.RuntimeException: java.sql.SQLException: ERROR 214 (22008): Values in IN must evaluate to a constant.
      	at org.apache.calcite.avatica.jdbc.JdbcMeta.propagate(JdbcMeta.java:645)
      	at org.apache.calcite.avatica.jdbc.JdbcMeta.prepare(JdbcMeta.java:671)
      	at org.apache.calcite.avatica.remote.LocalService.apply(LocalService.java:177)
      	at org.apache.calcite.avatica.remote.Service$PrepareRequest.accept(Service.java:1401)
      	at org.apache.calcite.avatica.remote.Service$PrepareRequest.accept(Service.java:1379)
      	at org.apache.calcite.avatica.remote.AbstractHandler.apply(AbstractHandler.java:102)
      	at org.apache.calcite.avatica.remote.ProtobufHandler.apply(ProtobufHandler.java:38)
      	at org.apache.calcite.avatica.server.AvaticaProtobufHandler.handle(AvaticaProtobufHandler.java:68)
      	at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                julianhyde Julian Hyde
                Reporter:
                kliew Kevin Liew
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated: