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

Fri, 01 Jan 2021 03:57:37 -0800 


     [ 
https://issues.apache.org/jira/browse/HIVE-24576?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

appleyuchi updated HIVE-24576:
------------------------------
    Description: 
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>

I have googled relevant information,but no luck

need support,
thanks for your help~




  was:
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>







> 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
>            Priority: Critical
>
> 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>
> I have googled relevant information,but no luck
> need support,
> thanks for your help~



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

Reply via email to