| PREHOOK: query: DROP TABLE orc_llap_acid_fast |
| PREHOOK: type: DROPTABLE |
| POSTHOOK: query: DROP TABLE orc_llap_acid_fast |
| POSTHOOK: type: DROPTABLE |
| PREHOOK: query: CREATE TABLE orc_llap_acid_fast ( |
| cint INT, |
| cbigint BIGINT, |
| cfloat FLOAT, |
| cdouble DOUBLE) |
| partitioned by (csmallint smallint) |
| clustered by (cint) into 2 buckets stored as orc |
| TBLPROPERTIES ('transactional'='true', 'transactional_properties'='default') |
| PREHOOK: type: CREATETABLE |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@orc_llap_acid_fast |
| POSTHOOK: query: CREATE TABLE orc_llap_acid_fast ( |
| cint INT, |
| cbigint BIGINT, |
| cfloat FLOAT, |
| cdouble DOUBLE) |
| partitioned by (csmallint smallint) |
| clustered by (cint) into 2 buckets stored as orc |
| TBLPROPERTIES ('transactional'='true', 'transactional_properties'='default') |
| POSTHOOK: type: CREATETABLE |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@orc_llap_acid_fast |
| PREHOOK: query: insert into table orc_llap_acid_fast partition (csmallint = 1) |
| select cint, cbigint, cfloat, cdouble from alltypesorc |
| where cdouble is not null order by cdouble asc limit 10 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@alltypesorc |
| PREHOOK: Output: default@orc_llap_acid_fast@csmallint=1 |
| POSTHOOK: query: insert into table orc_llap_acid_fast partition (csmallint = 1) |
| select cint, cbigint, cfloat, cdouble from alltypesorc |
| where cdouble is not null order by cdouble asc limit 10 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@alltypesorc |
| POSTHOOK: Output: default@orc_llap_acid_fast@csmallint=1 |
| POSTHOOK: Lineage: orc_llap_acid_fast PARTITION(csmallint=1).cbigint SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cbigint, type:bigint, comment:null), ] |
| POSTHOOK: Lineage: orc_llap_acid_fast PARTITION(csmallint=1).cdouble SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cdouble, type:double, comment:null), ] |
| POSTHOOK: Lineage: orc_llap_acid_fast PARTITION(csmallint=1).cfloat SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cfloat, type:float, comment:null), ] |
| POSTHOOK: Lineage: orc_llap_acid_fast PARTITION(csmallint=1).cint SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ] |
| PREHOOK: query: insert into table orc_llap_acid_fast partition (csmallint = 2) |
| select cint, cbigint, cfloat, cdouble from alltypesorc |
| where cdouble is not null order by cdouble asc limit 10 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@alltypesorc |
| PREHOOK: Output: default@orc_llap_acid_fast@csmallint=2 |
| POSTHOOK: query: insert into table orc_llap_acid_fast partition (csmallint = 2) |
| select cint, cbigint, cfloat, cdouble from alltypesorc |
| where cdouble is not null order by cdouble asc limit 10 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@alltypesorc |
| POSTHOOK: Output: default@orc_llap_acid_fast@csmallint=2 |
| POSTHOOK: Lineage: orc_llap_acid_fast PARTITION(csmallint=2).cbigint SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cbigint, type:bigint, comment:null), ] |
| POSTHOOK: Lineage: orc_llap_acid_fast PARTITION(csmallint=2).cdouble SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cdouble, type:double, comment:null), ] |
| POSTHOOK: Lineage: orc_llap_acid_fast PARTITION(csmallint=2).cfloat SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cfloat, type:float, comment:null), ] |
| POSTHOOK: Lineage: orc_llap_acid_fast PARTITION(csmallint=2).cint SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ] |
| PREHOOK: query: insert into table orc_llap_acid_fast partition (csmallint = 3) |
| select cint, cbigint, cfloat, cdouble from alltypesorc |
| where cdouble is not null order by cdouble desc limit 10 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@alltypesorc |
| PREHOOK: Output: default@orc_llap_acid_fast@csmallint=3 |
| POSTHOOK: query: insert into table orc_llap_acid_fast partition (csmallint = 3) |
| select cint, cbigint, cfloat, cdouble from alltypesorc |
| where cdouble is not null order by cdouble desc limit 10 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@alltypesorc |
| POSTHOOK: Output: default@orc_llap_acid_fast@csmallint=3 |
| POSTHOOK: Lineage: orc_llap_acid_fast PARTITION(csmallint=3).cbigint SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cbigint, type:bigint, comment:null), ] |
| POSTHOOK: Lineage: orc_llap_acid_fast PARTITION(csmallint=3).cdouble SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cdouble, type:double, comment:null), ] |
| POSTHOOK: Lineage: orc_llap_acid_fast PARTITION(csmallint=3).cfloat SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cfloat, type:float, comment:null), ] |
| POSTHOOK: Lineage: orc_llap_acid_fast PARTITION(csmallint=3).cint SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ] |
| PREHOOK: query: explain vectorization only detail |
| select cint, csmallint, cbigint from orc_llap_acid_fast where cint is not null order |
| by csmallint, cint |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_llap_acid_fast |
| PREHOOK: Input: default@orc_llap_acid_fast@csmallint=1 |
| PREHOOK: Input: default@orc_llap_acid_fast@csmallint=2 |
| PREHOOK: Input: default@orc_llap_acid_fast@csmallint=3 |
| #### A masked pattern was here #### |
| POSTHOOK: query: explain vectorization only detail |
| select cint, csmallint, cbigint from orc_llap_acid_fast where cint is not null order |
| by csmallint, cint |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@orc_llap_acid_fast |
| POSTHOOK: Input: default@orc_llap_acid_fast@csmallint=1 |
| POSTHOOK: Input: default@orc_llap_acid_fast@csmallint=2 |
| POSTHOOK: Input: default@orc_llap_acid_fast@csmallint=3 |
| #### A masked pattern was here #### |
| PLAN VECTORIZATION: |
| enabled: true |
| enabledConditionsMet: [hive.vectorized.execution.enabled IS true] |
| |
| STAGE DEPENDENCIES: |
| Stage-1 is a root stage |
| Stage-0 depends on stages: Stage-1 |
| |
| STAGE PLANS: |
| Stage: Stage-1 |
| Tez |
| Edges: |
| Reducer 2 <- Map 1 (SIMPLE_EDGE) |
| Vertices: |
| Map 1 |
| Map Operator Tree: |
| TableScan Vectorization: |
| native: true |
| vectorizationSchemaColumns: [0:cint:int, 1:cbigint:bigint, 2:cfloat:float, 3:cdouble:double, 4:csmallint:smallint, 5:ROW__ID:struct<writeid:bigint,bucketid:int,rowid:bigint>] |
| Filter Vectorization: |
| className: VectorFilterOperator |
| native: true |
| predicateExpression: SelectColumnIsNotNull(col 0:int) |
| Select Vectorization: |
| className: VectorSelectOperator |
| native: true |
| projectedOutputColumnNums: [0, 4, 1] |
| Reduce Sink Vectorization: |
| className: VectorReduceSinkObjectHashOperator |
| keyColumns: 4:smallint, 0:int |
| native: true |
| nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true, No PTF TopN IS true, No DISTINCT columns IS true, BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true |
| valueColumns: 1:bigint |
| Execution mode: vectorized, llap |
| LLAP IO: may be used (ACID table) |
| Map Vectorization: |
| enabled: true |
| enabledConditionsMet: hive.vectorized.use.vectorized.input.format IS true |
| inputFormatFeatureSupport: [DECIMAL_64] |
| featureSupportInUse: [DECIMAL_64] |
| inputFileFormats: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat |
| allNative: true |
| usesVectorUDFAdaptor: false |
| vectorized: true |
| rowBatchContext: |
| dataColumnCount: 4 |
| includeColumns: [0, 1] |
| dataColumns: cint:int, cbigint:bigint, cfloat:float, cdouble:double |
| partitionColumnCount: 1 |
| partitionColumns: csmallint:smallint |
| scratchColumnTypeNames: [] |
| Reducer 2 |
| Execution mode: vectorized, llap |
| Reduce Vectorization: |
| enabled: true |
| enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true |
| reduceColumnNullOrder: zz |
| reduceColumnSortOrder: ++ |
| allNative: false |
| usesVectorUDFAdaptor: false |
| vectorized: true |
| rowBatchContext: |
| dataColumnCount: 3 |
| dataColumns: KEY.reducesinkkey0:smallint, KEY.reducesinkkey1:int, VALUE._col0:bigint |
| partitionColumnCount: 0 |
| scratchColumnTypeNames: [] |
| Reduce Operator Tree: |
| Select Vectorization: |
| className: VectorSelectOperator |
| native: true |
| projectedOutputColumnNums: [1, 0, 2] |
| File Sink Vectorization: |
| className: VectorFileSinkOperator |
| native: false |
| |
| Stage: Stage-0 |
| Fetch Operator |
| |
| PREHOOK: query: select cint, csmallint, cbigint from orc_llap_acid_fast where cint is not null order |
| by csmallint, cint |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_llap_acid_fast |
| PREHOOK: Input: default@orc_llap_acid_fast@csmallint=1 |
| PREHOOK: Input: default@orc_llap_acid_fast@csmallint=2 |
| PREHOOK: Input: default@orc_llap_acid_fast@csmallint=3 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select cint, csmallint, cbigint from orc_llap_acid_fast where cint is not null order |
| by csmallint, cint |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@orc_llap_acid_fast |
| POSTHOOK: Input: default@orc_llap_acid_fast@csmallint=1 |
| POSTHOOK: Input: default@orc_llap_acid_fast@csmallint=2 |
| POSTHOOK: Input: default@orc_llap_acid_fast@csmallint=3 |
| #### A masked pattern was here #### |
| -894716315 1 1864027286 |
| 206154150 1 1864027286 |
| 253665376 1 NULL |
| 253665376 1 NULL |
| 253665376 1 NULL |
| 528534767 1 NULL |
| 528534767 1 NULL |
| 626923679 1 NULL |
| 626923679 1 NULL |
| 626923679 1 NULL |
| -894716315 2 1864027286 |
| 206154150 2 1864027286 |
| 253665376 2 NULL |
| 253665376 2 NULL |
| 253665376 2 NULL |
| 528534767 2 NULL |
| 528534767 2 NULL |
| 626923679 2 NULL |
| 626923679 2 NULL |
| 626923679 2 NULL |
| -923308739 3 -1887561756 |
| -3728 3 -1887561756 |
| 762 3 -1645852809 |
| 6981 3 -1887561756 |
| 253665376 3 NULL |
| 497728223 3 -1887561756 |
| 528534767 3 NULL |
| 528534767 3 NULL |
| 528534767 3 NULL |
| 528534767 3 NULL |
| PREHOOK: query: insert into table orc_llap_acid_fast partition (csmallint = 1) values (1, 1, 1, 1) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: _dummy_database@_dummy_table |
| PREHOOK: Output: default@orc_llap_acid_fast@csmallint=1 |
| POSTHOOK: query: insert into table orc_llap_acid_fast partition (csmallint = 1) values (1, 1, 1, 1) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: _dummy_database@_dummy_table |
| POSTHOOK: Output: default@orc_llap_acid_fast@csmallint=1 |
| POSTHOOK: Lineage: orc_llap_acid_fast PARTITION(csmallint=1).cbigint SCRIPT [] |
| POSTHOOK: Lineage: orc_llap_acid_fast PARTITION(csmallint=1).cdouble SCRIPT [] |
| POSTHOOK: Lineage: orc_llap_acid_fast PARTITION(csmallint=1).cfloat SCRIPT [] |
| POSTHOOK: Lineage: orc_llap_acid_fast PARTITION(csmallint=1).cint SCRIPT [] |
| PREHOOK: query: explain vectorization only detail |
| update orc_llap_acid_fast set cbigint = 2 where cint = 1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_llap_acid_fast |
| PREHOOK: Input: default@orc_llap_acid_fast@csmallint=1 |
| PREHOOK: Input: default@orc_llap_acid_fast@csmallint=2 |
| PREHOOK: Input: default@orc_llap_acid_fast@csmallint=3 |
| PREHOOK: Output: default@orc_llap_acid_fast@csmallint=1 |
| PREHOOK: Output: default@orc_llap_acid_fast@csmallint=2 |
| PREHOOK: Output: default@orc_llap_acid_fast@csmallint=3 |
| POSTHOOK: query: explain vectorization only detail |
| update orc_llap_acid_fast set cbigint = 2 where cint = 1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@orc_llap_acid_fast |
| POSTHOOK: Input: default@orc_llap_acid_fast@csmallint=1 |
| POSTHOOK: Input: default@orc_llap_acid_fast@csmallint=2 |
| POSTHOOK: Input: default@orc_llap_acid_fast@csmallint=3 |
| POSTHOOK: Output: default@orc_llap_acid_fast@csmallint=1 |
| POSTHOOK: Output: default@orc_llap_acid_fast@csmallint=2 |
| POSTHOOK: Output: default@orc_llap_acid_fast@csmallint=3 |
| PLAN VECTORIZATION: |
| enabled: true |
| enabledConditionsMet: [hive.vectorized.execution.enabled IS true] |
| |
| STAGE DEPENDENCIES: |
| Stage-1 is a root stage |
| Stage-2 depends on stages: Stage-1 |
| Stage-0 depends on stages: Stage-2 |
| Stage-3 depends on stages: Stage-0 |
| |
| STAGE PLANS: |
| Stage: Stage-1 |
| Tez |
| Edges: |
| Reducer 2 <- Map 1 (SIMPLE_EDGE) |
| Vertices: |
| Map 1 |
| Map Operator Tree: |
| TableScan Vectorization: |
| native: true |
| vectorizationSchemaColumns: [0:cint:int, 1:cbigint:bigint, 2:cfloat:float, 3:cdouble:double, 4:csmallint:smallint, 5:ROW__ID:struct<writeid:bigint,bucketid:int,rowid:bigint>] |
| Filter Vectorization: |
| className: VectorFilterOperator |
| native: true |
| predicateExpression: FilterLongColEqualLongScalar(col 0:int, val 1) |
| Select Vectorization: |
| className: VectorSelectOperator |
| native: true |
| projectedOutputColumnNums: [5, 2, 3, 4] |
| Reduce Sink Vectorization: |
| className: VectorReduceSinkObjectHashOperator |
| keyColumns: 5:struct<writeid:bigint,bucketid:int,rowid:bigint> |
| native: true |
| nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true, No PTF TopN IS true, No DISTINCT columns IS true, BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true |
| partitionColumns: 6:int |
| valueColumns: 2:float, 3:double, 4:smallint |
| Execution mode: vectorized, llap |
| LLAP IO: may be used (ACID table) |
| Map Vectorization: |
| enabled: true |
| enabledConditionsMet: hive.vectorized.use.vectorized.input.format IS true |
| inputFormatFeatureSupport: [DECIMAL_64] |
| featureSupportInUse: [DECIMAL_64] |
| inputFileFormats: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat |
| allNative: true |
| usesVectorUDFAdaptor: false |
| vectorized: true |
| rowBatchContext: |
| dataColumnCount: 4 |
| includeColumns: [0, 2, 3] |
| dataColumns: cint:int, cbigint:bigint, cfloat:float, cdouble:double |
| neededVirtualColumns: [ROWID] |
| partitionColumnCount: 1 |
| partitionColumns: csmallint:smallint |
| scratchColumnTypeNames: [bigint] |
| Reducer 2 |
| Execution mode: vectorized, llap |
| Reduce Vectorization: |
| enabled: true |
| enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true |
| reduceColumnNullOrder: z |
| reduceColumnSortOrder: + |
| allNative: false |
| usesVectorUDFAdaptor: false |
| vectorized: true |
| rowBatchContext: |
| dataColumnCount: 4 |
| dataColumns: KEY.reducesinkkey0:struct<writeid:bigint,bucketid:int,rowid:bigint>, VALUE._col0:float, VALUE._col1:double, VALUE._col2:smallint |
| partitionColumnCount: 0 |
| scratchColumnTypeNames: [bigint, bigint] |
| Reduce Operator Tree: |
| Select Vectorization: |
| className: VectorSelectOperator |
| native: true |
| projectedOutputColumnNums: [0, 4, 5, 1, 2, 3] |
| selectExpressions: ConstantVectorExpression(val 1) -> 4:int, ConstantVectorExpression(val 2) -> 5:bigint |
| File Sink Vectorization: |
| className: VectorFileSinkOperator |
| native: false |
| |
| Stage: Stage-2 |
| |
| Stage: Stage-0 |
| |
| Stage: Stage-3 |
| |
| PREHOOK: query: update orc_llap_acid_fast set cbigint = 2 where cint = 1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_llap_acid_fast |
| PREHOOK: Input: default@orc_llap_acid_fast@csmallint=1 |
| PREHOOK: Input: default@orc_llap_acid_fast@csmallint=2 |
| PREHOOK: Input: default@orc_llap_acid_fast@csmallint=3 |
| PREHOOK: Output: default@orc_llap_acid_fast@csmallint=1 |
| PREHOOK: Output: default@orc_llap_acid_fast@csmallint=2 |
| PREHOOK: Output: default@orc_llap_acid_fast@csmallint=3 |
| POSTHOOK: query: update orc_llap_acid_fast set cbigint = 2 where cint = 1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@orc_llap_acid_fast |
| POSTHOOK: Input: default@orc_llap_acid_fast@csmallint=1 |
| POSTHOOK: Input: default@orc_llap_acid_fast@csmallint=2 |
| POSTHOOK: Input: default@orc_llap_acid_fast@csmallint=3 |
| POSTHOOK: Output: default@orc_llap_acid_fast@csmallint=1 |
| POSTHOOK: Output: default@orc_llap_acid_fast@csmallint=2 |
| POSTHOOK: Output: default@orc_llap_acid_fast@csmallint=3 |
| PREHOOK: query: explain vectorization only detail |
| select cint, csmallint, cbigint from orc_llap_acid_fast where cint is not null order |
| by csmallint, cint |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_llap_acid_fast |
| PREHOOK: Input: default@orc_llap_acid_fast@csmallint=1 |
| PREHOOK: Input: default@orc_llap_acid_fast@csmallint=2 |
| PREHOOK: Input: default@orc_llap_acid_fast@csmallint=3 |
| #### A masked pattern was here #### |
| POSTHOOK: query: explain vectorization only detail |
| select cint, csmallint, cbigint from orc_llap_acid_fast where cint is not null order |
| by csmallint, cint |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@orc_llap_acid_fast |
| POSTHOOK: Input: default@orc_llap_acid_fast@csmallint=1 |
| POSTHOOK: Input: default@orc_llap_acid_fast@csmallint=2 |
| POSTHOOK: Input: default@orc_llap_acid_fast@csmallint=3 |
| #### A masked pattern was here #### |
| PLAN VECTORIZATION: |
| enabled: true |
| enabledConditionsMet: [hive.vectorized.execution.enabled IS true] |
| |
| STAGE DEPENDENCIES: |
| Stage-1 is a root stage |
| Stage-0 depends on stages: Stage-1 |
| |
| STAGE PLANS: |
| Stage: Stage-1 |
| Tez |
| Edges: |
| Reducer 2 <- Map 1 (SIMPLE_EDGE) |
| Vertices: |
| Map 1 |
| Map Operator Tree: |
| TableScan Vectorization: |
| native: true |
| vectorizationSchemaColumns: [0:cint:int, 1:cbigint:bigint, 2:cfloat:float, 3:cdouble:double, 4:csmallint:smallint, 5:ROW__ID:struct<writeid:bigint,bucketid:int,rowid:bigint>] |
| Filter Vectorization: |
| className: VectorFilterOperator |
| native: true |
| predicateExpression: SelectColumnIsNotNull(col 0:int) |
| Select Vectorization: |
| className: VectorSelectOperator |
| native: true |
| projectedOutputColumnNums: [0, 4, 1] |
| Reduce Sink Vectorization: |
| className: VectorReduceSinkObjectHashOperator |
| keyColumns: 4:smallint, 0:int |
| native: true |
| nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true, No PTF TopN IS true, No DISTINCT columns IS true, BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true |
| valueColumns: 1:bigint |
| Execution mode: vectorized, llap |
| LLAP IO: may be used (ACID table) |
| Map Vectorization: |
| enabled: true |
| enabledConditionsMet: hive.vectorized.use.vectorized.input.format IS true |
| inputFormatFeatureSupport: [DECIMAL_64] |
| featureSupportInUse: [DECIMAL_64] |
| inputFileFormats: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat |
| allNative: true |
| usesVectorUDFAdaptor: false |
| vectorized: true |
| rowBatchContext: |
| dataColumnCount: 4 |
| includeColumns: [0, 1] |
| dataColumns: cint:int, cbigint:bigint, cfloat:float, cdouble:double |
| partitionColumnCount: 1 |
| partitionColumns: csmallint:smallint |
| scratchColumnTypeNames: [] |
| Reducer 2 |
| Execution mode: vectorized, llap |
| Reduce Vectorization: |
| enabled: true |
| enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true |
| reduceColumnNullOrder: zz |
| reduceColumnSortOrder: ++ |
| allNative: false |
| usesVectorUDFAdaptor: false |
| vectorized: true |
| rowBatchContext: |
| dataColumnCount: 3 |
| dataColumns: KEY.reducesinkkey0:smallint, KEY.reducesinkkey1:int, VALUE._col0:bigint |
| partitionColumnCount: 0 |
| scratchColumnTypeNames: [] |
| Reduce Operator Tree: |
| Select Vectorization: |
| className: VectorSelectOperator |
| native: true |
| projectedOutputColumnNums: [1, 0, 2] |
| File Sink Vectorization: |
| className: VectorFileSinkOperator |
| native: false |
| |
| Stage: Stage-0 |
| Fetch Operator |
| |
| PREHOOK: query: select cint, csmallint, cbigint from orc_llap_acid_fast where cint is not null order |
| by csmallint, cint |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@orc_llap_acid_fast |
| PREHOOK: Input: default@orc_llap_acid_fast@csmallint=1 |
| PREHOOK: Input: default@orc_llap_acid_fast@csmallint=2 |
| PREHOOK: Input: default@orc_llap_acid_fast@csmallint=3 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select cint, csmallint, cbigint from orc_llap_acid_fast where cint is not null order |
| by csmallint, cint |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@orc_llap_acid_fast |
| POSTHOOK: Input: default@orc_llap_acid_fast@csmallint=1 |
| POSTHOOK: Input: default@orc_llap_acid_fast@csmallint=2 |
| POSTHOOK: Input: default@orc_llap_acid_fast@csmallint=3 |
| #### A masked pattern was here #### |
| -894716315 1 1864027286 |
| 1 1 2 |
| 206154150 1 1864027286 |
| 253665376 1 NULL |
| 253665376 1 NULL |
| 253665376 1 NULL |
| 528534767 1 NULL |
| 528534767 1 NULL |
| 626923679 1 NULL |
| 626923679 1 NULL |
| 626923679 1 NULL |
| -894716315 2 1864027286 |
| 206154150 2 1864027286 |
| 253665376 2 NULL |
| 253665376 2 NULL |
| 253665376 2 NULL |
| 528534767 2 NULL |
| 528534767 2 NULL |
| 626923679 2 NULL |
| 626923679 2 NULL |
| 626923679 2 NULL |
| -923308739 3 -1887561756 |
| -3728 3 -1887561756 |
| 762 3 -1645852809 |
| 6981 3 -1887561756 |
| 253665376 3 NULL |
| 497728223 3 -1887561756 |
| 528534767 3 NULL |
| 528534767 3 NULL |
| 528534767 3 NULL |
| 528534767 3 NULL |
| PREHOOK: query: DROP TABLE orc_llap_acid_fast |
| PREHOOK: type: DROPTABLE |
| PREHOOK: Input: default@orc_llap_acid_fast |
| PREHOOK: Output: default@orc_llap_acid_fast |
| POSTHOOK: query: DROP TABLE orc_llap_acid_fast |
| POSTHOOK: type: DROPTABLE |
| POSTHOOK: Input: default@orc_llap_acid_fast |
| POSTHOOK: Output: default@orc_llap_acid_fast |