PREHOOK: query: DESCRIBE FUNCTION shiftright
PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION shiftright
POSTHOOK: type: DESCFUNCTION
shiftright(a, b) - Bitwise right shift
PREHOOK: query: DESC FUNCTION EXTENDED shiftright
PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESC FUNCTION EXTENDED shiftright
POSTHOOK: type: DESCFUNCTION
shiftright(a, b) - Bitwise right shift
Returns int for tinyint, smallint and int a. Returns bigint for bigint a.
Example:
  > SELECT shiftright(4, 1);
  2
PREHOOK: query: explain select shiftright(4, 1)
PREHOOK: type: QUERY
POSTHOOK: query: explain select shiftright(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: 0 Data size: 1 Basic stats: PARTIAL Column stats: COMPLETE
          Select Operator
            expressions: 2 (type: int)
            outputColumnNames: _col0
            Statistics: Num rows: 0 Data size: 1 Basic stats: PARTIAL Column stats: COMPLETE
            ListSink

PREHOOK: query: select
shiftright(a, 0),
shiftright(a, 1),
shiftright(a, 2),
shiftright(a, 3),
shiftright(a, 4),
shiftright(a, 5),
shiftright(a, 6),
shiftright(a, 31),
shiftright(a, 32)
from (
  select cast(-128 as tinyint) a
) t
PREHOOK: type: QUERY
PREHOOK: Input: _dummy_database@_dummy_table
#### A masked pattern was here ####
POSTHOOK: query: select
shiftright(a, 0),
shiftright(a, 1),
shiftright(a, 2),
shiftright(a, 3),
shiftright(a, 4),
shiftright(a, 5),
shiftright(a, 6),
shiftright(a, 31),
shiftright(a, 32)
from (
  select cast(-128 as tinyint) a
) t
POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
#### A masked pattern was here ####
-128	-64	-32	-16	-8	-4	-2	-1	-128
PREHOOK: query: select
shiftright(a, 0),
shiftright(a, 1),
shiftright(a, 2),
shiftright(a, 8),
shiftright(a, 9),
shiftright(a, 10),
shiftright(a, 11),
shiftright(a, 12),
shiftright(a, 13),
shiftright(a, 14),
shiftright(a, 31),
shiftright(a, 32)
from (
  select cast(-32768 as smallint) a
) t
PREHOOK: type: QUERY
PREHOOK: Input: _dummy_database@_dummy_table
#### A masked pattern was here ####
POSTHOOK: query: select
shiftright(a, 0),
shiftright(a, 1),
shiftright(a, 2),
shiftright(a, 8),
shiftright(a, 9),
shiftright(a, 10),
shiftright(a, 11),
shiftright(a, 12),
shiftright(a, 13),
shiftright(a, 14),
shiftright(a, 31),
shiftright(a, 32)
from (
  select cast(-32768 as smallint) a
) t
POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
#### A masked pattern was here ####
-32768	-16384	-8192	-128	-64	-32	-16	-8	-4	-2	-1	-32768
PREHOOK: query: select
shiftright(a, 0),
shiftright(a, 1),
shiftright(a, 2),
shiftright(a, 24),
shiftright(a, 25),
shiftright(a, 26),
shiftright(a, 27),
shiftright(a, 28),
shiftright(a, 29),
shiftright(a, 30),
shiftright(a, 31),
shiftright(a, 32)
from (
  select cast(-2147483648 as int) a
) t
PREHOOK: type: QUERY
PREHOOK: Input: _dummy_database@_dummy_table
#### A masked pattern was here ####
POSTHOOK: query: select
shiftright(a, 0),
shiftright(a, 1),
shiftright(a, 2),
shiftright(a, 24),
shiftright(a, 25),
shiftright(a, 26),
shiftright(a, 27),
shiftright(a, 28),
shiftright(a, 29),
shiftright(a, 30),
shiftright(a, 31),
shiftright(a, 32)
from (
  select cast(-2147483648 as int) a
) t
POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
#### A masked pattern was here ####
-2147483648	-1073741824	-536870912	-128	-64	-32	-16	-8	-4	-2	-1	-2147483648
PREHOOK: query: select
shiftright(a, 0),
shiftright(a, 1),
shiftright(a, 2),
shiftright(a, 56),
shiftright(a, 57),
shiftright(a, 58),
shiftright(a, 59),
shiftright(a, 60),
shiftright(a, 61),
shiftright(a, 62),
shiftright(a, 63),
shiftright(a, 64)
from (
  select cast(-9223372036854775808 as bigint) a
) t
PREHOOK: type: QUERY
PREHOOK: Input: _dummy_database@_dummy_table
#### A masked pattern was here ####
POSTHOOK: query: select
shiftright(a, 0),
shiftright(a, 1),
shiftright(a, 2),
shiftright(a, 56),
shiftright(a, 57),
shiftright(a, 58),
shiftright(a, 59),
shiftright(a, 60),
shiftright(a, 61),
shiftright(a, 62),
shiftright(a, 63),
shiftright(a, 64)
from (
  select cast(-9223372036854775808 as bigint) a
) t
POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
#### A masked pattern was here ####
-9223372036854775808	-4611686018427387904	-2305843009213693952	-128	-64	-32	-16	-8	-4	-2	-1	-9223372036854775808
PREHOOK: query: select
shiftright(1024, 33),
shiftright(1024, 65),
shiftright(1024, 4001),
shiftright(1024, -2),
shiftright(1024, cast(null as int)),
shiftright(cast(null as int), 4),
shiftright(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
shiftright(1024, 33),
shiftright(1024, 65),
shiftright(1024, 4001),
shiftright(1024, -2),
shiftright(1024, cast(null as int)),
shiftright(cast(null as int), 4),
shiftright(cast(null as int), cast(null as int))
POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
#### A masked pattern was here ####
512	512	512	0	NULL	NULL	NULL