Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hive insert/select errors out after final partition updated

Hive insert/select errors out after final partition updated

Explorer

Hive insert/select errors out after final partition updated


Hive job completes and partitions are loaded but job returns error after last partition (client_id=9950)

INFO  : Partition sin_ci_raw_prod.interaction__x{interaction_year=2015, interaction_type=WEB, client_id=990} stats: [numFiles=1, numRows=43210, totalSize=6007511, rawDataSize=5574090]
INFO  : Partition sin_ci_raw_prod.interaction__x{interaction_year=2015, interaction_type=WEB, client_id=994} stats: [numFiles=1, numRows=325710, totalSize=50857506, rawDataSize=42016590]
INFO  : Partition sin_ci_raw_prod.interaction__x{interaction_year=2015, interaction_type=WEB, client_id=9950} stats: [numFiles=1, numRows=8470, totalSize=1112314, rawDataSize=1092630]
INFO  : [Warning] could not update stats.Failed with exception Unable to alter partition. java.net.SocketTimeoutException: Read timed out
org.apache.hadoop.hive.ql.metadata.HiveException: Unable to alter partition. java.net.SocketTimeoutException: Read timed out


--       
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.thrift.transport.TTransportException: java.net.SocketTimeoutException: Read timed out

        at sun.reflect.GeneratedMethodAccessor91.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:91)
        at com.sun.proxy.$Proxy10.alter_partitions(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor91.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at org.apache.hadoop.hive.metastore.HiveMetaStoreClient$SynchronizedHandler.invoke(HiveMetaStoreClient.java:1909)
        at com.sun.proxy.$Proxy10.alter_partitions(Unknown Source)
        at org.apache.hadoop.hive.ql.metadata.Hive.alterPartitions(Hive.java:598)
        ... 21 more
Caused by: java.net.SocketTimeoutException: Read timed out