[
https://issues.apache.org/jira/browse/TAJO-1071?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14162099#comment-14162099
]
Hyunsik Choi edited comment on TAJO-1071 at 10/7/14 4:48 PM:
-------------------------------------------------------------
Hi [~nivo999],
I've tested it with the master branch which will be released as 0.9.0 soon.
This bug was fixed already. I also fixed other bugs that I found while testing
it.
{noformat}
bin/tsql -c "select * from orders"
o_orderkey, o_custkey, o_orderstatus, o_totalprice, o_orderdate,
o_orderpriority, o_clerk, o_shippriority, o_comment
-------------------------------
1, 36901, O, 173665.47, 1996-01-02, 5-LOW, Clerk#000000951, 0,
nstructions sleep furiously among
2, 78002, O, 46929.18, 1996-12-01, 1-URGENT, Clerk#000000880, 0,
foxes. pending accounts at the pending, silent asymptot
....
....
5999975, 113398, F, 63216.65, 1993-07-25, 1-URGENT, Clerk#000000813, 0,
oost! ironic instructions h
6000000, 110063, O, 37625.29, 1996-08-31, 2-HIGH, Clerk#000000411, 0,
ess pinto beans boost slyly regular accounts! furiously even
(1500000 rows, 0.192 sec, 164.0 MiB selected)
hyunsik@Hyunsiks-MacBook-Pro:tajo-0.9.0-SNAPSHOT$
{noformat}
If there is no objection, I'll close this issue.
Thanks,
Hyunsik
was (Author: hyunsik):
Hi [~nivo999],
I've tested it with the master branch which will be released as 0.9.0 soon.
This bug was fixed already. I also fixed other bugs that I found while testing
it.
{noformat}
bin/tsql -c "select * from orders"
o_orderkey, o_custkey, o_orderstatus, o_totalprice, o_orderdate,
o_orderpriority, o_clerk, o_shippriority, o_comment
-------------------------------
1, 36901, O, 173665.47, 1996-01-02, 5-LOW, Clerk#000000951, 0,
nstructions sleep furiously among
2, 78002, O, 46929.18, 1996-12-01, 1-URGENT, Clerk#000000880, 0,
foxes. pending accounts at the pending, silent asymptot
3, 123314, F, 193846.25, 1993-10-14, 5-LOW, Clerk#000000955, 0, sly
final accounts boost. carefully regular ideas cajole carefully. depos
4, 136777, O, 32151.78, 1995-10-11, 5-LOW, Clerk#000000124, 0, sits.
slyly regular warthogs cajole. regular, regular theodolites acro
5, 44485, F, 144659.2, 1994-07-30, 5-LOW, Clerk#000000925, 0, quickly.
bold deposits sleep slyly. packages use slyly
6, 55624, F, 58749.59, 1992-02-21, 4-NOT SPECIFIED, Clerk#000000058, 0,
ggle. special, final requests are against the furiously specia
7, 39136, O, 252004.18, 1996-01-10, 2-HIGH, Clerk#000000470, 0, ly
special requests
32, 130057, O, 208660.75, 1995-07-16, 2-HIGH, Clerk#000000616, 0, ise
blithely bold, regular requests. quickly unusual dep
33, 66958, F, 163243.98, 1993-10-27, 3-MEDIUM, Clerk#000000409, 0,
uriously. furiously final request
34, 61001, O, 58949.67, 1998-07-21, 3-MEDIUM, Clerk#000000223, 0, ly
final packages. fluffily final deposits wake blithely ideas. spe
35, 127588, O, 253724.56, 1995-10-23, 4-NOT SPECIFIED, Clerk#000000259,
0, zzle. carefully enticing deposits nag furio
36, 115252, O, 68289.96, 1995-11-03, 1-URGENT, Clerk#000000358, 0,
quick packages are blithely. slyly silent accounts wake qu
37, 86116, F, 206680.66, 1992-06-03, 3-MEDIUM, Clerk#000000456, 0, kly
regular pinto beans. carefully unusual waters cajole never
38, 124828, O, 82500.05, 1996-08-21, 4-NOT SPECIFIED, Clerk#000000604,
0, haggle blithely. furiously express ideas haggle blithely furiously regular
re
39, 81763, O, 341734.47, 1996-09-20, 3-MEDIUM, Clerk#000000659, 0, ole
express, ironic requests: ir
64, 32113, F, 39414.99, 1994-07-16, 3-MEDIUM, Clerk#000000661, 0, wake
fluffily. sometimes ironic pinto
....
....
5999975, 113398, F, 63216.65, 1993-07-25, 1-URGENT, Clerk#000000813, 0,
oost! ironic instructions h
6000000, 110063, O, 37625.29, 1996-08-31, 2-HIGH, Clerk#000000411, 0,
ess pinto beans boost slyly regular accounts! furiously even
(1500000 rows, 0.192 sec, 164.0 MiB selected)
hyunsik@Hyunsiks-MacBook-Pro:tajo-0.9.0-SNAPSHOT$
{noformat}
If there is no objection, I'll close this issue.
Thanks,
Hyunsik
> 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
> Assignee: Hyunsik Choi
> Priority: Minor
> Fix For: 0.9.0
>
>
> 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)
