[
https://issues.apache.org/jira/browse/TAJO-1071?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14147685#comment-14147685
]
Jihoon Son commented on TAJO-1071:
----------------------------------
Hi Niv,
thanks for your interest in Tajo.
If you want to get the entire query results, you can run the tsql with options
of '-c' and '-f' as follows.
{noformat}
$ bin/tsql -c "select * from region"
r_regionkey, r_name, r_comment
-------------------------------
0, AFRICA, lar deposits. blithely final packages cajole. regular waters are
final requests. regular accounts are according to
1, AMERICA, hs use ironic, even requests. s
2, ASIA, ges. thinly even pinto beans ca
3, EUROPE, ly final courts cajole furiously final excuse
4, MIDDLE EAST, uickly special accounts cajole carefully blithely close
requests. carefully final asymptotes haggle furiousl
(5 rows, 0.095 sec, 384 B selected)
{noformat}
{noformat}
$ cat test.sql
select * from region
$ bin/tsql -f test.sql
r_regionkey, r_name, r_comment
-------------------------------
0, AFRICA, lar deposits. blithely final packages cajole. regular waters are
final requests. regular accounts are according to
1, AMERICA, hs use ironic, even requests. s
2, ASIA, ges. thinly even pinto beans ca
3, EUROPE, ly final courts cajole furiously final excuse
4, MIDDLE EAST, uickly special accounts cajole carefully blithely close
requests. carefully final asymptotes haggle furiousl
(5 rows, 0.095 sec, 384 B selected)
{noformat}
If these options are used, the query results are printed without blocking.
You can get more detailed information in
http://tajo.apache.org/docs/current/cli.html.
Thanks!
> 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)
