Skip to content

Inserting values into a table causes error with Hive 3.1.3 with Hadoop stack 3.3.6 #26

@SteBaum

Description

@SteBaum

Inserting with beeline values in a newly created table throughs the following error:

0: jdbc:hive2://master-01.tdp:2181,master-02.> INSERT INTO TABLE table1 VALUES (1, 'one'), (2, 'two');
15:29:50.855 [main] DEBUG org.apache.hive.jdbc.logs.InPlaceUpdateStream$EventNotifier - progress bar is complete
Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask (state=08S01,code=1)

Here is the error in the Hive2Server logs

15:30:46.954 [json-metric-reporter] DEBUG org.apache.hadoop.security.UserGroupInformation - PrivilegedAction [as: hive (auth:PROXY) via hive/master-02.tdp@REALM.TDP (auth:KERBEROS)][action: org.apache.hive.service.cli.session.HiveSessionProxy$1@1b5ecf63]
java.lang.Exception: null
        at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1896)
        at org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:59)
        at com.sun.proxy.$Proxy70.getNoOperationTime(Unknown Source)
        at org.apache.hive.service.cli.session.SessionManager$3$1.apply(SessionManager.java:149)
        at org.apache.hive.service.cli.session.SessionManager$3$1.apply(SessionManager.java:146)
        at com.google.common.collect.Iterators$7.computeNext(Iterators.java:675)
        at com.google.common.collect.AbstractIterator.tryToComputeNext(AbstractIterator.java:143)
        at com.google.common.collect.AbstractIterator.hasNext(AbstractIterator.java:138)
        at com.google.common.collect.Iterators.size(Iterators.java:200)
        at com.google.common.collect.Iterables.size(Iterables.java:107)
        at org.apache.hive.service.cli.session.SessionManager$3.getValue(SessionManager.java:152)
        at org.apache.hive.service.cli.session.SessionManager$3.getValue(SessionManager.java:143)
        at org.apache.hadoop.hive.common.metrics.metrics2.MetricVariableRatioGauge.getRatio(MetricVariableRatioGauge.java:40)
        at com.codahale.metrics.RatioGauge.getValue(RatioGauge.java:64)
        at com.codahale.metrics.RatioGauge.getValue(RatioGauge.java:11)
        at com.codahale.metrics.json.MetricsModule$GaugeSerializer.serialize(MetricsModule.java:32)
        at com.codahale.metrics.json.MetricsModule$GaugeSerializer.serialize(MetricsModule.java:20)
        at com.fasterxml.jackson.databind.ser.std.MapSerializer.serializeFields(MapSerializer.java:808)
        at com.fasterxml.jackson.databind.ser.std.MapSerializer.serializeWithoutTypeInfo(MapSerializer.java:764)
        at com.fasterxml.jackson.databind.ser.std.MapSerializer.serialize(MapSerializer.java:720)
        at com.fasterxml.jackson.databind.ser.std.MapSerializer.serialize(MapSerializer.java:35)
        at com.fasterxml.jackson.databind.ser.DefaultSerializerProvider._serialize(DefaultSerializerProvider.java:480)
        at com.fasterxml.jackson.databind.ser.DefaultSerializerProvider.serializeValue(DefaultSerializerProvider.java:319)
        at com.fasterxml.jackson.databind.ObjectMapper.writeValue(ObjectMapper.java:3126)
        at com.fasterxml.jackson.core.base.GeneratorBase.writeObject(GeneratorBase.java:388)
        at com.fasterxml.jackson.core.JsonGenerator.writeObjectField(JsonGenerator.java:1881)
        at com.codahale.metrics.json.MetricsModule$MetricRegistrySerializer.serialize(MetricsModule.java:186)
        at com.codahale.metrics.json.MetricsModule$MetricRegistrySerializer.serialize(MetricsModule.java:171)
        at com.fasterxml.jackson.databind.ser.DefaultSerializerProvider._serialize(DefaultSerializerProvider.java:480)
        at com.fasterxml.jackson.databind.ser.DefaultSerializerProvider.serializeValue(DefaultSerializerProvider.java:319)
        at com.fasterxml.jackson.databind.ObjectWriter$Prefetch.serialize(ObjectWriter.java:1514)
        at com.fasterxml.jackson.databind.ObjectWriter._writeValueAndClose(ObjectWriter.java:1215)
        at com.fasterxml.jackson.databind.ObjectWriter.writeValueAsString(ObjectWriter.java:1085)
        at org.apache.hadoop.hive.common.metrics.metrics2.JsonFileMetricsReporter.run(JsonFileMetricsReporter.java:143)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:750)
        ```

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions