Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-463

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

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 0.4.0
    • None
    • 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.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: