[BUG] Issues found by Spark UT Framework on RapidsJsonSuite

[binmahone]

Describe the bug

Spark UT Framework enabled RapidsJsonSuite (#10743), with the following test cases explicitly excluded:

• Casting long as timestamp
• Write timestamps correctly with timestampFormat option and timeZone option
• SPARK-23723: json in UTF-16 with BOM [FEA] Access test files in resources from Spark source code when running Spark UT #10875
• SPARK-23723: multi-line json in UTF-32BE with BOM
• SPARK-23723: Use user's encoding in reading of multi-line json in UTF-16LE
• SPARK-23723: Unsupported encoding name
• SPARK-23723: checking that the encoding option is case agnostic
• SPARK-23723: specified encoding is not matched to actual encoding
• SPARK-23724: lineSep should be set if encoding if different from UTF-8
• SPARK-31716: inferring should handle malformed input [FEA] Access test files in resources from Spark source code when running Spark UT #10875
• SPARK-24190: restrictions for JSONOptions in read [FEA] Access test files in resources from Spark source code when running Spark UT #10875
• exception mode for parsing date/timestamp string
• Spark UT failed: SPARK-37360: Timestamp type inference for a mix of TIMESTAMP_NTZ and TIMESTAMP_LTZ #10902

These excluded test cases needs further investigating!!!
Notice: Other test cases in this suite may pass with falling back!

Steps/Code to reproduce bug

1. Compile everything with mvn -Dbuildver=330 install -DskipTests
2. Pick a test case name in the above table
3. Go to RapidsTestSettings and find the line starting with ".exclude" and containing the test case name, comment it out
4. Run the Suite then you'll see one failed test case. E.g. mvn -nsu -Dbuildver=330 -pl tests -Dsuites="org.apache.spark.sql.rapids.suites.RapidsXXXSuite" test (replace RapidsXXXSuite with the right name in issue header). ALWAYS double check if your suite name coincide with in source code, as it may contain typos!

Expected behavior
The suite can pass without excluding any test case.