2

Has someone the TPC-H schema? I try to compile but has some errors.

I need the sql schema file. And if possible the data sql file.

Thanks

vladimir
  • 13,428
  • 2
  • 44
  • 70
walves
  • 2,026
  • 6
  • 28
  • 46
  • I've found the Visual TPC-H that allow to generate the TPC-H data, adn modify the eschema. It's was the best solution, instead DBGen. – walves Jul 29 '12 at 19:41

2 Answers2

1

I maintain a repo of the data generator and schema here: https://bitbucket.org/tkejser/tpch-dbgen. It is a bit nicer to work with than the one from TPC.

There is a postgres ready schema in the repo as well as a makefile that does The Right Thing for Postgres.

Thomas Kejser
  • 1,264
  • 1
  • 10
  • 30
1

TPC-H have a DBGEN that generates a database.

You can see at : http://www.tpc.org/tpch/

Anderson Carniel
  • 1,711
  • 2
  • 16
  • 22