[BUG] JNI nightly build failing after upgrade to Arrow 9.x

[jlowe]

Describe the bug
After #11507 the nightly cudf JNI and spark-rapids-jni builds have been failing, sample failure from the nightly cudf snapshot jar publishing build:

07:19:06       [exec] CMake Error at CMakeLists.txt:129 (add_library):
07:19:06       [exec]   Target "cudfjni" links to target "arrow::flatbuffers" but the target was
07:19:06       [exec]   not found.  Perhaps a find_package() call is missing for an IMPORTED
07:19:06       [exec]   target, or an ALIAS target is missing?
07:19:06       [exec] 
07:19:06       [exec] 
07:19:06       [exec] CMake Error at CMakeLists.txt:129 (add_library):
07:19:06       [exec]   Target "cudfjni" links to target "arrow::hadoop" but the target was not
07:19:06       [exec]   found.  Perhaps a find_package() call is missing for an IMPORTED target, or
07:19:06       [exec]   an ALIAS target is missing?
07:19:06       [exec] 
07:19:06       [exec] 
07:19:06       [exec] CMake Error at CMakeLists.txt:161 (add_library):
07:19:06       [exec]   Target "cudfjnistub" links to target "arrow::flatbuffers" but the target
07:19:06       [exec]   was not found.  Perhaps a find_package() call is missing for an IMPORTED
07:19:06       [exec]   target, or an ALIAS target is missing?
07:19:06       [exec] 
07:19:06       [exec] 
07:19:06       [exec] CMake Error at CMakeLists.txt:161 (add_library):
07:19:06       [exec]   Target "cudfjnistub" links to target "arrow::hadoop" but the target was not
07:19:06       [exec]   found.  Perhaps a find_package() call is missing for an IMPORTED target, or
07:19:06       [exec]   an ALIAS target is missing?
07:19:06       [exec] 
07:19:06       [exec] 
07:19:06       [exec] CMake Error at CMakeLists.txt:203 (add_library):
07:19:06       [exec]   Target "cufilejni" links to target "arrow::flatbuffers" but the target was
07:19:06       [exec]   not found.  Perhaps a find_package() call is missing for an IMPORTED
07:19:06       [exec]   target, or an ALIAS target is missing?
07:19:06       [exec] 
07:19:06       [exec] 
07:19:06       [exec] CMake Error at CMakeLists.txt:203 (add_library):
07:19:06       [exec]   Target "cufilejni" links to target "arrow::hadoop" but the target was not
07:19:06       [exec]   found.  Perhaps a find_package() call is missing for an IMPORTED target, or
07:19:06       [exec]   an ALIAS target is missing?
07:19:06       [exec] 
07:19:06       [exec] 
07:19:06       [exec] -- Generating done
07:19:06       [exec] CMake Generate step failed.  Build files cannot be regenerated correctly.

The JNI build does not explicitly depend on the things it is complaining about, these are transitive dependencies from depending on libcudf. Note that this is a build outside of the conda environment, with -DCUDF_USE_ARROW_STATIC_ON and -DBUILD_SHARED_LIBS=OFF. My guess is that something about the Arrow 9.x static configuration is causing cmake to get confused on how to find these transitive Arrow dependencies from the libcudf cpp/build area.

Steps/Code to reproduce bug
Follow the build instructions in the cudf Java CI README.

Expected behavior
Build should complete successfully.

Environment overview (please complete the following information)

• Docker environment
• Not building with Conda
• Static Arrow libraries with a static libcudf library build

[revans2]

Because of NVIDIA/spark-rapids-jni#479 I think this is now blocking a lot of work on spark-rapids.