[
https://issues.apache.org/jira/browse/TAJO-1071?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14147791#comment-14147791
]
Niv Zvi edited comment on TAJO-1071 at 9/25/14 2:21 PM:
--------------------------------------------------------
Hi,
Thanks for getting back to me!
I used -c like in your example, however, if you have more than 24 hits on the
query results, it blocks:
$ tsql -c "select * from supplier"
result: unknown rows (0 B)
s_suppkey, s_name, s_address, s_nationkey, s_phone, s_acctbal, s_comment
-------------------------------
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
continue... ('q' is quit)
was (Author: nivo999):
I went again over your comment and I think I miss read it.
What ever you have below the prompt ($) is the output, well, this is exactly
how I ran it so far, and it do blocks if you have more than 24 results in the
query:
$ tsql -c "select * from supplier"
result: unknown rows (0 B)
s_suppkey, s_name, s_address, s_nationkey, s_phone, s_acctbal, s_comment
-------------------------------
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
1, abc, def, 1500, ghi, 100.98, jkl
continue... ('q' is quit)
> should be possible to get long query results with no prompt
> -----------------------------------------------------------
>
> Key: TAJO-1071
> URL: https://issues.apache.org/jira/browse/TAJO-1071
> Project: Tajo
> Issue Type: Improvement
> Components: cli
> Affects Versions: 0.8.0
> Reporter: Niv Zvi
> Priority: Minor
>
> Hi,
> I need to be able to run queries in batch mode, however, when the query
> result is long, I get a message to that I need to conform in order to
> continue:
> continue... ('q' is quit)
> If I run this using my scheduler, the job gets stuck.
> Is it possible to add a way to override this limitation and get the entire
> query result back?
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
