| PREHOOK: query: EXPLAIN |
| SELECT key, randum123 |
| FROM (SELECT *, cast(rand() as double) AS randum123 FROM src WHERE key = 100) a |
| WHERE randum123 <=0.1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN |
| SELECT key, randum123 |
| FROM (SELECT *, cast(rand() as double) AS randum123 FROM src WHERE key = 100) a |
| WHERE randum123 <=0.1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| TableScan |
| alias: src |
| filterExpr: (UDFToDouble(key) = 100.0D) (type: boolean) |
| Filter Operator |
| predicate: (UDFToDouble(key) = 100.0D) (type: boolean) |
| Select Operator |
| expressions: key (type: string), rand() (type: double) |
| outputColumnNames: _col0, _col1 |
| Filter Operator |
| predicate: (_col1 <= 0.1D) (type: boolean) |
| ListSink |
| |
| PREHOOK: query: EXPLAIN |
| SELECT * FROM |
| ( |
| SELECT key, randum123 |
| FROM (SELECT *, cast(rand() as double) AS randum123 FROM src WHERE key = 100) a |
| WHERE randum123 <=0.1)s WHERE s.randum123>0.1 LIMIT 20 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN |
| SELECT * FROM |
| ( |
| SELECT key, randum123 |
| FROM (SELECT *, cast(rand() as double) AS randum123 FROM src WHERE key = 100) a |
| WHERE randum123 <=0.1)s WHERE s.randum123>0.1 LIMIT 20 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: 0 |
| Processor Tree: |
| ListSink |
| |
| PREHOOK: query: EXPLAIN |
| SELECT key,randum123, h4 |
| FROM (SELECT *, cast(rand() as double) AS randum123, hex(4) AS h4 FROM src WHERE key = 100) a |
| WHERE a.h4 <= 3 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN |
| SELECT key,randum123, h4 |
| FROM (SELECT *, cast(rand() as double) AS randum123, hex(4) AS h4 FROM src WHERE key = 100) a |
| WHERE a.h4 <= 3 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| TableScan |
| alias: src |
| filterExpr: (UDFToDouble(key) = 100.0D) (type: boolean) |
| Filter Operator |
| predicate: (UDFToDouble(key) = 100.0D) (type: boolean) |
| Limit |
| Number of rows: 0 |
| Select Operator |
| expressions: key (type: string) |
| outputColumnNames: _col0 |
| Select Operator |
| expressions: _col0 (type: string), rand() (type: double), '4' (type: string) |
| outputColumnNames: _col0, _col1, _col2 |
| ListSink |
| |
| PREHOOK: query: EXPLAIN |
| SELECT key,randum123, v10 |
| FROM (SELECT *, cast(rand() as double) AS randum123, value*10 AS v10 FROM src WHERE key = 100) a |
| WHERE a.v10 <= 200 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN |
| SELECT key,randum123, v10 |
| FROM (SELECT *, cast(rand() as double) AS randum123, value*10 AS v10 FROM src WHERE key = 100) a |
| WHERE a.v10 <= 200 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| TableScan |
| alias: src |
| filterExpr: ((UDFToDouble(key) = 100.0D) and ((UDFToDouble(value) * 10.0D) <= 200.0D)) (type: boolean) |
| Filter Operator |
| predicate: ((UDFToDouble(key) = 100.0D) and ((UDFToDouble(value) * 10.0D) <= 200.0D)) (type: boolean) |
| Select Operator |
| expressions: key (type: string), rand() (type: double), (UDFToDouble(value) * 10.0D) (type: double) |
| outputColumnNames: _col0, _col1, _col2 |
| ListSink |
| |
| PREHOOK: query: EXPLAIN |
| SELECT key, randum123 |
| FROM (SELECT *, cast(rand() as double) AS randum123 FROM src WHERE key = 100) a |
| WHERE randum123 <=0.1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN |
| SELECT key, randum123 |
| FROM (SELECT *, cast(rand() as double) AS randum123 FROM src WHERE key = 100) a |
| WHERE randum123 <=0.1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| TableScan |
| alias: src |
| filterExpr: (UDFToDouble(key) = 100.0D) (type: boolean) |
| Filter Operator |
| predicate: (UDFToDouble(key) = 100.0D) (type: boolean) |
| Select Operator |
| expressions: key (type: string), rand() (type: double) |
| outputColumnNames: _col0, _col1 |
| Filter Operator |
| predicate: (_col1 <= 0.1D) (type: boolean) |
| ListSink |
| |
| PREHOOK: query: EXPLAIN |
| SELECT * FROM |
| ( |
| SELECT key, randum123 |
| FROM (SELECT *, cast(rand() as double) AS randum123 FROM src WHERE key = 100) a |
| WHERE randum123 <=0.1)s WHERE s.randum123>0.1 LIMIT 20 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN |
| SELECT * FROM |
| ( |
| SELECT key, randum123 |
| FROM (SELECT *, cast(rand() as double) AS randum123 FROM src WHERE key = 100) a |
| WHERE randum123 <=0.1)s WHERE s.randum123>0.1 LIMIT 20 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: 0 |
| Processor Tree: |
| ListSink |
| |
| PREHOOK: query: EXPLAIN |
| SELECT key,randum123, h4 |
| FROM (SELECT *, cast(rand() as double) AS randum123, hex(4) AS h4 FROM src WHERE key = 100) a |
| WHERE a.h4 <= 3 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN |
| SELECT key,randum123, h4 |
| FROM (SELECT *, cast(rand() as double) AS randum123, hex(4) AS h4 FROM src WHERE key = 100) a |
| WHERE a.h4 <= 3 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| TableScan |
| alias: src |
| filterExpr: (UDFToDouble(key) = 100.0D) (type: boolean) |
| Filter Operator |
| predicate: (UDFToDouble(key) = 100.0D) (type: boolean) |
| Limit |
| Number of rows: 0 |
| Select Operator |
| expressions: key (type: string) |
| outputColumnNames: _col0 |
| Select Operator |
| expressions: _col0 (type: string), rand() (type: double), '4' (type: string) |
| outputColumnNames: _col0, _col1, _col2 |
| ListSink |
| |
| PREHOOK: query: EXPLAIN |
| SELECT key,randum123, v10 |
| FROM (SELECT *, cast(rand() as double) AS randum123, value*10 AS v10 FROM src WHERE key = 100) a |
| WHERE a.v10 <= 200 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN |
| SELECT key,randum123, v10 |
| FROM (SELECT *, cast(rand() as double) AS randum123, value*10 AS v10 FROM src WHERE key = 100) a |
| WHERE a.v10 <= 200 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| TableScan |
| alias: src |
| filterExpr: ((UDFToDouble(key) = 100.0D) and ((UDFToDouble(value) * 10.0D) <= 200.0D)) (type: boolean) |
| Filter Operator |
| predicate: ((UDFToDouble(key) = 100.0D) and ((UDFToDouble(value) * 10.0D) <= 200.0D)) (type: boolean) |
| Select Operator |
| expressions: key (type: string), rand() (type: double), (UDFToDouble(value) * 10.0D) (type: double) |
| outputColumnNames: _col0, _col1, _col2 |
| ListSink |
| |
| PREHOOK: query: EXPLAIN |
| SELECT key, randum123 |
| FROM (SELECT *, cast(rand() as double) AS randum123 FROM src WHERE key = 100) a |
| WHERE randum123 <=0.1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN |
| SELECT key, randum123 |
| FROM (SELECT *, cast(rand() as double) AS randum123 FROM src WHERE key = 100) a |
| WHERE randum123 <=0.1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| TableScan |
| alias: src |
| filterExpr: (key = 100) (type: boolean) |
| Filter Operator |
| predicate: (key = 100) (type: boolean) |
| Select Operator |
| expressions: key (type: string), rand() (type: double) |
| outputColumnNames: _col0, _col2 |
| Filter Operator |
| predicate: (_col2 <= 0.1D) (type: boolean) |
| Select Operator |
| expressions: _col0 (type: string), _col2 (type: double) |
| outputColumnNames: _col0, _col1 |
| ListSink |
| |
| PREHOOK: query: EXPLAIN |
| SELECT * FROM |
| ( |
| SELECT key, randum123 |
| FROM (SELECT *, cast(rand() as double) AS randum123 FROM src WHERE key = 100) a |
| WHERE randum123 <=0.1)s WHERE s.randum123>0.1 LIMIT 20 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN |
| SELECT * FROM |
| ( |
| SELECT key, randum123 |
| FROM (SELECT *, cast(rand() as double) AS randum123 FROM src WHERE key = 100) a |
| WHERE randum123 <=0.1)s WHERE s.randum123>0.1 LIMIT 20 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: 20 |
| Processor Tree: |
| TableScan |
| alias: src |
| filterExpr: (key = 100) (type: boolean) |
| Filter Operator |
| predicate: (key = 100) (type: boolean) |
| Select Operator |
| expressions: key (type: string), rand() (type: double) |
| outputColumnNames: _col0, _col2 |
| Filter Operator |
| predicate: ((_col2 <= 0.1D) and (_col2 > 0.1D)) (type: boolean) |
| Limit |
| Number of rows: 20 |
| Select Operator |
| expressions: _col0 (type: string), _col2 (type: double) |
| outputColumnNames: _col0, _col1 |
| ListSink |
| |
| PREHOOK: query: EXPLAIN |
| SELECT key,randum123, h4 |
| FROM (SELECT *, cast(rand() as double) AS randum123, hex(4) AS h4 FROM src WHERE key = 100) a |
| WHERE a.h4 <= 3 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN |
| SELECT key,randum123, h4 |
| FROM (SELECT *, cast(rand() as double) AS randum123, hex(4) AS h4 FROM src WHERE key = 100) a |
| WHERE a.h4 <= 3 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| TableScan |
| alias: src |
| Filter Operator |
| predicate: false (type: boolean) |
| Select Operator |
| expressions: key (type: string), rand() (type: double), '4' (type: string) |
| outputColumnNames: _col0, _col1, _col2 |
| ListSink |
| |
| PREHOOK: query: EXPLAIN |
| SELECT key,randum123, v10 |
| FROM (SELECT *, cast(rand() as double) AS randum123, value*10 AS v10 FROM src WHERE key = 100) a |
| WHERE a.v10 <= 200 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN |
| SELECT key,randum123, v10 |
| FROM (SELECT *, cast(rand() as double) AS randum123, value*10 AS v10 FROM src WHERE key = 100) a |
| WHERE a.v10 <= 200 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| TableScan |
| alias: src |
| filterExpr: ((key = 100) and ((value * 10) <= 200.0D)) (type: boolean) |
| Filter Operator |
| predicate: ((key = 100) and ((value * 10) <= 200.0D)) (type: boolean) |
| Select Operator |
| expressions: key (type: string), rand() (type: double), (value * 10) (type: double) |
| outputColumnNames: _col0, _col1, _col2 |
| ListSink |
| |
| PREHOOK: query: EXPLAIN |
| SELECT key, randum123 |
| FROM (SELECT *, cast(rand() as double) AS randum123 FROM src WHERE key = 100) a |
| WHERE randum123 <=0.1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN |
| SELECT key, randum123 |
| FROM (SELECT *, cast(rand() as double) AS randum123 FROM src WHERE key = 100) a |
| WHERE randum123 <=0.1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| TableScan |
| alias: src |
| filterExpr: (key = 100) (type: boolean) |
| Filter Operator |
| predicate: (key = 100) (type: boolean) |
| Select Operator |
| expressions: key (type: string), rand() (type: double) |
| outputColumnNames: _col0, _col2 |
| Filter Operator |
| predicate: (_col2 <= 0.1D) (type: boolean) |
| Select Operator |
| expressions: _col0 (type: string), _col2 (type: double) |
| outputColumnNames: _col0, _col1 |
| ListSink |
| |
| PREHOOK: query: EXPLAIN |
| SELECT * FROM |
| ( |
| SELECT key, randum123 |
| FROM (SELECT *, cast(rand() as double) AS randum123 FROM src WHERE key = 100) a |
| WHERE randum123 <=0.1)s WHERE s.randum123>0.1 LIMIT 20 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN |
| SELECT * FROM |
| ( |
| SELECT key, randum123 |
| FROM (SELECT *, cast(rand() as double) AS randum123 FROM src WHERE key = 100) a |
| WHERE randum123 <=0.1)s WHERE s.randum123>0.1 LIMIT 20 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: 20 |
| Processor Tree: |
| TableScan |
| alias: src |
| filterExpr: (key = 100) (type: boolean) |
| Filter Operator |
| predicate: (key = 100) (type: boolean) |
| Select Operator |
| expressions: key (type: string), rand() (type: double) |
| outputColumnNames: _col0, _col2 |
| Filter Operator |
| predicate: (_col2 <= 0.1D) (type: boolean) |
| Select Operator |
| expressions: _col0 (type: string), _col2 (type: double) |
| outputColumnNames: _col0, _col1 |
| Filter Operator |
| predicate: (_col1 > 0.1D) (type: boolean) |
| Limit |
| Number of rows: 20 |
| ListSink |
| |
| PREHOOK: query: EXPLAIN |
| SELECT key,randum123, h4 |
| FROM (SELECT *, cast(rand() as double) AS randum123, hex(4) AS h4 FROM src WHERE key = 100) a |
| WHERE a.h4 <= 3 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN |
| SELECT key,randum123, h4 |
| FROM (SELECT *, cast(rand() as double) AS randum123, hex(4) AS h4 FROM src WHERE key = 100) a |
| WHERE a.h4 <= 3 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| TableScan |
| alias: src |
| Filter Operator |
| predicate: ((key = 100) and false) (type: boolean) |
| Select Operator |
| expressions: key (type: string), rand() (type: double) |
| outputColumnNames: _col0, _col2 |
| Filter Operator |
| predicate: false (type: boolean) |
| Select Operator |
| expressions: _col0 (type: string), _col2 (type: double), '4' (type: string) |
| outputColumnNames: _col0, _col1, _col2 |
| ListSink |
| |
| PREHOOK: query: EXPLAIN |
| SELECT key,randum123, v10 |
| FROM (SELECT *, cast(rand() as double) AS randum123, value*10 AS v10 FROM src WHERE key = 100) a |
| WHERE a.v10 <= 200 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN |
| SELECT key,randum123, v10 |
| FROM (SELECT *, cast(rand() as double) AS randum123, value*10 AS v10 FROM src WHERE key = 100) a |
| WHERE a.v10 <= 200 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| TableScan |
| alias: src |
| filterExpr: ((key = 100) and ((value * 10) <= 200.0D)) (type: boolean) |
| Filter Operator |
| predicate: ((key = 100) and ((value * 10) <= 200.0D)) (type: boolean) |
| Select Operator |
| expressions: key (type: string), rand() (type: double), (value * 10) (type: double) |
| outputColumnNames: _col0, _col2, _col3 |
| Filter Operator |
| predicate: (_col3 <= 200.0D) (type: boolean) |
| Select Operator |
| expressions: _col0 (type: string), _col2 (type: double), _col3 (type: double) |
| outputColumnNames: _col0, _col1, _col2 |
| ListSink |
| |