Stack Overflow
Stack Overflow

Questions tagged [tpc]

The industry-standard set of database benchmarks (TPC-DS, TPC-C, TPC-E, etc)

The TPC (Transaction Processing Performance Council) is a non-profit corporation founded to define transaction processing and database benchmarks and to disseminate objective, verifiable TPC performance data to the industry.

See http://www.tpc.org/information/benchmarks.asp

40 questions
0
votes
1 answer

TPC-DS Query 6: Why do we need 'where j.i_category = i.i_category' condition?

I'm going through TPC-DS for Amazon Athena. It was fine until query 5. I got some problem on query 6. (which is below) select a.ca_state state, count(*) cnt from customer_address a ,customer c ,store_sales s ,date_dim d ,item…
Bumhwan Kim
  • 312
  • 1
  • 4
  • 16
0
votes
1 answer

Generate data from TPC-E using Mac os

I'm trying to generate data from the TPC-E benchmark using macOS: When using the following commands: cd Utilities/prj/GNUMake/ make I get: ../../prj/GNUMake/Makefile.EGenUtilities:136: ../../obj/DateTime.d: No such file or…
Manel SOUIBGUI
  • 1
  • 2
0
votes
1 answer

Placeholder for Lookup in TPC (The Portal Connector)

I have a requirement to provide placeholder for all controls in my TPC form. I wanted to know if there is a way to do so. I have tried placing placeholder in Template like:
Anuja
  • 1
0
votes
1 answer

How to Benchmark Hive (Azure Interactive Query HDI 4.0)

Does anyone have a working and tested as of 2020 TPC-DS or TPC-H benchmarks for Azure Interactive Query HDI 4.0 clusters, which uses Hadoop 3.x+? I was using https://github.com/hortonworks/hive-testbench but I ran into an error trying to generate…
user7644509
  • 130
  • 9
0
votes
1 answer

How to generate tables in parallel with tpc-ds benchmark?

How do I run tpc-ds data generation (dsdgen) and then run queries on these data (dsqgen) in a parallel distributed mode. I am using Spark on yarn configuration (spark.master yarn) and storing data on a burst buffer storage system.
user9332151
  • 47
  • 1
  • 8
0
votes
1 answer

How to generate and load test data in amazon RDS for Oracle

For a POC, we need 10 GB of data to be available in Oracle RDS instance. Any test data is ok ( like TPC for benchmarking ) , for this requirement is there any specific way to create database and pump the sample data ?
Devoloper250
  • 753
  • 2
  • 8
  • 12
0
votes
0 answers

How to import Large flat file into SQL SERVER 2016?

I have a tpcds dsdgen generated data about 100GB, and each dat file is around 20GB+, I have exhaustively searched how to load flat file into sql-server 2016, and i tried importing it using SSIS package and enabled fast parse on all the decimal…
Nawap
  • 43
  • 5
0
votes
1 answer

TPC DS queries and database

Where can I find TPC DS queries and the dataset? It’s for one of my project work, where I need to analyze their performance on redshift and snowflake.
naturegirl
  • 11
  • 3
0
votes
1 answer

Oracle db workload testing with TPC-H hammerdb

What is the workload percentage of DML/Select operations in hammerdb TPC-H??? As calling circle of oracle swingbench benchmark percentage is like Large amounts of dynamic PL/SQL. Heavy CPU utilization • Select 83% • Insert 7% • Update 10% •…
Ahmad
  • 1
  • 1
0
votes
1 answer

how to use a whole hive database in spark and read sql queries from external files?

I am using hortonworks sandbox in Azure with spark 1.6. I have a Hive database populated with TPC-DS sample data. I want to read some SQL queries from external files and run them on the hive dataset in spark. I follow this topic Using hive database…
Fardin Behboudi
  • 459
  • 4
  • 15
1 2
3