Transformation script output only around 100 rows

In the stage of transformation, I run the Vertica SQL script and the output only shows the first 100 rows. But I want to see all rows. Is it possible to do some configuration to see all output rows? Can I export the output? Thanks.

Hi David,

welcome to the community!

Vertica only shows the first 100 rows. In case you try to retrieve less than 200 rows you could work with ORDER BY. If you order the results of your query in DESC or ASC order you can get up to 200 results.

Best,

Justin

Hi Justin. Thanks for your reply. I have tried the following script (and tried DESC as well), but still only 100 line:
SELECT * FROM ADB ORDER BY KEY ASC

Did I miss something? Thanks.

Hi David,

you did it correctly!

SELECT * FROM ADB ORDER BY KEY ASC gives you the first 100 rows and
SELECT * FROM ADB ORDER BY KEY DESC would give you the last 100 rows. So in total you have your 200 rows.

I hope that this workaround is of support for you!

Best,

Justin

Great! Thanks, Justin