ql/src/test/results/clientpositive/llap/acid_bucket_pruning.q.out

PREHOOK: query: CREATE TABLE acidTblDefault(a INT) CLUSTERED BY(a) INTO 16 BUCKETS STORED AS ORC TBLPROPERTIES ('transactional'='true', 'transactional_properties'='default')
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@acidTblDefault
POSTHOOK: query: CREATE TABLE acidTblDefault(a INT) CLUSTERED BY(a) INTO 16 BUCKETS STORED AS ORC TBLPROPERTIES ('transactional'='true', 'transactional_properties'='default')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acidTblDefault
PREHOOK: query: INSERT INTO TABLE acidTblDefault SELECT cint FROM alltypesorc WHERE cint IS NOT NULL ORDER BY cint
PREHOOK: type: QUERY
PREHOOK: Input: default@alltypesorc
PREHOOK: Output: default@acidtbldefault
POSTHOOK: query: INSERT INTO TABLE acidTblDefault SELECT cint FROM alltypesorc WHERE cint IS NOT NULL ORDER BY cint
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alltypesorc
POSTHOOK: Output: default@acidtbldefault
POSTHOOK: Lineage: acidtbldefault.a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
PREHOOK: query: INSERT INTO TABLE acidTblDefault VALUES (1)
PREHOOK: type: QUERY
PREHOOK: Input: _dummy_database@_dummy_table
PREHOOK: Output: default@acidtbldefault
POSTHOOK: query: INSERT INTO TABLE acidTblDefault VALUES (1)
POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
POSTHOOK: Output: default@acidtbldefault
POSTHOOK: Lineage: acidtbldefault.a SCRIPT []
PREHOOK: query: EXPLAIN EXTENDED
SELECT * FROM acidTblDefault WHERE a = 1
PREHOOK: type: QUERY
PREHOOK: Input: default@acidtbldefault
PREHOOK: Output: hdfs://### HDFS PATH ###
POSTHOOK: query: EXPLAIN EXTENDED
SELECT * FROM acidTblDefault WHERE a = 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@acidtbldefault
POSTHOOK: Output: hdfs://### HDFS PATH ###
OPTIMIZED SQL: SELECT CAST(1 AS INTEGER) AS `$f0`
FROM `default`.`acidtbldefault`
WHERE `a` = 1
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: acidtbldefault
                  filterExpr: (a = 1) (type: boolean)
                  buckets included: [13,] of 16
                  Statistics: Num rows: 9174 Data size: 36696 Basic stats: COMPLETE Column stats: COMPLETE
                  GatherStats: false
                  Filter Operator
                    isSamplingPred: false
                    predicate: (a = 1) (type: boolean)
                    Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
                    Select Operator
                      expressions: 1 (type: int)
                      outputColumnNames: _col0
                      Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
                      File Output Operator
                        bucketingVersion: 2
                        compressed: false
                        GlobalTableId: 0
                        directory: hdfs://### HDFS PATH ###
                        NumFilesPerFileSink: 1
                        Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
                        Stats Publishing Key Prefix: hdfs://### HDFS PATH ###
                        table:
                            input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                            output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                            properties:
                              bucketing_version -1
                              columns _col0
                              columns.types int
                              escape.delim \
                              hive.serialization.extend.additional.nesting.levels true
                              serialization.escape.crlf true
                              serialization.format 1
                              serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                            serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                        TotalFiles: 1
                        GatherStats: false
                        MultiFileSpray: false
            Execution mode: vectorized, llap
            LLAP IO: may be used (ACID table)
            Path -> Alias:
              hdfs://### HDFS PATH ### [acidtbldefault]
            Path -> Partition:
              hdfs://### HDFS PATH ### 
                Partition
                  base file name: acidtbldefault
                  input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
                  output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
                  properties:
                    bucket_count 16
                    bucket_field_name a
                    bucketing_version 2
                    column.name.delimiter ,
                    columns a
                    columns.types int
#### A masked pattern was here ####
                    location hdfs://### HDFS PATH ###
                    name default.acidtbldefault
                    serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
                    transactional true
                    transactional_properties default
                  serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
                
                    input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
                    output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
                    properties:
                      bucket_count 16
                      bucket_field_name a
                      bucketing_version 2
                      column.name.delimiter ,
                      columns a
                      columns.comments 
                      columns.types int
#### A masked pattern was here ####
                      location hdfs://### HDFS PATH ###
                      name default.acidtbldefault
                      serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
                      transactional true
                      transactional_properties default
                    serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
                    name: default.acidtbldefault
                  name: default.acidtbldefault
            Truncated Path -> Alias:
              /acidtbldefault [acidtbldefault]

  Stage: Stage-0
    Fetch Operator
      limit: -1
      Processor Tree:
        ListSink

PREHOOK: query: select count(*) from acidTblDefault WHERE a = 1
PREHOOK: type: QUERY
PREHOOK: Input: default@acidtbldefault
PREHOOK: Output: hdfs://### HDFS PATH ###
POSTHOOK: query: select count(*) from acidTblDefault WHERE a = 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@acidtbldefault
POSTHOOK: Output: hdfs://### HDFS PATH ###
1
PREHOOK: query: select count(*) from acidTblDefault WHERE a = 1
PREHOOK: type: QUERY
PREHOOK: Input: default@acidtbldefault
PREHOOK: Output: hdfs://### HDFS PATH ###
POSTHOOK: query: select count(*) from acidTblDefault WHERE a = 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@acidtbldefault
POSTHOOK: Output: hdfs://### HDFS PATH ###
1