You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "appleyuchi (Jira)" <ji...@apache.org> on 2021/01/01 11:56:00 UTC

[jira] [Created] (HIVE-24576) org.apache.thrift.transport.TTransportException when insert data in hive3.1.2

appleyuchi created HIVE-24576:
---------------------------------

             Summary: org.apache.thrift.transport.TTransportException when insert data in hive3.1.2
                 Key: HIVE-24576
                 URL: https://issues.apache.org/jira/browse/HIVE-24576
             Project: Hive
          Issue Type: Test
    Affects Versions: 3.1.2
            Reporter: appleyuchi


my error log is:

https://paste.ubuntu.com/p/y4N7RTtBz5/

when i try to insert some data in to internal table.

my hive-site.xml is

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
        <property>
                <name>javax.jdo.option.ConnectionURL</name>
                <value>jdbc:mysql://Desktop:3306/hive?useUnicode=true&amp;characterEncoding=utf8</value>(mysql地址localhost)
        </property>


        <property>
                <name>javax.jdo.option.ConnectionDriverName</name>(mysql的驱动)
                <value>com.mysql.cj.jdbc.Driver</value>
        </property>

        <property>
                <name>javax.jdo.option.ConnectionUserName</name>(用户名)
                <value>appleyuchi</value>
        </property>

        <property>
                <name>javax.jdo.option.ConnectionPassword</name>(密码)
                <value>appleyuchi</value>
        </property>
        <property>
                <name>datanucleus.schema.autoCreateAll</name>
                <value>true</value>
        </property>

        <property>
            <name>hive.metastore.uris</name>
            <value>thrift://Desktop:9083</value>
                <description>Thrift uri for the remote metastore. Used by metastore client to connect to remote metastore.</description>
        </property>

        <property>
                <name>hive.metastore.schema.verification</name>
                <value>false</value>
        </property>


        <property>
                <name>hive.map.aggr.hash.percentmemoryn</name>
                <value>0.25</value>
        </property>

        


<!-- 这是hiveserver2 -->
<property>
        <name>hive.server2.thrift.port</name>
        <value>10000</value>
</property>
 
<property>
        <name>hive.server2.thrift.bind.host</name>
        <value>Desktop</value>
</property>



<property>  
        <name>javax.jdo.option.ConnectionUserName</name>  
        <value>appleyuchi</value>  
        <description>ername to use against metastoredatabase</description>  
</property>  

<property>  
        <name>javax.jdo.option.ConnectionPassword</name>  
        <value>appleyuchi</value>  
        <description>password to use against metastoredatabase</description>  
</property>


<property>
    <name>hive.metastore.event.db.notification.api.auth</name>
    <value>false</value>
  </property>



   <property>
    <name>hive.server2.active.passive.ha.enable</name>
    <value>true</value>
  </property>

<property>
    <name>hive.support.concurrency</name>
    <value>true</value>
</property>


<property>
    <name>hive.txn.manager</name>
    <value>org.apache.hadoop.hive.ql.lockmgr.DbTxnManager</value>
</property>





<!-- 下面是给tez设置的 -->
<!-- <property>
    <name>hive.execution.engine</name>
    <value>tez</value>
</property>
 -->



<!-- 下面是给hive支持事务操作而设置的 -->

<property>
<name>hive.enforce.bucketing</name>
<value>true</value>
</property>
<property>
<name>hive.exec.dynamic.partition.mode</name>
<value>nonstrict</value>
</property>
<!-- <property>
<name>hive.txn.manager</name>
<value>org.apache.hadoop.hive.ql.lockmgr.DbTxnManager</value>
</property> -->
<property>
<name>hive.compactor.initiator.on</name>
<value>true</value>
</property>
<property>
<name>hive.compactor.worker.threads</name>
<value>1</value>
</property>

<!-- <property>
<name>hive.in.test</name>
<value>true</value>
</property>  -->

<property>
<name>hive.auto.convert.join.noconditionaltask.size</name>
<value>10000000</value>
</property>


<property>
<name>hive.server2.logging.operation.enabled</name>
<value>false</value>
</property>

</configuration>








--
This message was sent by Atlassian Jira
(v8.3.4#803005)