| PREHOOK: query: drop table if exists src_orc |
| PREHOOK: type: DROPTABLE |
| POSTHOOK: query: drop table if exists src_orc |
| POSTHOOK: type: DROPTABLE |
| PREHOOK: query: create table src_orc stored as orc as select * from src |
| PREHOOK: type: CREATETABLE_AS_SELECT |
| PREHOOK: Input: default@src |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@src_orc |
| POSTHOOK: query: create table src_orc stored as orc as select * from src |
| POSTHOOK: type: CREATETABLE_AS_SELECT |
| POSTHOOK: Input: default@src |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@src_orc |
| POSTHOOK: Lineage: src_orc.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] |
| POSTHOOK: Lineage: src_orc.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] |
| PREHOOK: query: -- Not using GenericUDFTestGetJavaBoolean; that is already registered when tests begin |
| |
| CREATE TEMPORARY FUNCTION test_udf0 AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFEvaluateNPE' |
| PREHOOK: type: CREATEFUNCTION |
| PREHOOK: Output: test_udf0 |
| POSTHOOK: query: -- Not using GenericUDFTestGetJavaBoolean; that is already registered when tests begin |
| |
| CREATE TEMPORARY FUNCTION test_udf0 AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFEvaluateNPE' |
| POSTHOOK: type: CREATEFUNCTION |
| POSTHOOK: Output: test_udf0 |
| PREHOOK: query: EXPLAIN SELECT test_udf0(cast(key as string)) from src_orc |
| PREHOOK: type: QUERY |
| POSTHOOK: query: EXPLAIN SELECT test_udf0(cast(key as string)) from src_orc |
| POSTHOOK: type: QUERY |
| STAGE DEPENDENCIES: |
| Stage-1 is a root stage |
| Stage-0 depends on stages: Stage-1 |
| |
| STAGE PLANS: |
| Stage: Stage-1 |
| Tez |
| #### A masked pattern was here #### |
| Vertices: |
| Map 1 |
| Map Operator Tree: |
| TableScan |
| alias: src_orc |
| Statistics: Num rows: 500 Data size: 88000 Basic stats: COMPLETE Column stats: NONE |
| Select Operator |
| expressions: evaluate_npe(key) (type: string) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 500 Data size: 88000 Basic stats: COMPLETE Column stats: NONE |
| File Output Operator |
| compressed: false |
| Statistics: Num rows: 500 Data size: 88000 Basic stats: COMPLETE Column stats: NONE |
| table: |
| input format: org.apache.hadoop.mapred.SequenceFileInputFormat |
| output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat |
| serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
| |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| ListSink |
| |
| PREHOOK: query: CREATE FUNCTION test_udf2 AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestGetJavaString' |
| PREHOOK: type: CREATEFUNCTION |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default.test_udf2 |
| POSTHOOK: query: CREATE FUNCTION test_udf2 AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestGetJavaString' |
| POSTHOOK: type: CREATEFUNCTION |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default.test_udf2 |
| PREHOOK: query: CREATE FUNCTION test_udf3 AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestGetJavaString' |
| PREHOOK: type: CREATEFUNCTION |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default.test_udf3 |
| POSTHOOK: query: CREATE FUNCTION test_udf3 AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFTestGetJavaString' |
| POSTHOOK: type: CREATEFUNCTION |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default.test_udf3 |
| PREHOOK: query: CREATE FUNCTION test_udf4 AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFEvaluateNPE' |
| PREHOOK: type: CREATEFUNCTION |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default.test_udf4 |
| POSTHOOK: query: CREATE FUNCTION test_udf4 AS 'org.apache.hadoop.hive.ql.udf.generic.GenericUDFEvaluateNPE' |
| POSTHOOK: type: CREATEFUNCTION |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default.test_udf4 |
| PREHOOK: query: EXPLAIN |
| SELECT test_udf2(cast(key as string)), test_udf3(cast(key as string)), test_udf4(cast(key as string)) from src_orc |
| PREHOOK: type: QUERY |
| POSTHOOK: query: EXPLAIN |
| SELECT test_udf2(cast(key as string)), test_udf3(cast(key as string)), test_udf4(cast(key as string)) from src_orc |
| POSTHOOK: type: QUERY |
| STAGE DEPENDENCIES: |
| Stage-1 is a root stage |
| Stage-0 depends on stages: Stage-1 |
| |
| STAGE PLANS: |
| Stage: Stage-1 |
| Tez |
| #### A masked pattern was here #### |
| Vertices: |
| Map 1 |
| Map Operator Tree: |
| TableScan |
| alias: src_orc |
| Statistics: Num rows: 500 Data size: 88000 Basic stats: COMPLETE Column stats: NONE |
| Select Operator |
| expressions: GenericUDFTestGetJavaString(key) (type: string), GenericUDFTestGetJavaString(key) (type: string), evaluate_npe(key) (type: string) |
| outputColumnNames: _col0, _col1, _col2 |
| Statistics: Num rows: 500 Data size: 88000 Basic stats: COMPLETE Column stats: NONE |
| File Output Operator |
| compressed: false |
| Statistics: Num rows: 500 Data size: 88000 Basic stats: COMPLETE Column stats: NONE |
| table: |
| input format: org.apache.hadoop.mapred.SequenceFileInputFormat |
| output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat |
| serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
| Execution mode: llap |
| LLAP IO: all inputs |
| |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| ListSink |
| |
| PREHOOK: query: -- Verification is based on classes, so 0 would work based on 4. |
| EXPLAIN |
| SELECT test_udf0(cast(key as string)) from src_orc |
| PREHOOK: type: QUERY |
| POSTHOOK: query: -- Verification is based on classes, so 0 would work based on 4. |
| EXPLAIN |
| SELECT test_udf0(cast(key as string)) from src_orc |
| POSTHOOK: type: QUERY |
| STAGE DEPENDENCIES: |
| Stage-1 is a root stage |
| Stage-0 depends on stages: Stage-1 |
| |
| STAGE PLANS: |
| Stage: Stage-1 |
| Tez |
| #### A masked pattern was here #### |
| Vertices: |
| Map 1 |
| Map Operator Tree: |
| TableScan |
| alias: src_orc |
| Statistics: Num rows: 500 Data size: 88000 Basic stats: COMPLETE Column stats: NONE |
| Select Operator |
| expressions: evaluate_npe(key) (type: string) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 500 Data size: 88000 Basic stats: COMPLETE Column stats: NONE |
| File Output Operator |
| compressed: false |
| Statistics: Num rows: 500 Data size: 88000 Basic stats: COMPLETE Column stats: NONE |
| table: |
| input format: org.apache.hadoop.mapred.SequenceFileInputFormat |
| output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat |
| serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
| |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| ListSink |
| |
| PREHOOK: query: DROP FUNCTION test_udf2 |
| PREHOOK: type: DROPFUNCTION |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default.test_udf2 |
| POSTHOOK: query: DROP FUNCTION test_udf2 |
| POSTHOOK: type: DROPFUNCTION |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default.test_udf2 |
| PREHOOK: query: -- ...verify that 3 still works |
| EXPLAIN |
| SELECT test_udf3(cast(key as string)), test_udf4(cast(key as string)) from src_orc |
| PREHOOK: type: QUERY |
| POSTHOOK: query: -- ...verify that 3 still works |
| EXPLAIN |
| SELECT test_udf3(cast(key as string)), test_udf4(cast(key as string)) from src_orc |
| POSTHOOK: type: QUERY |
| STAGE DEPENDENCIES: |
| Stage-1 is a root stage |
| Stage-0 depends on stages: Stage-1 |
| |
| STAGE PLANS: |
| Stage: Stage-1 |
| Tez |
| #### A masked pattern was here #### |
| Vertices: |
| Map 1 |
| Map Operator Tree: |
| TableScan |
| alias: src_orc |
| Statistics: Num rows: 500 Data size: 88000 Basic stats: COMPLETE Column stats: NONE |
| Select Operator |
| expressions: GenericUDFTestGetJavaString(key) (type: string), evaluate_npe(key) (type: string) |
| outputColumnNames: _col0, _col1 |
| Statistics: Num rows: 500 Data size: 88000 Basic stats: COMPLETE Column stats: NONE |
| File Output Operator |
| compressed: false |
| Statistics: Num rows: 500 Data size: 88000 Basic stats: COMPLETE Column stats: NONE |
| table: |
| input format: org.apache.hadoop.mapred.SequenceFileInputFormat |
| output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat |
| serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
| Execution mode: llap |
| LLAP IO: all inputs |
| |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| ListSink |
| |
| PREHOOK: query: DROP FUNCTION test_udf4 |
| PREHOOK: type: DROPFUNCTION |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default.test_udf4 |
| POSTHOOK: query: DROP FUNCTION test_udf4 |
| POSTHOOK: type: DROPFUNCTION |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default.test_udf4 |
| PREHOOK: query: -- ...now 0 should stop working |
| EXPLAIN |
| SELECT test_udf0(cast(key as string)) from src_orc |
| PREHOOK: type: QUERY |
| POSTHOOK: query: -- ...now 0 should stop working |
| EXPLAIN |
| SELECT test_udf0(cast(key as string)) from src_orc |
| POSTHOOK: type: QUERY |
| STAGE DEPENDENCIES: |
| Stage-1 is a root stage |
| Stage-0 depends on stages: Stage-1 |
| |
| STAGE PLANS: |
| Stage: Stage-1 |
| Tez |
| #### A masked pattern was here #### |
| Vertices: |
| Map 1 |
| Map Operator Tree: |
| TableScan |
| alias: src_orc |
| Statistics: Num rows: 500 Data size: 88000 Basic stats: COMPLETE Column stats: NONE |
| Select Operator |
| expressions: evaluate_npe(key) (type: string) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 500 Data size: 88000 Basic stats: COMPLETE Column stats: NONE |
| File Output Operator |
| compressed: false |
| Statistics: Num rows: 500 Data size: 88000 Basic stats: COMPLETE Column stats: NONE |
| table: |
| input format: org.apache.hadoop.mapred.SequenceFileInputFormat |
| output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat |
| serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
| |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| ListSink |
| |
| PREHOOK: query: EXPLAIN |
| SELECT test_udf3(cast(key as string)) from src_orc |
| PREHOOK: type: QUERY |
| POSTHOOK: query: EXPLAIN |
| SELECT test_udf3(cast(key as string)) from src_orc |
| POSTHOOK: type: QUERY |
| STAGE DEPENDENCIES: |
| Stage-1 is a root stage |
| Stage-0 depends on stages: Stage-1 |
| |
| STAGE PLANS: |
| Stage: Stage-1 |
| Tez |
| #### A masked pattern was here #### |
| Vertices: |
| Map 1 |
| Map Operator Tree: |
| TableScan |
| alias: src_orc |
| Statistics: Num rows: 500 Data size: 88000 Basic stats: COMPLETE Column stats: NONE |
| Select Operator |
| expressions: GenericUDFTestGetJavaString(key) (type: string) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 500 Data size: 88000 Basic stats: COMPLETE Column stats: NONE |
| File Output Operator |
| compressed: false |
| Statistics: Num rows: 500 Data size: 88000 Basic stats: COMPLETE Column stats: NONE |
| table: |
| input format: org.apache.hadoop.mapred.SequenceFileInputFormat |
| output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat |
| serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
| |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| ListSink |
| |
| PREHOOK: query: drop table if exists src_orc |
| PREHOOK: type: DROPTABLE |
| PREHOOK: Input: default@src_orc |
| PREHOOK: Output: default@src_orc |
| POSTHOOK: query: drop table if exists src_orc |
| POSTHOOK: type: DROPTABLE |
| POSTHOOK: Input: default@src_orc |
| POSTHOOK: Output: default@src_orc |