Greg Rahn
Greg Rahn
The definition of `customer` in `tpcds.sql` lists the last column as `c_last_review_date char(10)` however the TPC-DS spec v2.4 list the last column as `c_last_review_date_sk identifier` with FK to `d_date_sk` The...
As of v2.4 the `results` CTE has a `group by` that appears to be a mistake. There is no aggregate and when removing the `group by` query22a returns the same...
A change introduced in v2.9 modified query77a.tpl to fix the incorrect inline view `cr` (lines 75-84) is missing a comma after the first column (L76).
At some point the dialect definitions lost the following two lines and `dsqgen` will error if not present. ``` define _BEGIN = "-- start query " + [_QUERY] + "...
The business question for query91 states: > Display total returns of catalog sales by call center and manager in a particular month for male customers of unknown education or female...
Some systems default to `\N` being the `NULL` character in flat files versus a missing field. Adding an option to dbgen would be a nice solution for this.
There appears to be a bug in the data generation that only generates data for the 2nd of March when the year is a leap year, in this case year...
With v2.3.0 the KNX Gateway Automatic Discovery works as expected. ``` pi@homebridge:~/hkknx $ ./hkknx-2.3.0 -db ./database -verbose INFO 2022/08/24 00:02:25 main.go:79: version 2.3.0 (built at 2022-04-12T16:14:17Z+0200) INFO 2022/08/24 00:02:25 main.go:221:...
For example, tables `nation` and `region` are generated not once, but the number of the scale factor. e.g. at 300, there is 300x the data generated for each. See commit...
In your blog post [Benchmarking Apache Hive 13 for Enterprise Hadoop](http://hortonworks.com/blog/benchmarking-apache-hive-13-enterprise-hadoop/) you site this repo as the souce, but Hive 0.10 requires ANSI SQL-92 join syntax and the `hive13` branch...