You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@drill.apache.org by "Gopal Nagar (JIRA)" <ji...@apache.org> on 2016/12/09 13:38:58 UTC

[jira] [Created] (DRILL-5118) Select Query Limit is not working in Drill 1.8

Gopal Nagar created DRILL-5118:
----------------------------------

             Summary: Select Query Limit is not working in Drill 1.8
                 Key: DRILL-5118
                 URL: https://issues.apache.org/jira/browse/DRILL-5118
             Project: Apache Drill
          Issue Type: Bug
          Components: Client - CLI, Client - HTTP
    Affects Versions: 1.8.0
            Reporter: Gopal Nagar


Hi All,

Drill 1.8.0 has been installed on a AWS node which has 32 GB RAM and 80 GB storage. I didn't specify memory separately to Drill. I am trying to join two tables have rows 4607818 & 14273378 respectively and I have put limit 100 in query.

But after displaying the 100 rows on Drill CLI, Query doesn't terminated and it doesn't go back to CLI prompt and keep processing the data in Background. Please help.

Join Query 
--------------
select t1.col FROM hive.table1 as t1 join hive.table2 as t2 on t1.col = t2.col limit 100;



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)