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

sqlline hangs when query a text file with limit

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • 0.6.0
    • 0.7.0
    • Functions - Drill
    • None

    Description

      code base
      #Fri Sep 12 14:08:02 PDT 2014
      git.commit.id.abbrev=9e16466

      When I query a psv file with limit, sqlline frequently hangs. It sometimes comes back after a while but most of the time, it just hangs. When it hangs, I saw the InterruptedException in drill bit.log.

      11:43:23.238 [ce3297e2-8238-4f05-968f-e96550d23b10:frag:0:0 - Producer Thread] ERROR o.a.drill.exec.ops.FragmentContext - Fragment Context received failure.
      java.lang.InterruptedException: null
      at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.reportInterruptAfterWait(AbstractQueuedSynchronizer.java:2017) ~[na:1.7.0_45]
      at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2052) ~[na:1.7.0_45]
      at java.util.concurrent.LinkedBlockingDeque.putLast(LinkedBlockingDeque.java:393) ~[na:1.7.0_45]
      at java.util.concurrent.LinkedBlockingDeque.put(LinkedBlockingDeque.java:647) ~[na:1.7.0_45]
      at org.apache.drill.exec.physical.impl.producer.ProducerConsumerBatch$Producer.run(ProducerConsumerBatch.java:140) ~[drill-java-exec-0.6.0-incubating-SNAPSHOT-rebuffed.jar:0.6.0-incubating-SNAPSHOT]
      at java.lang.Thread.run(Thread.java:744) [na:1.7.0_45]

      sqlline just hangs:

      0: jdbc:drill:schema=dfs> select * from `tpcds/p1/store_sales.parquet` limit 1;
      ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

      ss_sold_date_sk ss_sold_time_sk ss_item_sk ss_customer_sk ss_cdemo_sk ss_hdemo_sk ss_addr_sk ss_store_sk ss_promo_sk ss_ticket_number ss_quantity ss_wholesale_cost ss_list_price ss_sales_price ss_ext_discount_amt ss_ext_sales_price ss_ext_wholesale_cost ss_ext_list_price ss_ext_tax ss_coupon_amt ss_net_paid ss_net_paid_inc_tax ss_net_profit

      ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

      2452603 71996 2739 59832 1659109 4339 13616 2 180 167289 60 80.79 147.03 89.68 2206.12 5380.8 4847.4 8821.8 222.22 2206.12 3174.68 3396.9 -1672.72

      Attachments

        1. DRILL-1435.1.patch.txt
          3 kB
          Hanifi Gunes

        Activity

          People

            cchang@maprtech.com Chun Chang
            cchang@maprtech.com Chun Chang
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: