CREATE EXTERNAL TABLE `inventory`( `inv_item_sk` int, `inv_warehouse_sk` int, `inv_quantity_on_hand` int) PARTITIONED BY ( `inv_date_sk` int) STORED AS ORC LOCATION 'xxx://fcbai001/';
报错:
Error: Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [xxx] does not have [READ] privilege on [xxx://fcbai001/] (state=42000,code=40000)
root# ./bin/hiveserver2 --debug 2022-01-29 15:33:47: Starting HiveServer2 Conflicting collector combinations in option list; please refer to the release notes for the combinations allowed Error: Could not create the Java Virtual Machine. Error: A fatal exception has occurred. Program will exit.
bool Arguments::check_gc_consistency() { bool status = true; // Ensure that the user has not selected conflicting sets // of collectors. [Note: this check is merely a user convenience; // collectors over-ride each other so that only a non-conflicting // set is selected; however what the user gets is not what they // may have expected from the combination they asked for. It's // better to reduce user confusion by not allowing them to // select conflicting combinations. uint i = 0; if (UseSerialGC) i++; if (UseConcMarkSweepGC || UseParNewGC) i++; if (UseParallelGC || UseParallelOldGC) i++; if (UseG1GC) i++; if (i > 1) { jio_fprintf(defaultStream::error_stream(), "Conflicting collector combinations in option list; " "please refer to the release notes for the combinations " "allowed\n"); status = false; }
./bin/hiveserver2 --debug 2022-01-29 16:06:55: Starting HiveServer2 Listening for transport dt_socket at address: 8000 SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in Äjar:file:/opt/tiger/current/hive-server2/lib/log4j-slf4j-impl-2.15.0.jar!/org/slf4j/impl/StaticLoggerBinder.classÅ SLF4J: Found binding in Äjar:file:/opt/tiger/current/hadoop/share/hadoop/common/lib/slf4j-log4j12-1.7.30.jar!/org/slf4j/impl/StaticLoggerBinder.classÅ SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type Äorg.apache.logging.slf4j.Log4jLoggerFactoryÅ Hive Session ID = bd213902-8c9d-45f7-8daa-bdfe90835e42 Hive Session ID = c7decf18-31a9-4f2f-a1ef-dd283a059a98