You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by br...@apache.org on 2014/08/19 21:36:59 UTC
svn commit: r1618953 - in /hive/branches/spark: itests/src/test/resources/
ql/src/test/results/clientpositive/spark/
Author: brock
Date: Tue Aug 19 19:36:59 2014
New Revision: 1618953
URL: http://svn.apache.org/r1618953
Log:
HIVE-7728 - Enable q-tests for TABLESAMPLE feature [Spark Branch] (Chengxiang Li via Brock)
Added:
hive/branches/spark/ql/src/test/results/clientpositive/spark/sample1.q.out
hive/branches/spark/ql/src/test/results/clientpositive/spark/sample2.q.out
hive/branches/spark/ql/src/test/results/clientpositive/spark/sample3.q.out
hive/branches/spark/ql/src/test/results/clientpositive/spark/sample4.q.out
hive/branches/spark/ql/src/test/results/clientpositive/spark/sample5.q.out
hive/branches/spark/ql/src/test/results/clientpositive/spark/sample6.q.out
hive/branches/spark/ql/src/test/results/clientpositive/spark/sample7.q.out
hive/branches/spark/ql/src/test/results/clientpositive/spark/sample9.q.out
Modified:
hive/branches/spark/itests/src/test/resources/testconfiguration.properties
Modified: hive/branches/spark/itests/src/test/resources/testconfiguration.properties
URL: http://svn.apache.org/viewvc/hive/branches/spark/itests/src/test/resources/testconfiguration.properties?rev=1618953&r1=1618952&r2=1618953&view=diff
==============================================================================
--- hive/branches/spark/itests/src/test/resources/testconfiguration.properties (original)
+++ hive/branches/spark/itests/src/test/resources/testconfiguration.properties Tue Aug 19 19:36:59 2014
@@ -318,6 +318,14 @@ spark.query.files=spark_test.q \
ptf_rcfile.q \
ptf_register_tblfn.q \
ptf_seqfile.q \
+ sample1.q \
+ sample2.q \
+ sample3.q \
+ sample4.q \
+ sample5.q \
+ sample6.q \
+ sample7.q \
+ sample9.q \
timestamp_1.q \
timestamp_2.q \
timestamp_3.q \
Added: hive/branches/spark/ql/src/test/results/clientpositive/spark/sample1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/sample1.q.out?rev=1618953&view=auto
==============================================================================
Files hive/branches/spark/ql/src/test/results/clientpositive/spark/sample1.q.out (added) and hive/branches/spark/ql/src/test/results/clientpositive/spark/sample1.q.out Tue Aug 19 19:36:59 2014 differ
Added: hive/branches/spark/ql/src/test/results/clientpositive/spark/sample2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/sample2.q.out?rev=1618953&view=auto
==============================================================================
Files hive/branches/spark/ql/src/test/results/clientpositive/spark/sample2.q.out (added) and hive/branches/spark/ql/src/test/results/clientpositive/spark/sample2.q.out Tue Aug 19 19:36:59 2014 differ
Added: hive/branches/spark/ql/src/test/results/clientpositive/spark/sample3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/sample3.q.out?rev=1618953&view=auto
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/spark/sample3.q.out (added)
+++ hive/branches/spark/ql/src/test/results/clientpositive/spark/sample3.q.out Tue Aug 19 19:36:59 2014
@@ -0,0 +1,229 @@
+PREHOOK: query: -- no input pruning, sample filter
+EXPLAIN
+SELECT s.key
+FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 5 on key) s
+PREHOOK: type: QUERY
+POSTHOOK: query: -- no input pruning, sample filter
+EXPLAIN
+SELECT s.key
+FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 5 on key) s
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ TableScan
+ alias: s
+ Statistics: Num rows: 2900 Data size: 11603 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: (((hash(key) & 2147483647) % 5) = 0) (type: boolean)
+ Statistics: Num rows: 1450 Data size: 5801 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: key (type: int)
+ outputColumnNames: _col0
+ Statistics: Num rows: 1450 Data size: 5801 Basic stats: COMPLETE Column stats: NONE
+ ListSink
+
+PREHOOK: query: SELECT s.key
+FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 5 on key) s SORT BY key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@srcbucket
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT s.key
+FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 5 on key) s SORT BY key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcbucket
+#### A masked pattern was here ####
+0
+0
+0
+0
+0
+5
+5
+5
+5
+10
+10
+15
+15
+15
+15
+20
+20
+20
+30
+30
+35
+35
+35
+35
+35
+35
+40
+40
+50
+60
+65
+65
+65
+70
+70
+70
+70
+75
+80
+80
+85
+85
+90
+90
+90
+95
+95
+100
+100
+100
+100
+105
+105
+105
+110
+120
+120
+120
+125
+125
+125
+135
+135
+135
+140
+145
+150
+155
+160
+160
+165
+165
+165
+170
+170
+175
+175
+175
+175
+180
+185
+190
+195
+195
+200
+200
+205
+205
+205
+215
+230
+230
+230
+230
+230
+235
+235
+240
+245
+245
+255
+255
+260
+260
+260
+265
+265
+265
+275
+275
+275
+280
+280
+285
+285
+295
+295
+300
+300
+305
+305
+310
+310
+310
+310
+315
+325
+325
+330
+335
+335
+335
+340
+345
+355
+355
+360
+360
+365
+375
+375
+375
+375
+375
+375
+385
+385
+390
+390
+390
+395
+395
+395
+395
+400
+405
+410
+415
+425
+430
+430
+430
+430
+435
+435
+440
+440
+450
+450
+455
+455
+455
+460
+470
+470
+475
+475
+480
+480
+480
+480
+480
+485
+485
+485
+490
+490
+495
+495
Added: hive/branches/spark/ql/src/test/results/clientpositive/spark/sample4.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/sample4.q.out?rev=1618953&view=auto
==============================================================================
Files hive/branches/spark/ql/src/test/results/clientpositive/spark/sample4.q.out (added) and hive/branches/spark/ql/src/test/results/clientpositive/spark/sample4.q.out Tue Aug 19 19:36:59 2014 differ
Added: hive/branches/spark/ql/src/test/results/clientpositive/spark/sample5.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/sample5.q.out?rev=1618953&view=auto
==============================================================================
Files hive/branches/spark/ql/src/test/results/clientpositive/spark/sample5.q.out (added) and hive/branches/spark/ql/src/test/results/clientpositive/spark/sample5.q.out Tue Aug 19 19:36:59 2014 differ
Added: hive/branches/spark/ql/src/test/results/clientpositive/spark/sample6.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/sample6.q.out?rev=1618953&view=auto
==============================================================================
Files hive/branches/spark/ql/src/test/results/clientpositive/spark/sample6.q.out (added) and hive/branches/spark/ql/src/test/results/clientpositive/spark/sample6.q.out Tue Aug 19 19:36:59 2014 differ
Added: hive/branches/spark/ql/src/test/results/clientpositive/spark/sample7.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/sample7.q.out?rev=1618953&view=auto
==============================================================================
Files hive/branches/spark/ql/src/test/results/clientpositive/spark/sample7.q.out (added) and hive/branches/spark/ql/src/test/results/clientpositive/spark/sample7.q.out Tue Aug 19 19:36:59 2014 differ
Added: hive/branches/spark/ql/src/test/results/clientpositive/spark/sample9.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/spark/sample9.q.out?rev=1618953&view=auto
==============================================================================
Files hive/branches/spark/ql/src/test/results/clientpositive/spark/sample9.q.out (added) and hive/branches/spark/ql/src/test/results/clientpositive/spark/sample9.q.out Tue Aug 19 19:36:59 2014 differ