Skip to main content

Random data generator

  • Nov 17, 2017 1:56 PM UTC
  • 5 replies
  • 22 views

Bernard92
Forum|alt.badge.img+2

Hello,

Have we got somewhere a Random data generator to do some volume testing on Vertica?
I have used various Python data generator and Benerator , but most of them are very slow and not very user friendly.

Regards
Bernard

5 replies

Forum|alt.badge.img+2
  • Participating Frequently
  • Nov 17, 2017 2:02 PM UTC

In /opt/vertica/examples/VMart_Schema there's the vmart_gen which will generate data and has the ability to pass it a seed as well as row counts per table so you can somewhat create random data. It is however specific to the VMart example database design. I used this recently to create a 50 million row fact table and it was pretty fast.


Bernard92
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • Nov 17, 2017 3:10 PM UTC

thanks , yes I know that smart_gen tool , I meant something a bit more generic , that could produce some random data according to a database schema.


siddyash
Forum|alt.badge.img
  • Participating Frequently
  • Nov 17, 2017 4:26 PM UTC

Hi Bernad,
We have a generic data generator that you can use. However, it is still in packaging stage. Therefore, I will reach out to you to share the data generator.
Thanks,
Jawahar.


Moshe
Forum|alt.badge.img
  • Participating Frequently
  • Nov 20, 2017 12:26 AM UTC

Hi Bernad,
I've learned from Maurizio how to generate data very quickly.
Try the attached demo script:
https://www.dropbox.com/s/kkn9qeono9s2zwz/gen_random.sql?dl=0

Thanks,
Moshe


Bernard92
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • Nov 20, 2017 8:54 AM UTC

Hi Moshe,
thanks , I'll give a try
regards
Bernard