Mailing-List: contact issues-help@drill.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.apache.org
Date: Fri, 9 Dec 2016 16:42:59 +0000 (UTC)
From: "Zelaine Fong (JIRA)" <jira@apache.org>
To: issues@drill.apache.org
Message-ID: <JIRA.13026999.1481290704000.484658.1481301779391@Atlassian.JIRA>
In-Reply-To: <JIRA.13026999.1481290704000@Atlassian.JIRA>
References: <JIRA.13026999.1481290704000@Atlassian.JIRA> <JIRA.13026999.1481290704429@arcas>
Subject: [jira] [Commented] (DRILL-5118) Select Query Limit is not working
 in Drill 1.8
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Fri, 09 Dec 2016 16:43:01 -0000


    [ https://issues.apache.org/jira/browse/DRILL-5118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15735744#comment-15735744 ] 

Zelaine Fong commented on DRILL-5118:
-------------------------------------

Not sure if this is related to DRILL-4905.

> 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)