0: jdbc:hive2://nc-h04:10000/casino> select * from foo7; 14/09/30 21:53:25 DEBUG parse.VariableSubstitution: Substitution is on: select * from foo7 14/09/30 21:53:25 INFO log.PerfLogger: 14/09/30 21:53:25 DEBUG parse.VariableSubstitution: Substitution is on: select * from foo7 14/09/30 21:53:25 INFO log.PerfLogger: 14/09/30 21:53:25 INFO parse.ParseDriver: Parsing command: select * from foo7 14/09/30 21:53:25 INFO parse.ParseDriver: Parse Completed 14/09/30 21:53:25 INFO log.PerfLogger: 14/09/30 21:53:25 INFO log.PerfLogger: 14/09/30 21:53:25 INFO parse.SemanticAnalyzer: Starting Semantic Analysis 14/09/30 21:53:25 INFO parse.SemanticAnalyzer: Completed phase 1 of Semantic Analysis 14/09/30 21:53:25 INFO parse.SemanticAnalyzer: Get metadata for source tables 14/09/30 21:53:25 DEBUG exec.Utilities: Use session specified class loader 14/09/30 21:53:25 DEBUG exec.Utilities: Use session specified class loader 14/09/30 21:53:25 INFO parse.SemanticAnalyzer: Get metadata for subqueries 14/09/30 21:53:25 INFO parse.SemanticAnalyzer: Get metadata for destination tables 14/09/30 21:53:25 DEBUG hdfs.DFSClient: /tmp/hive/hduser/0d8ccf6b-84e1-4008-a8d6-a349c7d5ff3b/hive_2014-09-30_21-53-25_529_3230239964765977280-1: masked=rwx------ 14/09/30 21:53:25 DEBUG ipc.Client: The ping interval is 60000 ms. 14/09/30 21:53:25 DEBUG ipc.Client: Connecting to nc-h04/192.168.20.6:8020 14/09/30 21:53:25 DEBUG ipc.ProtobufRpcEngine: Call: mkdirs took 5ms 14/09/30 21:53:25 DEBUG ipc.ProtobufRpcEngine: Call: getFileInfo took 2ms 14/09/30 21:53:25 INFO ql.Context: 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 14/09/30 21:53:25 INFO parse.SemanticAnalyzer: Completed getting MetaData in Semantic Analysis 14/09/30 21:53:25 INFO parse.SemanticAnalyzer: Can not invoke CBO; query contains operators not supported for CBO. 14/09/30 21:53:25 DEBUG hive.log: DDL: struct foo7 { i32 id} 14/09/30 21:53:25 DEBUG parse.SemanticAnalyzer: Created Table Plan for foo7 TS[20] 14/09/30 21:53:25 DEBUG parse.SemanticAnalyzer: tree: (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) 14/09/30 21:53:25 DEBUG parse.SemanticAnalyzer: 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)} 14/09/30 21:53:25 DEBUG parse.SemanticAnalyzer: Created Select Plan row schema: foo7{(id,_col0: int)} 14/09/30 21:53:25 DEBUG parse.SemanticAnalyzer: Created Select Plan for clause: insclause-0 14/09/30 21:53:25 DEBUG exec.Utilities: Use session specified class loader 14/09/30 21:53:25 DEBUG lazy.LazySimpleSerDe: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe initialized with: columnNames=[_col0] columnTypes=[int] separator=[[B@67ca951a] nullstring=\N lastColumnTakesRest=false 14/09/30 21:53:25 DEBUG exec.Utilities: Use session specified class loader 14/09/30 21:53:25 DEBUG exec.Utilities: Use session specified class loader 14/09/30 21:53:25 DEBUG exec.Utilities: Use session specified class loader 14/09/30 21:53:25 DEBUG lazy.LazySimpleSerDe: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe initialized with: columnNames=[_col0] columnTypes=[int] separator=[[B@25031332] nullstring=\N lastColumnTakesRest=false 14/09/30 21:53:25 DEBUG parse.SemanticAnalyzer: 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)} 14/09/30 21:53:25 DEBUG parse.SemanticAnalyzer: Created Body Plan for Query Block null 14/09/30 21:53:25 DEBUG parse.SemanticAnalyzer: Created Plan for Query Block null 14/09/30 21:53:25 DEBUG parse.SemanticAnalyzer: Before logical optimization TS[20]-SEL[21]-FS[22] 14/09/30 21:53:25 INFO ppd.OpProcFactory: Processing for FS(22) 14/09/30 21:53:25 INFO ppd.OpProcFactory: Processing for SEL(21) 14/09/30 21:53:25 INFO ppd.OpProcFactory: Processing for TS(20) 14/09/30 21:53:25 DEBUG ppd.PredicatePushDown: After PPD: TS[20]-SEL[21]-FS[22] 14/09/30 21:53:25 DEBUG optimizer.ConstantPropagateProcCtx: 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)} 14/09/30 21:53:25 DEBUG optimizer.ConstantPropagateProcCtx: Offerring constants [] to operator TS[20] 14/09/30 21:53:25 DEBUG optimizer.ConstantPropagateProcCtx: Getting constants of op:SEL[21] with rr:foo7{(id,_col0: int)} 14/09/30 21:53:25 DEBUG optimizer.ConstantPropagateProcCtx: Offerring constants [] to operator SEL[21] 14/09/30 21:53:25 DEBUG optimizer.ConstantPropagateProcFactory: New column list:(Column[id]) +----------+--+ | foo7.id | +----------+--+ +----------+--+ No rows selected (0.317 seconds) 14/09/30 21:53:25 DEBUG optimizer.ConstantPropagateProcCtx: Getting constants of op:FS[22] with rr:foo7{(id,_col0: int)} 14/09/30 21:53:25 DEBUG optimizer.ConstantPropagateProcCtx: Offerring constants [] to operator FS[22] 14/09/30 21:53:25 DEBUG index.RewriteGBUsingIndex: No Valid Index Found to apply Rewrite, skipping RewriteGBUsingIndex optimization 14/09/30 21:53:25 DEBUG ipc.ProtobufRpcEngine: Call: getContentSummary took 1ms 14/09/30 21:53:25 DEBUG hive.log: DDL: struct foo7 { i32 id} 14/09/30 21:53:25 DEBUG parse.SemanticAnalyzer: After logical optimization TS[20]-SEL[21]-OP[23] 14/09/30 21:53:25 INFO parse.SemanticAnalyzer: Completed plan generation 14/09/30 21:53:25 INFO ql.Driver: Semantic Analysis Completed 14/09/30 21:53:25 DEBUG parse.SemanticAnalyzer: validation start 14/09/30 21:53:25 DEBUG parse.SemanticAnalyzer: not validating writeEntity, because entity is neither table nor partition 14/09/30 21:53:25 INFO log.PerfLogger: 14/09/30 21:53:25 DEBUG exec.Utilities: Use session specified class loader 14/09/30 21:53:25 INFO exec.TableScanOperator: Initializing Self TS[20] 14/09/30 21:53:25 INFO exec.TableScanOperator: Operator 20 TS initialized 14/09/30 21:53:25 INFO exec.TableScanOperator: Initializing children of 20 TS 14/09/30 21:53:25 INFO exec.SelectOperator: Initializing child 21 SEL 14/09/30 21:53:25 INFO exec.SelectOperator: Initializing Self SEL[21] 14/09/30 21:53:25 INFO exec.SelectOperator: SELECT struct 14/09/30 21:53:25 INFO exec.SelectOperator: Operator 21 SEL initialized 14/09/30 21:53:25 INFO exec.SelectOperator: Initializing children of 21 SEL 14/09/30 21:53:25 INFO exec.ListSinkOperator: Initializing child 23 OP 14/09/30 21:53:25 INFO exec.ListSinkOperator: Initializing Self OP[23] 14/09/30 21:53:25 DEBUG exec.Utilities: Use session specified class loader 14/09/30 21:53:25 INFO exec.ListSinkOperator: Operator 23 OP initialized 14/09/30 21:53:25 INFO exec.ListSinkOperator: Initialization Done 23 OP 14/09/30 21:53:25 INFO exec.SelectOperator: Initialization Done 21 SEL 14/09/30 21:53:25 INFO exec.TableScanOperator: Initialization Done 20 TS 14/09/30 21:53:25 INFO ql.Driver: Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:foo7.id, type:int, comment:null)], properties:null) 14/09/30 21:53:25 INFO log.PerfLogger: 14/09/30 21:53:25 INFO log.PerfLogger: 14/09/30 21:53:25 INFO log.PerfLogger: 14/09/30 21:53:25 INFO log.PerfLogger: 14/09/30 21:53:25 DEBUG lockmgr.DbTxnManager: Setting lock request transaction to 0 14/09/30 21:53:25 DEBUG lockmgr.DbTxnManager: Adding lock component to lock request LockComponent(type:SHARED_READ, level:TABLE, dbname:casino, tablename:foo7) 14/09/30 21:53:25 DEBUG lockmgr.DbLockManager: Requesting lock 14/09/30 21:53:25 DEBUG ql.Driver: Encoding valid txns info 556:396:399:402:410:411:412:414:418:445:462:468:469:470:471:472:483:503:543:555 14/09/30 21:53:25 INFO log.PerfLogger: 14/09/30 21:53:25 INFO log.PerfLogger: 14/09/30 21:53:25 INFO ql.Driver: Starting command: select * from foo7 14/09/30 21:53:25 INFO log.PerfLogger: 14/09/30 21:53:25 INFO log.PerfLogger: 14/09/30 21:53:25 INFO log.PerfLogger: 14/09/30 21:53:25 INFO log.PerfLogger: 14/09/30 21:53:25 INFO ql.Driver: OK 14/09/30 21:53:25 INFO log.PerfLogger: 14/09/30 21:53:25 DEBUG lockmgr.DbLockManager: Unlocking id:418756 14/09/30 21:53:25 DEBUG lockmgr.DbLockManager: Removed a lock true 14/09/30 21:53:25 INFO log.PerfLogger: 14/09/30 21:53:25 INFO log.PerfLogger: