2520667 - Impala Adapter: Creating a Virtual Table with an Impala Reserved Word causes Virtual Table to fail | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2520667 - Impala Adapter: Creating a Virtual Table with an Impala Reserved Word causes Virtual Table to fail

Symptom

When using the Impala Adapter, while creating a virtual table that contains an Impala “reserved words” on an Impala table or column name, the virtual table creation fails with errors.  The error trace below is an example of an error when you attempt to create a virtual table on Impala Tables names "data" and "replication" respectively:

[TRACE] DPFramework | WorkerThread.processImportMetadata  - Request Body:       "qadb"."data"
[ERROR] DPFramework | WorkerThread.processRequest  - AdapterException while processing request "SDA Request for ImpalaAdapter of type MDS_IMPORT"
[ERROR] DPFramework | WorkerThread.processRequest  - Could not find table "qadb"."data". Context: null
                                com.sap.hana.dp.adapter.sdk.AdapterException: Could not find table "qadb"."data".
                                        at com.sap.hana.dp.impalaadapter.ImpalaAdapter.importMetadata(ImpalaAdapter.java:241)
                                        at com.sap.hana.dp.adapter.framework.core.WorkerThread.processImportMetadata(WorkerThread.java:1507)
                                        at com.sap.hana.dp.adapter.framework.core.WorkerThread.processRequest(WorkerThread.java:221)
                                        at com.sap.hana.dp.adapter.framework.core.WorkerThread.run(WorkerThread.java:1822)
                                        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
                                        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
                                        at java.lang.Thread.run(Thread.java:805)
 
[TRACE] DPFramework | WorkerThread.processImportMetadata  - Request Body:       "qadb"."replication"
[ERROR] DPFramework | WorkerThread.processRequest  - AdapterException while processing request "SDA Request for ImpalaAdapter of type MDS_IMPORT"
[ERROR] DPFramework | WorkerThread.processRequest  - Could not find table "qadb"."replication". Context: null
                                com.sap.hana.dp.adapter.sdk.AdapterException: Could not find table "qadb"."replication".
                                        at com.sap.hana.dp.impalaadapter.ImpalaAdapter.importMetadata(ImpalaAdapter.java:241)
                                        at com.sap.hana.dp.adapter.framework.core.WorkerThread.processImportMetadata(WorkerThread.java:1507)
                                        at com.sap.hana.dp.adapter.framework.core.WorkerThread.processRequest(WorkerThread.java:221)
                                        at com.sap.hana.dp.adapter.framework.core.WorkerThread.run(WorkerThread.java:1822)
                                        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
                                        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
                                        at java.lang.Thread.run(Thread.java:805)

 


Read more...

Environment

SAP HANA Smart Data Integration

Data Provisioning Agent with Impala Adapter

Product

SAP HANA 1.0 smart data integration ; SAP HANA smart data integration 2.0

Keywords

han-dp-sdi, sdi, dpagent , KBA , HAN-DP-SDI , SAP HANA smart data integration , Problem

About this page

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

Search for additional results

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