[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: Not a bug after setting correct timezone
• Write timestamps correctly with timestampFormat option and timeZone option: Not a bug after setting correct timezone
• 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: Not a bug after setting correct timezone
• Spark UT failed: SPARK-37360: Timestamp type inference for a mix of TIMESTAMP_NTZ and TIMESTAMP_LTZ #10902

GpuJsonScan issues after enabling spark.rapids.sql.format.json.read.enabled=true by #11141

• SPARK-32810: JSON data source should be able to read files with escaped glob metacharacter in the paths [BUG] CSV/JSON data sources should avoid globbing paths when inferring schema #11158
• SPARK-18352: Parse normal multi-line JSON files (uncompressed), from known json string to float issue, doc
• SPARK-18352: Parse normal multi-line JSON files (compressed), from known json string to float issue, doc
• Applying schemas, from known json string to float issue, doc
• Loading a JSON dataset from a text file with SQL, from known json string to float issue, doc
• Loading a JSON dataset from a text file, from known json string to float issue, doc

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.