gazelle_plugin icon indicating copy to clipboard operation
gazelle_plugin copied to clipboard

Published 20 hours ago • verified publisher icon oap-project

7 queries with no results Fetched when running TPC-DS query

Open kelvin-qin opened this issue 2 years ago • 0 comments

Describe the bug I used the ddl schema of the databricks version, and then ran 99 queries of TPCDS. All the queries were completed and a running time was output. Most of them fetched results, but I checked that 7 of the queries had no results and no obvious errors were reported.

To Reproduce Steps to reproduce the behavior:

  1. Create 1000g of TPCDS data in hive with databricks ddl；
  2. run 99 queries with NativeSQL 1.4.0;
  3. check the log;

Expected behavior For comparison, vanilla spark3.1.1 ran the same query and got 99 results. NativeSQL only finds 92 "Fetched".

Additional context The result is the same for a partitioned or non-partitioned table.

kelvin-qin avatar Sep 01 '22 01:09 kelvin-qin