You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by gu...@apache.org on 2013/11/05 08:01:58 UTC
svn commit: r1538880 [40/46] - in /hive/branches/tez: ./ ant/
ant/src/org/apache/hadoop/hive/ant/ beeline/
beeline/src/java/org/apache/hive/beeline/ beeline/src/main/
beeline/src/test/org/apache/hive/beeline/src/test/ cli/ common/
common/src/java/conf/...
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_format_number.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_format_number.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_format_number.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_format_number.q.out Tue Nov 5 07:01:32 2013
@@ -22,61 +22,50 @@ Example:
PREHOOK: query: EXPLAIN
SELECT format_number(12332.123456, 4),
format_number(12332.1,4),
- format_number(12332.2,0) FROM src limit 1
+ format_number(12332.2,0) FROM src tablesample (1 rows)
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN
SELECT format_number(12332.123456, 4),
format_number(12332.1,4),
- format_number(12332.2,0) FROM src limit 1
+ format_number(12332.2,0) FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION format_number 12332.123456 4)) (TOK_SELEXPR (TOK_FUNCTION format_number 12332.1 4)) (TOK_SELEXPR (TOK_FUNCTION format_number 12332.2 0))) (TOK_LIMIT 1)))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src) (TOK_TABLESPLITSAMPLE TOK_ROWCOUNT 1))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION format_number 12332.123456 4)) (TOK_SELEXPR (TOK_FUNCTION format_number 12332.1 4)) (TOK_SELEXPR (TOK_FUNCTION format_number 12332.2 0)))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- src
- TableScan
- alias: src
- Select Operator
- expressions:
- expr: format_number(12332.123456, 4)
- type: string
- expr: format_number(12332.1, 4)
- type: string
- expr: format_number(12332.2, 0)
- type: string
- outputColumnNames: _col0, _col1, _col2
- Limit
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
Stage: Stage-0
Fetch Operator
- limit: 1
+ limit: -1
+ Processor Tree:
+ TableScan
+ alias: src
+ Row Limit Per Split: 1
+ Select Operator
+ expressions:
+ expr: format_number(12332.123456, 4)
+ type: string
+ expr: format_number(12332.1, 4)
+ type: string
+ expr: format_number(12332.2, 0)
+ type: string
+ outputColumnNames: _col0, _col1, _col2
+ ListSink
PREHOOK: query: SELECT format_number(12332.123456, 4),
format_number(12332.1,4),
format_number(12332.2,0)
-FROM src limit 1
+FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: SELECT format_number(12332.123456, 4),
format_number(12332.1,4),
format_number(12332.2,0)
-FROM src limit 1
+FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
@@ -86,7 +75,7 @@ SELECT format_number(0.123456789, 12),
format_number(12345678.123456789, 5),
format_number(1234567.123456789, 7),
format_number(123456.123456789, 0)
-FROM src limit 1
+FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
@@ -95,7 +84,7 @@ SELECT format_number(0.123456789, 12),
format_number(12345678.123456789, 5),
format_number(1234567.123456789, 7),
format_number(123456.123456789, 0)
-FROM src limit 1
+FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
@@ -105,7 +94,7 @@ SELECT format_number(-123456.123456789,
format_number(-1234567.123456789, 2),
format_number(-0.123456789, 15),
format_number(-12345.123456789, 4)
-FROM src limit 1
+FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
@@ -114,7 +103,7 @@ SELECT format_number(-123456.123456789,
format_number(-1234567.123456789, 2),
format_number(-0.123456789, 15),
format_number(-12345.123456789, 4)
-FROM src limit 1
+FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
@@ -125,7 +114,7 @@ SELECT format_number(0.0, 4),
format_number(000.0000, 1),
format_number(00000.0000, 1),
format_number(-00.0, 4)
-FROM src limit 1
+FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
@@ -135,7 +124,7 @@ SELECT format_number(0.0, 4),
format_number(000.0000, 1),
format_number(00000.0000, 1),
format_number(-00.0, 4)
-FROM src limit 1
+FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
@@ -146,7 +135,7 @@ SELECT format_number(0, 0),
format_number(12, 2),
format_number(123, 5),
format_number(1234, 7)
-FROM src limit 1
+FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
@@ -156,7 +145,7 @@ SELECT format_number(0, 0),
format_number(12, 2),
format_number(123, 5),
format_number(1234, 7)
-FROM src limit 1
+FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
@@ -171,7 +160,7 @@ SELECT format_number(-922337203685477580
format_number(9223372036854775807, 20),
format_number(4.9E-324, 324),
format_number(1.7976931348623157E308, 308)
-FROM src limit 1
+FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
@@ -185,7 +174,7 @@ SELECT format_number(-922337203685477580
format_number(9223372036854775807, 20),
format_number(4.9E-324, 324),
format_number(1.7976931348623157E308, 308)
-FROM src limit 1
+FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_get_json_object.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_get_json_object.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_get_json_object.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_get_json_object.q.out Tue Nov 5 07:01:32 2013
@@ -48,32 +48,21 @@ ABSTRACT SYNTAX TREE:
#### A masked pattern was here ####
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- src_json
- TableScan
- alias: src_json
- Select Operator
- expressions:
-#### A masked pattern was here ####
- type: string
- outputColumnNames: _col0
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
Stage: Stage-0
Fetch Operator
limit: -1
+ Processor Tree:
+ TableScan
+ alias: src_json
+ Select Operator
+ expressions:
+#### A masked pattern was here ####
+ type: string
+ outputColumnNames: _col0
+ ListSink
PREHOOK: query: SELECT get_json_object(src_json.json, '$') FROM src_json
@@ -184,11 +173,11 @@ CREATE TABLE dest2(c1 STRING) STORED AS
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@dest2
POSTHOOK: Lineage: dest1.c1 SIMPLE []
-PREHOOK: query: INSERT OVERWRITE TABLE dest2 SELECT '{"a":"b\nc"}' FROM src LIMIT 1
+PREHOOK: query: INSERT OVERWRITE TABLE dest2 SELECT '{"a":"b\nc"}' FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@dest2
-POSTHOOK: query: INSERT OVERWRITE TABLE dest2 SELECT '{"a":"b\nc"}' FROM src LIMIT 1
+POSTHOOK: query: INSERT OVERWRITE TABLE dest2 SELECT '{"a":"b\nc"}' FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@dest2
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_greaterthan.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_greaterthan.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_greaterthan.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_greaterthan.q.out Tue Nov 5 07:01:32 2013
@@ -8,11 +8,11 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED >
POSTHOOK: type: DESCFUNCTION
a > b - Returns TRUE if a is greater than b
-PREHOOK: query: SELECT true>false, false>true, false>false, true>true FROM src LIMIT 1
+PREHOOK: query: SELECT true>false, false>true, false>false, true>true FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT true>false, false>true, false>false, true>true FROM src LIMIT 1
+POSTHOOK: query: SELECT true>false, false>true, false>false, true>true FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_greaterthanorequal.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_greaterthanorequal.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_greaterthanorequal.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_greaterthanorequal.q.out Tue Nov 5 07:01:32 2013
@@ -8,11 +8,11 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED >=
POSTHOOK: type: DESCFUNCTION
a >= b - Returns TRUE if a is not smaller than b
-PREHOOK: query: SELECT true>=false, false>=true, false>=false, true>=true FROM src LIMIT 1
+PREHOOK: query: SELECT true>=false, false>=true, false>=false, true>=true FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT true>=false, false>=true, false>=false, true>=true FROM src LIMIT 1
+POSTHOOK: query: SELECT true>=false, false>=true, false>=false, true>=true FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_hash.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_hash.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_hash.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_hash.q.out Tue Nov 5 07:01:32 2013
@@ -14,7 +14,7 @@ SELECT hash(CAST(1 AS TINYINT)), hash(CA
hash(CAST(1.25 AS FLOAT)), hash(CAST(16.0 AS DOUBLE)),
hash('400'), hash('abc'), hash(TRUE), hash(FALSE),
hash(1, 2, 3)
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN
SELECT hash(CAST(1 AS TINYINT)), hash(CAST(2 AS SMALLINT)),
@@ -22,59 +22,48 @@ SELECT hash(CAST(1 AS TINYINT)), hash(CA
hash(CAST(1.25 AS FLOAT)), hash(CAST(16.0 AS DOUBLE)),
hash('400'), hash('abc'), hash(TRUE), hash(FALSE),
hash(1, 2, 3)
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION hash (TOK_FUNCTION TOK_TINYINT 1))) (TOK_SELEXPR (TOK_FUNCTION hash (TOK_FUNCTION TOK_SMALLINT 2))) (TOK_SELEXPR (TOK_FUNCTION hash 3)) (TOK_SELEXPR (TOK_FUNCTION hash (TOK_FUNCTION TOK_BIGINT '123456789012'))) (TOK_SELEXPR (TOK_FUNCTION hash (TOK_FUNCTION TOK_FLOAT 1.25))) (TOK_SELEXPR (TOK_FUNCTION hash (TOK_FUNCTION TOK_DOUBLE 16.0))) (TOK_SELEXPR (TOK_FUNCTION hash '400')) (TOK_SELEXPR (TOK_FUNCTION hash 'abc')) (TOK_SELEXPR (TOK_FUNCTION hash TRUE)) (TOK_SELEXPR (TOK_FUNCTION hash FALSE)) (TOK_SELEXPR (TOK_FUNCTION hash 1 2 3))) (TOK_LIMIT 1)))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src) (TOK_TABLESPLITSAMPLE TOK_ROWCOUNT 1))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION hash (TOK_FUNCTION TOK_TINYINT 1))) (TOK_SELEXPR (TOK_FUNCTION hash (TOK_FUNCTION TOK_SMALLINT 2))) (TOK_SELEXPR (TOK_FUNCTION hash 3)) (TOK_SELEXPR (TOK_FUNCTION hash (TOK_FUNCTION TOK_BIGINT '123456789012'))) (TOK_SELEXPR (TOK_FUNCTION hash (TOK_FUNCTION TOK_FLOAT 1.25))) (TOK_SELEXPR (TOK_FUNCTION hash (TOK_FUNCTION TOK_DOUBLE 16.0))) (TOK_SELEXPR (TOK_FUNCTION hash '400')) (TOK_SELEXPR (TOK_FUNCTION hash 'abc')) (TOK_SELEXPR (TOK_FUNCTION hash TRUE)) (TOK_SELEXPR (TOK_FUNCTION hash FALSE)) (TOK_SELEXPR (TOK_FUNCTION hash 1 2 3)))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- src
- TableScan
- alias: src
- Select Operator
- expressions:
- expr: hash(UDFToByte(1))
- type: int
- expr: hash(UDFToShort(2))
- type: int
- expr: hash(3)
- type: int
- expr: hash(UDFToLong('123456789012'))
- type: int
- expr: hash(UDFToFloat(1.25))
- type: int
- expr: hash(16.0)
- type: int
- expr: hash('400')
- type: int
- expr: hash('abc')
- type: int
- expr: hash(true)
- type: int
- expr: hash(false)
- type: int
- expr: hash(1,2,3)
- type: int
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10
- Limit
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
Stage: Stage-0
Fetch Operator
- limit: 1
+ limit: -1
+ Processor Tree:
+ TableScan
+ alias: src
+ Row Limit Per Split: 1
+ Select Operator
+ expressions:
+ expr: hash(UDFToByte(1))
+ type: int
+ expr: hash(UDFToShort(2))
+ type: int
+ expr: hash(3)
+ type: int
+ expr: hash(UDFToLong('123456789012'))
+ type: int
+ expr: hash(UDFToFloat(1.25))
+ type: int
+ expr: hash(16.0)
+ type: int
+ expr: hash('400')
+ type: int
+ expr: hash('abc')
+ type: int
+ expr: hash(true)
+ type: int
+ expr: hash(false)
+ type: int
+ expr: hash(1,2,3)
+ type: int
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10
+ ListSink
PREHOOK: query: SELECT hash(CAST(1 AS TINYINT)), hash(CAST(2 AS SMALLINT)),
@@ -82,7 +71,7 @@ PREHOOK: query: SELECT hash(CAST(1 AS TI
hash(CAST(1.25 AS FLOAT)), hash(CAST(16.0 AS DOUBLE)),
hash('400'), hash('abc'), hash(TRUE), hash(FALSE),
hash(1, 2, 3)
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
@@ -91,7 +80,7 @@ POSTHOOK: query: SELECT hash(CAST(1 AS T
hash(CAST(1.25 AS FLOAT)), hash(CAST(16.0 AS DOUBLE)),
hash('400'), hash('abc'), hash(TRUE), hash(FALSE),
hash(1, 2, 3)
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_hex.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_hex.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_hex.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_hex.q.out Tue Nov 5 07:01:32 2013
@@ -21,7 +21,7 @@ SELECT
hex('Facebook'),
hex('\0'),
hex('qwertyuiopasdfghjkl')
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
@@ -31,7 +31,7 @@ SELECT
hex('Facebook'),
hex('\0'),
hex('qwertyuiopasdfghjkl')
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
@@ -41,7 +41,7 @@ SELECT
hex(1),
hex(0),
hex(4207849477)
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
@@ -50,18 +50,18 @@ SELECT
hex(1),
hex(0),
hex(4207849477)
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
1 0 FACEB005
PREHOOK: query: -- Negative numbers should be treated as two's complement (64 bit).
-SELECT hex(-5) FROM src LIMIT 1
+SELECT hex(-5) FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: -- Negative numbers should be treated as two's complement (64 bit).
-SELECT hex(-5) FROM src LIMIT 1
+SELECT hex(-5) FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_hour.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_hour.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_hour.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_hour.q.out Tue Nov 5 07:01:32 2013
@@ -26,40 +26,29 @@ ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION hour '2009-08-07 13:14:15')) (TOK_SELEXPR (TOK_FUNCTION hour '13:14:15')) (TOK_SELEXPR (TOK_FUNCTION hour '2009-08-07'))) (TOK_WHERE (= (TOK_TABLE_OR_COL key) 86))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- src
- TableScan
- alias: src
- Filter Operator
- predicate:
- expr: (key = 86)
- type: boolean
- Select Operator
- expressions:
- expr: hour('2009-08-07 13:14:15')
- type: int
- expr: hour('13:14:15')
- type: int
- expr: hour('2009-08-07')
- type: int
- outputColumnNames: _col0, _col1, _col2
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
Stage: Stage-0
Fetch Operator
limit: -1
+ Processor Tree:
+ TableScan
+ alias: src
+ Filter Operator
+ predicate:
+ expr: (key = 86)
+ type: boolean
+ Select Operator
+ expressions:
+ expr: hour('2009-08-07 13:14:15')
+ type: int
+ expr: hour('13:14:15')
+ type: int
+ expr: hour('2009-08-07')
+ type: int
+ outputColumnNames: _col0, _col1, _col2
+ ListSink
PREHOOK: query: SELECT hour('2009-08-07 13:14:15'), hour('13:14:15'), hour('2009-08-07')
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_if.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_if.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_if.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_if.q.out Tue Nov 5 07:01:32 2013
@@ -15,7 +15,7 @@ SELECT IF(TRUE, 1, 2) AS COL1,
IF(2=2, 1, NULL) AS COL4,
IF(2=2, NULL, 1) AS COL5,
IF(IF(TRUE, NULL, FALSE), 1, 2) AS COL6
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN
SELECT IF(TRUE, 1, 2) AS COL1,
@@ -24,49 +24,38 @@ SELECT IF(TRUE, 1, 2) AS COL1,
IF(2=2, 1, NULL) AS COL4,
IF(2=2, NULL, 1) AS COL5,
IF(IF(TRUE, NULL, FALSE), 1, 2) AS COL6
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION IF TRUE 1 2) COL1) (TOK_SELEXPR (TOK_FUNCTION IF FALSE (TOK_FUNCTION TOK_STRING TOK_NULL) (TOK_FUNCTION TOK_STRING 1)) COL2) (TOK_SELEXPR (TOK_FUNCTION IF (= 1 1) (TOK_FUNCTION IF (= 2 2) 1 2) (TOK_FUNCTION IF (= 3 3) 3 4)) COL3) (TOK_SELEXPR (TOK_FUNCTION IF (= 2 2) 1 TOK_NULL) COL4) (TOK_SELEXPR (TOK_FUNCTION IF (= 2 2) TOK_NULL 1) COL5) (TOK_SELEXPR (TOK_FUNCTION IF (TOK_FUNCTION IF TRUE TOK_NULL FALSE) 1 2) COL6)) (TOK_LIMIT 1)))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src) (TOK_TABLESPLITSAMPLE TOK_ROWCOUNT 1))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION IF TRUE 1 2) COL1) (TOK_SELEXPR (TOK_FUNCTION IF FALSE (TOK_FUNCTION TOK_STRING TOK_NULL) (TOK_FUNCTION TOK_STRING 1)) COL2) (TOK_SELEXPR (TOK_FUNCTION IF (= 1 1) (TOK_FUNCTION IF (= 2 2) 1 2) (TOK_FUNCTION IF (= 3 3) 3 4)) COL3) (TOK_SELEXPR (TOK_FUNCTION IF (= 2 2) 1 TOK_NULL) COL4) (TOK_SELEXPR (TOK_FUNCTION IF (= 2 2) TOK_NULL 1) COL5) (TOK_SELEXPR (TOK_FUNCTION IF (TOK_FUNCTION IF TRUE TOK_NULL FALSE) 1 2) COL6))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- src
- TableScan
- alias: src
- Select Operator
- expressions:
- expr: if(true, 1, 2)
- type: int
- expr: if(false, UDFToString(null), UDFToString(1))
- type: string
- expr: if((1 = 1), if((2 = 2), 1, 2), if((3 = 3), 3, 4))
- type: int
- expr: if((2 = 2), 1, null)
- type: int
- expr: if((2 = 2), null, 1)
- type: int
- expr: if(if(true, null, false), 1, 2)
- type: int
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Limit
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
Stage: Stage-0
Fetch Operator
- limit: 1
+ limit: -1
+ Processor Tree:
+ TableScan
+ alias: src
+ Row Limit Per Split: 1
+ Select Operator
+ expressions:
+ expr: if(true, 1, 2)
+ type: int
+ expr: if(false, UDFToString(null), UDFToString(1))
+ type: string
+ expr: if((1 = 1), if((2 = 2), 1, 2), if((3 = 3), 3, 4))
+ type: int
+ expr: if((2 = 2), 1, null)
+ type: int
+ expr: if((2 = 2), null, 1)
+ type: int
+ expr: if(if(true, null, false), 1, 2)
+ type: int
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ ListSink
PREHOOK: query: SELECT IF(TRUE, 1, 2) AS COL1,
@@ -75,7 +64,7 @@ PREHOOK: query: SELECT IF(TRUE, 1, 2) AS
IF(2=2, 1, NULL) AS COL4,
IF(2=2, NULL, 1) AS COL5,
IF(IF(TRUE, NULL, FALSE), 1, 2) AS COL6
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
@@ -85,7 +74,7 @@ POSTHOOK: query: SELECT IF(TRUE, 1, 2) A
IF(2=2, 1, NULL) AS COL4,
IF(2=2, NULL, 1) AS COL5,
IF(IF(TRUE, NULL, FALSE), 1, 2) AS COL6
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
@@ -96,7 +85,7 @@ SELECT IF(TRUE, CAST(128 AS SMALLINT), C
IF(FALSE, 1, 1.1) AS COL2,
IF(FALSE, 1, 'ABC') AS COL3,
IF(FALSE, 'ABC', 12.3) AS COL4
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
PREHOOK: type: QUERY
POSTHOOK: query: -- Type conversions
EXPLAIN
@@ -104,52 +93,41 @@ SELECT IF(TRUE, CAST(128 AS SMALLINT), C
IF(FALSE, 1, 1.1) AS COL2,
IF(FALSE, 1, 'ABC') AS COL3,
IF(FALSE, 'ABC', 12.3) AS COL4
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION IF TRUE (TOK_FUNCTION TOK_SMALLINT 128) (TOK_FUNCTION TOK_TINYINT 1)) COL1) (TOK_SELEXPR (TOK_FUNCTION IF FALSE 1 1.1) COL2) (TOK_SELEXPR (TOK_FUNCTION IF FALSE 1 'ABC') COL3) (TOK_SELEXPR (TOK_FUNCTION IF FALSE 'ABC' 12.3) COL4)) (TOK_LIMIT 1)))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src) (TOK_TABLESPLITSAMPLE TOK_ROWCOUNT 1))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION IF TRUE (TOK_FUNCTION TOK_SMALLINT 128) (TOK_FUNCTION TOK_TINYINT 1)) COL1) (TOK_SELEXPR (TOK_FUNCTION IF FALSE 1 1.1) COL2) (TOK_SELEXPR (TOK_FUNCTION IF FALSE 1 'ABC') COL3) (TOK_SELEXPR (TOK_FUNCTION IF FALSE 'ABC' 12.3) COL4))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- src
- TableScan
- alias: src
- Select Operator
- expressions:
- expr: if(true, UDFToShort(128), UDFToByte(1))
- type: smallint
- expr: if(false, 1, 1.1)
- type: double
- expr: if(false, 1, 'ABC')
- type: string
- expr: if(false, 'ABC', 12.3)
- type: string
- outputColumnNames: _col0, _col1, _col2, _col3
- Limit
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
Stage: Stage-0
Fetch Operator
- limit: 1
+ limit: -1
+ Processor Tree:
+ TableScan
+ alias: src
+ Row Limit Per Split: 1
+ Select Operator
+ expressions:
+ expr: if(true, UDFToShort(128), UDFToByte(1))
+ type: smallint
+ expr: if(false, 1, 1.1)
+ type: double
+ expr: if(false, 1, 'ABC')
+ type: string
+ expr: if(false, 'ABC', 12.3)
+ type: string
+ outputColumnNames: _col0, _col1, _col2, _col3
+ ListSink
PREHOOK: query: SELECT IF(TRUE, CAST(128 AS SMALLINT), CAST(1 AS TINYINT)) AS COL1,
IF(FALSE, 1, 1.1) AS COL2,
IF(FALSE, 1, 'ABC') AS COL3,
IF(FALSE, 'ABC', 12.3) AS COL4
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
@@ -157,7 +135,7 @@ POSTHOOK: query: SELECT IF(TRUE, CAST(12
IF(FALSE, 1, 1.1) AS COL2,
IF(FALSE, 1, 'ABC') AS COL3,
IF(FALSE, 'ABC', 12.3) AS COL4
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_in.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_in.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_in.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_in.q.out Tue Nov 5 07:01:32 2013
@@ -8,7 +8,7 @@ PREHOOK: query: SELECT 1 IN (1, 2, 3),
1 IN (1, 2, 3) OR false IN(false),
NULL IN (1, 2, 3),
4 IN (1, 2, 3, NULL),
- (1+3) IN (5, 6, (1+2) + 1) FROM src LIMIT 1
+ (1+3) IN (5, 6, (1+2) + 1) FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
@@ -22,7 +22,7 @@ POSTHOOK: query: SELECT 1 IN (1, 2, 3),
1 IN (1, 2, 3) OR false IN(false),
NULL IN (1, 2, 3),
4 IN (1, 2, 3, NULL),
- (1+3) IN (5, 6, (1+2) + 1) FROM src LIMIT 1
+ (1+3) IN (5, 6, (1+2) + 1) FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_in_file.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_in_file.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_in_file.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_in_file.q.out Tue Nov 5 07:01:32 2013
@@ -4,19 +4,19 @@ POSTHOOK: query: DESCRIBE FUNCTION in_fi
POSTHOOK: type: DESCFUNCTION
in_file(str, filename) - Returns true if str appears in the file
PREHOOK: query: EXPLAIN
-SELECT in_file("303", "../data/files/test2.dat"),
- in_file("304", "../data/files/test2.dat"),
- in_file(CAST(NULL AS STRING), "../data/files/test2.dat")
+SELECT in_file("303", "../../data/files/test2.dat"),
+ in_file("304", "../../data/files/test2.dat"),
+ in_file(CAST(NULL AS STRING), "../../data/files/test2.dat")
FROM src LIMIT 1
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN
-SELECT in_file("303", "../data/files/test2.dat"),
- in_file("304", "../data/files/test2.dat"),
- in_file(CAST(NULL AS STRING), "../data/files/test2.dat")
+SELECT in_file("303", "../../data/files/test2.dat"),
+ in_file("304", "../../data/files/test2.dat"),
+ in_file(CAST(NULL AS STRING), "../../data/files/test2.dat")
FROM src LIMIT 1
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION in_file "303" "../data/files/test2.dat")) (TOK_SELEXPR (TOK_FUNCTION in_file "304" "../data/files/test2.dat")) (TOK_SELEXPR (TOK_FUNCTION in_file (TOK_FUNCTION TOK_STRING TOK_NULL) "../data/files/test2.dat"))) (TOK_LIMIT 1)))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION in_file "303" "../../data/files/test2.dat")) (TOK_SELEXPR (TOK_FUNCTION in_file "304" "../../data/files/test2.dat")) (TOK_SELEXPR (TOK_FUNCTION in_file (TOK_FUNCTION TOK_STRING TOK_NULL) "../../data/files/test2.dat"))) (TOK_LIMIT 1)))
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -31,11 +31,11 @@ STAGE PLANS:
alias: src
Select Operator
expressions:
- expr: in_file('303', '../data/files/test2.dat')
+ expr: in_file('303', '../../data/files/test2.dat')
type: boolean
- expr: in_file('304', '../data/files/test2.dat')
+ expr: in_file('304', '../../data/files/test2.dat')
type: boolean
- expr: in_file(UDFToString(null), '../data/files/test2.dat')
+ expr: in_file(UDFToString(null), '../../data/files/test2.dat')
type: boolean
outputColumnNames: _col0, _col1, _col2
Limit
@@ -52,16 +52,16 @@ STAGE PLANS:
limit: 1
-PREHOOK: query: SELECT in_file("303", "../data/files/test2.dat"),
- in_file("304", "../data/files/test2.dat"),
- in_file(CAST(NULL AS STRING), "../data/files/test2.dat")
+PREHOOK: query: SELECT in_file("303", "../../data/files/test2.dat"),
+ in_file("304", "../../data/files/test2.dat"),
+ in_file(CAST(NULL AS STRING), "../../data/files/test2.dat")
FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT in_file("303", "../data/files/test2.dat"),
- in_file("304", "../data/files/test2.dat"),
- in_file(CAST(NULL AS STRING), "../data/files/test2.dat")
+POSTHOOK: query: SELECT in_file("303", "../../data/files/test2.dat"),
+ in_file("304", "../../data/files/test2.dat"),
+ in_file(CAST(NULL AS STRING), "../../data/files/test2.dat")
FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_instr.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_instr.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_instr.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_instr.q.out Tue Nov 5 07:01:32 2013
@@ -25,7 +25,7 @@ SELECT instr('abcd', 'abc'),
instr(CAST(16.0 AS DOUBLE), '.0'),
instr(null, 'abc'),
instr('abcd', null)
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN
SELECT instr('abcd', 'abc'),
@@ -41,63 +41,52 @@ SELECT instr('abcd', 'abc'),
instr(CAST(16.0 AS DOUBLE), '.0'),
instr(null, 'abc'),
instr('abcd', null)
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION instr 'abcd' 'abc')) (TOK_SELEXPR (TOK_FUNCTION instr 'abcabc' 'ccc')) (TOK_SELEXPR (TOK_FUNCTION instr 123 '23')) (TOK_SELEXPR (TOK_FUNCTION instr 123 23)) (TOK_SELEXPR (TOK_FUNCTION instr TRUE 1)) (TOK_SELEXPR (TOK_FUNCTION instr FALSE 1)) (TOK_SELEXPR (TOK_FUNCTION instr '12345' (TOK_FUNCTION TOK_TINYINT '2'))) (TOK_SELEXPR (TOK_FUNCTION instr (TOK_FUNCTION TOK_SMALLINT '12345') '34')) (TOK_SELEXPR (TOK_FUNCTION instr (TOK_FUNCTION TOK_BIGINT '123456789012') '456')) (TOK_SELEXPR (TOK_FUNCTION instr (TOK_FUNCTION TOK_FLOAT 1.25) '.25')) (TOK_SELEXPR (TOK_FUNCTION instr (TOK_FUNCTION TOK_DOUBLE 16.0) '.0')) (TOK_SELEXPR (TOK_FUNCTION instr TOK_NULL 'abc')) (TOK_SELEXPR (TOK_FUNCTION instr 'abcd' TOK_NULL))) (TOK_LIMIT 1)))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src) (TOK_TABLESPLITSAMPLE TOK_ROWCOUNT 1))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION instr 'abcd' 'abc')) (TOK_SELEXPR (TOK_FUNCTION instr 'abcabc' 'ccc')) (TOK_SELEXPR (TOK_FUNCTION instr 123 '23')) (TOK_SELEXPR (TOK_FUNCTION instr 123 23)) (TOK_SELEXPR (TOK_FUNCTION instr TRUE 1)) (TOK_SELEXPR (TOK_FUNCTION instr FALSE 1)) (TOK_SELEXPR (TOK_FUNCTION instr '12345' (TOK_FUNCTION TOK_TINYINT '2'))) (TOK_SELEXPR (TOK_FUNCTION instr (TOK_FUNCTION TOK_SMALLINT '12345') '34')) (TOK_SELEXPR (TOK_FUNCTION instr (TOK_FUNCTION TOK_BIGINT '123456789012') '456')) (TOK_SELEXPR (TOK_FUNCTION instr (TOK_FUNCTION TOK_FLOAT 1.25) '.25')) (TOK_SELEXPR (TOK_FUNCTION instr (TOK_FUNCTION TOK_DOUBLE 16.0) '.0')) (TOK_SELEXPR (TOK_FUNCTION instr TOK_NULL 'abc')) (TOK_SELEXPR (TOK_FUNCTION instr 'abcd' TOK_NULL)))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- src
- TableScan
- alias: src
- Select Operator
- expressions:
- expr: instr('abcd''abc')
- type: int
- expr: instr('abcabc''ccc')
- type: int
- expr: instr(123'23')
- type: int
- expr: instr(12323)
- type: int
- expr: instr(true1)
- type: int
- expr: instr(false1)
- type: int
- expr: instr('12345'UDFToByte('2'))
- type: int
- expr: instr(UDFToShort('12345')'34')
- type: int
- expr: instr(UDFToLong('123456789012')'456')
- type: int
- expr: instr(UDFToFloat(1.25)'.25')
- type: int
- expr: instr(16.0'.0')
- type: int
- expr: instr(null'abc')
- type: int
- expr: instr('abcd'null)
- type: int
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12
- Limit
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
Stage: Stage-0
Fetch Operator
- limit: 1
+ limit: -1
+ Processor Tree:
+ TableScan
+ alias: src
+ Row Limit Per Split: 1
+ Select Operator
+ expressions:
+ expr: instr('abcd''abc')
+ type: int
+ expr: instr('abcabc''ccc')
+ type: int
+ expr: instr(123'23')
+ type: int
+ expr: instr(12323)
+ type: int
+ expr: instr(true1)
+ type: int
+ expr: instr(false1)
+ type: int
+ expr: instr('12345'UDFToByte('2'))
+ type: int
+ expr: instr(UDFToShort('12345')'34')
+ type: int
+ expr: instr(UDFToLong('123456789012')'456')
+ type: int
+ expr: instr(UDFToFloat(1.25)'.25')
+ type: int
+ expr: instr(16.0'.0')
+ type: int
+ expr: instr(null'abc')
+ type: int
+ expr: instr('abcd'null)
+ type: int
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12
+ ListSink
PREHOOK: query: SELECT instr('abcd', 'abc'),
@@ -113,7 +102,7 @@ PREHOOK: query: SELECT instr('abcd', 'ab
instr(CAST(16.0 AS DOUBLE), '.0'),
instr(null, 'abc'),
instr('abcd', null)
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
@@ -130,7 +119,7 @@ POSTHOOK: query: SELECT instr('abcd', 'a
instr(CAST(16.0 AS DOUBLE), '.0'),
instr(null, 'abc'),
instr('abcd', null)
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_isnull_isnotnull.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_isnull_isnotnull.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_isnull_isnotnull.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_isnull_isnotnull.q.out Tue Nov 5 07:01:32 2013
@@ -36,41 +36,30 @@ ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION TOK_ISNULL TOK_NULL)) (TOK_SELEXPR (TOK_FUNCTION TOK_ISNOTNULL 1)) (TOK_SELEXPR (TOK_FUNCTION TOK_ISNOTNULL 'my string'))) (TOK_WHERE (TOK_FUNCTION TOK_ISNOTNULL true)) (TOK_LIMIT 1)))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- src
- TableScan
- alias: src
- Filter Operator
- predicate:
- expr: true is not null
- type: boolean
- Select Operator
- expressions:
- expr: null is null
- type: boolean
- expr: 1 is not null
- type: boolean
- expr: 'my string' is not null
- type: boolean
- outputColumnNames: _col0, _col1, _col2
- Limit
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
Stage: Stage-0
Fetch Operator
limit: 1
+ Processor Tree:
+ TableScan
+ alias: src
+ Filter Operator
+ predicate:
+ expr: true is not null
+ type: boolean
+ Select Operator
+ expressions:
+ expr: null is null
+ type: boolean
+ expr: 1 is not null
+ type: boolean
+ expr: 'my string' is not null
+ type: boolean
+ outputColumnNames: _col0, _col1, _col2
+ Limit
+ ListSink
PREHOOK: query: SELECT NULL IS NULL,
@@ -110,41 +99,30 @@ ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src_thrift))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION TOK_ISNOTNULL (. (TOK_TABLE_OR_COL src_thrift) lint))) (TOK_SELEXPR (TOK_FUNCTION TOK_ISNOTNULL (. (TOK_TABLE_OR_COL src_thrift) lintstring))) (TOK_SELEXPR (TOK_FUNCTION TOK_ISNOTNULL (. (TOK_TABLE_OR_COL src_thrift) mstringstring)))) (TOK_WHERE (AND (TOK_FUNCTION TOK_ISNOTNULL (. (TOK_TABLE_OR_COL src_thrift) lint)) (NOT (TOK_FUNCTION TOK_ISNULL (. (TOK_TABLE_OR_COL src_thrift) mstringstring))))) (TOK_LIMIT 1)))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- src_thrift
- TableScan
- alias: src_thrift
- Filter Operator
- predicate:
- expr: (lint is not null and (not mstringstring is null))
- type: boolean
- Select Operator
- expressions:
- expr: lint is not null
- type: boolean
- expr: lintstring is not null
- type: boolean
- expr: mstringstring is not null
- type: boolean
- outputColumnNames: _col0, _col1, _col2
- Limit
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
Stage: Stage-0
Fetch Operator
limit: 1
+ Processor Tree:
+ TableScan
+ alias: src_thrift
+ Filter Operator
+ predicate:
+ expr: (lint is not null and (not mstringstring is null))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: lint is not null
+ type: boolean
+ expr: lintstring is not null
+ type: boolean
+ expr: mstringstring is not null
+ type: boolean
+ outputColumnNames: _col0, _col1, _col2
+ Limit
+ ListSink
PREHOOK: query: FROM src_thrift
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_java_method.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_java_method.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_java_method.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_java_method.q.out Tue Nov 5 07:01:32 2013
@@ -21,7 +21,7 @@ SELECT java_method("java.lang.String", "
java_method("java.lang.Math", "round", 2.5),
java_method("java.lang.Math", "exp", 1.0),
java_method("java.lang.Math", "floor", 1.9)
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
PREHOOK: type: QUERY
POSTHOOK: query: -- java_method() is a synonym for reflect()
@@ -33,112 +33,41 @@ SELECT java_method("java.lang.String", "
java_method("java.lang.Math", "round", 2.5),
java_method("java.lang.Math", "exp", 1.0),
java_method("java.lang.Math", "floor", 1.9)
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION java_method "java.lang.String" "valueOf" 1)) (TOK_SELEXPR (TOK_FUNCTION java_method "java.lang.String" "isEmpty")) (TOK_SELEXPR (TOK_FUNCTION java_method "java.lang.Math" "max" 2 3)) (TOK_SELEXPR (TOK_FUNCTION java_method "java.lang.Math" "min" 2 3)) (TOK_SELEXPR (TOK_FUNCTION java_method "java.lang.Math" "round" 2.5)) (TOK_SELEXPR (TOK_FUNCTION java_method "java.lang.Math" "exp" 1.0)) (TOK_SELEXPR (TOK_FUNCTION java_method "java.lang.Math" "floor" 1.9))) (TOK_LIMIT 1)))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src) (TOK_TABLESPLITSAMPLE TOK_ROWCOUNT 1))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION java_method "java.lang.String" "valueOf" 1)) (TOK_SELEXPR (TOK_FUNCTION java_method "java.lang.String" "isEmpty")) (TOK_SELEXPR (TOK_FUNCTION java_method "java.lang.Math" "max" 2 3)) (TOK_SELEXPR (TOK_FUNCTION java_method "java.lang.Math" "min" 2 3)) (TOK_SELEXPR (TOK_FUNCTION java_method "java.lang.Math" "round" 2.5)) (TOK_SELEXPR (TOK_FUNCTION java_method "java.lang.Math" "exp" 1.0)) (TOK_SELEXPR (TOK_FUNCTION java_method "java.lang.Math" "floor" 1.9)))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- src
- TableScan
- alias: src
- GatherStats: false
- Select Operator
- expressions:
- expr: reflect('java.lang.String','valueOf',1)
- type: string
- expr: reflect('java.lang.String','isEmpty')
- type: string
- expr: reflect('java.lang.Math','max',2,3)
- type: string
- expr: reflect('java.lang.Math','min',2,3)
- type: string
- expr: reflect('java.lang.Math','round',2.5)
- type: string
- expr: reflect('java.lang.Math','exp',1.0)
- type: string
- expr: reflect('java.lang.Math','floor',1.9)
- type: string
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
- Limit
- File Output Operator
- compressed: false
- GlobalTableId: 0
-#### A masked pattern was here ####
- NumFilesPerFileSink: 1
-#### A masked pattern was here ####
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- properties:
- columns _col0,_col1,_col2,_col3,_col4,_col5,_col6
- columns.types string:string:string:string:string:string:string
- escape.delim \
- hive.serialization.extend.nesting.levels 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
- Path -> Alias:
-#### A masked pattern was here ####
- Path -> Partition:
-#### A masked pattern was here ####
- Partition
- base file name: src
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- properties:
- bucket_count -1
- columns key,value
- columns.types string:string
-#### A masked pattern was here ####
- name default.src
- numFiles 1
- numPartitions 0
- numRows 0
- rawDataSize 0
- serialization.ddl struct src { string key, string value}
- serialization.format 1
- serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- totalSize 5812
-#### A masked pattern was here ####
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- properties:
- bucket_count -1
- columns key,value
- columns.types string:string
-#### A masked pattern was here ####
- name default.src
- numFiles 1
- numPartitions 0
- numRows 0
- rawDataSize 0
- serialization.ddl struct src { string key, string value}
- serialization.format 1
- serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- totalSize 5812
-#### A masked pattern was here ####
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.src
- name: default.src
- Truncated Path -> Alias:
- /src [src]
-
Stage: Stage-0
Fetch Operator
- limit: 1
+ limit: -1
+ Processor Tree:
+ TableScan
+ alias: src
+ Row Limit Per Split: 1
+ GatherStats: false
+ Select Operator
+ expressions:
+ expr: reflect('java.lang.String','valueOf',1)
+ type: string
+ expr: reflect('java.lang.String','isEmpty')
+ type: string
+ expr: reflect('java.lang.Math','max',2,3)
+ type: string
+ expr: reflect('java.lang.Math','min',2,3)
+ type: string
+ expr: reflect('java.lang.Math','round',2.5)
+ type: string
+ expr: reflect('java.lang.Math','exp',1.0)
+ type: string
+ expr: reflect('java.lang.Math','floor',1.9)
+ type: string
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
+ ListSink
PREHOOK: query: SELECT java_method("java.lang.String", "valueOf", 1),
@@ -148,7 +77,7 @@ PREHOOK: query: SELECT java_method("java
java_method("java.lang.Math", "round", 2.5),
java_method("java.lang.Math", "exp", 1.0),
java_method("java.lang.Math", "floor", 1.9)
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
@@ -159,7 +88,7 @@ POSTHOOK: query: SELECT java_method("jav
java_method("java.lang.Math", "round", 2.5),
java_method("java.lang.Math", "exp", 1.0),
java_method("java.lang.Math", "floor", 1.9)
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_length.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_length.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_length.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_length.q.out Tue Nov 5 07:01:32 2013
@@ -171,10 +171,10 @@ CREATE TABLE dest1(name STRING) STORED A
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: dest1.len EXPRESSION [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv4.txt' INTO TABLE dest1
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv4.txt' INTO TABLE dest1
PREHOOK: type: LOAD
PREHOOK: Output: default@dest1
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv4.txt' INTO TABLE dest1
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv4.txt' INTO TABLE dest1
POSTHOOK: type: LOAD
POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: dest1.len EXPRESSION [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
@@ -187,32 +187,21 @@ ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME dest1))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION length (. (TOK_TABLE_OR_COL dest1) name))))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- dest1
- TableScan
- alias: dest1
- Select Operator
- expressions:
- expr: length(name)
- type: int
- outputColumnNames: _col0
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
Stage: Stage-0
Fetch Operator
limit: -1
+ Processor Tree:
+ TableScan
+ alias: dest1
+ Select Operator
+ expressions:
+ expr: length(name)
+ type: int
+ outputColumnNames: _col0
+ ListSink
PREHOOK: query: SELECT length(dest1.name) FROM dest1
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_lessthan.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_lessthan.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_lessthan.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_lessthan.q.out Tue Nov 5 07:01:32 2013
@@ -8,11 +8,11 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED <
POSTHOOK: type: DESCFUNCTION
a < b - Returns TRUE if a is less than b
-PREHOOK: query: SELECT true<false, false<true, false<false, true<true FROM src LIMIT 1
+PREHOOK: query: SELECT true<false, false<true, false<false, true<true FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT true<false, false<true, false<false, true<true FROM src LIMIT 1
+POSTHOOK: query: SELECT true<false, false<true, false<false, true<true FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_lessthanorequal.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_lessthanorequal.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_lessthanorequal.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_lessthanorequal.q.out Tue Nov 5 07:01:32 2013
@@ -8,11 +8,11 @@ PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED <=
POSTHOOK: type: DESCFUNCTION
a <= b - Returns TRUE if a is not greater than b
-PREHOOK: query: SELECT true<=false, false<=true, false<=false, true<=true FROM src LIMIT 1
+PREHOOK: query: SELECT true<=false, false<=true, false<=false, true<=true FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: SELECT true<=false, false<=true, false<=false, true<=true FROM src LIMIT 1
+POSTHOOK: query: SELECT true<=false, false<=true, false<=false, true<=true FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_like.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_like.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_like.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_like.q.out Tue Nov 5 07:01:32 2013
@@ -27,62 +27,51 @@ ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (LIKE '_%_' '%\_\%\_%')) (TOK_SELEXPR (LIKE '__' '%\_\%\_%')) (TOK_SELEXPR (LIKE '%%_%_' '%\_\%\_%')) (TOK_SELEXPR (LIKE '%_%_%' '%\%\_\%')) (TOK_SELEXPR (LIKE '_%_' '\%\_%')) (TOK_SELEXPR (LIKE '%__' '__\%%')) (TOK_SELEXPR (LIKE '_%' '\_\%\_\%%')) (TOK_SELEXPR (LIKE '_%' '\_\%_%')) (TOK_SELEXPR (LIKE '%_' '\%\_')) (TOK_SELEXPR (LIKE 'ab' '\%\_')) (TOK_SELEXPR (LIKE 'ab' '_a%')) (TOK_SELEXPR (LIKE 'ab' 'a')) (TOK_SELEXPR (LIKE 'ab' '')) (TOK_SELEXPR (LIKE '' ''))) (TOK_WHERE (= (. (TOK_TABLE_OR_COL src) key) 86))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- src
- TableScan
- alias: src
- Filter Operator
- predicate:
- expr: (key = 86)
- type: boolean
- Select Operator
- expressions:
- expr: ('_%_' like '%\_\%\_%')
- type: boolean
- expr: ('__' like '%\_\%\_%')
- type: boolean
- expr: ('%%_%_' like '%\_\%\_%')
- type: boolean
- expr: ('%_%_%' like '%\%\_\%')
- type: boolean
- expr: ('_%_' like '\%\_%')
- type: boolean
- expr: ('%__' like '__\%%')
- type: boolean
- expr: ('_%' like '\_\%\_\%%')
- type: boolean
- expr: ('_%' like '\_\%_%')
- type: boolean
- expr: ('%_' like '\%\_')
- type: boolean
- expr: ('ab' like '\%\_')
- type: boolean
- expr: ('ab' like '_a%')
- type: boolean
- expr: ('ab' like 'a')
- type: boolean
- expr: ('ab' like '')
- type: boolean
- expr: ('' like '')
- type: boolean
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
Stage: Stage-0
Fetch Operator
limit: -1
+ Processor Tree:
+ TableScan
+ alias: src
+ Filter Operator
+ predicate:
+ expr: (key = 86)
+ type: boolean
+ Select Operator
+ expressions:
+ expr: ('_%_' like '%\_\%\_%')
+ type: boolean
+ expr: ('__' like '%\_\%\_%')
+ type: boolean
+ expr: ('%%_%_' like '%\_\%\_%')
+ type: boolean
+ expr: ('%_%_%' like '%\%\_\%')
+ type: boolean
+ expr: ('_%_' like '\%\_%')
+ type: boolean
+ expr: ('%__' like '__\%%')
+ type: boolean
+ expr: ('_%' like '\_\%\_\%%')
+ type: boolean
+ expr: ('_%' like '\_\%_%')
+ type: boolean
+ expr: ('%_' like '\%\_')
+ type: boolean
+ expr: ('ab' like '\%\_')
+ type: boolean
+ expr: ('ab' like '_a%')
+ type: boolean
+ expr: ('ab' like 'a')
+ type: boolean
+ expr: ('ab' like '')
+ type: boolean
+ expr: ('' like '')
+ type: boolean
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13
+ ListSink
PREHOOK: query: SELECT '_%_' LIKE '%\_\%\_%', '__' LIKE '%\_\%\_%', '%%_%_' LIKE '%\_\%\_%', '%_%_%' LIKE '%\%\_\%',
@@ -105,7 +94,7 @@ PREHOOK: query: SELECT '1+2' LIKE '_+_',
'112' LIKE '1+_',
'|||' LIKE '|_|',
'+++' LIKE '1+_'
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
@@ -114,7 +103,7 @@ POSTHOOK: query: SELECT '1+2' LIKE '_+_'
'112' LIKE '1+_',
'|||' LIKE '|_|',
'+++' LIKE '1+_'
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_locate.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_locate.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_locate.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_locate.q.out Tue Nov 5 07:01:32 2013
@@ -29,7 +29,7 @@ SELECT locate('abc', 'abcd'),
locate('abc', null),
locate('abc', 'abcd', null),
locate('abc', 'abcd', 'invalid number')
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN
SELECT locate('abc', 'abcd'),
@@ -49,71 +49,60 @@ SELECT locate('abc', 'abcd'),
locate('abc', null),
locate('abc', 'abcd', null),
locate('abc', 'abcd', 'invalid number')
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION locate 'abc' 'abcd')) (TOK_SELEXPR (TOK_FUNCTION locate 'ccc' 'abcabc')) (TOK_SELEXPR (TOK_FUNCTION locate '23' 123)) (TOK_SELEXPR (TOK_FUNCTION locate 23 123)) (TOK_SELEXPR (TOK_FUNCTION locate 'abc' 'abcabc' 2)) (TOK_SELEXPR (TOK_FUNCTION locate 'abc' 'abcabc' '2')) (TOK_SELEXPR (TOK_FUNCTION locate 1 TRUE)) (TOK_SELEXPR (TOK_FUNCTION locate 1 FALSE)) (TOK_SELEXPR (TOK_FUNCTION locate (TOK_FUNCTION TOK_TINYINT '2') '12345')) (TOK_SELEXPR (TOK_FUNCTION locate '34' (TOK_FUNCTION TOK_SMALLINT '12345'))) (TOK_SELEXPR (TOK_FUNCTION locate '456' (TOK_FUNCTION TOK_BIGINT '123456789012'))) (TOK_SELEXPR (TOK_FUNCTION locate '.25' (TOK_FUNCTION TOK_FLOAT 1.25))) (TOK_SELEXPR (TOK_FUNCTION locate '.0' (TOK_FUNCTION TOK_DOUBLE 16.0))) (TOK_SELEXPR (TOK_FUNCTION locate TOK_NULL 'abc')) (TOK_SELEXPR (TOK_FUNCTION locate 'abc' TOK_NULL)) (TOK_SELEXPR
(TOK_FUNCTION locate 'abc' 'abcd' TOK_NULL)) (TOK_SELEXPR (TOK_FUNCTION locate 'abc' 'abcd' 'invalid number'))) (TOK_LIMIT 1)))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src) (TOK_TABLESPLITSAMPLE TOK_ROWCOUNT 1))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION locate 'abc' 'abcd')) (TOK_SELEXPR (TOK_FUNCTION locate 'ccc' 'abcabc')) (TOK_SELEXPR (TOK_FUNCTION locate '23' 123)) (TOK_SELEXPR (TOK_FUNCTION locate 23 123)) (TOK_SELEXPR (TOK_FUNCTION locate 'abc' 'abcabc' 2)) (TOK_SELEXPR (TOK_FUNCTION locate 'abc' 'abcabc' '2')) (TOK_SELEXPR (TOK_FUNCTION locate 1 TRUE)) (TOK_SELEXPR (TOK_FUNCTION locate 1 FALSE)) (TOK_SELEXPR (TOK_FUNCTION locate (TOK_FUNCTION TOK_TINYINT '2') '12345')) (TOK_SELEXPR (TOK_FUNCTION locate '34' (TOK_FUNCTION TOK_SMALLINT '12345'))) (TOK_SELEXPR (TOK_FUNCTION locate '456' (TOK_FUNCTION TOK_BIGINT '123456789012'))) (TOK_SELEXPR (TOK_FUNCTION locate '.25' (TOK_FUNCTION TOK_FLOAT 1.25))) (TOK_SELEXPR (TOK_FUNCTION locate '.0' (TOK_FUNCTION TOK_DOUBLE 16.0))) (TOK_SELEXPR (TOK_FUNCTION locate TOK_NULL 'abc')) (TOK_SELEXPR (TOK_FUNCTION
locate 'abc' TOK_NULL)) (TOK_SELEXPR (TOK_FUNCTION locate 'abc' 'abcd' TOK_NULL)) (TOK_SELEXPR (TOK_FUNCTION locate 'abc' 'abcd' 'invalid number')))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- src
- TableScan
- alias: src
- Select Operator
- expressions:
- expr: locate('abc''abcd')
- type: int
- expr: locate('ccc''abcabc')
- type: int
- expr: locate('23'123)
- type: int
- expr: locate(23123)
- type: int
- expr: locate('abc''abcabc'2)
- type: int
- expr: locate('abc''abcabc''2')
- type: int
- expr: locate(1true)
- type: int
- expr: locate(1false)
- type: int
- expr: locate(UDFToByte('2')'12345')
- type: int
- expr: locate('34'UDFToShort('12345'))
- type: int
- expr: locate('456'UDFToLong('123456789012'))
- type: int
- expr: locate('.25'UDFToFloat(1.25))
- type: int
- expr: locate('.0'16.0)
- type: int
- expr: locate(null'abc')
- type: int
- expr: locate('abc'null)
- type: int
- expr: locate('abc''abcd'null)
- type: int
- expr: locate('abc''abcd''invalid number')
- type: int
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16
- Limit
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
Stage: Stage-0
Fetch Operator
- limit: 1
+ limit: -1
+ Processor Tree:
+ TableScan
+ alias: src
+ Row Limit Per Split: 1
+ Select Operator
+ expressions:
+ expr: locate('abc''abcd')
+ type: int
+ expr: locate('ccc''abcabc')
+ type: int
+ expr: locate('23'123)
+ type: int
+ expr: locate(23123)
+ type: int
+ expr: locate('abc''abcabc'2)
+ type: int
+ expr: locate('abc''abcabc''2')
+ type: int
+ expr: locate(1true)
+ type: int
+ expr: locate(1false)
+ type: int
+ expr: locate(UDFToByte('2')'12345')
+ type: int
+ expr: locate('34'UDFToShort('12345'))
+ type: int
+ expr: locate('456'UDFToLong('123456789012'))
+ type: int
+ expr: locate('.25'UDFToFloat(1.25))
+ type: int
+ expr: locate('.0'16.0)
+ type: int
+ expr: locate(null'abc')
+ type: int
+ expr: locate('abc'null)
+ type: int
+ expr: locate('abc''abcd'null)
+ type: int
+ expr: locate('abc''abcd''invalid number')
+ type: int
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16
+ ListSink
PREHOOK: query: SELECT locate('abc', 'abcd'),
@@ -133,7 +122,7 @@ PREHOOK: query: SELECT locate('abc', 'ab
locate('abc', null),
locate('abc', 'abcd', null),
locate('abc', 'abcd', 'invalid number')
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
@@ -154,7 +143,7 @@ POSTHOOK: query: SELECT locate('abc', 'a
locate('abc', null),
locate('abc', 'abcd', null),
locate('abc', 'abcd', 'invalid number')
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_lpad.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_lpad.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_lpad.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_lpad.q.out Tue Nov 5 07:01:32 2013
@@ -17,56 +17,45 @@ PREHOOK: query: EXPLAIN SELECT
lpad('hi', 1, '?'),
lpad('hi', 5, '.'),
lpad('hi', 6, '123')
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN SELECT
lpad('hi', 1, '?'),
lpad('hi', 5, '.'),
lpad('hi', 6, '123')
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION lpad 'hi' 1 '?')) (TOK_SELEXPR (TOK_FUNCTION lpad 'hi' 5 '.')) (TOK_SELEXPR (TOK_FUNCTION lpad 'hi' 6 '123'))) (TOK_LIMIT 1)))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src) (TOK_TABLESPLITSAMPLE TOK_ROWCOUNT 1))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION lpad 'hi' 1 '?')) (TOK_SELEXPR (TOK_FUNCTION lpad 'hi' 5 '.')) (TOK_SELEXPR (TOK_FUNCTION lpad 'hi' 6 '123')))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- src
- TableScan
- alias: src
- Select Operator
- expressions:
- expr: lpad('hi', 1, '?')
- type: string
- expr: lpad('hi', 5, '.')
- type: string
- expr: lpad('hi', 6, '123')
- type: string
- outputColumnNames: _col0, _col1, _col2
- Limit
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
Stage: Stage-0
Fetch Operator
- limit: 1
+ limit: -1
+ Processor Tree:
+ TableScan
+ alias: src
+ Row Limit Per Split: 1
+ Select Operator
+ expressions:
+ expr: lpad('hi', 1, '?')
+ type: string
+ expr: lpad('hi', 5, '.')
+ type: string
+ expr: lpad('hi', 6, '123')
+ type: string
+ outputColumnNames: _col0, _col1, _col2
+ ListSink
PREHOOK: query: SELECT
lpad('hi', 1, '?'),
lpad('hi', 5, '.'),
lpad('hi', 6, '123')
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
@@ -74,7 +63,7 @@ POSTHOOK: query: SELECT
lpad('hi', 1, '?'),
lpad('hi', 5, '.'),
lpad('hi', 6, '123')
-FROM src LIMIT 1
+FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_map.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_map.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_map.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_map.q.out Tue Nov 5 07:01:32 2013
@@ -9,61 +9,50 @@ POSTHOOK: query: DESCRIBE FUNCTION EXTEN
POSTHOOK: type: DESCFUNCTION
map(key0, value0, key1, value1...) - Creates a map with the given key/value pairs
PREHOOK: query: EXPLAIN SELECT map(), map(1, "a", 2, "b", 3, "c"), map(1, 2, "a", "b"),
-map(1, "a", 2, "b", 3, "c")[2], map(1, 2, "a", "b")["a"], map(1, array("a"))[1][0] FROM src LIMIT 1
+map(1, "a", 2, "b", 3, "c")[2], map(1, 2, "a", "b")["a"], map(1, array("a"))[1][0] FROM src tablesample (1 rows)
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN SELECT map(), map(1, "a", 2, "b", 3, "c"), map(1, 2, "a", "b"),
-map(1, "a", 2, "b", 3, "c")[2], map(1, 2, "a", "b")["a"], map(1, array("a"))[1][0] FROM src LIMIT 1
+map(1, "a", 2, "b", 3, "c")[2], map(1, 2, "a", "b")["a"], map(1, array("a"))[1][0] FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION map)) (TOK_SELEXPR (TOK_FUNCTION map 1 "a" 2 "b" 3 "c")) (TOK_SELEXPR (TOK_FUNCTION map 1 2 "a" "b")) (TOK_SELEXPR ([ (TOK_FUNCTION map 1 "a" 2 "b" 3 "c") 2)) (TOK_SELEXPR ([ (TOK_FUNCTION map 1 2 "a" "b") "a")) (TOK_SELEXPR ([ ([ (TOK_FUNCTION map 1 (TOK_FUNCTION array "a")) 1) 0))) (TOK_LIMIT 1)))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src) (TOK_TABLESPLITSAMPLE TOK_ROWCOUNT 1))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION map)) (TOK_SELEXPR (TOK_FUNCTION map 1 "a" 2 "b" 3 "c")) (TOK_SELEXPR (TOK_FUNCTION map 1 2 "a" "b")) (TOK_SELEXPR ([ (TOK_FUNCTION map 1 "a" 2 "b" 3 "c") 2)) (TOK_SELEXPR ([ (TOK_FUNCTION map 1 2 "a" "b") "a")) (TOK_SELEXPR ([ ([ (TOK_FUNCTION map 1 (TOK_FUNCTION array "a")) 1) 0)))))
STAGE DEPENDENCIES:
- Stage-1 is a root stage
Stage-0 is a root stage
STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- src
- TableScan
- alias: src
- Select Operator
- expressions:
- expr: map()
- type: map<string,string>
- expr: map(1:'a',2:'b',3:'c')
- type: map<int,string>
- expr: map(1:2,'a':'b')
- type: map<string,string>
- expr: map(1:'a',2:'b',3:'c')[2]
- type: string
- expr: map(1:2,'a':'b')['a']
- type: string
- expr: map(1:array('a'))[1][0]
- type: string
- outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Limit
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
Stage: Stage-0
Fetch Operator
- limit: 1
+ limit: -1
+ Processor Tree:
+ TableScan
+ alias: src
+ Row Limit Per Split: 1
+ Select Operator
+ expressions:
+ expr: map()
+ type: map<string,string>
+ expr: map(1:'a',2:'b',3:'c')
+ type: map<int,string>
+ expr: map(1:2,'a':'b')
+ type: map<string,string>
+ expr: map(1:'a',2:'b',3:'c')[2]
+ type: string
+ expr: map(1:2,'a':'b')['a']
+ type: string
+ expr: map(1:array('a'))[1][0]
+ type: string
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
+ ListSink
PREHOOK: query: SELECT map(), map(1, "a", 2, "b", 3, "c"), map(1, 2, "a", "b"),
-map(1, "a", 2, "b", 3, "c")[2], map(1, 2, "a", "b")["a"], map(1, array("a"))[1][0] FROM src LIMIT 1
+map(1, "a", 2, "b", 3, "c")[2], map(1, 2, "a", "b")["a"], map(1, array("a"))[1][0] FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: SELECT map(), map(1, "a", 2, "b", 3, "c"), map(1, 2, "a", "b"),
-map(1, "a", 2, "b", 3, "c")[2], map(1, 2, "a", "b")["a"], map(1, array("a"))[1][0] FROM src LIMIT 1
+map(1, "a", 2, "b", 3, "c")[2], map(1, 2, "a", "b")["a"], map(1, array("a"))[1][0] FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_map_keys.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_map_keys.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_map_keys.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_map_keys.q.out Tue Nov 5 07:01:32 2013
@@ -17,23 +17,23 @@ POSTHOOK: query: DESCRIBE FUNCTION EXTEN
POSTHOOK: type: DESCFUNCTION
map_keys(map) - Returns an unordered array containing the keys of the input map.
PREHOOK: query: -- Evaluate function against INT valued keys
-SELECT map_keys(map(1, "a", 2, "b", 3, "c")) FROM src LIMIT 1
+SELECT map_keys(map(1, "a", 2, "b", 3, "c")) FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: -- Evaluate function against INT valued keys
-SELECT map_keys(map(1, "a", 2, "b", 3, "c")) FROM src LIMIT 1
+SELECT map_keys(map(1, "a", 2, "b", 3, "c")) FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
[1,2,3]
PREHOOK: query: -- Evaluate function against STRING valued keys
-SELECT map_keys(map("a", 1, "b", 2, "c", 3)) FROM src LIMIT 1
+SELECT map_keys(map("a", 1, "b", 2, "c", 3)) FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: -- Evaluate function against STRING valued keys
-SELECT map_keys(map("a", 1, "b", 2, "c", 3)) FROM src LIMIT 1
+SELECT map_keys(map("a", 1, "b", 2, "c", 3)) FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_map_values.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_map_values.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_map_values.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_map_values.q.out Tue Nov 5 07:01:32 2013
@@ -17,23 +17,23 @@ POSTHOOK: query: DESCRIBE FUNCTION EXTEN
POSTHOOK: type: DESCFUNCTION
map_values(map) - Returns an unordered array containing the values of the input map.
PREHOOK: query: -- Evaluate function against STRING valued values
-SELECT map_values(map(1, "a", 2, "b", 3, "c")) FROM src LIMIT 1
+SELECT map_values(map(1, "a", 2, "b", 3, "c")) FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: -- Evaluate function against STRING valued values
-SELECT map_values(map(1, "a", 2, "b", 3, "c")) FROM src LIMIT 1
+SELECT map_values(map(1, "a", 2, "b", 3, "c")) FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
["a","b","c"]
PREHOOK: query: -- Evaluate function against INT valued keys
-SELECT map_values(map("a", 1, "b", 2, "c", 3)) FROM src LIMIT 1
+SELECT map_values(map("a", 1, "b", 2, "c", 3)) FROM src tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: -- Evaluate function against INT valued keys
-SELECT map_values(map("a", 1, "b", 2, "c", 3)) FROM src LIMIT 1
+SELECT map_values(map("a", 1, "b", 2, "c", 3)) FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####