ql/src/test/results/clientpositive/udf_bitwise_shiftleft.q.out

PREHOOK: query: DESCRIBE FUNCTION shiftleft
PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION shiftleft
POSTHOOK: type: DESCFUNCTION
shiftleft(a, b) - Bitwise left shift
PREHOOK: query: DESC FUNCTION EXTENDED shiftleft
PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESC FUNCTION EXTENDED shiftleft
POSTHOOK: type: DESCFUNCTION
shiftleft(a, b) - Bitwise left shift
Returns int for tinyint, smallint and int a. Returns bigint for bigint a.
Example:
  > SELECT shiftleft(2, 1);
  4
Function class:org.apache.hadoop.hive.ql.udf.UDFOPBitShiftLeft
Function type:BUILTIN
PREHOOK: query: explain select shiftleft(4, 1)
PREHOOK: type: QUERY
POSTHOOK: query: explain select shiftleft(4, 1)
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
  Stage-0 is a root stage

STAGE PLANS:
  Stage: Stage-0
    Fetch Operator
      limit: -1
      Processor Tree:
        TableScan
          alias: _dummy_table
          Row Limit Per Split: 1
          Statistics: Num rows: 1 Data size: 10 Basic stats: COMPLETE Column stats: COMPLETE
          Select Operator
            expressions: 8 (type: int)
            outputColumnNames: _col0
            Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE Column stats: COMPLETE
            ListSink

PREHOOK: query: select
shiftleft(a, 0),
shiftleft(a, 1),
shiftleft(a, 2),
shiftleft(a, 3),
shiftleft(a, 4),
shiftleft(a, 5),
shiftleft(a, 6),
shiftleft(a, 7),
shiftleft(a, 8),
shiftleft(a, 13),
shiftleft(a, 14),
shiftleft(a, 29),
shiftleft(a, 30),
shiftleft(a, 61),
shiftleft(a, 62)
from (
  select cast(4 as tinyint) a
) t
PREHOOK: type: QUERY
PREHOOK: Input: _dummy_database@_dummy_table
#### A masked pattern was here ####
POSTHOOK: query: select
shiftleft(a, 0),
shiftleft(a, 1),
shiftleft(a, 2),
shiftleft(a, 3),
shiftleft(a, 4),
shiftleft(a, 5),
shiftleft(a, 6),
shiftleft(a, 7),
shiftleft(a, 8),
shiftleft(a, 13),
shiftleft(a, 14),
shiftleft(a, 29),
shiftleft(a, 30),
shiftleft(a, 61),
shiftleft(a, 62)
from (
  select cast(4 as tinyint) a
) t
POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
#### A masked pattern was here ####
4	8	16	32	64	128	256	512	1024	32768	65536	-2147483648	0	-2147483648	0
PREHOOK: query: select
shiftleft(a, 0),
shiftleft(a, 1),
shiftleft(a, 2),
shiftleft(a, 3),
shiftleft(a, 4),
shiftleft(a, 5),
shiftleft(a, 6),
shiftleft(a, 7),
shiftleft(a, 8),
shiftleft(a, 13),
shiftleft(a, 14),
shiftleft(a, 29),
shiftleft(a, 30),
shiftleft(a, 61),
shiftleft(a, 62)
from (
  select cast(4 as smallint) a
) t
PREHOOK: type: QUERY
PREHOOK: Input: _dummy_database@_dummy_table
#### A masked pattern was here ####
POSTHOOK: query: select
shiftleft(a, 0),
shiftleft(a, 1),
shiftleft(a, 2),
shiftleft(a, 3),
shiftleft(a, 4),
shiftleft(a, 5),
shiftleft(a, 6),
shiftleft(a, 7),
shiftleft(a, 8),
shiftleft(a, 13),
shiftleft(a, 14),
shiftleft(a, 29),
shiftleft(a, 30),
shiftleft(a, 61),
shiftleft(a, 62)
from (
  select cast(4 as smallint) a
) t
POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
#### A masked pattern was here ####
4	8	16	32	64	128	256	512	1024	32768	65536	-2147483648	0	-2147483648	0
PREHOOK: query: select
shiftleft(a, 0),
shiftleft(a, 1),
shiftleft(a, 2),
shiftleft(a, 3),
shiftleft(a, 4),
shiftleft(a, 5),
shiftleft(a, 6),
shiftleft(a, 7),
shiftleft(a, 8),
shiftleft(a, 13),
shiftleft(a, 14),
shiftleft(a, 29),
shiftleft(a, 30),
shiftleft(a, 61),
shiftleft(a, 62)
from (
  select cast(4 as int) a
) t
PREHOOK: type: QUERY
PREHOOK: Input: _dummy_database@_dummy_table
#### A masked pattern was here ####
POSTHOOK: query: select
shiftleft(a, 0),
shiftleft(a, 1),
shiftleft(a, 2),
shiftleft(a, 3),
shiftleft(a, 4),
shiftleft(a, 5),
shiftleft(a, 6),
shiftleft(a, 7),
shiftleft(a, 8),
shiftleft(a, 13),
shiftleft(a, 14),
shiftleft(a, 29),
shiftleft(a, 30),
shiftleft(a, 61),
shiftleft(a, 62)
from (
  select cast(4 as int) a
) t
POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
#### A masked pattern was here ####
4	8	16	32	64	128	256	512	1024	32768	65536	-2147483648	0	-2147483648	0
PREHOOK: query: select
shiftleft(a, 0),
shiftleft(a, 1),
shiftleft(a, 2),
shiftleft(a, 3),
shiftleft(a, 4),
shiftleft(a, 5),
shiftleft(a, 6),
shiftleft(a, 7),
shiftleft(a, 8),
shiftleft(a, 13),
shiftleft(a, 14),
shiftleft(a, 29),
shiftleft(a, 30),
shiftleft(a, 61),
shiftleft(a, 62)
from (
  select cast(4 as bigint) a
) t
PREHOOK: type: QUERY
PREHOOK: Input: _dummy_database@_dummy_table
#### A masked pattern was here ####
POSTHOOK: query: select
shiftleft(a, 0),
shiftleft(a, 1),
shiftleft(a, 2),
shiftleft(a, 3),
shiftleft(a, 4),
shiftleft(a, 5),
shiftleft(a, 6),
shiftleft(a, 7),
shiftleft(a, 8),
shiftleft(a, 13),
shiftleft(a, 14),
shiftleft(a, 29),
shiftleft(a, 30),
shiftleft(a, 61),
shiftleft(a, 62)
from (
  select cast(4 as bigint) a
) t
POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
#### A masked pattern was here ####
4	8	16	32	64	128	256	512	1024	32768	65536	2147483648	4294967296	-9223372036854775808	0
PREHOOK: query: select
shiftleft(4, 33),
shiftleft(4, 65),
shiftleft(4, 4001),
shiftleft(16, -2),
shiftleft(4, cast(null as int)),
shiftleft(cast(null as int), 4),
shiftleft(cast(null as int), cast(null as int))
PREHOOK: type: QUERY
PREHOOK: Input: _dummy_database@_dummy_table
#### A masked pattern was here ####
POSTHOOK: query: select
shiftleft(4, 33),
shiftleft(4, 65),
shiftleft(4, 4001),
shiftleft(16, -2),
shiftleft(4, cast(null as int)),
shiftleft(cast(null as int), 4),
shiftleft(cast(null as int), cast(null as int))
POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
#### A masked pattern was here ####
8	8	8	0	NULL	NULL	NULL