2017-04-14 07:49:30,254 INFO [pool-5-thread-197]: metastore.ObjectStore (ObjectStore.java:writeMTableColumnStatistics(6003)) - Updating table level column statistics for db=milestone tableName=tt_dw_shipment_line_milestone_combined_fact_orc colName=mlstn_54_actual_date_utc 2017-04-14 07:49:30,255 INFO [pool-5-thread-197]: metastore.ObjectStore (ObjectStore.java:writeMTableColumnStatistics(6003)) - Updating table level column statistics for db=milestone tableName=tt_dw_shipment_line_milestone_combined_fact_orc colName=mlstn_54_actual_date_dim_id 2017-04-14 07:49:30,255 INFO [pool-5-thread-197]: metastore.ObjectStore (ObjectStore.java:writeMTableColumnStatistics(6003)) - Updating table level column statistics for db=milestone tableName=tt_dw_shipment_line_milestone_combined_fact_orc colName=mlstn_54_outlook_date_utc 2017-04-14 07:49:30,256 INFO [pool-5-thread-197]: metastore.ObjectStore (ObjectStore.java:writeMTableColumnStatistics(6003)) - Updating table level column statistics for db=milestone tableName=tt_dw_shipment_line_milestone_combined_fact_orc colName=mlstn_54_outlook_date_utc_date_dim_id 2017-04-14 07:49:30,266 INFO [pool-5-thread-197]: metastore.ObjectStore (ObjectStore.java:writeMTableColumnStatistics(6003)) - Updating table level column statistics for db=milestone tableName=tt_dw_shipment_line_milestone_combined_fact_orc colName=mlstn_54_model_date_utc 2017-04-14 07:49:30,266 INFO [pool-5-thread-197]: metastore.ObjectStore (ObjectStore.java:writeMTableColumnStatistics(6003)) - Updating table level column statistics for db=milestone tableName=tt_dw_shipment_line_milestone_combined_fact_orc colName=mlstn_54_location_city_dim_id 2017-04-14 07:49:30,267 INFO [pool-5-thread-197]: metastore.ObjectStore (ObjectStore.java:writeMTableColumnStatistics(6003)) - Updating table level column statistics for db=milestone tableName=tt_dw_shipment_line_milestone_combined_fact_orc colName=mlstn_54_owner_org_dim_id 2017-04-14 07:49:30,267 INFO [pool-5-thread-197]: metastore.ObjectStore (ObjectStore.java:writeMTableColumnStatistics(6003)) - Updating table level column statistics for db=milestone tableName=tt_dw_shipment_line_milestone_combined_fact_orc colName=mlstn_54_quantity 2017-04-14 07:49:30,302 ERROR [pool-5-thread-197]: metastore.RetryingHMSHandler (RetryingHMSHandler.java:invokeInternal(201)) - HMSHandler Fatal error: javax.jdo.JDODataStoreException: Cannot set Object parameter: value = Infinity for column "`TAB_COL_STATS`.`DOUBLE_HIGH_VALUE`" : 'Infinity' is not a valid numeric or approximate numeric value at org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:543) at org.datanucleus.api.jdo.JDOPersistenceManager.jdoMakePersistent(JDOPersistenceManager.java:720) at org.datanucleus.api.jdo.JDOPersistenceManager.makePersistent(JDOPersistenceManager.java:740) at org.apache.hadoop.hive.metastore.ObjectStore.writeMTableColumnStatistics(ObjectStore.java:6010) at org.apache.hadoop.hive.metastore.ObjectStore.updateTableColumnStatistics(ObjectStore.java:6089) at sun.reflect.GeneratedMethodAccessor50.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.RawStoreProxy.invoke(RawStoreProxy.java:103) at com.sun.proxy.$Proxy13.updateTableColumnStatistics(Unknown Source) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.update_table_column_statistics(HiveMetaStore.java:4513) at sun.reflect.GeneratedMethodAccessor49.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.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:139) at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:97) at com.sun.proxy.$Proxy15.update_table_column_statistics(Unknown Source) at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$update_table_column_statistics.getResult(ThriftHiveMetastore.java:10862) at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$update_table_column_statistics.getResult(ThriftHiveMetastore.java:10846) at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) at org.apache.hadoop.hive.metastore.TUGIBasedProcessor$1.run(TUGIBasedProcessor.java:110) at org.apache.hadoop.hive.metastore.TUGIBasedProcessor$1.run(TUGIBasedProcessor.java:106) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:415) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1724) at org.apache.hadoop.hive.metastore.TUGIBasedProcessor.process(TUGIBasedProcessor.java:118) at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286) 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) NestedThrowablesStackTrace: java.sql.SQLException: 'Infinity' is not a valid numeric or approximate numeric value at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927) at com.mysql.jdbc.PreparedStatement.setDouble(PreparedStatement.java:3643) at com.jolbox.bonecp.PreparedStatementHandle.setDouble(PreparedStatementHandle.java:788) at org.datanucleus.store.rdbms.ParamLoggingPreparedStatement.setDouble(ParamLoggingPreparedStatement.java:720) at org.datanucleus.store.rdbms.mapping.datastore.DoubleRDBMSMapping.setObject(DoubleRDBMSMapping.java:244) at org.datanucleus.store.rdbms.mapping.java.SingleFieldMapping.setObject(SingleFieldMapping.java:190) at org.datanucleus.store.rdbms.fieldmanager.ParameterSetter.storeObjectField(ParameterSetter.java:195) at org.datanucleus.state.AbstractStateManager.providedObjectField(AbstractStateManager.java:1460) at org.datanucleus.state.StateManagerImpl.providedObjectField(StateManagerImpl.java:120) at org.apache.hadoop.hive.metastore.model.MTableColumnStatistics.dnProvideField(MTableColumnStatistics.java) at org.apache.hadoop.hive.metastore.model.MTableColumnStatistics.dnProvideFields(MTableColumnStatistics.java) at org.datanucleus.state.StateManagerImpl.provideFields(StateManagerImpl.java:1170) at org.datanucleus.store.rdbms.request.InsertRequest.execute(InsertRequest.java:292) at org.datanucleus.store.rdbms.RDBMSPersistenceHandler.insertObjectInTable(RDBMSPersistenceHandler.java:162) at org.datanucleus.store.rdbms.RDBMSPersistenceHandler.insertObject(RDBMSPersistenceHandler.java:138) at org.datanucleus.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3363) at org.datanucleus.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3339) at org.datanucleus.ExecutionContextImpl.persistObjectInternal(ExecutionContextImpl.java:2079) at org.datanucleus.ExecutionContextImpl.persistObjectWork(ExecutionContextImpl.java:1922) at org.datanucleus.ExecutionContextImpl.persistObject(ExecutionContextImpl.java:1777) at org.datanucleus.ExecutionContextThreadedImpl.persistObject(ExecutionContextThreadedImpl.java:217) at org.datanucleus.api.jdo.JDOPersistenceManager.jdoMakePersistent(JDOPersistenceManager.java:715) at org.datanucleus.api.jdo.JDOPersistenceManager.makePersistent(JDOPersistenceManager.java:740) at org.apache.hadoop.hive.metastore.ObjectStore.writeMTableColumnStatistics(ObjectStore.java:6010) at org.apache.hadoop.hive.metastore.ObjectStore.updateTableColumnStatistics(ObjectStore.java:6089) at sun.reflect.GeneratedMethodAccessor50.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.RawStoreProxy.invoke(RawStoreProxy.java:103) at com.sun.proxy.$Proxy13.updateTableColumnStatistics(Unknown Source) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.update_table_column_statistics(HiveMetaStore.java:4513) at sun.reflect.GeneratedMethodAccessor49.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.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:139) at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:97) at com.sun.proxy.$Proxy15.update_table_column_statistics(Unknown Source) at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$update_table_column_statistics.getResult(ThriftHiveMetastore.java:10862) at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$update_table_column_statistics.getResult(ThriftHiveMetastore.java:10846) at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) at org.apache.hadoop.hive.metastore.TUGIBasedProcessor$1.run(TUGIBasedProcessor.java:110) at org.apache.hadoop.hive.metastore.TUGIBasedProcessor$1.run(TUGIBasedProcessor.java:106) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:415) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1724) at org.apache.hadoop.hive.metastore.TUGIBasedProcessor.process(TUGIBasedProcessor.java:118) at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286) 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) 2017-04-14 07:49:35,305 INFO [pool-5-thread-197]: metastore.HiveMetaStore (HiveMetaStore.java:logInfo(822)) - 197: Shutting down the object store... 2017-04-14 07:49:35,305 INFO [pool-5-thread-197]: HiveMetaStore.audit (HiveMetaStore.java:logAuditEvent(391)) - ugi=lzhang ip=10.237.214.121 cmd=Shutting down the object store... 2017-04-14 07:49:35,330 INFO [pool-5-thread-197]: metastore.HiveMetaStore (HiveMetaStore.java:logInfo(822)) - 197: Metastore shutdown complete. 2017-04-14 07:49:35,330 INFO [pool-5-thread-197]: HiveMetaStore.audit (HiveMetaStore.java:logAuditEvent(391)) - ugi=lzhang ip=10.237.214.121 cmd=Metastore shutdown complete. 2017-04-14 07:49:48,017 INFO [pool-5-thread-197]: metastore.HiveMetaStore (HiveMetaStore.java:logInfo(822)) - 197: source:10.237.214.121 get_all_databases 2017-04-14 07:49:48,017 INFO [pool-5-thread-197]: HiveMetaStore.audit (HiveMetaStore.java:logAuditEvent(391)) - ugi=ambari-qa ip=10.237.214.121 cmd=source:10.237.214.121 get_all_databases 2017-04-14 07:49:48,017 INFO [pool-5-thread-197]: metastore.HiveMetaStore (HiveMetaStore.java:newRawStore(665)) - 197: Opening raw store with implemenation class:org.apache.hadoop.hive.metastore.ObjectStore 2017-04-14 07:49:48,018 INFO [pool-5-thread-197]: metastore.ObjectStore (ObjectStore.java:initialize(299)) - ObjectStore, initialize called 2017-04-14 07:49:48,022 INFO [pool-5-thread-197]: metastore.MetaStoreDirectSql (MetaStoreDirectSql.java:(139)) - Using direct SQL, underlying DB is MYSQL 2017-04-14 07:49:48,022 INFO [pool-5-thread-197]: metastore.ObjectStore (ObjectStore.java:setConf(282)) - Initialized ObjectStore 2017-04-14 07:49:48,026 INFO [pool-5-thread-197]: metastore.HiveMetaStore (HiveMetaStore.java:logInfo(822)) - 197: source:10.237.214.121 get_functions: db=bookingpoc pat=* 2017-04-14 07:49:48,026 INFO [pool-5-thread-197]: HiveMetaStore.audit (HiveMetaStore.java:logAuditEvent(391)) - ugi=ambari-qa ip=10.237.214.121 cmd=source:10.237.214.121 get_functions: db=bookingpoc pat=* 2017-04-14 07:49:48,028 INFO [pool-5-thread-197]: metastore.HiveMetaStore (HiveMetaStore.java:logInfo(822)) - 197: source:10.237.214.121 get_functions: db=contracts_common pat=* 2017-04-14 07:49:48,028 INFO [pool-5-thread-197]: HiveMetaStore.audit (HiveMetaStore.java:logAuditEvent(391)) - ugi=ambari-qa ip=10.237.214.121 cmd=source:10.237.214.121 get_functions: db=contracts_common pat=* 2017-04-14 07:49:48,029 INFO [pool-5-thread-197]: metastore.HiveMetaStore (HiveMetaStore.java:logInfo(822)) - 197: source:10.237.214.121 get_functions: db=default pat=* ....................... 2017-04-14 07:55:59,632 INFO [pool-5-thread-197]: metastore.ObjectStore (ObjectStore.java:writeMTableColumnStatistics(6003)) - Updating table level column statistics for db=milestone tableName=tt_dw_shipment_line_milestone_combined_fact_orc colName=mlstn_54_quantity 2017-04-14 07:55:59,661 ERROR [pool-5-thread-197]: metastore.RetryingHMSHandler (RetryingHMSHandler.java:invokeInternal(209)) - Retrying HMSHandler after 2000 ms (attempt 2 of 10) with error: javax.jdo.JDODataStoreException: Cannot set Object parameter: value = Infinity for column "`TAB_COL_STATS`.`DOUBLE_HIGH_VALUE`" : 'Infinity' is not a valid numeric or approximate numeric value at org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:543) at org.datanucleus.api.jdo.JDOPersistenceManager.jdoMakePersistent(JDOPersistenceManager.java:720) at org.datanucleus.api.jdo.JDOPersistenceManager.makePersistent(JDOPersistenceManager.java:740) at org.apache.hadoop.hive.metastore.ObjectStore.writeMTableColumnStatistics(ObjectStore.java:6010) at org.apache.hadoop.hive.metastore.ObjectStore.updateTableColumnStatistics(ObjectStore.java:6089) at sun.reflect.GeneratedMethodAccessor50.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.RawStoreProxy.invoke(RawStoreProxy.java:103) at com.sun.proxy.$Proxy13.updateTableColumnStatistics(Unknown Source) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.update_table_column_statistics(HiveMetaStore.java:4513) at sun.reflect.GeneratedMethodAccessor49.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.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:139) at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:97) at com.sun.proxy.$Proxy15.update_table_column_statistics(Unknown Source) at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$update_table_column_statistics.getResult(ThriftHiveMetastore.java:10862) at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$update_table_column_statistics.getResult(ThriftHiveMetastore.java:10846) at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) at org.apache.hadoop.hive.metastore.TUGIBasedProcessor$1.run(TUGIBasedProcessor.java:110) at org.apache.hadoop.hive.metastore.TUGIBasedProcessor$1.run(TUGIBasedProcessor.java:106) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:415) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1724) at org.apache.hadoop.hive.metastore.TUGIBasedProcessor.process(TUGIBasedProcessor.java:118) at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286) 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) NestedThrowablesStackTrace: java.sql.SQLException: 'Infinity' is not a valid numeric or approximate numeric value at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927) at com.mysql.jdbc.PreparedStatement.setDouble(PreparedStatement.java:3643) at com.jolbox.bonecp.PreparedStatementHandle.setDouble(PreparedStatementHandle.java:788) at org.datanucleus.store.rdbms.ParamLoggingPreparedStatement.setDouble(ParamLoggingPreparedStatement.java:720) at org.datanucleus.store.rdbms.mapping.datastore.DoubleRDBMSMapping.setObject(DoubleRDBMSMapping.java:244) at org.datanucleus.store.rdbms.mapping.java.SingleFieldMapping.setObject(SingleFieldMapping.java:190) at org.datanucleus.store.rdbms.fieldmanager.ParameterSetter.storeObjectField(ParameterSetter.java:195) at org.datanucleus.state.AbstractStateManager.providedObjectField(AbstractStateManager.java:1460) at org.datanucleus.state.StateManagerImpl.providedObjectField(StateManagerImpl.java:120) at org.apache.hadoop.hive.metastore.model.MTableColumnStatistics.dnProvideField(MTableColumnStatistics.java) at org.apache.hadoop.hive.metastore.model.MTableColumnStatistics.dnProvideFields(MTableColumnStatistics.java) at org.datanucleus.state.StateManagerImpl.provideFields(StateManagerImpl.java:1170) at org.datanucleus.store.rdbms.request.InsertRequest.execute(InsertRequest.java:292) at org.datanucleus.store.rdbms.RDBMSPersistenceHandler.insertObjectInTable(RDBMSPersistenceHandler.java:162) at org.datanucleus.store.rdbms.RDBMSPersistenceHandler.insertObject(RDBMSPersistenceHandler.java:138) at org.datanucleus.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3363) at org.datanucleus.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3339) at org.datanucleus.ExecutionContextImpl.persistObjectInternal(ExecutionContextImpl.java:2079) at org.datanucleus.ExecutionContextImpl.persistObjectWork(ExecutionContextImpl.java:1922) at org.datanucleus.ExecutionContextImpl.persistObject(ExecutionContextImpl.java:1777) at org.datanucleus.ExecutionContextThreadedImpl.persistObject(ExecutionContextThreadedImpl.java:217) at org.datanucleus.api.jdo.JDOPersistenceManager.jdoMakePersistent(JDOPersistenceManager.java:715) at org.datanucleus.api.jdo.JDOPersistenceManager.makePersistent(JDOPersistenceManager.java:740) at org.apache.hadoop.hive.metastore.ObjectStore.writeMTableColumnStatistics(ObjectStore.java:6010) at org.apache.hadoop.hive.metastore.ObjectStore.updateTableColumnStatistics(ObjectStore.java:6089) at sun.reflect.GeneratedMethodAccessor50.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.RawStoreProxy.invoke(RawStoreProxy.java:103) at com.sun.proxy.$Proxy13.updateTableColumnStatistics(Unknown Source) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.update_table_column_statistics(HiveMetaStore.java:4513) at sun.reflect.GeneratedMethodAccessor49.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.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:139) at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:97) at com.sun.proxy.$Proxy15.update_table_column_statistics(Unknown Source) at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$update_table_column_statistics.getResult(ThriftHiveMetastore.java:10862) at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$update_table_column_statistics.getResult(ThriftHiveMetastore.java:10846) at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) at org.apache.hadoop.hive.metastore.TUGIBasedProcessor$1.run(TUGIBasedProcessor.java:110) at org.apache.hadoop.hive.metastore.TUGIBasedProcessor$1.run(TUGIBasedProcessor.java:106) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:415) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1724) at org.apache.hadoop.hive.metastore.TUGIBasedProcessor.process(TUGIBasedProcessor.java:118) at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) .............. 2017-04-14 07:56:01,666 INFO [pool-5-thread-197]: HiveMetaStore.audit (HiveMetaStore.java:logAuditEvent(391)) - ugi=lzhang ip=10.237.214.121 cmd=source:10.237.214.121 write_column_statistics: db=milestone table=tt_dw_shipment_line_milestone_combined_fact_orc column=mlstn_2_quantity 2017-04-14 07:56:01,666 INFO [pool-5-thread-197]: metastore.HiveMetaStore (HiveMetaStore.java:logInfo(822)) - 197: source:10.237.214.121 write_column_statistics: db=milestone table=tt_dw_shipment_line_milestone_combined_fact_orc column=mlstn_3_actual_date_utc 2017-04-14 07:56:01,666 INFO [pool-5-thread-197]: HiveMetaStore.audit (HiveMetaStore.java:logAuditEvent(391)) - ugi=lzhang ip=10.237.214.121 cmd=source:10.237.214.121 write_column_statistics: db=milestone table=tt_dw_shipment_line_milestone_combined_fact_orc column=mlstn_3_actual_date_utc 2017-04-14 07:56:01,666 INFO [pool-5-thread-197]: metastore.HiveMetaStore (HiveMetaStore.java:logInfo(822)) - 197: source:10.237.214.121 write_column_statistics: db=milestone table=tt_dw_shipment_line_milestone_combined_fact_orc column=mlstn_3_actual_date_dim_id ....... 2017-04-14 07:56:36,741 INFO [pool-5-thread-197]: metastore.ObjectStore (ObjectStore.java:writeMTableColumnStatistics(6003)) - Updating table level column statistics for db=milestone tableName=tt_dw_shipment_line_milestone_combined_fact_orc colName=mlstn_54_owner_org_dim_id 2017-04-14 07:56:36,742 INFO [pool-5-thread-197]: metastore.ObjectStore (ObjectStore.java:writeMTableColumnStatistics(6003)) - Updating table level column statistics for db=milestone tableName=tt_dw_shipment_line_milestone_combined_fact_orc colName=mlstn_54_quantity 2017-04-14 07:56:36,771 ERROR [pool-5-thread-197]: metastore.RetryingHMSHandler (RetryingHMSHandler.java:invokeInternal(201)) - HMSHandler Fatal error: javax.jdo.JDODataStoreException: Cannot set Object parameter: value = Infinity for column "`TAB_COL_STATS`.`DOUBLE_HIGH_VALUE`" : 'Infinity' is not a valid numeric or approximate numeric value at org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:543) at org.datanucleus.api.jdo.JDOPersistenceManager.jdoMakePersistent(JDOPersistenceManager.java:720) at org.datanucleus.api.jdo.JDOPersistenceManager.makePersistent(JDOPersistenceManager.java:740) at org.apache.hadoop.hive.metastore.ObjectStore.writeMTableColumnStatistics(ObjectStore.java:6010) at org.apache.hadoop.hive.metastore.ObjectStore.updateTableColumnStatistics(ObjectStore.java:6089) at sun.reflect.GeneratedMethodAccessor50.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.RawStoreProxy.invoke(RawStoreProxy.java:103) at com.sun.proxy.$Proxy13.updateTableColumnStatistics(Unknown Source) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.update_table_column_statistics(HiveMetaStore.java:4513) at sun.reflect.GeneratedMethodAccessor49.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.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:139) at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:97) at com.sun.proxy.$Proxy15.update_table_column_statistics(Unknown Source) at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$update_table_column_statistics.getResult(ThriftHiveMetastore.java:10862) at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$update_table_column_statistics.getResult(ThriftHiveMetastore.java:10846) at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) at org.apache.hadoop.hive.metastore.TUGIBasedProcessor$1.run(TUGIBasedProcessor.java:110) at org.apache.hadoop.hive.metastore.TUGIBasedProcessor$1.run(TUGIBasedProcessor.java:106) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:415) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1724) at org.apache.hadoop.hive.metastore.TUGIBasedProcessor.process(TUGIBasedProcessor.java:118) at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286) 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) NestedThrowablesStackTrace: java.sql.SQLException: 'Infinity' is not a valid numeric or approximate numeric value at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927) at com.mysql.jdbc.PreparedStatement.setDouble(PreparedStatement.java:3643) at com.jolbox.bonecp.PreparedStatementHandle.setDouble(PreparedStatementHandle.java:788) at org.datanucleus.store.rdbms.ParamLoggingPreparedStatement.setDouble(ParamLoggingPreparedStatement.java:720) at org.datanucleus.store.rdbms.mapping.datastore.DoubleRDBMSMapping.setObject(DoubleRDBMSMapping.java:244) at org.datanucleus.store.rdbms.mapping.java.SingleFieldMapping.setObject(SingleFieldMapping.java:190) at org.datanucleus.store.rdbms.fieldmanager.ParameterSetter.storeObjectField(ParameterSetter.java:195) at org.datanucleus.state.AbstractStateManager.providedObjectField(AbstractStateManager.java:1460) at org.datanucleus.state.StateManagerImpl.providedObjectField(StateManagerImpl.java:120) at org.apache.hadoop.hive.metastore.model.MTableColumnStatistics.dnProvideField(MTableColumnStatistics.java) at org.apache.hadoop.hive.metastore.model.MTableColumnStatistics.dnProvideFields(MTableColumnStatistics.java) at org.datanucleus.state.StateManagerImpl.provideFields(StateManagerImpl.java:1170) at org.datanucleus.store.rdbms.request.InsertRequest.execute(InsertRequest.java:292) at org.datanucleus.store.rdbms.RDBMSPersistenceHandler.insertObjectInTable(RDBMSPersistenceHandler.java:162) at org.datanucleus.store.rdbms.RDBMSPersistenceHandler.insertObject(RDBMSPersistenceHandler.java:138) at org.datanucleus.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3363) at org.datanucleus.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3339) at org.datanucleus.ExecutionContextImpl.persistObjectInternal(ExecutionContextImpl.java:2079) at org.datanucleus.ExecutionContextImpl.persistObjectWork(ExecutionContextImpl.java:1922) at org.datanucleus.ExecutionContextImpl.persistObject(ExecutionContextImpl.java:1777) at org.datanucleus.ExecutionContextThreadedImpl.persistObject(ExecutionContextThreadedImpl.java:217) at org.datanucleus.api.jdo.JDOPersistenceManager.jdoMakePersistent(JDOPersistenceManager.java:715) at org.datanucleus.api.jdo.JDOPersistenceManager.makePersistent(JDOPersistenceManager.java:740) at org.apache.hadoop.hive.metastore.ObjectStore.writeMTableColumnStatistics(ObjectStore.java:6010) at org.apache.hadoop.hive.metastore.ObjectStore.updateTableColumnStatistics(ObjectStore.java:6089) at sun.reflect.GeneratedMethodAccessor50.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.RawStoreProxy.invoke(RawStoreProxy.java:103) at com.sun.proxy.$Proxy13.updateTableColumnStatistics(Unknown Source) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.update_table_column_statistics(HiveMetaStore.java:4513) at sun.reflect.GeneratedMethodAccessor49.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.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:139) at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:97) at com.sun.proxy.$Proxy15.update_table_column_statistics(Unknown Source) at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$update_table_column_statistics.getResult(ThriftHiveMetastore.java:10862) at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$update_table_column_statistics.getResult(ThriftHiveMetastore.java:10846) at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) at org.apache.hadoop.hive.metastore.TUGIBasedProcessor$1.run(TUGIBasedProcessor.java:110) at org.apache.hadoop.hive.metastore.TUGIBasedProcessor$1.run(TUGIBasedProcessor.java:106) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:415) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1724) at org.apache.hadoop.hive.metastore.TUGIBasedProcessor.process(TUGIBasedProcessor.java:118) at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286) 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) 2017-04-14 07:58:47,963 INFO [pool-5-thread-197]: metastore.HiveMetaStore (HiveMetaStore.java:logInfo(822)) - 197: source:10.237.214.121 get_all_databases 2017-04-14 07:58:47,963 INFO [pool-5-thread-197]: HiveMetaStore.audit (HiveMetaStore.java:logAuditEvent(391)) - ugi=ambari-qa ip=10.237.214.121 cmd=source:10.237.214.121 get_all_databases