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)
