I have loaded the data and everything is set. But the dialects available are db2, oracle, sqlserver, ansi and netezza. None of these are fully compatible with mysql. Is there a way to generate the queries for mysql?
Asked
Active
Viewed 247 times
2
-
I would be surprised. Although I'm not intimately familiar with TPC-DS, I would expect it to make use of window/analytic functions, which are not available in MySQL. – Gordon Linoff Jul 11 '15 at 14:09
-
The queries are in sql, but constructs like top N and with VAR as (select ...) etc. are not suppoerted in mysql. One can edit the queries manually, but I was looking for a better way. – Kumar Deepak Jul 12 '15 at 05:12
-
`top` is specific to SQL Server. `with` is a standard construct as are window functions. MySQL functionality is sufficiently different from ANSI standard that it can be hard to implement "standard" queries. Admittedly, other databases have differences, but these tend to be more like `substr()` versus `substring()`. – Gordon Linoff Jul 12 '15 at 22:12