SAP Knowledge Base Article - Preview

2520667 - Impala Adapter: Creating a Virtual Table with an Impala Reserved Word causes Virtual Table to fail - SAP HANA Smart Data Integration

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

Product

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

Keywords

han-dp-sdi, sdi, dpagent, impala , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , 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.