Apache Drill
  1. Apache Drill
  2. DRILL-463

Exception in the query without LIMIT: Failure while trying to get next result batch.

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.4.0
    • Component/s: None
    • Labels:
      None

      Description

      Executed the following query and this throws and exception.
      The same query works if I apply a LIMIT clause.
      0: jdbc:drill:> Select l_orderkey,sum(l_extendedprice * (1 - l_discount)) as revenue,o_orderdate, o_shippriority from hive.customer join hive.orders on c_custkey = o_custkey join hive.lineitem on l_orderkey = o_orderkey group by l_orderkey, o_orderdate,o_shippriority;

      java.lang.RuntimeException: java.sql.SQLException: Failure while trying to get next result batch.

        Activity

        Tony Stevenson made changes -
        Workflow no-reopen-closed, patch-avail, testing [ 12859977 ] Drill workflow [ 12934236 ]
        Jacques Nadeau made changes -
        Fix Version/s 0.4.0 [ 12324963 ]
        Jacques Nadeau made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Jake Farrell made changes -
        Field Original Value New Value
        Workflow no-reopen-closed, patch-avail [ 12851462 ] no-reopen-closed, patch-avail, testing [ 12859977 ]
        Neeraja created issue -

          People

          • Assignee:
            Unassigned
            Reporter:
            Neeraja
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development