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