[
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 3:10 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:
{noformat}
$ 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)
{noformat}
was (Author: nivo999):
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)
> 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)
