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

PREHOOK: query: create table t_n17 (s string) stored as orc
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@t_n17
POSTHOOK: query: create table t_n17 (s string) stored as orc
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@t_n17
PREHOOK: query: insert into t_n17 values ('false')
PREHOOK: type: QUERY
PREHOOK: Input: _dummy_database@_dummy_table
PREHOOK: Output: default@t_n17
POSTHOOK: query: insert into t_n17 values ('false')
POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
POSTHOOK: Output: default@t_n17
POSTHOOK: Lineage: t_n17.s SCRIPT []
PREHOOK: query: insert into t_n17 values ('FALSE')
PREHOOK: type: QUERY
PREHOOK: Input: _dummy_database@_dummy_table
PREHOOK: Output: default@t_n17
POSTHOOK: query: insert into t_n17 values ('FALSE')
POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
POSTHOOK: Output: default@t_n17
POSTHOOK: Lineage: t_n17.s SCRIPT []
PREHOOK: query: insert into t_n17 values ('FaLsE')
PREHOOK: type: QUERY
PREHOOK: Input: _dummy_database@_dummy_table
PREHOOK: Output: default@t_n17
POSTHOOK: query: insert into t_n17 values ('FaLsE')
POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
POSTHOOK: Output: default@t_n17
POSTHOOK: Lineage: t_n17.s SCRIPT []
PREHOOK: query: insert into t_n17 values ('true')
PREHOOK: type: QUERY
PREHOOK: Input: _dummy_database@_dummy_table
PREHOOK: Output: default@t_n17
POSTHOOK: query: insert into t_n17 values ('true')
POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
POSTHOOK: Output: default@t_n17
POSTHOOK: Lineage: t_n17.s SCRIPT []
PREHOOK: query: insert into t_n17 values ('TRUE')
PREHOOK: type: QUERY
PREHOOK: Input: _dummy_database@_dummy_table
PREHOOK: Output: default@t_n17
POSTHOOK: query: insert into t_n17 values ('TRUE')
POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
POSTHOOK: Output: default@t_n17
POSTHOOK: Lineage: t_n17.s SCRIPT []
PREHOOK: query: insert into t_n17 values ('TrUe')
PREHOOK: type: QUERY
PREHOOK: Input: _dummy_database@_dummy_table
PREHOOK: Output: default@t_n17
POSTHOOK: query: insert into t_n17 values ('TrUe')
POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
POSTHOOK: Output: default@t_n17
POSTHOOK: Lineage: t_n17.s SCRIPT []
PREHOOK: query: insert into t_n17 values ('')
PREHOOK: type: QUERY
PREHOOK: Input: _dummy_database@_dummy_table
PREHOOK: Output: default@t_n17
POSTHOOK: query: insert into t_n17 values ('')
POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
POSTHOOK: Output: default@t_n17
POSTHOOK: Lineage: t_n17.s SCRIPT []
PREHOOK: query: insert into t_n17 values ('Other')
PREHOOK: type: QUERY
PREHOOK: Input: _dummy_database@_dummy_table
PREHOOK: Output: default@t_n17
POSTHOOK: query: insert into t_n17 values ('Other')
POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
POSTHOOK: Output: default@t_n17
POSTHOOK: Lineage: t_n17.s SCRIPT []
PREHOOK: query: insert into t_n17 values ('Off')
PREHOOK: type: QUERY
PREHOOK: Input: _dummy_database@_dummy_table
PREHOOK: Output: default@t_n17
POSTHOOK: query: insert into t_n17 values ('Off')
POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
POSTHOOK: Output: default@t_n17
POSTHOOK: Lineage: t_n17.s SCRIPT []
PREHOOK: query: insert into t_n17 values ('No')
PREHOOK: type: QUERY
PREHOOK: Input: _dummy_database@_dummy_table
PREHOOK: Output: default@t_n17
POSTHOOK: query: insert into t_n17 values ('No')
POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
POSTHOOK: Output: default@t_n17
POSTHOOK: Lineage: t_n17.s SCRIPT []
PREHOOK: query: insert into t_n17 values ('0')
PREHOOK: type: QUERY
PREHOOK: Input: _dummy_database@_dummy_table
PREHOOK: Output: default@t_n17
POSTHOOK: query: insert into t_n17 values ('0')
POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
POSTHOOK: Output: default@t_n17
POSTHOOK: Lineage: t_n17.s SCRIPT []
PREHOOK: query: insert into t_n17 values ('1')
PREHOOK: type: QUERY
PREHOOK: Input: _dummy_database@_dummy_table
PREHOOK: Output: default@t_n17
POSTHOOK: query: insert into t_n17 values ('1')
POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
POSTHOOK: Output: default@t_n17
POSTHOOK: Lineage: t_n17.s SCRIPT []
PREHOOK: query: explain select s,cast(s as boolean) from t_n17 order by s
PREHOOK: type: QUERY
PREHOOK: Input: default@t_n17
#### A masked pattern was here ####
POSTHOOK: query: explain select s,cast(s as boolean) from t_n17 order by s
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t_n17
#### A masked pattern was here ####
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 ####
      Edges:
        Reducer 2 <- Map 1 (SIMPLE_EDGE)
#### A masked pattern was here ####
      Vertices:
        Map 1 
            Map Operator Tree:
                TableScan
                  alias: t_n17
                  Statistics: Num rows: 12 Data size: 1068 Basic stats: COMPLETE Column stats: COMPLETE
                  Select Operator
                    expressions: s (type: string), UDFToBoolean(s) (type: boolean)
                    outputColumnNames: _col0, _col1
                    Statistics: Num rows: 12 Data size: 1116 Basic stats: COMPLETE Column stats: COMPLETE
                    Reduce Output Operator
                      key expressions: _col0 (type: string)
                      null sort order: z
                      sort order: +
                      Statistics: Num rows: 12 Data size: 1116 Basic stats: COMPLETE Column stats: COMPLETE
                      value expressions: _col1 (type: boolean)
            Execution mode: llap
            LLAP IO: all inputs
        Reducer 2 
            Execution mode: llap
            Reduce Operator Tree:
              Select Operator
                expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: boolean)
                outputColumnNames: _col0, _col1
                Statistics: Num rows: 12 Data size: 1116 Basic stats: COMPLETE Column stats: COMPLETE
                File Output Operator
                  compressed: false
                  Statistics: Num rows: 12 Data size: 1116 Basic stats: COMPLETE Column stats: COMPLETE
                  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: select s,cast(s as boolean) from t_n17 order by s
PREHOOK: type: QUERY
PREHOOK: Input: default@t_n17
#### A masked pattern was here ####
POSTHOOK: query: select s,cast(s as boolean) from t_n17 order by s
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t_n17
#### A masked pattern was here ####
	false
0	false
1	true
FALSE	false
FaLsE	false
No	false
Off	false
Other	true
TRUE	true
TrUe	true
false	false
true	true