2014-09-30 21:53:25,525 DEBUG [HiveServer2-Handler-Pool: Thread-49]: transport.TSaslTransport (TSaslTransport.java:readFrame(429)) - SERVER: reading data length: 125
2014-09-30 21:53:25,526 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4jLoggerAdapter.java:debug(252)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,526 DEBUG [HiveServer2-Handler-Pool: Thread-49]: security.UserGroupInformation (UserGroupInformation.java:logPrivilegedAction(1572)) - PrivilegedAction as:hduser (auth:SIMPLE) from:org.apache.hadoop.hive.shims.HadoopShimsSecure.doAs(HadoopShimsSecure.java:508)
2014-09-30 21:53:25,526 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,527 DEBUG [HiveServer2-Handler-Pool: Thread-49]: parse.VariableSubstitution (VariableSubstitution.java:substitute(53)) - Substitution is on: select * from foo7
2014-09-30 21:53:25,528 INFO [HiveServer2-Handler-Pool: Thread-49]: log.PerfLogger (PerfLogger.java:PerfLogBegin(108)) -
2014-09-30 21:53:25,529 DEBUG [HiveServer2-Handler-Pool: Thread-49]: parse.VariableSubstitution (VariableSubstitution.java:substitute(53)) - Substitution is on: select * from foo7
2014-09-30 21:53:25,529 INFO [HiveServer2-Handler-Pool: Thread-49]: log.PerfLogger (PerfLogger.java:PerfLogBegin(108)) -
2014-09-30 21:53:25,529 INFO [HiveServer2-Handler-Pool: Thread-49]: parse.ParseDriver (ParseDriver.java:parse(185)) - Parsing command: select * from foo7
2014-09-30 21:53:25,538 INFO [HiveServer2-Handler-Pool: Thread-49]: parse.ParseDriver (ParseDriver.java:parse(206)) - Parse Completed
2014-09-30 21:53:25,538 INFO [HiveServer2-Handler-Pool: Thread-49]: log.PerfLogger (PerfLogger.java:PerfLogEnd(135)) -
2014-09-30 21:53:25,538 INFO [HiveServer2-Handler-Pool: Thread-49]: log.PerfLogger (PerfLogger.java:PerfLogBegin(108)) -
2014-09-30 21:53:25,539 INFO [HiveServer2-Handler-Pool: Thread-49]: parse.SemanticAnalyzer (SemanticAnalyzer.java:analyzeInternal(9810)) - Starting Semantic Analysis
2014-09-30 21:53:25,539 INFO [HiveServer2-Handler-Pool: Thread-49]: parse.SemanticAnalyzer (SemanticAnalyzer.java:analyzeInternal(9845)) - Completed phase 1 of Semantic Analysis
2014-09-30 21:53:25,540 INFO [HiveServer2-Handler-Pool: Thread-49]: parse.SemanticAnalyzer (SemanticAnalyzer.java:getMetaData(1498)) - Get metadata for source tables
2014-09-30 21:53:25,565 DEBUG [HiveServer2-Handler-Pool: Thread-49]: exec.Utilities (Utilities.java:getSessionSpecifiedClassLoader(2050)) - Use session specified class loader
2014-09-30 21:53:25,565 DEBUG [HiveServer2-Handler-Pool: Thread-49]: exec.Utilities (Utilities.java:getSessionSpecifiedClassLoader(2050)) - Use session specified class loader
2014-09-30 21:53:25,565 INFO [HiveServer2-Handler-Pool: Thread-49]: parse.SemanticAnalyzer (SemanticAnalyzer.java:getMetaData(1646)) - Get metadata for subqueries
2014-09-30 21:53:25,565 INFO [HiveServer2-Handler-Pool: Thread-49]: parse.SemanticAnalyzer (SemanticAnalyzer.java:getMetaData(1670)) - Get metadata for destination tables
2014-09-30 21:53:25,567 DEBUG [HiveServer2-Handler-Pool: Thread-49]: hdfs.DFSClient (DFSClient.java:primitiveMkdir(2550)) - /tmp/hive/hduser/0d8ccf6b-84e1-4008-a8d6-a349c7d5ff3b/hive_2014-09-30_21-53-25_529_3230239964765977280-1: masked=rwx------
2014-09-30 21:53:25,567 DEBUG [HiveServer2-Handler-Pool: Thread-49]: ipc.Client (Client.java:(424)) - The ping interval is 60000 ms.
2014-09-30 21:53:25,567 DEBUG [HiveServer2-Handler-Pool: Thread-49]: ipc.Client (Client.java:setupIOstreams(693)) - Connecting to nc-h04/192.168.20.6:8020
2014-09-30 21:53:25,568 DEBUG [IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser]: ipc.Client (Client.java:run(944)) - IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser: starting, having connections 1
2014-09-30 21:53:25,569 DEBUG [IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser
2014-09-30 21:53:25,569 DEBUG [IPC Parameter Sending Thread #6]: ipc.Client (Client.java:run(1007)) - IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser sending #804
2014-09-30 21:53:25,569 DEBUG [IPC Parameter Sending Thread #6]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread IPC Parameter Sending Thread #6
2014-09-30 21:53:25,571 DEBUG [IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser]: ipc.Client (Client.java:receiveRpcResponse(1064)) - IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser got value #804
2014-09-30 21:53:25,572 DEBUG [IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser
2014-09-30 21:53:25,572 DEBUG [HiveServer2-Handler-Pool: Thread-49]: ipc.ProtobufRpcEngine (ProtobufRpcEngine.java:invoke(221)) - Call: mkdirs took 5ms
2014-09-30 21:53:25,572 DEBUG [IPC Parameter Sending Thread #6]: ipc.Client (Client.java:run(1007)) - IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser sending #805
2014-09-30 21:53:25,573 DEBUG [IPC Parameter Sending Thread #6]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread IPC Parameter Sending Thread #6
2014-09-30 21:53:25,573 DEBUG [IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser]: ipc.Client (Client.java:receiveRpcResponse(1064)) - IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser got value #805
2014-09-30 21:53:25,573 DEBUG [IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser
2014-09-30 21:53:25,574 DEBUG [HiveServer2-Handler-Pool: Thread-49]: ipc.ProtobufRpcEngine (ProtobufRpcEngine.java:invoke(221)) - Call: getFileInfo took 2ms
2014-09-30 21:53:25,574 INFO [HiveServer2-Handler-Pool: Thread-49]: ql.Context (Context.java:getMRScratchDir(266)) - New scratch dir is hdfs://nc-h04/tmp/hive/hduser/0d8ccf6b-84e1-4008-a8d6-a349c7d5ff3b/hive_2014-09-30_21-53-25_529_3230239964765977280-1
2014-09-30 21:53:25,574 INFO [HiveServer2-Handler-Pool: Thread-49]: parse.SemanticAnalyzer (SemanticAnalyzer.java:analyzeInternal(9848)) - Completed getting MetaData in Semantic Analysis
2014-09-30 21:53:25,575 INFO [HiveServer2-Handler-Pool: Thread-49]: parse.SemanticAnalyzer (SemanticAnalyzer.java:canHandleQuery(12184)) - Can not invoke CBO; query contains operators not supported for CBO.
2014-09-30 21:53:25,575 DEBUG [HiveServer2-Handler-Pool: Thread-49]: hive.log (MetaStoreUtils.java:getDDLFromFieldSchema(770)) - DDL: struct foo7 { i32 id}
2014-09-30 21:53:25,576 DEBUG [HiveServer2-Handler-Pool: Thread-49]: parse.SemanticAnalyzer (SemanticAnalyzer.java:genTablePlan(9402)) - Created Table Plan for foo7 TS[20]
2014-09-30 21:53:25,576 DEBUG [HiveServer2-Handler-Pool: Thread-49]: parse.SemanticAnalyzer (SemanticAnalyzer.java:genSelectPlan(3372)) - tree: (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF))
2014-09-30 21:53:25,576 DEBUG [HiveServer2-Handler-Pool: Thread-49]: parse.SemanticAnalyzer (SemanticAnalyzer.java:genSelectPlan(3479)) - genSelectPlan: input = foo7{(id,id: int)(block__offset__inside__file,BLOCK__OFFSET__INSIDE__FILE: bigint)(input__file__name,INPUT__FILE__NAME: string)(row__id,ROW__ID: struct)}
2014-09-30 21:53:25,577 DEBUG [HiveServer2-Handler-Pool: Thread-49]: parse.SemanticAnalyzer (SemanticAnalyzer.java:genSelectPlan(3634)) - Created Select Plan row schema: foo7{(id,_col0: int)}
2014-09-30 21:53:25,577 DEBUG [HiveServer2-Handler-Pool: Thread-49]: parse.SemanticAnalyzer (SemanticAnalyzer.java:genSelectPlan(3361)) - Created Select Plan for clause: insclause-0
2014-09-30 21:53:25,585 DEBUG [HiveServer2-Handler-Pool: Thread-49]: exec.Utilities (Utilities.java:getSessionSpecifiedClassLoader(2050)) - Use session specified class loader
2014-09-30 21:53:25,586 DEBUG [HiveServer2-Handler-Pool: Thread-49]: lazy.LazySimpleSerDe (LazySimpleSerDe.java:initialize(208)) - org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe initialized with: columnNames=[_col0] columnTypes=[int] separator=[[B@67ca951a] nullstring=\N lastColumnTakesRest=false
2014-09-30 21:53:25,586 DEBUG [HiveServer2-Handler-Pool: Thread-49]: exec.Utilities (Utilities.java:getSessionSpecifiedClassLoader(2050)) - Use session specified class loader
2014-09-30 21:53:25,586 DEBUG [HiveServer2-Handler-Pool: Thread-49]: exec.Utilities (Utilities.java:getSessionSpecifiedClassLoader(2050)) - Use session specified class loader
2014-09-30 21:53:25,586 DEBUG [HiveServer2-Handler-Pool: Thread-49]: exec.Utilities (Utilities.java:getSessionSpecifiedClassLoader(2050)) - Use session specified class loader
2014-09-30 21:53:25,587 DEBUG [HiveServer2-Handler-Pool: Thread-49]: lazy.LazySimpleSerDe (LazySimpleSerDe.java:initialize(208)) - org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe initialized with: columnNames=[_col0] columnTypes=[int] separator=[[B@25031332] nullstring=\N lastColumnTakesRest=false
2014-09-30 21:53:25,587 DEBUG [HiveServer2-Handler-Pool: Thread-49]: parse.SemanticAnalyzer (SemanticAnalyzer.java:genFileSinkPlan(6367)) - Created FileSink Plan for clause: insclause-0dest_path: hdfs://nc-h04/tmp/hive/hduser/0d8ccf6b-84e1-4008-a8d6-a349c7d5ff3b/hive_2014-09-30_21-53-25_529_3230239964765977280-1/-mr-10000 row schema: foo7{(id,_col0: int)}
2014-09-30 21:53:25,587 DEBUG [HiveServer2-Handler-Pool: Thread-49]: parse.SemanticAnalyzer (SemanticAnalyzer.java:genBodyPlan(8779)) - Created Body Plan for Query Block null
2014-09-30 21:53:25,587 DEBUG [HiveServer2-Handler-Pool: Thread-49]: parse.SemanticAnalyzer (SemanticAnalyzer.java:genPlan(9604)) - Created Plan for Query Block null
2014-09-30 21:53:25,588 DEBUG [HiveServer2-Handler-Pool: Thread-49]: parse.SemanticAnalyzer (SemanticAnalyzer.java:analyzeInternal(9971)) - Before logical optimization
TS[20]-SEL[21]-FS[22]
2014-09-30 21:53:25,594 INFO [HiveServer2-Handler-Pool: Thread-49]: ppd.OpProcFactory (OpProcFactory.java:process(752)) - Processing for FS(22)
2014-09-30 21:53:25,594 INFO [HiveServer2-Handler-Pool: Thread-49]: ppd.OpProcFactory (OpProcFactory.java:process(752)) - Processing for SEL(21)
2014-09-30 21:53:25,594 INFO [HiveServer2-Handler-Pool: Thread-49]: ppd.OpProcFactory (OpProcFactory.java:process(390)) - Processing for TS(20)
2014-09-30 21:53:25,595 DEBUG [HiveServer2-Handler-Pool: Thread-49]: ppd.PredicatePushDown (PredicatePushDown.java:transform(133)) - After PPD:
TS[20]-SEL[21]-FS[22]
2014-09-30 21:53:25,597 DEBUG [HiveServer2-Handler-Pool: Thread-49]: optimizer.ConstantPropagateProcCtx (ConstantPropagateProcCtx.java:getPropagatedConstants(125)) - Getting constants of op:TS[20] with rr:foo7{(id,id: int)(block__offset__inside__file,BLOCK__OFFSET__INSIDE__FILE: bigint)(input__file__name,INPUT__FILE__NAME: string)(row__id,ROW__ID: struct)}
2014-09-30 21:53:25,597 DEBUG [HiveServer2-Handler-Pool: Thread-49]: optimizer.ConstantPropagateProcCtx (ConstantPropagateProcCtx.java:getPropagatedConstants(189)) - Offerring constants [] to operator TS[20]
2014-09-30 21:53:25,597 DEBUG [HiveServer2-Handler-Pool: Thread-49]: optimizer.ConstantPropagateProcCtx (ConstantPropagateProcCtx.java:getPropagatedConstants(125)) - Getting constants of op:SEL[21] with rr:foo7{(id,_col0: int)}
2014-09-30 21:53:25,597 DEBUG [HiveServer2-Handler-Pool: Thread-49]: optimizer.ConstantPropagateProcCtx (ConstantPropagateProcCtx.java:getPropagatedConstants(189)) - Offerring constants [] to operator SEL[21]
2014-09-30 21:53:25,597 DEBUG [HiveServer2-Handler-Pool: Thread-49]: optimizer.ConstantPropagateProcFactory (ConstantPropagateProcFactory.java:process(683)) - New column list:(Column[id])
2014-09-30 21:53:25,598 DEBUG [HiveServer2-Handler-Pool: Thread-49]: optimizer.ConstantPropagateProcCtx (ConstantPropagateProcCtx.java:getPropagatedConstants(125)) - Getting constants of op:FS[22] with rr:foo7{(id,_col0: int)}
2014-09-30 21:53:25,598 DEBUG [HiveServer2-Handler-Pool: Thread-49]: optimizer.ConstantPropagateProcCtx (ConstantPropagateProcCtx.java:getPropagatedConstants(189)) - Offerring constants [] to operator FS[22]
2014-09-30 21:53:25,603 DEBUG [HiveServer2-Handler-Pool: Thread-49]: index.RewriteGBUsingIndex (RewriteGBUsingIndex.java:shouldApplyOptimization(162)) - No Valid Index Found to apply Rewrite, skipping RewriteGBUsingIndex optimization
2014-09-30 21:53:25,619 DEBUG [IPC Parameter Sending Thread #6]: ipc.Client (Client.java:run(1007)) - IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser sending #806
2014-09-30 21:53:25,619 DEBUG [IPC Parameter Sending Thread #6]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread IPC Parameter Sending Thread #6
2014-09-30 21:53:25,620 DEBUG [IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser]: ipc.Client (Client.java:receiveRpcResponse(1064)) - IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser got value #806
2014-09-30 21:53:25,620 DEBUG [IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser
2014-09-30 21:53:25,620 DEBUG [HiveServer2-Handler-Pool: Thread-49]: ipc.ProtobufRpcEngine (ProtobufRpcEngine.java:invoke(221)) - Call: getContentSummary took 1ms
2014-09-30 21:53:25,621 DEBUG [HiveServer2-Handler-Pool: Thread-49]: hive.log (MetaStoreUtils.java:getDDLFromFieldSchema(770)) - DDL: struct foo7 { i32 id}
2014-09-30 21:53:25,623 DEBUG [HiveServer2-Handler-Pool: Thread-49]: parse.SemanticAnalyzer (SemanticAnalyzer.java:analyzeInternal(9982)) - After logical optimization
TS[20]-SEL[21]-OP[23]
2014-09-30 21:53:25,623 INFO [HiveServer2-Handler-Pool: Thread-49]: parse.SemanticAnalyzer (SemanticAnalyzer.java:analyzeInternal(10005)) - Completed plan generation
2014-09-30 21:53:25,623 INFO [HiveServer2-Handler-Pool: Thread-49]: ql.Driver (Driver.java:compile(422)) - Semantic Analysis Completed
2014-09-30 21:53:25,624 DEBUG [HiveServer2-Handler-Pool: Thread-49]: parse.SemanticAnalyzer (SemanticAnalyzer.java:validate(10343)) - validation start
2014-09-30 21:53:25,624 DEBUG [HiveServer2-Handler-Pool: Thread-49]: parse.SemanticAnalyzer (SemanticAnalyzer.java:validate(10399)) - not validating writeEntity, because entity is neither table nor partition
2014-09-30 21:53:25,624 INFO [HiveServer2-Handler-Pool: Thread-49]: log.PerfLogger (PerfLogger.java:PerfLogEnd(135)) -
2014-09-30 21:53:25,631 DEBUG [HiveServer2-Handler-Pool: Thread-49]: exec.Utilities (Utilities.java:getSessionSpecifiedClassLoader(2050)) - Use session specified class loader
2014-09-30 21:53:25,633 INFO [HiveServer2-Handler-Pool: Thread-49]: exec.TableScanOperator (Operator.java:initialize(342)) - Initializing Self TS[20]
2014-09-30 21:53:25,634 INFO [HiveServer2-Handler-Pool: Thread-49]: exec.TableScanOperator (Operator.java:initializeChildren(415)) - Operator 20 TS initialized
2014-09-30 21:53:25,634 INFO [HiveServer2-Handler-Pool: Thread-49]: exec.TableScanOperator (Operator.java:initializeChildren(419)) - Initializing children of 20 TS
2014-09-30 21:53:25,634 INFO [HiveServer2-Handler-Pool: Thread-49]: exec.SelectOperator (Operator.java:initialize(454)) - Initializing child 21 SEL
2014-09-30 21:53:25,634 INFO [HiveServer2-Handler-Pool: Thread-49]: exec.SelectOperator (Operator.java:initialize(342)) - Initializing Self SEL[21]
2014-09-30 21:53:25,639 INFO [HiveServer2-Handler-Pool: Thread-49]: exec.SelectOperator (SelectOperator.java:initializeOp(62)) - SELECT struct
2014-09-30 21:53:25,640 INFO [HiveServer2-Handler-Pool: Thread-49]: exec.SelectOperator (Operator.java:initializeChildren(415)) - Operator 21 SEL initialized
2014-09-30 21:53:25,640 INFO [HiveServer2-Handler-Pool: Thread-49]: exec.SelectOperator (Operator.java:initializeChildren(419)) - Initializing children of 21 SEL
2014-09-30 21:53:25,640 INFO [HiveServer2-Handler-Pool: Thread-49]: exec.ListSinkOperator (Operator.java:initialize(454)) - Initializing child 23 OP
2014-09-30 21:53:25,640 INFO [HiveServer2-Handler-Pool: Thread-49]: exec.ListSinkOperator (Operator.java:initialize(342)) - Initializing Self OP[23]
2014-09-30 21:53:25,640 DEBUG [HiveServer2-Handler-Pool: Thread-49]: exec.Utilities (Utilities.java:getSessionSpecifiedClassLoader(2050)) - Use session specified class loader
2014-09-30 21:53:25,641 INFO [HiveServer2-Handler-Pool: Thread-49]: exec.ListSinkOperator (Operator.java:initializeChildren(415)) - Operator 23 OP initialized
2014-09-30 21:53:25,641 INFO [HiveServer2-Handler-Pool: Thread-49]: exec.ListSinkOperator (Operator.java:initialize(390)) - Initialization Done 23 OP
2014-09-30 21:53:25,641 INFO [HiveServer2-Handler-Pool: Thread-49]: exec.SelectOperator (Operator.java:initialize(390)) - Initialization Done 21 SEL
2014-09-30 21:53:25,641 INFO [HiveServer2-Handler-Pool: Thread-49]: exec.TableScanOperator (Operator.java:initialize(390)) - Initialization Done 20 TS
2014-09-30 21:53:25,642 INFO [HiveServer2-Handler-Pool: Thread-49]: ql.Driver (Driver.java:getSchema(235)) - Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:foo7.id, type:int, comment:null)], properties:null)
2014-09-30 21:53:25,642 INFO [HiveServer2-Handler-Pool: Thread-49]: log.PerfLogger (PerfLogger.java:PerfLogEnd(135)) -
2014-09-30 21:53:25,642 DEBUG [HiveServer2-Handler-Pool: Thread-49]: cli.CLIService (CLIService.java:executeStatementAsync(244)) - SessionHandle [0d8ccf6b-84e1-4008-a8d6-a349c7d5ff3b]: executeStatementAsync()
2014-09-30 21:53:25,643 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,643 DEBUG [HiveServer2-Background-Pool: Thread-202]: security.UserGroupInformation (UserGroupInformation.java:logPrivilegedAction(1572)) - PrivilegedAction as:hduser (auth:SIMPLE) from:org.apache.hadoop.hive.shims.HadoopShimsSecure.doAs(HadoopShimsSecure.java:508)
2014-09-30 21:53:25,643 DEBUG [HiveServer2-Background-Pool: Thread-202]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread HiveServer2-Background-Pool: Thread-202
2014-09-30 21:53:25,643 DEBUG [HiveServer2-Handler-Pool: Thread-49]: transport.TSaslTransport (TSaslTransport.java:flush(468)) - writing data length: 109
2014-09-30 21:53:25,643 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4jLoggerAdapter.java:debug(229)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,643 INFO [HiveServer2-Background-Pool: Thread-202]: log.PerfLogger (PerfLogger.java:PerfLogBegin(108)) -
2014-09-30 21:53:25,644 INFO [HiveServer2-Background-Pool: Thread-202]: log.PerfLogger (PerfLogger.java:PerfLogBegin(108)) -
2014-09-30 21:53:25,644 INFO [HiveServer2-Background-Pool: Thread-202]: log.PerfLogger (PerfLogger.java:PerfLogBegin(108)) -
2014-09-30 21:53:25,644 DEBUG [HiveServer2-Handler-Pool: Thread-49]: transport.TSaslTransport (TSaslTransport.java:readFrame(429)) - SERVER: reading data length: 117
2014-09-30 21:53:25,644 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4jLoggerAdapter.java:debug(252)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,644 DEBUG [HiveServer2-Background-Pool: Thread-202]: lockmgr.DbTxnManager (DbTxnManager.java:acquireLocks(88)) - Setting lock request transaction to 0
2014-09-30 21:53:25,644 DEBUG [HiveServer2-Background-Pool: Thread-202]: lockmgr.DbTxnManager (DbTxnManager.java:acquireLocks(127)) - Adding lock component to lock request LockComponent(type:SHARED_READ, level:TABLE, dbname:casino, tablename:foo7)
2014-09-30 21:53:25,645 DEBUG [HiveServer2-Handler-Pool: Thread-49]: security.UserGroupInformation (UserGroupInformation.java:logPrivilegedAction(1572)) - PrivilegedAction as:hduser (auth:SIMPLE) from:org.apache.hadoop.hive.shims.HadoopShimsSecure.doAs(HadoopShimsSecure.java:508)
2014-09-30 21:53:25,645 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,645 DEBUG [HiveServer2-Background-Pool: Thread-202]: lockmgr.DbLockManager (DbLockManager.java:lock(79)) - Requesting lock
2014-09-30 21:53:25,645 DEBUG [HiveServer2-Handler-Pool: Thread-49]: cli.CLIService (CLIService.java:fetchResults(424)) - OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier()=13f6b763-c533-400d-9587-c8f7327b45f1]: fetchResults()
2014-09-30 21:53:25,645 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,646 DEBUG [HiveServer2-Handler-Pool: Thread-49]: transport.TSaslTransport (TSaslTransport.java:flush(468)) - writing data length: 5374
2014-09-30 21:53:25,646 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4jLoggerAdapter.java:debug(229)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,648 DEBUG [HiveServer2-Handler-Pool: Thread-49]: transport.TSaslTransport (TSaslTransport.java:readFrame(429)) - SERVER: reading data length: 100
2014-09-30 21:53:25,648 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4jLoggerAdapter.java:debug(252)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,657 DEBUG [HiveServer2-Background-Pool: Thread-202]: ql.Driver (Driver.java:recordValidTxns(881)) - Encoding valid txns info 556:396:399:402:410:411:412:414:418:445:462:468:469:470:471:472:483:503:543:555
2014-09-30 21:53:25,657 INFO [HiveServer2-Background-Pool: Thread-202]: log.PerfLogger (PerfLogger.java:PerfLogEnd(135)) -
2014-09-30 21:53:25,657 INFO [HiveServer2-Background-Pool: Thread-202]: log.PerfLogger (PerfLogger.java:PerfLogBegin(108)) -
2014-09-30 21:53:25,657 INFO [HiveServer2-Background-Pool: Thread-202]: ql.Driver (Driver.java:execute(1284)) - Starting command: select * from foo7
2014-09-30 21:53:25,658 INFO [HiveServer2-Background-Pool: Thread-202]: log.PerfLogger (PerfLogger.java:PerfLogEnd(135)) -
2014-09-30 21:53:25,658 INFO [HiveServer2-Background-Pool: Thread-202]: log.PerfLogger (PerfLogger.java:PerfLogBegin(108)) -
2014-09-30 21:53:25,658 INFO [HiveServer2-Background-Pool: Thread-202]: log.PerfLogger (PerfLogger.java:PerfLogEnd(135)) -
2014-09-30 21:53:25,658 INFO [HiveServer2-Background-Pool: Thread-202]: log.PerfLogger (PerfLogger.java:PerfLogEnd(135)) -
2014-09-30 21:53:25,658 INFO [HiveServer2-Background-Pool: Thread-202]: ql.Driver (SessionState.java:printInfo(816)) - OK
2014-09-30 21:53:25,658 INFO [HiveServer2-Background-Pool: Thread-202]: log.PerfLogger (PerfLogger.java:PerfLogBegin(108)) -
2014-09-30 21:53:25,659 DEBUG [HiveServer2-Background-Pool: Thread-202]: lockmgr.DbLockManager (DbLockManager.java:unlock(110)) - Unlocking id:418756
2014-09-30 21:53:25,667 DEBUG [HiveServer2-Background-Pool: Thread-202]: lockmgr.DbLockManager (DbLockManager.java:unlock(113)) - Removed a lock true
2014-09-30 21:53:25,667 INFO [HiveServer2-Background-Pool: Thread-202]: log.PerfLogger (PerfLogger.java:PerfLogEnd(135)) -
2014-09-30 21:53:25,667 INFO [HiveServer2-Background-Pool: Thread-202]: log.PerfLogger (PerfLogger.java:PerfLogEnd(135)) -
2014-09-30 21:53:25,667 DEBUG [HiveServer2-Handler-Pool: Thread-49]: cli.CLIService (CLIService.java:getOperationStatus(371)) - OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier()=13f6b763-c533-400d-9587-c8f7327b45f1]: getOperationStatus()
2014-09-30 21:53:25,668 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,668 DEBUG [HiveServer2-Handler-Pool: Thread-49]: transport.TSaslTransport (TSaslTransport.java:flush(468)) - writing data length: 53
2014-09-30 21:53:25,668 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4jLoggerAdapter.java:debug(229)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,686 DEBUG [HiveServer2-Handler-Pool: Thread-49]: transport.TSaslTransport (TSaslTransport.java:readFrame(429)) - SERVER: reading data length: 102
2014-09-30 21:53:25,687 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4jLoggerAdapter.java:debug(252)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,706 DEBUG [HiveServer2-Handler-Pool: Thread-49]: security.UserGroupInformation (UserGroupInformation.java:logPrivilegedAction(1572)) - PrivilegedAction as:hduser (auth:SIMPLE) from:org.apache.hadoop.hive.shims.HadoopShimsSecure.doAs(HadoopShimsSecure.java:508)
2014-09-30 21:53:25,706 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,706 DEBUG [HiveServer2-Handler-Pool: Thread-49]: cli.CLIService (CLIService.java:getResultSetMetadata(405)) - OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier()=13f6b763-c533-400d-9587-c8f7327b45f1]: getResultSetMetadata()
2014-09-30 21:53:25,706 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,740 DEBUG [HiveServer2-Handler-Pool: Thread-49]: transport.TSaslTransport (TSaslTransport.java:flush(468)) - writing data length: 106
2014-09-30 21:53:25,741 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4jLoggerAdapter.java:debug(229)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,787 DEBUG [HiveServer2-Handler-Pool: Thread-49]: transport.TSaslTransport (TSaslTransport.java:readFrame(429)) - SERVER: reading data length: 112
2014-09-30 21:53:25,787 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4jLoggerAdapter.java:debug(252)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,787 DEBUG [HiveServer2-Handler-Pool: Thread-49]: security.UserGroupInformation (UserGroupInformation.java:logPrivilegedAction(1572)) - PrivilegedAction as:hduser (auth:SIMPLE) from:org.apache.hadoop.hive.shims.HadoopShimsSecure.doAs(HadoopShimsSecure.java:508)
2014-09-30 21:53:25,787 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,788 DEBUG [IPC Parameter Sending Thread #6]: ipc.Client (Client.java:run(1007)) - IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser sending #807
2014-09-30 21:53:25,788 DEBUG [IPC Parameter Sending Thread #6]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread IPC Parameter Sending Thread #6
2014-09-30 21:53:25,789 DEBUG [IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser]: ipc.Client (Client.java:receiveRpcResponse(1064)) - IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser got value #807
2014-09-30 21:53:25,789 DEBUG [IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser
2014-09-30 21:53:25,790 DEBUG [HiveServer2-Handler-Pool: Thread-49]: ipc.ProtobufRpcEngine (ProtobufRpcEngine.java:invoke(221)) - Call: getFileInfo took 2ms
2014-09-30 21:53:25,790 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,790 DEBUG [IPC Parameter Sending Thread #6]: ipc.Client (Client.java:run(1007)) - IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser sending #808
2014-09-30 21:53:25,791 DEBUG [IPC Parameter Sending Thread #6]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread IPC Parameter Sending Thread #6
2014-09-30 21:53:25,791 DEBUG [IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser]: ipc.Client (Client.java:receiveRpcResponse(1064)) - IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser got value #808
2014-09-30 21:53:25,791 DEBUG [IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser
2014-09-30 21:53:25,791 DEBUG [HiveServer2-Handler-Pool: Thread-49]: ipc.ProtobufRpcEngine (ProtobufRpcEngine.java:invoke(221)) - Call: getListing took 1ms
2014-09-30 21:53:25,792 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,792 DEBUG [IPC Parameter Sending Thread #6]: ipc.Client (Client.java:run(1007)) - IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser sending #809
2014-09-30 21:53:25,793 DEBUG [IPC Parameter Sending Thread #6]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread IPC Parameter Sending Thread #6
2014-09-30 21:53:25,793 DEBUG [IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser]: ipc.Client (Client.java:receiveRpcResponse(1064)) - IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser got value #809
2014-09-30 21:53:25,793 DEBUG [IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser
2014-09-30 21:53:25,793 DEBUG [HiveServer2-Handler-Pool: Thread-49]: ipc.ProtobufRpcEngine (ProtobufRpcEngine.java:invoke(221)) - Call: getListing took 1ms
2014-09-30 21:53:25,793 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,794 INFO [HiveServer2-Handler-Pool: Thread-49]: Configuration.deprecation (Configuration.java:warnOnceIfDeprecated(1009)) - mapred.input.dir is deprecated. Instead, use mapreduce.input.fileinputformat.inputdir
2014-09-30 21:53:25,794 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4JLogger.java:info(176)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,815 INFO [HiveServer2-Handler-Pool: Thread-49]: log.PerfLogger (PerfLogger.java:PerfLogBegin(108)) -
2014-09-30 21:53:25,815 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4JLogger.java:info(176)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,821 DEBUG [IPC Parameter Sending Thread #6]: ipc.Client (Client.java:run(1007)) - IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser sending #810
2014-09-30 21:53:25,821 DEBUG [IPC Parameter Sending Thread #6]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread IPC Parameter Sending Thread #6
2014-09-30 21:53:25,822 DEBUG [IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser]: ipc.Client (Client.java:receiveRpcResponse(1064)) - IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser got value #810
2014-09-30 21:53:25,822 DEBUG [IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser
2014-09-30 21:53:25,822 DEBUG [ORC_GET_SPLITS #0]: ipc.ProtobufRpcEngine (ProtobufRpcEngine.java:invoke(221)) - Call: getFileInfo took 1ms
2014-09-30 21:53:25,822 DEBUG [ORC_GET_SPLITS #0]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread ORC_GET_SPLITS #0
2014-09-30 21:53:25,823 DEBUG [IPC Parameter Sending Thread #6]: ipc.Client (Client.java:run(1007)) - IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser sending #811
2014-09-30 21:53:25,823 DEBUG [IPC Parameter Sending Thread #6]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread IPC Parameter Sending Thread #6
2014-09-30 21:53:25,824 DEBUG [IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser]: ipc.Client (Client.java:receiveRpcResponse(1064)) - IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser got value #811
2014-09-30 21:53:25,824 DEBUG [IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser
2014-09-30 21:53:25,824 DEBUG [ORC_GET_SPLITS #0]: ipc.ProtobufRpcEngine (ProtobufRpcEngine.java:invoke(221)) - Call: getListing took 1ms
2014-09-30 21:53:25,824 DEBUG [ORC_GET_SPLITS #0]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread ORC_GET_SPLITS #0
2014-09-30 21:53:25,827 DEBUG [ORC_GET_SPLITS #0]: io.AcidUtils (AcidUtils.java:getAcidState(406)) - in directory hdfs://nc-h04/user/hive/warehouse/casino.db/foo7 base = null deltas = 1
2014-09-30 21:53:25,827 DEBUG [ORC_GET_SPLITS #0]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread ORC_GET_SPLITS #0
2014-09-30 21:53:25,828 INFO [HiveServer2-Handler-Pool: Thread-49]: orc.OrcInputFormat (OrcInputFormat.java:generateSplitsInfo(955)) - FooterCacheHitRatio: 0/0
2014-09-30 21:53:25,828 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4JLogger.java:info(176)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,828 INFO [HiveServer2-Handler-Pool: Thread-49]: log.PerfLogger (PerfLogger.java:PerfLogEnd(135)) -
2014-09-30 21:53:25,828 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4JLogger.java:info(176)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,829 DEBUG [HiveServer2-Handler-Pool: Thread-49]: exec.FetchOperator (FetchOperator.java:getRecordReader(474)) - Creating fetchTask with deserializer typeinfo: struct
2014-09-30 21:53:25,829 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,829 DEBUG [HiveServer2-Handler-Pool: Thread-49]: exec.FetchOperator (FetchOperator.java:getRecordReader(476)) - deserializer properties:
table properties: {name=casino.foo7, numFiles=1, columns.types=int, serialization.ddl=struct foo7 { i32 id}, serialization.format=1, columns=id, rawDataSize=0, columns.comments=, numRows=1, bucket_count=-1, serialization.lib=org.apache.hadoop.hive.ql.io.orc.OrcSerde, COLUMN_STATS_ACCURATE=true, file.inputformat=org.apache.hadoop.hive.ql.io.orc.OrcInputFormat, totalSize=607, file.outputformat=org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat, location=hdfs://nc-h04/user/hive/warehouse/casino.db/foo7, transient_lastDdlTime=1412106678}
partition properties: {name=casino.foo7, numFiles=1, columns.types=int, serialization.ddl=struct foo7 { i32 id}, serialization.format=1, columns=id, rawDataSize=0, columns.comments=, numRows=1, bucket_count=-1, serialization.lib=org.apache.hadoop.hive.ql.io.orc.OrcSerde, COLUMN_STATS_ACCURATE=true, file.inputformat=org.apache.hadoop.hive.ql.io.orc.OrcInputFormat, totalSize=607, file.outputformat=org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat, location=hdfs://nc-h04/user/hive/warehouse/casino.db/foo7, transient_lastDdlTime=1412106678}
2014-09-30 21:53:25,829 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,830 DEBUG [HiveServer2-Handler-Pool: Thread-49]: cli.CLIService (CLIService.java:fetchResults(424)) - OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier()=13f6b763-c533-400d-9587-c8f7327b45f1]: fetchResults()
2014-09-30 21:53:25,830 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,834 DEBUG [HiveServer2-Handler-Pool: Thread-49]: transport.TSaslTransport (TSaslTransport.java:flush(468)) - writing data length: 96
2014-09-30 21:53:25,835 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4jLoggerAdapter.java:debug(229)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,843 DEBUG [HiveServer2-Handler-Pool: Thread-49]: transport.TSaslTransport (TSaslTransport.java:readFrame(429)) - SERVER: reading data length: 117
2014-09-30 21:53:25,843 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4jLoggerAdapter.java:debug(252)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,844 DEBUG [HiveServer2-Handler-Pool: Thread-49]: security.UserGroupInformation (UserGroupInformation.java:logPrivilegedAction(1572)) - PrivilegedAction as:hduser (auth:SIMPLE) from:org.apache.hadoop.hive.shims.HadoopShimsSecure.doAs(HadoopShimsSecure.java:508)
2014-09-30 21:53:25,844 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,844 DEBUG [HiveServer2-Handler-Pool: Thread-49]: cli.CLIService (CLIService.java:fetchResults(424)) - OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier()=13f6b763-c533-400d-9587-c8f7327b45f1]: fetchResults()
2014-09-30 21:53:25,845 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,845 DEBUG [HiveServer2-Handler-Pool: Thread-49]: transport.TSaslTransport (TSaslTransport.java:flush(468)) - writing data length: 5069
2014-09-30 21:53:25,845 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4jLoggerAdapter.java:debug(229)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,851 DEBUG [HiveServer2-Handler-Pool: Thread-49]: transport.TSaslTransport (TSaslTransport.java:readFrame(429)) - SERVER: reading data length: 117
2014-09-30 21:53:25,851 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4jLoggerAdapter.java:debug(252)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,851 DEBUG [HiveServer2-Handler-Pool: Thread-49]: security.UserGroupInformation (UserGroupInformation.java:logPrivilegedAction(1572)) - PrivilegedAction as:hduser (auth:SIMPLE) from:org.apache.hadoop.hive.shims.HadoopShimsSecure.doAs(HadoopShimsSecure.java:508)
2014-09-30 21:53:25,851 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,852 DEBUG [HiveServer2-Handler-Pool: Thread-49]: cli.CLIService (CLIService.java:fetchResults(424)) - OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier()=13f6b763-c533-400d-9587-c8f7327b45f1]: fetchResults()
2014-09-30 21:53:25,852 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,852 DEBUG [HiveServer2-Handler-Pool: Thread-49]: transport.TSaslTransport (TSaslTransport.java:flush(468)) - writing data length: 96
2014-09-30 21:53:25,852 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4jLoggerAdapter.java:debug(229)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,853 DEBUG [HiveServer2-Handler-Pool: Thread-49]: transport.TSaslTransport (TSaslTransport.java:readFrame(429)) - SERVER: reading data length: 96
2014-09-30 21:53:25,853 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4jLoggerAdapter.java:debug(252)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,853 DEBUG [HiveServer2-Handler-Pool: Thread-49]: security.UserGroupInformation (UserGroupInformation.java:logPrivilegedAction(1572)) - PrivilegedAction as:hduser (auth:SIMPLE) from:org.apache.hadoop.hive.shims.HadoopShimsSecure.doAs(HadoopShimsSecure.java:508)
2014-09-30 21:53:25,853 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,854 INFO [HiveServer2-Handler-Pool: Thread-49]: exec.TableScanOperator (Operator.java:close(581)) - 20 finished. closing...
2014-09-30 21:53:25,854 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4JLogger.java:info(176)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,854 DEBUG [HiveServer2-Handler-Pool: Thread-49]: exec.TableScanOperator (Operator.java:close(595)) - Closing child = SEL[21]
2014-09-30 21:53:25,854 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,854 DEBUG [HiveServer2-Handler-Pool: Thread-49]: exec.SelectOperator (Operator.java:allInitializedParentsAreClosed(554)) - allInitializedParentsAreClosed? parent.state = CLOSE
2014-09-30 21:53:25,854 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,854 INFO [HiveServer2-Handler-Pool: Thread-49]: exec.SelectOperator (Operator.java:close(581)) - 21 finished. closing...
2014-09-30 21:53:25,855 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4JLogger.java:info(176)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,855 DEBUG [HiveServer2-Handler-Pool: Thread-49]: exec.SelectOperator (Operator.java:close(595)) - Closing child = OP[23]
2014-09-30 21:53:25,855 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,855 DEBUG [HiveServer2-Handler-Pool: Thread-49]: exec.ListSinkOperator (Operator.java:allInitializedParentsAreClosed(554)) - allInitializedParentsAreClosed? parent.state = CLOSE
2014-09-30 21:53:25,855 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,855 INFO [HiveServer2-Handler-Pool: Thread-49]: exec.ListSinkOperator (Operator.java:close(581)) - 23 finished. closing...
2014-09-30 21:53:25,855 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4JLogger.java:info(176)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,855 INFO [HiveServer2-Handler-Pool: Thread-49]: exec.ListSinkOperator (Operator.java:close(599)) - 23 Close done
2014-09-30 21:53:25,855 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4JLogger.java:info(176)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,856 INFO [HiveServer2-Handler-Pool: Thread-49]: exec.SelectOperator (Operator.java:close(599)) - 21 Close done
2014-09-30 21:53:25,856 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4JLogger.java:info(176)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,856 INFO [HiveServer2-Handler-Pool: Thread-49]: exec.TableScanOperator (Operator.java:close(599)) - 20 Close done
2014-09-30 21:53:25,856 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4JLogger.java:info(176)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,856 DEBUG [HiveServer2-Handler-Pool: Thread-49]: ql.Driver (DriverContext.java:shutdown(132)) - Shutting down query select * from foo7
2014-09-30 21:53:25,856 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,857 DEBUG [IPC Parameter Sending Thread #6]: ipc.Client (Client.java:run(1007)) - IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser sending #812
2014-09-30 21:53:25,857 DEBUG [IPC Parameter Sending Thread #6]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread IPC Parameter Sending Thread #6
2014-09-30 21:53:25,858 DEBUG [IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser]: ipc.Client (Client.java:receiveRpcResponse(1064)) - IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser got value #812
2014-09-30 21:53:25,858 DEBUG [IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser
2014-09-30 21:53:25,858 DEBUG [HiveServer2-Handler-Pool: Thread-49]: ipc.ProtobufRpcEngine (ProtobufRpcEngine.java:invoke(221)) - Call: delete took 1ms
2014-09-30 21:53:25,859 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,859 DEBUG [IPC Parameter Sending Thread #6]: ipc.Client (Client.java:run(1007)) - IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser sending #813
2014-09-30 21:53:25,860 DEBUG [IPC Parameter Sending Thread #6]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread IPC Parameter Sending Thread #6
2014-09-30 21:53:25,861 DEBUG [IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser]: ipc.Client (Client.java:receiveRpcResponse(1064)) - IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser got value #813
2014-09-30 21:53:25,861 DEBUG [IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread IPC Client (343751645) connection to nc-h04/192.168.20.6:8020 from hduser
2014-09-30 21:53:25,861 DEBUG [HiveServer2-Handler-Pool: Thread-49]: ipc.ProtobufRpcEngine (ProtobufRpcEngine.java:invoke(221)) - Call: delete took 2ms
2014-09-30 21:53:25,861 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,862 INFO [HiveServer2-Handler-Pool: Thread-49]: log.PerfLogger (PerfLogger.java:PerfLogBegin(108)) -
2014-09-30 21:53:25,862 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4JLogger.java:info(176)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,862 INFO [HiveServer2-Handler-Pool: Thread-49]: log.PerfLogger (PerfLogger.java:PerfLogEnd(135)) -
2014-09-30 21:53:25,862 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4JLogger.java:info(176)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,862 DEBUG [HiveServer2-Handler-Pool: Thread-49]: cli.CLIService (CLIService.java:closeOperation(394)) - OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier()=13f6b763-c533-400d-9587-c8f7327b45f1]: closeOperation
2014-09-30 21:53:25,862 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4JLogger.java:debug(155)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49
2014-09-30 21:53:25,862 DEBUG [HiveServer2-Handler-Pool: Thread-49]: transport.TSaslTransport (TSaslTransport.java:flush(468)) - writing data length: 42
2014-09-30 21:53:25,862 DEBUG [HiveServer2-Handler-Pool: Thread-49]: operation.LogDivertAppender (Log4jLoggerAdapter.java:debug(229)) - ---+++=== Dropped log event from thread HiveServer2-Handler-Pool: Thread-49