[
https://issues.apache.org/jira/browse/TAJO-1071?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14162099#comment-14162099
]
Hyunsik Choi commented on TAJO-1071:
------------------------------------
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
....
....
5999908, 79121, F, 15695.83, 1995-03-02, 1-URGENT, Clerk#000000520, 0,
y final instructions against the platelets ca
5999909, 32708, F, 142936.22, 1993-12-08, 1-URGENT, Clerk#000000357, 0,
deposits. quietly regular ideas haggle fluffily. blithely bold depe
5999910, 118651, O, 59204.86, 1996-02-10, 2-HIGH, Clerk#000000441, 0,
uriously above the excuses. carefully even deposits sleep. carefully regular
5999911, 53767, O, 206058.0, 1998-05-07, 3-MEDIUM, Clerk#000000091, 0,
g pinto beans. carefully regular req
5999936, 60281, F, 3696.95, 1992-09-28, 5-LOW, Clerk#000000999, 0,
pinto beans. foxes are fluffily bol
5999937, 40513, O, 71913.98, 1996-02-04, 3-MEDIUM, Clerk#000000813, 0,
lyly: carefully ironic accounts pr
5999938, 42247, O, 232300.89, 1997-01-27, 3-MEDIUM, Clerk#000000100, 0,
cajole furiously among the regu
5999939, 79657, O, 129665.58, 1998-01-20, 3-MEDIUM, Clerk#000000998, 0,
, regular foxes nag along
5999940, 22351, F, 14349.56, 1994-08-26, 2-HIGH, Clerk#000000243, 0,
heodolites cajole packages. carefully regular pinto
5999941, 32512, O, 102961.29, 1998-03-26, 5-LOW, Clerk#000000927, 0,
integrate slyly. special, final re
5999942, 110807, F, 32586.85, 1994-05-13, 4-NOT SPECIFIED,
Clerk#000000454, 0, refully unusual braids wake carefully according to the
final
5999943, 77497, O, 290029.26, 1998-03-09, 1-URGENT, Clerk#000000119, 0,
y regular deposits sleep. furiously express accounts wake unusual instr
5999968, 12896, F, 354575.46, 1992-12-24, 3-MEDIUM, Clerk#000000736, 0,
cajole blithely ag
5999969, 138182, O, 26663.0, 1996-06-01, 1-URGENT, Clerk#000000712, 0,
g quickly after the fluff
5999970, 124754, O, 192134.85, 1995-11-19, 2-HIGH, Clerk#000000822, 0,
ss deposits. blithely final deposit
5999971, 30355, O, 317382.84, 1996-07-18, 4-NOT SPECIFIED,
Clerk#000000608, 0, aggle blithely among the blithely
5999972, 143594, O, 114856.68, 1996-05-02, 3-MEDIUM, Clerk#000000536, 0,
y express accounts above the blithely bold
5999973, 32071, O, 68906.56, 1997-07-13, 4-NOT SPECIFIED,
Clerk#000000130, 0, special ideas use pending pinto beans. requests haggle
blithely ca
5999974, 55448, F, 92750.9, 1993-07-28, 3-MEDIUM, Clerk#000000776, 0,
fts. requests affix furiously a
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)
