How to Generate Custom data files

Moderator: NorbertKrupa

Post Reply
sonynavi
Newbie
Newbie
Posts: 7
Joined: Sat Dec 15, 2012 11:08 am

How to Generate Custom data files

Post by sonynavi » Sat Dec 15, 2012 11:14 am

I am trying to generate custom data files , but I could not.

My code : ./vmart_gen store_sales_fact1.tbl --files 3

I would like to divide my file into 3 files. How?

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: How to Generate Custom data files

Post by id10t » Sat Dec 15, 2012 12:27 pm

Hi!

From Docs:
Step 8: (Optional) Generate Custom Data Files
...
Splits the fact table data into the specified number of files. By default, the data generator produces a single, unnumbered fact table data file. If you specify a value of two (2) or more, the data generator numbers the files by appending an underscore character (_) and three digits to the file name, starting at _001. For example:

./vmart_gen --files 3

produces:

VMart_Fact_001.tbl
VMart_Fact_002.tbl
VMart_Fact_003.tbl

Default: 1
You do not specifies a table, generator do it automatically for FACT table.

Example of cmd:

Code: Select all

./vmart_gen \
--files 3
--datadirectory /tmp/VMart
--seed 9999
--time_file /path/to/time_file.txt \
--inventory_fact 100000 \
--customer_dimension 500 \
--date_dimension 500 \
--employee_dimension 50 \
--product_dimension 500 \
--promotion_dimension 500 \
--shipping_dimension 500 \
--vendor_dimension 500 \
--warehouse_dimension 500 \
--promotion_dimension 100

jpcavanaugh
Intermediate
Intermediate
Posts: 149
Joined: Mon Apr 30, 2012 10:04 pm
Location: New York
Contact:

Re: How to Generate Custom data files

Post by jpcavanaugh » Mon Dec 17, 2012 2:01 pm

What error if any are you getting when you do this?

sonynavi
Newbie
Newbie
Posts: 7
Joined: Sat Dec 15, 2012 11:08 am

Re: How to Generate Custom data files

Post by sonynavi » Tue Dec 18, 2012 4:34 am

--$./vmart_gen \
> --Store_Dimension_tbl files 3

Invalid command line options: files 3

Here , I am trying to split my fact tables into 3 files.

Post Reply

Return to “New to Vertica Database Administration”