Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-49537

Internal error when compiling Analytics Query

    XMLWordPrintable

Details

    • Untriaged
    • 1
    • Unknown
    • CX Sprint 270

    Description

      The query is

      select count (*) from orders o, lineitem l, customer c
      where tobigint (l.l_orderkey) =  (o.o_orderkey)
      and (o.o_custkey+l.l_orderkey) = c.c_custkey +l.l_orderkey;
      

      The stack trace is as follows:

      2021-11-12T16:06:37.866-08:00 INFO CBAS.messaging.CCMessageBroker [Executor-31:ClusterController] Received message: ExecuteStatementRequestMessage(id=4, from=2e34b8157f6115c9b7ce726f115857c2): <ud>explain select count (*) from orders o, lineitem l, customer c\nwhere tobigint (l.l_orderkey) = (o.o_orderkey)\nand (o.o_custkey+l.l_orderkey) = c.c_custkey +l.l_orderkey;</ud>
      2021-11-12T16:06:37.947-08:00 INFO CBAS.translator.QueryTranslator [QueryTranslator:c303423b-bc92-479d-b61b-808035139766] null
      java.lang.NullPointerException: null
       at org.apache.asterix.om.typecomputer.impl.TypeComputeUtils.getActualType(TypeComputeUtils.java:206) ~[asterix-om-7.0.1-0000.jar:7.0.1-0000]
       at org.apache.asterix.om.typecomputer.impl.TypeComputeUtils.getActualType(TypeComputeUtils.java:185) ~[asterix-om-7.0.1-0000.jar:7.0.1-0000]
       at org.apache.asterix.om.typecomputer.impl.TypeComputeUtils.resolveResultType(TypeComputeUtils.java:90) ~[asterix-om-7.0.1-0000.jar:7.0.1-0000]
       at org.apache.asterix.om.typecomputer.base.AbstractResultTypeComputer.computeType(AbstractResultTypeComputer.java:44) ~[asterix-om-7.0.1-0000.jar:7.0.1-0000]
       at org.apache.asterix.dataflow.data.common.ExpressionTypeComputer.getTypeForFunction(ExpressionTypeComputer.java:70) ~[asterix-om-7.0.1-0000.jar:7.0.1-0000]
       at org.apache.asterix.dataflow.data.common.ExpressionTypeComputer.getType(ExpressionTypeComputer.java:52) ~[asterix-om-7.0.1-0000.jar:7.0.1-0000]
       at org.apache.hyracks.algebricks.core.algebra.typing.AbstractTypeEnvironment.getType(AbstractTypeEnvironment.java:45) ~[algebricks-core-7.0.1-0000.jar:7.0.1-0000]
       at org.apache.asterix.om.typecomputer.impl.TypeComputeUtils.resolveResultType(TypeComputeUtils.java:86) ~[asterix-om-7.0.1-0000.jar:7.0.1-0000]
      

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            umang.agrawal Umang
            murali.krishna Murali Krishna
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty