43 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
1
answer
234
views
How do I use TPC to generate a sequence for each inherited entity in EF Core?
I've written a BaseEntity class which defines common fields in my database. It looks something like this:
public abstract class BaseEntity
{
[Key]
public int Id { get; set; }
public ...
1
vote
0
answers
90
views
How to add JHDF 5 aarch64 support?
I'm currently exploring a benchmark from TPC - TPC-AI
This benchmark uses Parallel Data Generation Framework (PDGF) in java for generating the input datasets. It looks like one of the dependencies is ...
0
votes
1
answer
427
views
Is complex types supported in abstract base class for TPC strategy in EF Core?
Summary
I try to implement a hierarchy in EF Core where I use the TPC strategy and have complex types in the abstract base class. I also use migrations, in Visual Studio Professional 2022.
Description
...
0
votes
1
answer
622
views
Databricks SQL: Type Inference Challenges Using `COPY INTO`
I'm currently working on executing TPC-DS Benchmark queries in a Databricks SQL warehouse. The process involves generating data locally in CSV files, creating a Databricks database, and Delta tables ...
0
votes
1
answer
222
views
Error loading to MySQL TPC-H data via dbgen
I am using https://github.com/electrum/tpch-dbgen to generate the 8 tables of TPC-H.
However, for the PART table, when loading the data to MySQL via load infile command,
I get via show warnings, tons ...
0
votes
1
answer
99
views
Does Spark TPCDS supports on YARN?
I am testing Spark-3.3.0-without-Hadoop using TPCDS referring spark-tpcds-datagen
,This spark is running on my Hadoop-3.2
Data is produced and -put to hdfs://xxx/tpcds/data330
When I run :
./SPARK/bin/...
6
votes
1
answer
976
views
Many "multiple definition of" errors shows up when compiling TPC-DS tools
I'm trying to compile TPC-DS tools (i..e Tools used to benchmark databases) but I'm seeing the following errors:
$ make
gcc -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -DYYDEBUG -DLINUX -g -Wall -o ...
1
vote
0
answers
81
views
Can anyone help tranlating this sql queries to functional sql queries for sql server?
I am using TPC-H Benchmark to do some studies, and i have been having some difficulties to understand and find the correct functions to use on sql server.
What is the meaning of :n -1 at the end of ...
1
vote
0
answers
220
views
How to Get Nested Structure Using EF Core 7 TPC
I have base abstract class:
public abstract class PossibleAnswerBase
{
public Uuid Id { get; protected set; }
public string Title { get; protected set; }
#region Navigation
public ...
1
vote
1
answer
1k
views
.NET MAUI TCP listener; Scrollview not updating
Im new in MAUI and i have problem with tcp listener. The listener is working properly but not visualisation signals in UI at (CollectionView).The (CollectionView) in UI stay freeze. When user clicl at ...
3
votes
1
answer
978
views
HammerDB: what does 'Number of Warehouses' mean?
In HammerDB in schema building there is an option named 'Number of Warehouses'.
But the meaning of this term is unclear. I mean I know what 'warehouse' IS, but I don't understand what it MEANS in ...
user avatar
user17939629
0
votes
0
answers
270
views
how to speed up TPC-H benchmark on Oracle database
im trying TPC-H benchmark on my Oracle database, testing takes place on a 10GB dataset. Currently I have target_memory set to 7GB, but the current test time is 18 minutes. The biggest problem is with ...
0
votes
3
answers
249
views
TPC-DS data in Snowflake Cloud warehouse is available only with 10 TB and 100 TB, is it possible to get it with fewer records(10 GB or even lesser)?
By default, Snowflake comes with a 10 TB and 100 TB scale of TPC-DS datasets. Is it possible to get the same number of tables with fewer records/less volume(10 GB or even lesser than that)?
Thanks in ...
0
votes
2
answers
514
views
PySpark using both aggregate and group by
Can someone help me with pyspark using both aggregate and groupby functions? I have made my data frames, and applied filters and selects to get the data I want. However, I am now stuck trying to ...
2
votes
1
answer
5k
views
MySQL 1114 Error, Table /tmp/#sql is full
I am trying to run TPC-H queries in MySQL server.
Currently, I am using 8.0.23 version (The error did not appear when I used 8.0.19 somehow).
Benchmark size of TPC-H is 10 GB.
I get this error (1114 ...