You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by go...@apache.org on 2014/10/02 22:53:35 UTC
svn commit: r1629067 [4/11] - in /hive/trunk: data/files/
itests/src/test/resources/ ql/src/java/org/apache/hadoop/hive/ql/exec/vector/
ql/src/test/queries/clientpositive/ ql/src/test/results/clientpositive/
ql/src/test/results/clientpositive/tez/
Added: hive/trunk/ql/src/test/results/clientpositive/tez/vector_distinct_2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/vector_distinct_2.q.out?rev=1629067&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/vector_distinct_2.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/vector_distinct_2.q.out Thu Oct 2 20:53:34 2014
@@ -0,0 +1,1866 @@
+PREHOOK: query: create table vectortab2k(
+ t tinyint,
+ si smallint,
+ i int,
+ b bigint,
+ f float,
+ d double,
+ dc decimal(38,18),
+ bo boolean,
+ s string,
+ s2 string,
+ ts timestamp,
+ ts2 timestamp,
+ dt date)
+ROW FORMAT DELIMITED FIELDS TERMINATED BY '|'
+STORED AS TEXTFILE
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@vectortab2k
+POSTHOOK: query: create table vectortab2k(
+ t tinyint,
+ si smallint,
+ i int,
+ b bigint,
+ f float,
+ d double,
+ dc decimal(38,18),
+ bo boolean,
+ s string,
+ s2 string,
+ ts timestamp,
+ ts2 timestamp,
+ dt date)
+ROW FORMAT DELIMITED FIELDS TERMINATED BY '|'
+STORED AS TEXTFILE
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@vectortab2k
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/vectortab2k' OVERWRITE INTO TABLE vectortab2k
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@vectortab2k
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/vectortab2k' OVERWRITE INTO TABLE vectortab2k
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@vectortab2k
+PREHOOK: query: create table vectortab2korc(
+ t tinyint,
+ si smallint,
+ i int,
+ b bigint,
+ f float,
+ d double,
+ dc decimal(38,18),
+ bo boolean,
+ s string,
+ s2 string,
+ ts timestamp,
+ ts2 timestamp,
+ dt date)
+STORED AS ORC
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@vectortab2korc
+POSTHOOK: query: create table vectortab2korc(
+ t tinyint,
+ si smallint,
+ i int,
+ b bigint,
+ f float,
+ d double,
+ dc decimal(38,18),
+ bo boolean,
+ s string,
+ s2 string,
+ ts timestamp,
+ ts2 timestamp,
+ dt date)
+STORED AS ORC
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@vectortab2korc
+PREHOOK: query: INSERT INTO TABLE vectortab2korc SELECT * FROM vectortab2k
+PREHOOK: type: QUERY
+PREHOOK: Input: default@vectortab2k
+PREHOOK: Output: default@vectortab2korc
+POSTHOOK: query: INSERT INTO TABLE vectortab2korc SELECT * FROM vectortab2k
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@vectortab2k
+POSTHOOK: Output: default@vectortab2korc
+POSTHOOK: Lineage: vectortab2korc.b SIMPLE [(vectortab2k)vectortab2k.FieldSchema(name:b, type:bigint, comment:null), ]
+POSTHOOK: Lineage: vectortab2korc.bo SIMPLE [(vectortab2k)vectortab2k.FieldSchema(name:bo, type:boolean, comment:null), ]
+POSTHOOK: Lineage: vectortab2korc.d SIMPLE [(vectortab2k)vectortab2k.FieldSchema(name:d, type:double, comment:null), ]
+POSTHOOK: Lineage: vectortab2korc.dc SIMPLE [(vectortab2k)vectortab2k.FieldSchema(name:dc, type:decimal(38,18), comment:null), ]
+POSTHOOK: Lineage: vectortab2korc.dt SIMPLE [(vectortab2k)vectortab2k.FieldSchema(name:dt, type:date, comment:null), ]
+POSTHOOK: Lineage: vectortab2korc.f SIMPLE [(vectortab2k)vectortab2k.FieldSchema(name:f, type:float, comment:null), ]
+POSTHOOK: Lineage: vectortab2korc.i SIMPLE [(vectortab2k)vectortab2k.FieldSchema(name:i, type:int, comment:null), ]
+POSTHOOK: Lineage: vectortab2korc.s SIMPLE [(vectortab2k)vectortab2k.FieldSchema(name:s, type:string, comment:null), ]
+POSTHOOK: Lineage: vectortab2korc.s2 SIMPLE [(vectortab2k)vectortab2k.FieldSchema(name:s2, type:string, comment:null), ]
+POSTHOOK: Lineage: vectortab2korc.si SIMPLE [(vectortab2k)vectortab2k.FieldSchema(name:si, type:smallint, comment:null), ]
+POSTHOOK: Lineage: vectortab2korc.t SIMPLE [(vectortab2k)vectortab2k.FieldSchema(name:t, type:tinyint, comment:null), ]
+POSTHOOK: Lineage: vectortab2korc.ts SIMPLE [(vectortab2k)vectortab2k.FieldSchema(name:ts, type:timestamp, comment:null), ]
+POSTHOOK: Lineage: vectortab2korc.ts2 SIMPLE [(vectortab2k)vectortab2k.FieldSchema(name:ts2, type:timestamp, comment:null), ]
+PREHOOK: query: explain
+select distinct s, t from vectortab2korc
+PREHOOK: type: QUERY
+POSTHOOK: query: explain
+select distinct s, t from vectortab2korc
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Tez
+ Edges:
+ Reducer 2 <- Map 1 (SIMPLE_EDGE)
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: vectortab2korc
+ Statistics: Num rows: 2000 Data size: 918712 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: s (type: string), t (type: tinyint)
+ outputColumnNames: s, t
+ Statistics: Num rows: 2000 Data size: 918712 Basic stats: COMPLETE Column stats: NONE
+ Group By Operator
+ keys: s (type: string), t (type: tinyint)
+ mode: hash
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 2000 Data size: 918712 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: _col0 (type: string), _col1 (type: tinyint)
+ sort order: ++
+ Map-reduce partition columns: _col0 (type: string), _col1 (type: tinyint)
+ Statistics: Num rows: 2000 Data size: 918712 Basic stats: COMPLETE Column stats: NONE
+ Execution mode: vectorized
+ Reducer 2
+ Reduce Operator Tree:
+ Group By Operator
+ keys: KEY._col0 (type: string), KEY._col1 (type: tinyint)
+ mode: mergepartial
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 1000 Data size: 459356 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: _col0 (type: string), _col1 (type: tinyint)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 1000 Data size: 459356 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 1000 Data size: 459356 Basic stats: COMPLETE Column stats: NONE
+ 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
+ Execution mode: vectorized
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
+PREHOOK: query: select distinct s, t from vectortab2korc
+PREHOOK: type: QUERY
+PREHOOK: Input: default@vectortab2korc
+#### A masked pattern was here ####
+POSTHOOK: query: select distinct s, t from vectortab2korc
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@vectortab2korc
+#### A masked pattern was here ####
+ NULL
+ -116
+ -114
+ -113
+ -108
+ -107
+ -104
+ -91
+ -87
+ -86
+ -85
+ -84
+ -83
+ -80
+ -75
+ -72
+ -66
+ -53
+ -46
+ -38
+ -36
+ -33
+ -29
+ -28
+ -25
+ -24
+ -19
+ -16
+ -14
+ -12
+ -10
+ -5
+ -4
+ -2
+ 0
+ 4
+ 5
+ 8
+ 12
+ 16
+ 19
+ 22
+ 23
+ 26
+ 29
+ 31
+ 37
+ 42
+ 46
+ 48
+ 54
+ 57
+ 59
+ 60
+ 62
+ 64
+ 79
+ 84
+ 87
+ 88
+ 90
+ 91
+ 96
+ 97
+ 102
+ 103
+ 105
+ 109
+ 112
+ 113
+ 114
+ 123
+american history NULL
+american history -127
+american history -119
+american history -116
+american history -112
+american history -110
+american history -108
+american history -105
+american history -103
+american history -101
+american history -95
+american history -94
+american history -92
+american history -90
+american history -89
+american history -87
+american history -86
+american history -81
+american history -80
+american history -73
+american history -66
+american history -60
+american history -59
+american history -55
+american history -53
+american history -50
+american history -48
+american history -47
+american history -34
+american history -30
+american history -28
+american history -27
+american history -26
+american history -19
+american history -18
+american history -17
+american history -15
+american history -11
+american history -9
+american history 0
+american history 5
+american history 20
+american history 22
+american history 29
+american history 31
+american history 33
+american history 38
+american history 39
+american history 40
+american history 42
+american history 46
+american history 48
+american history 54
+american history 56
+american history 60
+american history 68
+american history 69
+american history 71
+american history 72
+american history 74
+american history 77
+american history 79
+american history 82
+american history 84
+american history 89
+american history 96
+american history 100
+american history 103
+american history 111
+american history 119
+american history 122
+american history 123
+biology NULL
+biology -127
+biology -121
+biology -120
+biology -119
+biology -104
+biology -101
+biology -98
+biology -97
+biology -96
+biology -92
+biology -90
+biology -86
+biology -85
+biology -83
+biology -82
+biology -81
+biology -79
+biology -72
+biology -67
+biology -66
+biology -59
+biology -57
+biology -54
+biology -53
+biology -49
+biology -46
+biology -44
+biology -42
+biology -40
+biology -36
+biology -35
+biology -31
+biology -20
+biology -19
+biology -16
+biology -13
+biology -7
+biology -6
+biology -5
+biology 0
+biology 2
+biology 3
+biology 4
+biology 5
+biology 6
+biology 7
+biology 8
+biology 12
+biology 18
+biology 27
+biology 30
+biology 34
+biology 35
+biology 36
+biology 41
+biology 47
+biology 51
+biology 52
+biology 54
+biology 55
+biology 57
+biology 64
+biology 83
+biology 86
+biology 89
+biology 90
+biology 91
+biology 100
+biology 111
+biology 113
+biology 114
+biology 115
+biology 117
+biology 120
+biology 124
+chemistry NULL
+chemistry -127
+chemistry -125
+chemistry -122
+chemistry -117
+chemistry -115
+chemistry -110
+chemistry -109
+chemistry -108
+chemistry -103
+chemistry -101
+chemistry -98
+chemistry -95
+chemistry -91
+chemistry -90
+chemistry -89
+chemistry -81
+chemistry -75
+chemistry -68
+chemistry -61
+chemistry -59
+chemistry -57
+chemistry -56
+chemistry -52
+chemistry -46
+chemistry -44
+chemistry -40
+chemistry -37
+chemistry -33
+chemistry -31
+chemistry -30
+chemistry -26
+chemistry -23
+chemistry -8
+chemistry -3
+chemistry -2
+chemistry 3
+chemistry 4
+chemistry 8
+chemistry 14
+chemistry 16
+chemistry 19
+chemistry 25
+chemistry 27
+chemistry 32
+chemistry 37
+chemistry 39
+chemistry 41
+chemistry 46
+chemistry 51
+chemistry 55
+chemistry 64
+chemistry 74
+chemistry 75
+chemistry 78
+chemistry 79
+chemistry 83
+chemistry 88
+chemistry 90
+chemistry 91
+chemistry 96
+chemistry 102
+chemistry 104
+chemistry 110
+chemistry 113
+chemistry 116
+chemistry 124
+chemistry 126
+debate NULL
+debate -127
+debate -117
+debate -114
+debate -108
+debate -106
+debate -98
+debate -96
+debate -95
+debate -88
+debate -87
+debate -86
+debate -85
+debate -82
+debate -72
+debate -70
+debate -69
+debate -67
+debate -57
+debate -52
+debate -50
+debate -47
+debate -46
+debate -41
+debate -35
+debate -32
+debate -29
+debate -28
+debate -27
+debate -26
+debate -24
+debate -15
+debate -12
+debate -3
+debate 5
+debate 17
+debate 19
+debate 20
+debate 26
+debate 34
+debate 36
+debate 41
+debate 42
+debate 52
+debate 54
+debate 56
+debate 63
+debate 67
+debate 68
+debate 69
+debate 70
+debate 73
+debate 75
+debate 77
+debate 85
+debate 87
+debate 89
+debate 90
+debate 93
+debate 94
+debate 113
+debate 124
+education NULL
+education -127
+education -125
+education -113
+education -111
+education -109
+education -105
+education -101
+education -98
+education -96
+education -93
+education -92
+education -89
+education -87
+education -86
+education -77
+education -72
+education -69
+education -64
+education -61
+education -55
+education -52
+education -44
+education -43
+education -38
+education -37
+education -36
+education -34
+education -28
+education -24
+education -15
+education -13
+education -9
+education 4
+education 12
+education 17
+education 27
+education 33
+education 34
+education 35
+education 38
+education 41
+education 45
+education 46
+education 49
+education 51
+education 53
+education 59
+education 61
+education 66
+education 73
+education 75
+education 77
+education 81
+education 82
+education 85
+education 89
+education 95
+education 102
+education 103
+education 110
+education 111
+education 113
+education 114
+education 116
+education 119
+education 125
+forestry NULL
+forestry -126
+forestry -118
+forestry -116
+forestry -109
+forestry -105
+forestry -98
+forestry -95
+forestry -94
+forestry -83
+forestry -81
+forestry -80
+forestry -79
+forestry -77
+forestry -74
+forestry -73
+forestry -68
+forestry -58
+forestry -51
+forestry -50
+forestry -49
+forestry -42
+forestry -34
+forestry -23
+forestry -12
+forestry -11
+forestry -10
+forestry -8
+forestry -3
+forestry -1
+forestry 0
+forestry 7
+forestry 8
+forestry 11
+forestry 12
+forestry 19
+forestry 29
+forestry 31
+forestry 35
+forestry 37
+forestry 39
+forestry 40
+forestry 44
+forestry 45
+forestry 50
+forestry 51
+forestry 52
+forestry 55
+forestry 56
+forestry 71
+forestry 78
+forestry 79
+forestry 87
+forestry 90
+forestry 93
+forestry 94
+forestry 97
+forestry 102
+forestry 106
+forestry 107
+forestry 111
+forestry 115
+forestry 117
+forestry 120
+geology NULL
+geology -124
+geology -117
+geology -115
+geology -112
+geology -108
+geology -106
+geology -101
+geology -100
+geology -96
+geology -94
+geology -84
+geology -82
+geology -80
+geology -79
+geology -75
+geology -72
+geology -68
+geology -59
+geology -57
+geology -54
+geology -53
+geology -50
+geology -48
+geology -35
+geology -34
+geology -32
+geology -31
+geology -30
+geology -23
+geology -21
+geology -18
+geology -16
+geology 1
+geology 4
+geology 5
+geology 6
+geology 9
+geology 14
+geology 18
+geology 21
+geology 23
+geology 26
+geology 28
+geology 31
+geology 33
+geology 37
+geology 38
+geology 49
+geology 58
+geology 72
+geology 82
+geology 84
+geology 86
+geology 89
+geology 92
+geology 93
+geology 95
+geology 100
+geology 101
+geology 102
+geology 116
+geology 121
+geology 124
+geology 127
+history NULL
+history -125
+history -124
+history -105
+history -104
+history -103
+history -101
+history -98
+history -91
+history -90
+history -89
+history -79
+history -75
+history -67
+history -61
+history -58
+history -54
+history -42
+history -37
+history -34
+history -26
+history -24
+history -19
+history -18
+history -15
+history -12
+history -8
+history -5
+history -1
+history 1
+history 2
+history 7
+history 14
+history 18
+history 25
+history 50
+history 51
+history 52
+history 57
+history 58
+history 59
+history 61
+history 62
+history 71
+history 72
+history 73
+history 75
+history 78
+history 84
+history 92
+history 95
+history 98
+history 100
+history 108
+history 112
+history 113
+history 114
+history 126
+history 127
+industrial engineering NULL
+industrial engineering -124
+industrial engineering -110
+industrial engineering -101
+industrial engineering -98
+industrial engineering -96
+industrial engineering -87
+industrial engineering -85
+industrial engineering -72
+industrial engineering -68
+industrial engineering -65
+industrial engineering -58
+industrial engineering -57
+industrial engineering -53
+industrial engineering -49
+industrial engineering -47
+industrial engineering -43
+industrial engineering -38
+industrial engineering -35
+industrial engineering -31
+industrial engineering -30
+industrial engineering -28
+industrial engineering -22
+industrial engineering -11
+industrial engineering -7
+industrial engineering -6
+industrial engineering -5
+industrial engineering -1
+industrial engineering 3
+industrial engineering 7
+industrial engineering 27
+industrial engineering 29
+industrial engineering 32
+industrial engineering 33
+industrial engineering 36
+industrial engineering 42
+industrial engineering 43
+industrial engineering 48
+industrial engineering 54
+industrial engineering 58
+industrial engineering 59
+industrial engineering 70
+industrial engineering 73
+industrial engineering 78
+industrial engineering 79
+industrial engineering 83
+industrial engineering 95
+industrial engineering 96
+industrial engineering 98
+industrial engineering 99
+industrial engineering 102
+industrial engineering 104
+industrial engineering 105
+industrial engineering 106
+industrial engineering 113
+industrial engineering 126
+joggying NULL
+joggying -125
+joggying -121
+joggying -119
+joggying -110
+joggying -101
+joggying -100
+joggying -80
+joggying -79
+joggying -77
+joggying -76
+joggying -73
+joggying -69
+joggying -64
+joggying -62
+joggying -61
+joggying -57
+joggying -55
+joggying -48
+joggying -47
+joggying -43
+joggying -40
+joggying -30
+joggying -27
+joggying -24
+joggying -15
+joggying -14
+joggying -8
+joggying -1
+joggying 13
+joggying 20
+joggying 25
+joggying 26
+joggying 27
+joggying 28
+joggying 37
+joggying 43
+joggying 46
+joggying 48
+joggying 49
+joggying 52
+joggying 57
+joggying 61
+joggying 62
+joggying 69
+joggying 70
+joggying 72
+joggying 74
+joggying 80
+joggying 85
+joggying 87
+joggying 92
+joggying 93
+joggying 94
+joggying 97
+joggying 99
+joggying 104
+joggying 105
+joggying 118
+joggying 119
+joggying 121
+joggying 123
+joggying 125
+kindergarten NULL
+kindergarten -126
+kindergarten -113
+kindergarten -106
+kindergarten -98
+kindergarten -95
+kindergarten -92
+kindergarten -79
+kindergarten -78
+kindergarten -75
+kindergarten -74
+kindergarten -69
+kindergarten -60
+kindergarten -59
+kindergarten -57
+kindergarten -54
+kindergarten -42
+kindergarten -40
+kindergarten -26
+kindergarten -18
+kindergarten -8
+kindergarten 10
+kindergarten 16
+kindergarten 18
+kindergarten 19
+kindergarten 23
+kindergarten 29
+kindergarten 37
+kindergarten 46
+kindergarten 48
+kindergarten 51
+kindergarten 52
+kindergarten 55
+kindergarten 61
+kindergarten 66
+kindergarten 69
+kindergarten 82
+kindergarten 84
+kindergarten 85
+kindergarten 86
+kindergarten 90
+kindergarten 92
+kindergarten 96
+kindergarten 100
+kindergarten 101
+kindergarten 109
+kindergarten 111
+kindergarten 116
+kindergarten 118
+kindergarten 120
+kindergarten 122
+kindergarten 127
+linguistics NULL
+linguistics -127
+linguistics -122
+linguistics -113
+linguistics -101
+linguistics -90
+linguistics -89
+linguistics -87
+linguistics -86
+linguistics -78
+linguistics -77
+linguistics -73
+linguistics -70
+linguistics -69
+linguistics -68
+linguistics -67
+linguistics -53
+linguistics -52
+linguistics -41
+linguistics -34
+linguistics -28
+linguistics -22
+linguistics -20
+linguistics -17
+linguistics -16
+linguistics -14
+linguistics -13
+linguistics -12
+linguistics -6
+linguistics -4
+linguistics -2
+linguistics 0
+linguistics 1
+linguistics 3
+linguistics 6
+linguistics 7
+linguistics 10
+linguistics 11
+linguistics 18
+linguistics 33
+linguistics 37
+linguistics 42
+linguistics 44
+linguistics 50
+linguistics 53
+linguistics 64
+linguistics 67
+linguistics 72
+linguistics 73
+linguistics 83
+linguistics 89
+linguistics 93
+linguistics 96
+linguistics 98
+linguistics 100
+linguistics 113
+linguistics 115
+linguistics 123
+linguistics 125
+linguistics 126
+mathematics NULL
+mathematics -127
+mathematics -124
+mathematics -122
+mathematics -120
+mathematics -118
+mathematics -117
+mathematics -103
+mathematics -101
+mathematics -100
+mathematics -99
+mathematics -98
+mathematics -95
+mathematics -91
+mathematics -88
+mathematics -81
+mathematics -79
+mathematics -77
+mathematics -75
+mathematics -66
+mathematics -57
+mathematics -52
+mathematics -50
+mathematics -49
+mathematics -46
+mathematics -45
+mathematics -40
+mathematics -33
+mathematics -31
+mathematics -21
+mathematics -19
+mathematics -7
+mathematics 0
+mathematics 3
+mathematics 6
+mathematics 10
+mathematics 22
+mathematics 23
+mathematics 25
+mathematics 32
+mathematics 35
+mathematics 38
+mathematics 39
+mathematics 46
+mathematics 48
+mathematics 50
+mathematics 53
+mathematics 55
+mathematics 56
+mathematics 58
+mathematics 59
+mathematics 62
+mathematics 63
+mathematics 65
+mathematics 76
+mathematics 79
+mathematics 80
+mathematics 82
+mathematics 87
+mathematics 92
+mathematics 98
+mathematics 102
+mathematics 107
+mathematics 111
+mathematics 114
+nap time NULL
+nap time -122
+nap time -119
+nap time -115
+nap time -113
+nap time -104
+nap time -102
+nap time -101
+nap time -91
+nap time -85
+nap time -71
+nap time -61
+nap time -54
+nap time -49
+nap time -45
+nap time -41
+nap time -31
+nap time -15
+nap time -6
+nap time -4
+nap time -2
+nap time 0
+nap time 3
+nap time 6
+nap time 16
+nap time 23
+nap time 27
+nap time 31
+nap time 35
+nap time 42
+nap time 51
+nap time 52
+nap time 56
+nap time 62
+nap time 69
+nap time 70
+nap time 73
+nap time 76
+nap time 80
+nap time 89
+nap time 90
+nap time 92
+nap time 93
+nap time 98
+nap time 103
+nap time 104
+nap time 105
+nap time 107
+nap time 108
+nap time 118
+opthamology NULL
+opthamology -122
+opthamology -121
+opthamology -118
+opthamology -111
+opthamology -99
+opthamology -97
+opthamology -91
+opthamology -86
+opthamology -82
+opthamology -79
+opthamology -78
+opthamology -77
+opthamology -75
+opthamology -73
+opthamology -63
+opthamology -59
+opthamology -55
+opthamology -49
+opthamology -48
+opthamology -44
+opthamology -35
+opthamology -33
+opthamology -30
+opthamology -28
+opthamology -27
+opthamology -24
+opthamology -22
+opthamology -18
+opthamology -17
+opthamology -14
+opthamology -8
+opthamology -5
+opthamology 4
+opthamology 5
+opthamology 21
+opthamology 39
+opthamology 41
+opthamology 48
+opthamology 49
+opthamology 52
+opthamology 53
+opthamology 55
+opthamology 68
+opthamology 69
+opthamology 74
+opthamology 76
+opthamology 77
+opthamology 79
+opthamology 81
+opthamology 84
+opthamology 87
+opthamology 88
+opthamology 89
+opthamology 92
+opthamology 96
+opthamology 97
+opthamology 100
+opthamology 104
+opthamology 117
+opthamology 120
+opthamology 122
+opthamology 125
+opthamology 127
+philosophy NULL
+philosophy -125
+philosophy -121
+philosophy -119
+philosophy -115
+philosophy -110
+philosophy -105
+philosophy -103
+philosophy -100
+philosophy -99
+philosophy -95
+philosophy -93
+philosophy -92
+philosophy -80
+philosophy -78
+philosophy -77
+philosophy -69
+philosophy -68
+philosophy -61
+philosophy -56
+philosophy -55
+philosophy -53
+philosophy -52
+philosophy -51
+philosophy -50
+philosophy -40
+philosophy -39
+philosophy -27
+philosophy -26
+philosophy -25
+philosophy -17
+philosophy -11
+philosophy 8
+philosophy 20
+philosophy 21
+philosophy 22
+philosophy 29
+philosophy 31
+philosophy 34
+philosophy 38
+philosophy 41
+philosophy 43
+philosophy 45
+philosophy 48
+philosophy 64
+philosophy 67
+philosophy 68
+philosophy 73
+philosophy 83
+philosophy 96
+philosophy 98
+philosophy 104
+philosophy 108
+philosophy 117
+philosophy 118
+philosophy 120
+philosophy 123
+quiet hour NULL
+quiet hour -127
+quiet hour -123
+quiet hour -121
+quiet hour -119
+quiet hour -114
+quiet hour -111
+quiet hour -105
+quiet hour -104
+quiet hour -88
+quiet hour -87
+quiet hour -76
+quiet hour -73
+quiet hour -68
+quiet hour -66
+quiet hour -65
+quiet hour -56
+quiet hour -55
+quiet hour -52
+quiet hour -50
+quiet hour -48
+quiet hour -45
+quiet hour -42
+quiet hour -41
+quiet hour -33
+quiet hour -31
+quiet hour -25
+quiet hour -14
+quiet hour -8
+quiet hour -1
+quiet hour 0
+quiet hour 6
+quiet hour 7
+quiet hour 8
+quiet hour 13
+quiet hour 21
+quiet hour 23
+quiet hour 29
+quiet hour 30
+quiet hour 33
+quiet hour 35
+quiet hour 38
+quiet hour 43
+quiet hour 58
+quiet hour 60
+quiet hour 66
+quiet hour 71
+quiet hour 74
+quiet hour 80
+quiet hour 82
+quiet hour 84
+quiet hour 93
+quiet hour 98
+quiet hour 110
+quiet hour 112
+quiet hour 115
+quiet hour 120
+quiet hour 121
+quiet hour 123
+religion NULL
+religion -125
+religion -106
+religion -104
+religion -94
+religion -93
+religion -81
+religion -78
+religion -77
+religion -76
+religion -71
+religion -70
+religion -69
+religion -64
+religion -62
+religion -60
+religion -56
+religion -44
+religion -42
+religion -41
+religion -38
+religion -35
+religion -32
+religion -29
+religion -28
+religion -26
+religion -24
+religion -23
+religion -9
+religion -7
+religion -3
+religion 0
+religion 2
+religion 4
+religion 5
+religion 15
+religion 17
+religion 29
+religion 31
+religion 38
+religion 44
+religion 45
+religion 49
+religion 52
+religion 54
+religion 58
+religion 67
+religion 70
+religion 73
+religion 74
+religion 76
+religion 78
+religion 82
+religion 92
+religion 93
+religion 96
+religion 97
+religion 102
+religion 103
+religion 106
+religion 107
+religion 110
+religion 115
+religion 120
+religion 123
+religion 124
+study skills NULL
+study skills -127
+study skills -126
+study skills -117
+study skills -107
+study skills -106
+study skills -100
+study skills -88
+study skills -86
+study skills -82
+study skills -81
+study skills -76
+study skills -73
+study skills -65
+study skills -52
+study skills -36
+study skills -33
+study skills -27
+study skills -26
+study skills -22
+study skills -17
+study skills -14
+study skills -13
+study skills -6
+study skills -5
+study skills -4
+study skills -3
+study skills -1
+study skills 2
+study skills 3
+study skills 18
+study skills 21
+study skills 23
+study skills 25
+study skills 28
+study skills 29
+study skills 30
+study skills 35
+study skills 39
+study skills 40
+study skills 47
+study skills 49
+study skills 50
+study skills 54
+study skills 55
+study skills 58
+study skills 62
+study skills 63
+study skills 66
+study skills 68
+study skills 72
+study skills 77
+study skills 80
+study skills 83
+study skills 92
+study skills 95
+study skills 96
+study skills 101
+study skills 106
+study skills 107
+study skills 110
+study skills 115
+study skills 119
+study skills 123
+topology NULL
+topology -122
+topology -116
+topology -106
+topology -105
+topology -102
+topology -98
+topology -96
+topology -88
+topology -86
+topology -78
+topology -74
+topology -71
+topology -60
+topology -58
+topology -57
+topology -50
+topology -44
+topology -42
+topology -41
+topology -36
+topology -32
+topology -31
+topology -25
+topology -21
+topology -5
+topology -1
+topology 7
+topology 11
+topology 13
+topology 14
+topology 18
+topology 26
+topology 30
+topology 38
+topology 41
+topology 42
+topology 47
+topology 50
+topology 52
+topology 54
+topology 55
+topology 58
+topology 59
+topology 61
+topology 63
+topology 67
+topology 69
+topology 71
+topology 80
+topology 81
+topology 83
+topology 86
+topology 87
+topology 94
+topology 105
+topology 107
+topology 119
+topology 121
+topology 127
+undecided NULL
+undecided -120
+undecided -118
+undecided -117
+undecided -116
+undecided -115
+undecided -114
+undecided -112
+undecided -105
+undecided -104
+undecided -96
+undecided -93
+undecided -90
+undecided -84
+undecided -83
+undecided -78
+undecided -69
+undecided -62
+undecided -53
+undecided -52
+undecided -51
+undecided -43
+undecided -41
+undecided -29
+undecided -28
+undecided -23
+undecided -19
+undecided -13
+undecided -10
+undecided -8
+undecided 0
+undecided 1
+undecided 7
+undecided 11
+undecided 13
+undecided 14
+undecided 27
+undecided 30
+undecided 33
+undecided 37
+undecided 45
+undecided 47
+undecided 50
+undecided 51
+undecided 56
+undecided 69
+undecided 76
+undecided 95
+undecided 97
+undecided 98
+undecided 111
+undecided 114
+undecided 119
+undecided 123
+undecided 124
+values clariffication NULL
+values clariffication -123
+values clariffication -119
+values clariffication -114
+values clariffication -109
+values clariffication -108
+values clariffication -107
+values clariffication -105
+values clariffication -100
+values clariffication -98
+values clariffication -97
+values clariffication -95
+values clariffication -92
+values clariffication -90
+values clariffication -81
+values clariffication -75
+values clariffication -70
+values clariffication -69
+values clariffication -67
+values clariffication -63
+values clariffication -62
+values clariffication -60
+values clariffication -55
+values clariffication -51
+values clariffication -50
+values clariffication -48
+values clariffication -46
+values clariffication -42
+values clariffication -40
+values clariffication -38
+values clariffication -37
+values clariffication -31
+values clariffication -28
+values clariffication -8
+values clariffication -6
+values clariffication -5
+values clariffication 4
+values clariffication 8
+values clariffication 9
+values clariffication 10
+values clariffication 12
+values clariffication 14
+values clariffication 15
+values clariffication 21
+values clariffication 23
+values clariffication 30
+values clariffication 32
+values clariffication 42
+values clariffication 50
+values clariffication 53
+values clariffication 56
+values clariffication 57
+values clariffication 62
+values clariffication 70
+values clariffication 74
+values clariffication 80
+values clariffication 85
+values clariffication 92
+values clariffication 93
+values clariffication 96
+values clariffication 97
+values clariffication 98
+values clariffication 108
+values clariffication 118
+values clariffication 120
+values clariffication 122
+values clariffication 124
+values clariffication 126
+values clariffication 127
+wind surfing NULL
+wind surfing -124
+wind surfing -121
+wind surfing -117
+wind surfing -116
+wind surfing -113
+wind surfing -111
+wind surfing -104
+wind surfing -102
+wind surfing -99
+wind surfing -98
+wind surfing -96
+wind surfing -83
+wind surfing -80
+wind surfing -78
+wind surfing -71
+wind surfing -65
+wind surfing -60
+wind surfing -57
+wind surfing -56
+wind surfing -42
+wind surfing -39
+wind surfing -38
+wind surfing -34
+wind surfing -31
+wind surfing -30
+wind surfing -21
+wind surfing -18
+wind surfing -14
+wind surfing -12
+wind surfing -8
+wind surfing -6
+wind surfing -2
+wind surfing 5
+wind surfing 11
+wind surfing 15
+wind surfing 16
+wind surfing 20
+wind surfing 21
+wind surfing 22
+wind surfing 26
+wind surfing 29
+wind surfing 33
+wind surfing 36
+wind surfing 37
+wind surfing 40
+wind surfing 41
+wind surfing 44
+wind surfing 45
+wind surfing 48
+wind surfing 52
+wind surfing 53
+wind surfing 54
+wind surfing 58
+wind surfing 59
+wind surfing 62
+wind surfing 63
+wind surfing 64
+wind surfing 66
+wind surfing 68
+wind surfing 71
+wind surfing 75
+wind surfing 78
+wind surfing 86
+wind surfing 88
+wind surfing 92
+wind surfing 96
+wind surfing 101
+wind surfing 102
+wind surfing 107
+wind surfing 108
+wind surfing 111
+wind surfing 112
+wind surfing 121
+xylophone band NULL
+xylophone band -115
+xylophone band -112
+xylophone band -109
+xylophone band -104
+xylophone band -101
+xylophone band -98
+xylophone band -96
+xylophone band -94
+xylophone band -91
+xylophone band -78
+xylophone band -75
+xylophone band -72
+xylophone band -70
+xylophone band -68
+xylophone band -59
+xylophone band -46
+xylophone band -27
+xylophone band -26
+xylophone band -23
+xylophone band -15
+xylophone band -13
+xylophone band -10
+xylophone band -6
+xylophone band -3
+xylophone band -2
+xylophone band 0
+xylophone band 3
+xylophone band 6
+xylophone band 7
+xylophone band 9
+xylophone band 11
+xylophone band 14
+xylophone band 17
+xylophone band 19
+xylophone band 22
+xylophone band 23
+xylophone band 33
+xylophone band 36
+xylophone band 38
+xylophone band 40
+xylophone band 52
+xylophone band 60
+xylophone band 62
+xylophone band 77
+xylophone band 79
+xylophone band 84
+xylophone band 85
+xylophone band 88
+xylophone band 92
+xylophone band 94
+xylophone band 107
+xylophone band 108
+xylophone band 112
+xylophone band 118
+xylophone band 122
+xylophone band 123
+xylophone band 125
+xylophone band 127
+yard duty NULL
+yard duty -127
+yard duty -115
+yard duty -114
+yard duty -109
+yard duty -103
+yard duty -102
+yard duty -100
+yard duty -98
+yard duty -93
+yard duty -91
+yard duty -88
+yard duty -86
+yard duty -85
+yard duty -82
+yard duty -76
+yard duty -62
+yard duty -61
+yard duty -57
+yard duty -53
+yard duty -51
+yard duty -50
+yard duty -49
+yard duty -48
+yard duty -46
+yard duty -45
+yard duty -44
+yard duty -33
+yard duty -28
+yard duty -27
+yard duty -21
+yard duty -19
+yard duty -17
+yard duty -15
+yard duty -1
+yard duty 8
+yard duty 9
+yard duty 10
+yard duty 15
+yard duty 18
+yard duty 22
+yard duty 25
+yard duty 28
+yard duty 30
+yard duty 34
+yard duty 42
+yard duty 48
+yard duty 53
+yard duty 55
+yard duty 57
+yard duty 60
+yard duty 64
+yard duty 65
+yard duty 78
+yard duty 86
+yard duty 90
+yard duty 102
+yard duty 105
+yard duty 110
+zync studies NULL
+zync studies -127
+zync studies -117
+zync studies -116
+zync studies -111
+zync studies -105
+zync studies -103
+zync studies -102
+zync studies -94
+zync studies -90
+zync studies -83
+zync studies -79
+zync studies -78
+zync studies -68
+zync studies -61
+zync studies -58
+zync studies -57
+zync studies -54
+zync studies -52
+zync studies -50
+zync studies -45
+zync studies -40
+zync studies -39
+zync studies -38
+zync studies -37
+zync studies -36
+zync studies -35
+zync studies -34
+zync studies -33
+zync studies -32
+zync studies -27
+zync studies -26
+zync studies -21
+zync studies -20
+zync studies -12
+zync studies 1
+zync studies 7
+zync studies 9
+zync studies 11
+zync studies 15
+zync studies 19
+zync studies 31
+zync studies 37
+zync studies 48
+zync studies 59
+zync studies 63
+zync studies 70
+zync studies 87
+zync studies 90
+zync studies 91
+zync studies 98
+zync studies 99
+zync studies 100
+zync studies 116
+zync studies 120
Added: hive/trunk/ql/src/test/results/clientpositive/tez/vector_elt.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/vector_elt.q.out?rev=1629067&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/vector_elt.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/vector_elt.q.out Thu Oct 2 20:53:34 2014
@@ -0,0 +1,121 @@
+PREHOOK: query: EXPLAIN SELECT (ctinyint % 2) + 1, cstring1, cint, elt((ctinyint % 2) + 1, cstring1, cint)
+FROM alltypesorc
+WHERE ctinyint > 0 LIMIT 10
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN SELECT (ctinyint % 2) + 1, cstring1, cint, elt((ctinyint % 2) + 1, cstring1, cint)
+FROM alltypesorc
+WHERE ctinyint > 0 LIMIT 10
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-0
+ Fetch Operator
+ limit: 10
+ Processor Tree:
+ TableScan
+ alias: alltypesorc
+ Filter Operator
+ predicate: (ctinyint > 0) (type: boolean)
+ Select Operator
+ expressions: ((ctinyint % 2) + 1) (type: int), cstring1 (type: string), cint (type: int), elt(((ctinyint % 2) + 1), cstring1, cint) (type: string)
+ outputColumnNames: _col0, _col1, _col2, _col3
+ Limit
+ Number of rows: 10
+ ListSink
+
+PREHOOK: query: SELECT (ctinyint % 2) + 1, cstring1, cint, elt((ctinyint % 2) + 1, cstring1, cint)
+FROM alltypesorc
+WHERE ctinyint > 0 LIMIT 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT (ctinyint % 2) + 1, cstring1, cint, elt((ctinyint % 2) + 1, cstring1, cint)
+FROM alltypesorc
+WHERE ctinyint > 0 LIMIT 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+2 cvLH6Eat2yFsyy7p 528534767 528534767
+2 cvLH6Eat2yFsyy7p 528534767 528534767
+2 cvLH6Eat2yFsyy7p 528534767 528534767
+2 cvLH6Eat2yFsyy7p 528534767 528534767
+2 cvLH6Eat2yFsyy7p 528534767 528534767
+1 cvLH6Eat2yFsyy7p 528534767 cvLH6Eat2yFsyy7p
+2 cvLH6Eat2yFsyy7p 528534767 528534767
+1 cvLH6Eat2yFsyy7p 528534767 cvLH6Eat2yFsyy7p
+2 cvLH6Eat2yFsyy7p 528534767 528534767
+1 cvLH6Eat2yFsyy7p 528534767 cvLH6Eat2yFsyy7p
+PREHOOK: query: EXPLAIN
+SELECT elt(2, 'abc', 'defg'),
+ elt(3, 'aa', 'bb', 'cc', 'dd', 'ee', 'ff', 'gg'),
+ elt('1', 'abc', 'defg'),
+ elt(2, 'aa', CAST('2' AS TINYINT)),
+ elt(2, 'aa', CAST('12345' AS SMALLINT)),
+ elt(2, 'aa', CAST('123456789012' AS BIGINT)),
+ elt(2, 'aa', CAST(1.25 AS FLOAT)),
+ elt(2, 'aa', CAST(16.0 AS DOUBLE)),
+ elt(0, 'abc', 'defg'),
+ elt(3, 'abc', 'defg')
+FROM alltypesorc LIMIT 1
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+SELECT elt(2, 'abc', 'defg'),
+ elt(3, 'aa', 'bb', 'cc', 'dd', 'ee', 'ff', 'gg'),
+ elt('1', 'abc', 'defg'),
+ elt(2, 'aa', CAST('2' AS TINYINT)),
+ elt(2, 'aa', CAST('12345' AS SMALLINT)),
+ elt(2, 'aa', CAST('123456789012' AS BIGINT)),
+ elt(2, 'aa', CAST(1.25 AS FLOAT)),
+ elt(2, 'aa', CAST(16.0 AS DOUBLE)),
+ elt(0, 'abc', 'defg'),
+ elt(3, 'abc', 'defg')
+FROM alltypesorc LIMIT 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: alltypesorc
+ Select Operator
+ expressions: 'defg' (type: string), 'cc' (type: string), 'abc' (type: string), '2' (type: string), '12345' (type: string), '123456789012' (type: string), '1.25' (type: string), '16.0' (type: string), null (type: void), null (type: void)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
+ Limit
+ Number of rows: 1
+ ListSink
+
+PREHOOK: query: SELECT elt(2, 'abc', 'defg'),
+ elt(3, 'aa', 'bb', 'cc', 'dd', 'ee', 'ff', 'gg'),
+ elt('1', 'abc', 'defg'),
+ elt(2, 'aa', CAST('2' AS TINYINT)),
+ elt(2, 'aa', CAST('12345' AS SMALLINT)),
+ elt(2, 'aa', CAST('123456789012' AS BIGINT)),
+ elt(2, 'aa', CAST(1.25 AS FLOAT)),
+ elt(2, 'aa', CAST(16.0 AS DOUBLE)),
+ elt(0, 'abc', 'defg'),
+ elt(3, 'abc', 'defg')
+FROM alltypesorc LIMIT 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT elt(2, 'abc', 'defg'),
+ elt(3, 'aa', 'bb', 'cc', 'dd', 'ee', 'ff', 'gg'),
+ elt('1', 'abc', 'defg'),
+ elt(2, 'aa', CAST('2' AS TINYINT)),
+ elt(2, 'aa', CAST('12345' AS SMALLINT)),
+ elt(2, 'aa', CAST('123456789012' AS BIGINT)),
+ elt(2, 'aa', CAST(1.25 AS FLOAT)),
+ elt(2, 'aa', CAST(16.0 AS DOUBLE)),
+ elt(0, 'abc', 'defg'),
+ elt(3, 'abc', 'defg')
+FROM alltypesorc LIMIT 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+defg cc abc 2 12345 123456789012 1.25 16.0 NULL NULL