drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zelaine Fong (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-5118) Select Query Limit is not working in Drill 1.8
Date Fri, 09 Dec 2016 16:42:59 GMT

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

Mime
View raw message