Re: Display of query result using command line

select count() query works fine for me - it returns exact number of rows close to 3 million. The way I am executing queries is - I am doing a putty session to the drill node, firing the query and getting the result printed on the putty console. on removing extract headers from the tsv and then

Re: Display of query result using command line

Three million rows is too many rows, for sqlline to print. Try doing a COUNT(*) and see if that query returns the correct count on that table. Thanks, Khurram From: PROJJWAL SAHA Sent: Wednesday, March 15, 2017 7:41:00 PM To:

Display of query result using command line

All, I am using drillconf from command line to display a query result like select * from xxx having 3 million rows. The screen display scrolls fast to display the result, however, it stops after some time with this exception - java.lang.NegativeArraySizeException at