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

        Hide
        Neeraja added a comment -

        The query also hands occasionally. Currently the behavior os unpredictable.
        Below is the full stack.

        java.lang.RuntimeException: java.sql.SQLException: Failure while trying to get next result batch.
        at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2514)
        at sqlline.SqlLine$TableOutputFormat.print(SqlLine.java:2148)
        at sqlline.SqlLine.print(SqlLine.java:1809)
        at sqlline.SqlLine$Commands.execute(SqlLine.java:3766)
        at sqlline.SqlLine$Commands.sql(SqlLine.java:3663)
        at sqlline.SqlLine.dispatch(SqlLine.java:889)
        at sqlline.SqlLine.begin(SqlLine.java:763)
        at sqlline.SqlLine.start(SqlLine.java:498)
        at sqlline.SqlLine.main(SqlLine.java:460)

        Show
        Neeraja added a comment - The query also hands occasionally. Currently the behavior os unpredictable. Below is the full stack. java.lang.RuntimeException: java.sql.SQLException: Failure while trying to get next result batch. at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2514) at sqlline.SqlLine$TableOutputFormat.print(SqlLine.java:2148) at sqlline.SqlLine.print(SqlLine.java:1809) at sqlline.SqlLine$Commands.execute(SqlLine.java:3766) at sqlline.SqlLine$Commands.sql(SqlLine.java:3663) at sqlline.SqlLine.dispatch(SqlLine.java:889) at sqlline.SqlLine.begin(SqlLine.java:763) at sqlline.SqlLine.start(SqlLine.java:498) at sqlline.SqlLine.main(SqlLine.java:460)

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development