cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

Query failures are seen during the TPC-DS performance benchmark run

Suresh1
New Contributor

When I'm running TPC-DS (1TB) benchmark on Photon 10.2 and I see the following failures:

Queries Q06, Q09 and Q41 fail with the error "Query: AEValueSubQuery is not supported".

Q66 fails with the error "[MISSING_COLUMN] org.apache.spark.sql.AnalysisException: Column 'x.xw_warehouse_sq_ft' does not exist" and

Q87 fails with "Query: AEExcept is not supported." error.

My understanding is that we should be able to run TPC-DS without any modification of the queries. Any idea why I'm seeing errors and how I can overcome these errors?

I tried to upgrade to Photon 10.4 and I still see the same errors.

Appreciate any help.

Thanks

Suresh

0 REPLIES 0
Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.