SAP Knowledge Base Article - Preview

3359116 - Google Cloud Bigquery adapter doesn't pushdown join from HANA to the remote source virtual table

Symptom

  • A join between a local HANA DB table and a virtual table hosted on a Google Cloud Platform remote source, is not pushed down as expected to the remote source.
  • A Planviz trace of the query in HANA Studio reveals a failed remote column scan under the task "[Local Compensation] CAP_CRT_TEMP_TABLES " when analyzing the execution flow of the involved operations:

         

         

"Images/data in this KBA from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental." 


Read more...

Environment

SAP HANA Platform Edition 2.0

Product

SAP HANA, platform edition 2.0

Keywords

KBA , HAN-DB-SDA , SAP HANA Smart Data Access , HAN-DB-ENG , SAP HANA DB Engines , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.