Transformation script output only around 100 rows

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

Hello,

quite old topic but I should share my experience.

As we want all production to be deployed code based, we built tools to backup analyses, models and also tables in order to be able to deploy them in other environment. (Its also a way to be fool-safe and manage human mistakes.)

I had to find a way to build a Pandas dataframe with all the data before saving them or reuse them.

I was unable to bypass the 100 rows limitation with job/transformation/dataframe from select.

Extracting data from models wasnt the way because several models can use a subset of tables.

In order to get the Graal, Ive scripted the following steps:

• created a temporary datamodel within the pool (create_datamodel)
• add all tables (add_table_from_pool)
• built a PQL query for each table
• created a dataframe (get_data_frame)

Easy

I can give you a full working script if anyone interested

Regards

I'd like to see you solution. Would you mind sharing your script.