Share via

ADF Oracle Dynamic Range Partition Option

BrokenCranium 96 Reputation points
2021-08-13T19:51:45.913+00:00

POS_TABLE does not have any partitions. I am using the ora_hash function to generate as per the help documentation. Listed below is the error I keep running into.

ERROR [42S22] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]ORA-00904: "NUM_RECORDS": invalid identifier.

The ADF config is listed below.
123137-screen-shot-2021-08-13-at-113956-am.png

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,639 questions
0 comments
Accepted answer
  1. BrokenCranium 96 Reputation points
    2021-08-13T21:47:08.703+00:00

    I replaced the partition column value NUM_RECORDS with mod(ora_hash(STORE_NUM),4). It does not err anymore.

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.