hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kgyrtk...@apache.org
Subject [07/11] hive git commit: HIVE-16146: If possible find a better way to filter the TestBeeLineDriver output(Peter Vary via Zoltan Haindrich, reviewed by Vihang Karajgaonkar)
Date Tue, 18 Apr 2017 07:02:54 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/2509e2fa/ql/src/test/results/clientpositive/beeline/smb_mapjoin_11.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_11.q.out b/ql/src/test/results/clientpositive/beeline/smb_mapjoin_11.q.out
index 19c07a0..b53e670 100644
--- a/ql/src/test/results/clientpositive/beeline/smb_mapjoin_11.q.out
+++ b/ql/src/test/results/clientpositive/beeline/smb_mapjoin_11.q.out
@@ -1,2563 +1,2161 @@
->>>  set hive.mapred.mode=nonstrict;
-No rows affected 
->>>  set hive.optimize.bucketmapjoin = true;
-No rows affected 
->>>  set hive.optimize.bucketmapjoin.sortedmerge = true;
-No rows affected 
->>>  set hive.input.format = org.apache.hadoop.hive.ql.io.BucketizedHiveInputFormat;
-No rows affected 
->>>  
->>>  set hive.cbo.enable=false;
-No rows affected 
->>>  
->>>  set hive.exec.reducers.max = 1;
-No rows affected 
->>>  set hive.merge.mapfiles=false;
-No rows affected 
->>>  set hive.merge.mapredfiles=false; 
-No rows affected 
->>>  
->>>  -- This test verifies that the output of a sort merge join on 2 partitions (one on each side of the join) is bucketed
->>>  
->>>  -- Create two bucketed and sorted tables
->>>  CREATE TABLE test_table1 (key INT, value STRING) PARTITIONED BY (ds STRING) CLUSTERED BY (key) SORTED BY (key) INTO 16 BUCKETS;
-INFO  : Compiling commandqueryId=(!!{queryId}!!): CREATE TABLE test_table1 (key INT, value STRING) PARTITIONED BY (ds STRING) CLUSTERED BY (key) SORTED BY (key) INTO 16 BUCKETS
-INFO  : Semantic Analysis Completed
-INFO  : Returning Hive schema: Schema(fieldSchemas:null, properties:null)
-INFO  : Completed compiling commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! seconds
-INFO  : Executing commandqueryId=(!!{queryId}!!): CREATE TABLE test_table1 (key INT, value STRING) PARTITIONED BY (ds STRING) CLUSTERED BY (key) SORTED BY (key) INTO 16 BUCKETS
-INFO  : PREHOOK: query: CREATE TABLE test_table1 (key INT, value STRING) PARTITIONED BY (ds STRING) CLUSTERED BY (key) SORTED BY (key) INTO 16 BUCKETS
-INFO  : PREHOOK: type: CREATETABLE
-INFO  : PREHOOK: Output: database:smb_mapjoin_11
-INFO  : PREHOOK: Output: smb_mapjoin_11@test_table1
-INFO  : Starting task [Stage-0:DDL] in serial mode
-INFO  : POSTHOOK: query: CREATE TABLE test_table1 (key INT, value STRING) PARTITIONED BY (ds STRING) CLUSTERED BY (key) SORTED BY (key) INTO 16 BUCKETS
-INFO  : POSTHOOK: type: CREATETABLE
-INFO  : POSTHOOK: Output: database:smb_mapjoin_11
-INFO  : POSTHOOK: Output: smb_mapjoin_11@test_table1
-INFO  : Completed executing commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! seconds
-INFO  : OK
-DEBUG : Shutting down query CREATE TABLE test_table1 (key INT, value STRING) PARTITIONED BY (ds STRING) CLUSTERED BY (key) SORTED BY (key) INTO 16 BUCKETS
-No rows affected 
->>>  CREATE TABLE test_table2 (key INT, value STRING) PARTITIONED BY (ds STRING) CLUSTERED BY (key) SORTED BY (key) INTO 16 BUCKETS;
-INFO  : Compiling commandqueryId=(!!{queryId}!!): CREATE TABLE test_table2 (key INT, value STRING) PARTITIONED BY (ds STRING) CLUSTERED BY (key) SORTED BY (key) INTO 16 BUCKETS
-INFO  : Semantic Analysis Completed
-INFO  : Returning Hive schema: Schema(fieldSchemas:null, properties:null)
-INFO  : Completed compiling commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! seconds
-INFO  : Executing commandqueryId=(!!{queryId}!!): CREATE TABLE test_table2 (key INT, value STRING) PARTITIONED BY (ds STRING) CLUSTERED BY (key) SORTED BY (key) INTO 16 BUCKETS
-INFO  : PREHOOK: query: CREATE TABLE test_table2 (key INT, value STRING) PARTITIONED BY (ds STRING) CLUSTERED BY (key) SORTED BY (key) INTO 16 BUCKETS
-INFO  : PREHOOK: type: CREATETABLE
-INFO  : PREHOOK: Output: database:smb_mapjoin_11
-INFO  : PREHOOK: Output: smb_mapjoin_11@test_table2
-INFO  : Starting task [Stage-0:DDL] in serial mode
-INFO  : POSTHOOK: query: CREATE TABLE test_table2 (key INT, value STRING) PARTITIONED BY (ds STRING) CLUSTERED BY (key) SORTED BY (key) INTO 16 BUCKETS
-INFO  : POSTHOOK: type: CREATETABLE
-INFO  : POSTHOOK: Output: database:smb_mapjoin_11
-INFO  : POSTHOOK: Output: smb_mapjoin_11@test_table2
-INFO  : Completed executing commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! seconds
-INFO  : OK
-DEBUG : Shutting down query CREATE TABLE test_table2 (key INT, value STRING) PARTITIONED BY (ds STRING) CLUSTERED BY (key) SORTED BY (key) INTO 16 BUCKETS
-No rows affected 
->>>  
->>>  FROM default.src
-INSERT OVERWRITE TABLE test_table1 PARTITION (ds = '1') SELECT *
-INSERT OVERWRITE TABLE test_table2 PARTITION (ds = '1') SELECT *;
-INFO  : Compiling commandqueryId=(!!{queryId}!!): FROM default.src
-INSERT OVERWRITE TABLE test_table1 PARTITION (ds = '1') SELECT *
-INSERT OVERWRITE TABLE test_table2 PARTITION (ds = '1') SELECT *
-INFO  : Semantic Analysis Completed
-INFO  : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:_col0, type:int, comment:null), FieldSchema(name:_col1, type:string, comment:null)], properties:null)
-INFO  : Completed compiling commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! seconds
-INFO  : Executing commandqueryId=(!!{queryId}!!): FROM default.src
-INSERT OVERWRITE TABLE test_table1 PARTITION (ds = '1') SELECT *
-INSERT OVERWRITE TABLE test_table2 PARTITION (ds = '1') SELECT *
-INFO  : PREHOOK: query: FROM default.src
+PREHOOK: query: CREATE TABLE test_table1 (key INT, value STRING) PARTITIONED BY (ds STRING) CLUSTERED BY (key) SORTED BY (key) INTO 16 BUCKETS
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@test_table1
+POSTHOOK: query: CREATE TABLE test_table1 (key INT, value STRING) PARTITIONED BY (ds STRING) CLUSTERED BY (key) SORTED BY (key) INTO 16 BUCKETS
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@test_table1
+PREHOOK: query: CREATE TABLE test_table2 (key INT, value STRING) PARTITIONED BY (ds STRING) CLUSTERED BY (key) SORTED BY (key) INTO 16 BUCKETS
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@test_table2
+POSTHOOK: query: CREATE TABLE test_table2 (key INT, value STRING) PARTITIONED BY (ds STRING) CLUSTERED BY (key) SORTED BY (key) INTO 16 BUCKETS
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@test_table2
+PREHOOK: query: FROM src
 INSERT OVERWRITE TABLE test_table1 PARTITION (ds = '1') SELECT *
 INSERT OVERWRITE TABLE test_table2 PARTITION (ds = '1') SELECT *
-INFO  : PREHOOK: type: QUERY
-INFO  : PREHOOK: Input: default@src
-INFO  : PREHOOK: Output: smb_mapjoin_11@test_table1@ds=1
-INFO  : PREHOOK: Output: smb_mapjoin_11@test_table2@ds=1
-WARN  : Hive-on-MR is deprecated in Hive 2 and may not be available in the future versions. Consider using a different execution engine (i.e. spark, tez) or using Hive 1.X releases.
-INFO  : Query ID = !!{queryId}!!
-INFO  : Total jobs = 2
-INFO  : Launching Job 1 out of 2
-INFO  : Starting task [Stage-2:MAPRED] in serial mode
-INFO  : Number of reduce tasks determined at compile time: 1
-INFO  : In order to change the average load for a reducer (in bytes):
-INFO  :   set hive.exec.reducers.bytes.per.reducer=<number>
-INFO  : In order to limit the maximum number of reducers:
-INFO  :   set hive.exec.reducers.max=<number>
-INFO  : In order to set a constant number of reducers:
-INFO  :   set mapreduce.job.reduces=<number>
-DEBUG : Configuring job !!{jobId}}!! with file:/!!ELIDED!! as the submit dir
-DEBUG : adding the following namenodes' delegation tokens:[file:///]
-DEBUG : Creating splits at file:/!!ELIDED!!
-INFO  : number of splits:1
-INFO  : Submitting tokens for job: !!{jobId}}!!
-INFO  : The url to track the job: http://localhost:8080/
-INFO  : Job running in-process (local Hadoop)
-INFO  : Ended Job = !!{jobId}!!
-INFO  : Starting task [Stage-0:MOVE] in serial mode
-INFO  : Loading data to table smb_mapjoin_11.test_table1 partition (ds=1) from file:/!!ELIDED!!
-INFO  : Launching Job 2 out of 2
-INFO  : Starting task [Stage-4:MAPRED] in serial mode
-INFO  : Number of reduce tasks determined at compile time: 1
-INFO  : In order to change the average load for a reducer (in bytes):
-INFO  :   set hive.exec.reducers.bytes.per.reducer=<number>
-INFO  : In order to limit the maximum number of reducers:
-INFO  :   set hive.exec.reducers.max=<number>
-INFO  : In order to set a constant number of reducers:
-INFO  :   set mapreduce.job.reduces=<number>
-DEBUG : Configuring job !!{jobId}}!! with file:/!!ELIDED!! as the submit dir
-DEBUG : adding the following namenodes' delegation tokens:[file:///]
-DEBUG : Creating splits at file:/!!ELIDED!!
-INFO  : number of splits:1
-INFO  : Submitting tokens for job: !!{jobId}}!!
-INFO  : The url to track the job: http://localhost:8080/
-INFO  : Job running in-process (local Hadoop)
-INFO  : Ended Job = !!{jobId}!!
-INFO  : Starting task [Stage-3:STATS] in serial mode
-INFO  : Starting task [Stage-1:MOVE] in serial mode
-INFO  : Loading data to table smb_mapjoin_11.test_table2 partition (ds=1) from file:/!!ELIDED!!
-INFO  : Starting task [Stage-5:STATS] in serial mode
-INFO  : POSTHOOK: query: FROM default.src
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@test_table1@ds=1
+PREHOOK: Output: default@test_table2@ds=1
+POSTHOOK: query: FROM src
 INSERT OVERWRITE TABLE test_table1 PARTITION (ds = '1') SELECT *
 INSERT OVERWRITE TABLE test_table2 PARTITION (ds = '1') SELECT *
-INFO  : POSTHOOK: type: QUERY
-INFO  : POSTHOOK: Input: default@src
-INFO  : POSTHOOK: Output: smb_mapjoin_11@test_table1@ds=1
-INFO  : POSTHOOK: Output: smb_mapjoin_11@test_table2@ds=1
-INFO  : POSTHOOK: Lineage: test_table1 PARTITION(ds=1).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-INFO  : POSTHOOK: Lineage: test_table1 PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-INFO  : POSTHOOK: Lineage: test_table2 PARTITION(ds=1).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-INFO  : POSTHOOK: Lineage: test_table2 PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-INFO  : MapReduce Jobs Launched: 
-INFO  : Stage-Stage-2:  HDFS Read: 0 HDFS Write: 0 SUCCESS
-INFO  : Stage-Stage-4:  HDFS Read: 0 HDFS Write: 0 SUCCESS
-INFO  : Total MapReduce CPU Time Spent: 0 msec
-INFO  : Completed executing commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! seconds
-INFO  : OK
-DEBUG : Shutting down query FROM default.src
-INSERT OVERWRITE TABLE test_table1 PARTITION (ds = '1') SELECT *
-INSERT OVERWRITE TABLE test_table2 PARTITION (ds = '1') SELECT *
-No rows affected 
->>>  
->>>  
->>>  
->>>  
->>>  -- Create a bucketed table
->>>  CREATE TABLE test_table3 (key INT, value STRING) PARTITIONED BY (ds STRING) CLUSTERED BY (key) INTO 16 BUCKETS;
-INFO  : Compiling commandqueryId=(!!{queryId}!!): CREATE TABLE test_table3 (key INT, value STRING) PARTITIONED BY (ds STRING) CLUSTERED BY (key) INTO 16 BUCKETS
-INFO  : Semantic Analysis Completed
-INFO  : Returning Hive schema: Schema(fieldSchemas:null, properties:null)
-INFO  : Completed compiling commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! seconds
-INFO  : Executing commandqueryId=(!!{queryId}!!): CREATE TABLE test_table3 (key INT, value STRING) PARTITIONED BY (ds STRING) CLUSTERED BY (key) INTO 16 BUCKETS
-INFO  : PREHOOK: query: CREATE TABLE test_table3 (key INT, value STRING) PARTITIONED BY (ds STRING) CLUSTERED BY (key) INTO 16 BUCKETS
-INFO  : PREHOOK: type: CREATETABLE
-INFO  : PREHOOK: Output: database:smb_mapjoin_11
-INFO  : PREHOOK: Output: smb_mapjoin_11@test_table3
-INFO  : Starting task [Stage-0:DDL] in serial mode
-INFO  : POSTHOOK: query: CREATE TABLE test_table3 (key INT, value STRING) PARTITIONED BY (ds STRING) CLUSTERED BY (key) INTO 16 BUCKETS
-INFO  : POSTHOOK: type: CREATETABLE
-INFO  : POSTHOOK: Output: database:smb_mapjoin_11
-INFO  : POSTHOOK: Output: smb_mapjoin_11@test_table3
-INFO  : Completed executing commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! seconds
-INFO  : OK
-DEBUG : Shutting down query CREATE TABLE test_table3 (key INT, value STRING) PARTITIONED BY (ds STRING) CLUSTERED BY (key) INTO 16 BUCKETS
-No rows affected 
->>>  
->>>  -- Insert data into the bucketed table by joining the two bucketed and sorted tables, bucketing is not enforced
->>>  EXPLAIN EXTENDED
-INSERT OVERWRITE TABLE test_table3 PARTITION (ds = '1') SELECT /*+ MAPJOIN(b) */ a.key, b.value FROM test_table1 a JOIN test_table2 b ON a.key = b.key AND a.ds = '1' AND b.ds = '1';
-INFO  : Compiling commandqueryId=(!!{queryId}!!): EXPLAIN EXTENDED
-INSERT OVERWRITE TABLE test_table3 PARTITION (ds = '1') SELECT /*+ MAPJOIN(b) */ a.key, b.value FROM test_table1 a JOIN test_table2 b ON a.key = b.key AND a.ds = '1' AND b.ds = '1'
-INFO  : Semantic Analysis Completed
-INFO  : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:Explain, type:string, comment:null)], properties:null)
-INFO  : Completed compiling commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! seconds
-INFO  : Executing commandqueryId=(!!{queryId}!!): EXPLAIN EXTENDED
-INSERT OVERWRITE TABLE test_table3 PARTITION (ds = '1') SELECT /*+ MAPJOIN(b) */ a.key, b.value FROM test_table1 a JOIN test_table2 b ON a.key = b.key AND a.ds = '1' AND b.ds = '1'
-INFO  : PREHOOK: query: EXPLAIN EXTENDED
-INSERT OVERWRITE TABLE test_table3 PARTITION (ds = '1') SELECT /*+ MAPJOIN(b) */ a.key, b.value FROM test_table1 a JOIN test_table2 b ON a.key = b.key AND a.ds = '1' AND b.ds = '1'
-INFO  : PREHOOK: type: QUERY
-INFO  : Starting task [Stage-4:EXPLAIN] in serial mode
-INFO  : POSTHOOK: query: EXPLAIN EXTENDED
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@test_table1@ds=1
+POSTHOOK: Output: default@test_table2@ds=1
+POSTHOOK: Lineage: test_table1 PARTITION(ds=1).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: test_table1 PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: test_table2 PARTITION(ds=1).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: test_table2 PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: CREATE TABLE test_table3 (key INT, value STRING) PARTITIONED BY (ds STRING) CLUSTERED BY (key) INTO 16 BUCKETS
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@test_table3
+POSTHOOK: query: CREATE TABLE test_table3 (key INT, value STRING) PARTITIONED BY (ds STRING) CLUSTERED BY (key) INTO 16 BUCKETS
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@test_table3
+PREHOOK: query: EXPLAIN EXTENDED
 INSERT OVERWRITE TABLE test_table3 PARTITION (ds = '1') SELECT /*+ MAPJOIN(b) */ a.key, b.value FROM test_table1 a JOIN test_table2 b ON a.key = b.key AND a.ds = '1' AND b.ds = '1'
-INFO  : POSTHOOK: type: QUERY
-INFO  : Completed executing commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! seconds
-INFO  : OK
-DEBUG : Shutting down query EXPLAIN EXTENDED
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN EXTENDED
 INSERT OVERWRITE TABLE test_table3 PARTITION (ds = '1') SELECT /*+ MAPJOIN(b) */ a.key, b.value FROM test_table1 a JOIN test_table2 b ON a.key = b.key AND a.ds = '1' AND b.ds = '1'
-'Explain'
-'STAGE DEPENDENCIES:'
-'  Stage-1 is a root stage'
-'  Stage-0 depends on stages: Stage-1'
-'  Stage-2 depends on stages: Stage-0'
-''
-'STAGE PLANS:'
-'  Stage: Stage-1'
-'    Map Reduce'
-'      Map Operator Tree:'
-'          TableScan'
-'            alias: a'
-'            Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE'
-'            GatherStats: false'
-'            Filter Operator'
-'              isSamplingPred: false'
-'              predicate: key is not null (type: boolean)'
-'              Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE'
-'              Sorted Merge Bucket Map Join Operator'
-'                condition map:'
-'                     Inner Join 0 to 1'
-'                keys:'
-'                  0 key (type: int)'
-'                  1 key (type: int)'
-'                outputColumnNames: _col0, _col7'
-'                Position of Big Table: 0'
-'                BucketMapJoin: true'
-'                Select Operator'
-'                  expressions: _col0 (type: int), _col7 (type: string)'
-'                  outputColumnNames: _col0, _col1'
-'                  Reduce Output Operator'
-'                    null sort order: '
-'                    sort order: '
-'                    Map-reduce partition columns: _col0 (type: int)'
-'                    tag: -1'
-'                    value expressions: _col0 (type: int), _col1 (type: string)'
-'                    auto parallelism: false'
-'      Path -> Alias:'
-'        file:/!!ELIDED!! [a]'
-'      Path -> Partition:'
-'        file:/!!ELIDED!! '
-'          Partition'
-'            base file name: ds=1'
-'            input format: org.apache.hadoop.mapred.TextInputFormat'
-'            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-'            partition values:'
-'              ds 1'
-'            properties:'
-'              COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}'
-'              bucket_count 16'
-'              bucket_field_name key'
-'              column.name.delimiter ,'
-'              columns key,value'
-'              columns.comments '
-'              columns.types int:string'
-'              file.inputformat org.apache.hadoop.mapred.TextInputFormat'
-'              file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-'              location file:/!!ELIDED!!
-'              name smb_mapjoin_11.test_table1'
-'              numFiles 16'
-'              numRows 500'
-'              partition_columns ds'
-'              partition_columns.types string'
-'              rawDataSize 5312'
-'              serialization.ddl struct test_table1 { i32 key, string value}'
-'              serialization.format 1'
-'              serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-'              totalSize 5812'
-'              transient_lastDdlTime !!UNIXTIME!!'
-'            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:'
-'                SORTBUCKETCOLSPREFIX TRUE'
-'                bucket_count 16'
-'                bucket_field_name key'
-'                column.name.delimiter ,'
-'                columns key,value'
-'                columns.comments '
-'                columns.types int:string'
-'                file.inputformat org.apache.hadoop.mapred.TextInputFormat'
-'                file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-'                location file:/!!ELIDED!!
-'                name smb_mapjoin_11.test_table1'
-'                partition_columns ds'
-'                partition_columns.types string'
-'                serialization.ddl struct test_table1 { i32 key, string value}'
-'                serialization.format 1'
-'                serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-'                transient_lastDdlTime !!UNIXTIME!!'
-'              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-'              name: smb_mapjoin_11.test_table1'
-'            name: smb_mapjoin_11.test_table1'
-'      Truncated Path -> Alias:'
-'        /smb_mapjoin_11.db/test_table1/ds=1 [a]'
-'      Needs Tagging: false'
-'      Reduce Operator Tree:'
-'        Select Operator'
-'          expressions: VALUE._col0 (type: int), VALUE._col1 (type: string)'
-'          outputColumnNames: _col0, _col1'
-'          File Output Operator'
-'            compressed: false'
-'            GlobalTableId: 1'
-'            directory: file:/!!ELIDED!!
-'            NumFilesPerFileSink: 16'
-'            Static Partition Specification: ds=1/'
-'            Stats Publishing Key Prefix: file:/!!ELIDED!!
-'            table:'
-'                input format: org.apache.hadoop.mapred.TextInputFormat'
-'                output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-'                properties:'
-'                  bucket_count 16'
-'                  bucket_field_name key'
-'                  column.name.delimiter ,'
-'                  columns key,value'
-'                  columns.comments '
-'                  columns.types int:string'
-'                  file.inputformat org.apache.hadoop.mapred.TextInputFormat'
-'                  file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-'                  location file:/!!ELIDED!!
-'                  name smb_mapjoin_11.test_table3'
-'                  partition_columns ds'
-'                  partition_columns.types string'
-'                  serialization.ddl struct test_table3 { i32 key, string value}'
-'                  serialization.format 1'
-'                  serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-'                  transient_lastDdlTime !!UNIXTIME!!'
-'                serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-'                name: smb_mapjoin_11.test_table3'
-'            TotalFiles: 16'
-'            GatherStats: true'
-'            MultiFileSpray: true'
-''
-'  Stage: Stage-0'
-'    Move Operator'
-'      tables:'
-'          partition:'
-'            ds 1'
-'          replace: true'
-'          source: file:/!!ELIDED!!
-'          table:'
-'              input format: org.apache.hadoop.mapred.TextInputFormat'
-'              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-'              properties:'
-'                bucket_count 16'
-'                bucket_field_name key'
-'                column.name.delimiter ,'
-'                columns key,value'
-'                columns.comments '
-'                columns.types int:string'
-'                file.inputformat org.apache.hadoop.mapred.TextInputFormat'
-'                file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-'                location file:/!!ELIDED!!
-'                name smb_mapjoin_11.test_table3'
-'                partition_columns ds'
-'                partition_columns.types string'
-'                serialization.ddl struct test_table3 { i32 key, string value}'
-'                serialization.format 1'
-'                serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-'                transient_lastDdlTime !!UNIXTIME!!'
-'              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-'              name: smb_mapjoin_11.test_table3'
-''
-'  Stage: Stage-2'
-'    Stats-Aggr Operator'
-'      Stats Aggregation Key Prefix: file:/!!ELIDED!!
-''
-167 rows selected 
->>>  
->>>  INSERT OVERWRITE TABLE test_table3 PARTITION (ds = '1') SELECT /*+ MAPJOIN(b) */ a.key, b.value FROM test_table1 a JOIN test_table2 b ON a.key = b.key AND a.ds = '1' AND b.ds = '1';
-INFO  : Compiling commandqueryId=(!!{queryId}!!): INSERT OVERWRITE TABLE test_table3 PARTITION (ds = '1') SELECT /*+ MAPJOIN(b) */ a.key, b.value FROM test_table1 a JOIN test_table2 b ON a.key = b.key AND a.ds = '1' AND b.ds = '1'
-INFO  : Semantic Analysis Completed
-INFO  : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:a.key, type:int, comment:null), FieldSchema(name:b.value, type:string, comment:null)], properties:null)
-INFO  : Completed compiling commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! seconds
-INFO  : Executing commandqueryId=(!!{queryId}!!): INSERT OVERWRITE TABLE test_table3 PARTITION (ds = '1') SELECT /*+ MAPJOIN(b) */ a.key, b.value FROM test_table1 a JOIN test_table2 b ON a.key = b.key AND a.ds = '1' AND b.ds = '1'
-INFO  : PREHOOK: query: INSERT OVERWRITE TABLE test_table3 PARTITION (ds = '1') SELECT /*+ MAPJOIN(b) */ a.key, b.value FROM test_table1 a JOIN test_table2 b ON a.key = b.key AND a.ds = '1' AND b.ds = '1'
-INFO  : PREHOOK: type: QUERY
-INFO  : PREHOOK: Input: smb_mapjoin_11@test_table1
-INFO  : PREHOOK: Input: smb_mapjoin_11@test_table1@ds=1
-INFO  : PREHOOK: Input: smb_mapjoin_11@test_table2
-INFO  : PREHOOK: Input: smb_mapjoin_11@test_table2@ds=1
-INFO  : PREHOOK: Output: smb_mapjoin_11@test_table3@ds=1
-WARN  : Hive-on-MR is deprecated in Hive 2 and may not be available in the future versions. Consider using a different execution engine (i.e. spark, tez) or using Hive 1.X releases.
-INFO  : Query ID = !!{queryId}!!
-INFO  : Total jobs = 1
-INFO  : Launching Job 1 out of 1
-INFO  : Starting task [Stage-1:MAPRED] in serial mode
-INFO  : Number of reduce tasks determined at compile time: 1
-INFO  : In order to change the average load for a reducer (in bytes):
-INFO  :   set hive.exec.reducers.bytes.per.reducer=<number>
-INFO  : In order to limit the maximum number of reducers:
-INFO  :   set hive.exec.reducers.max=<number>
-INFO  : In order to set a constant number of reducers:
-INFO  :   set mapreduce.job.reduces=<number>
-DEBUG : Configuring job !!{jobId}}!! with file:/!!ELIDED!! as the submit dir
-DEBUG : adding the following namenodes' delegation tokens:[file:///]
-DEBUG : Creating splits at file:/!!ELIDED!!
-INFO  : number of splits:16
-INFO  : Submitting tokens for job: !!{jobId}}!!
-INFO  : The url to track the job: http://localhost:8080/
-INFO  : Job running in-process (local Hadoop)
-INFO  : Ended Job = !!{jobId}!!
-INFO  : Starting task [Stage-0:MOVE] in serial mode
-INFO  : Loading data to table smb_mapjoin_11.test_table3 partition (ds=1) from file:/!!ELIDED!!
-INFO  : Starting task [Stage-2:STATS] in serial mode
-INFO  : POSTHOOK: query: INSERT OVERWRITE TABLE test_table3 PARTITION (ds = '1') SELECT /*+ MAPJOIN(b) */ a.key, b.value FROM test_table1 a JOIN test_table2 b ON a.key = b.key AND a.ds = '1' AND b.ds = '1'
-INFO  : POSTHOOK: type: QUERY
-INFO  : POSTHOOK: Input: smb_mapjoin_11@test_table1
-INFO  : POSTHOOK: Input: smb_mapjoin_11@test_table1@ds=1
-INFO  : POSTHOOK: Input: smb_mapjoin_11@test_table2
-INFO  : POSTHOOK: Input: smb_mapjoin_11@test_table2@ds=1
-INFO  : POSTHOOK: Output: smb_mapjoin_11@test_table3@ds=1
-INFO  : POSTHOOK: Lineage: test_table3 PARTITION(ds=1).key SIMPLE [(test_table1)a.FieldSchema(name:key, type:int, comment:null), ]
-INFO  : POSTHOOK: Lineage: test_table3 PARTITION(ds=1).value SIMPLE [(test_table2)b.FieldSchema(name:value, type:string, comment:null), ]
-INFO  : MapReduce Jobs Launched: 
-INFO  : Stage-Stage-1:  HDFS Read: 0 HDFS Write: 0 SUCCESS
-INFO  : Total MapReduce CPU Time Spent: 0 msec
-INFO  : Completed executing commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! seconds
-INFO  : OK
-DEBUG : Shutting down query INSERT OVERWRITE TABLE test_table3 PARTITION (ds = '1') SELECT /*+ MAPJOIN(b) */ a.key, b.value FROM test_table1 a JOIN test_table2 b ON a.key = b.key AND a.ds = '1' AND b.ds = '1'
-No rows affected 
->>>  
->>>  SELECT * FROM test_table1 ORDER BY key;
-INFO  : Compiling commandqueryId=(!!{queryId}!!): SELECT * FROM test_table1 ORDER BY key
-INFO  : Semantic Analysis Completed
-INFO  : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:test_table1.key, type:int, comment:null), FieldSchema(name:test_table1.value, type:string, comment:null), FieldSchema(name:test_table1.ds, type:string, comment:null)], properties:null)
-INFO  : Completed compiling commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! seconds
-INFO  : Executing commandqueryId=(!!{queryId}!!): SELECT * FROM test_table1 ORDER BY key
-INFO  : PREHOOK: query: SELECT * FROM test_table1 ORDER BY key
-INFO  : PREHOOK: type: QUERY
-INFO  : PREHOOK: Input: smb_mapjoin_11@test_table1
-INFO  : PREHOOK: Input: smb_mapjoin_11@test_table1@ds=1
-INFO  : PREHOOK: Output: file:/!!ELIDED!!
-WARN  : Hive-on-MR is deprecated in Hive 2 and may not be available in the future versions. Consider using a different execution engine (i.e. spark, tez) or using Hive 1.X releases.
-INFO  : Query ID = !!{queryId}!!
-INFO  : Total jobs = 1
-INFO  : Launching Job 1 out of 1
-INFO  : Starting task [Stage-1:MAPRED] in serial mode
-INFO  : Number of reduce tasks determined at compile time: 1
-INFO  : In order to change the average load for a reducer (in bytes):
-INFO  :   set hive.exec.reducers.bytes.per.reducer=<number>
-INFO  : In order to limit the maximum number of reducers:
-INFO  :   set hive.exec.reducers.max=<number>
-INFO  : In order to set a constant number of reducers:
-INFO  :   set mapreduce.job.reduces=<number>
-DEBUG : Configuring job !!{jobId}}!! with file:/!!ELIDED!! as the submit dir
-DEBUG : adding the following namenodes' delegation tokens:[file:///]
-DEBUG : Creating splits at file:/!!ELIDED!!
-INFO  : number of splits:16
-INFO  : Submitting tokens for job: !!{jobId}}!!
-INFO  : The url to track the job: http://localhost:8080/
-INFO  : Job running in-process (local Hadoop)
-INFO  : Ended Job = !!{jobId}!!
-INFO  : POSTHOOK: query: SELECT * FROM test_table1 ORDER BY key
-INFO  : POSTHOOK: type: QUERY
-INFO  : POSTHOOK: Input: smb_mapjoin_11@test_table1
-INFO  : POSTHOOK: Input: smb_mapjoin_11@test_table1@ds=1
-INFO  : POSTHOOK: Output: file:/!!ELIDED!!
-INFO  : MapReduce Jobs Launched: 
-INFO  : Stage-Stage-1:  HDFS Read: 0 HDFS Write: 0 SUCCESS
-INFO  : Total MapReduce CPU Time Spent: 0 msec
-INFO  : Completed executing commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! seconds
-INFO  : OK
-DEBUG : Shutting down query SELECT * FROM test_table1 ORDER BY key
-'test_table1.key','test_table1.value','test_table1.ds'
-'0','val_0','1'
-'0','val_0','1'
-'0','val_0','1'
-'2','val_2','1'
-'4','val_4','1'
-'5','val_5','1'
-'5','val_5','1'
-'5','val_5','1'
-'8','val_8','1'
-'9','val_9','1'
-'10','val_10','1'
-'11','val_11','1'
-'12','val_12','1'
-'12','val_12','1'
-'15','val_15','1'
-'15','val_15','1'
-'17','val_17','1'
-'18','val_18','1'
-'18','val_18','1'
-'19','val_19','1'
-'20','val_20','1'
-'24','val_24','1'
-'24','val_24','1'
-'26','val_26','1'
-'26','val_26','1'
-'27','val_27','1'
-'28','val_28','1'
-'30','val_30','1'
-'33','val_33','1'
-'34','val_34','1'
-'35','val_35','1'
-'35','val_35','1'
-'35','val_35','1'
-'37','val_37','1'
-'37','val_37','1'
-'41','val_41','1'
-'42','val_42','1'
-'42','val_42','1'
-'43','val_43','1'
-'44','val_44','1'
-'47','val_47','1'
-'51','val_51','1'
-'51','val_51','1'
-'53','val_53','1'
-'54','val_54','1'
-'57','val_57','1'
-'58','val_58','1'
-'58','val_58','1'
-'64','val_64','1'
-'65','val_65','1'
-'66','val_66','1'
-'67','val_67','1'
-'67','val_67','1'
-'69','val_69','1'
-'70','val_70','1'
-'70','val_70','1'
-'70','val_70','1'
-'72','val_72','1'
-'72','val_72','1'
-'74','val_74','1'
-'76','val_76','1'
-'76','val_76','1'
-'77','val_77','1'
-'78','val_78','1'
-'80','val_80','1'
-'82','val_82','1'
-'83','val_83','1'
-'83','val_83','1'
-'84','val_84','1'
-'84','val_84','1'
-'85','val_85','1'
-'86','val_86','1'
-'87','val_87','1'
-'90','val_90','1'
-'90','val_90','1'
-'90','val_90','1'
-'92','val_92','1'
-'95','val_95','1'
-'95','val_95','1'
-'96','val_96','1'
-'97','val_97','1'
-'97','val_97','1'
-'98','val_98','1'
-'98','val_98','1'
-'100','val_100','1'
-'100','val_100','1'
-'103','val_103','1'
-'103','val_103','1'
-'104','val_104','1'
-'104','val_104','1'
-'105','val_105','1'
-'111','val_111','1'
-'113','val_113','1'
-'113','val_113','1'
-'114','val_114','1'
-'116','val_116','1'
-'118','val_118','1'
-'118','val_118','1'
-'119','val_119','1'
-'119','val_119','1'
-'119','val_119','1'
-'120','val_120','1'
-'120','val_120','1'
-'125','val_125','1'
-'125','val_125','1'
-'126','val_126','1'
-'128','val_128','1'
-'128','val_128','1'
-'128','val_128','1'
-'129','val_129','1'
-'129','val_129','1'
-'131','val_131','1'
-'133','val_133','1'
-'134','val_134','1'
-'134','val_134','1'
-'136','val_136','1'
-'137','val_137','1'
-'137','val_137','1'
-'138','val_138','1'
-'138','val_138','1'
-'138','val_138','1'
-'138','val_138','1'
-'143','val_143','1'
-'145','val_145','1'
-'146','val_146','1'
-'146','val_146','1'
-'149','val_149','1'
-'149','val_149','1'
-'150','val_150','1'
-'152','val_152','1'
-'152','val_152','1'
-'153','val_153','1'
-'155','val_155','1'
-'156','val_156','1'
-'157','val_157','1'
-'158','val_158','1'
-'160','val_160','1'
-'162','val_162','1'
-'163','val_163','1'
-'164','val_164','1'
-'164','val_164','1'
-'165','val_165','1'
-'165','val_165','1'
-'166','val_166','1'
-'167','val_167','1'
-'167','val_167','1'
-'167','val_167','1'
-'168','val_168','1'
-'169','val_169','1'
-'169','val_169','1'
-'169','val_169','1'
-'169','val_169','1'
-'170','val_170','1'
-'172','val_172','1'
-'172','val_172','1'
-'174','val_174','1'
-'174','val_174','1'
-'175','val_175','1'
-'175','val_175','1'
-'176','val_176','1'
-'176','val_176','1'
-'177','val_177','1'
-'178','val_178','1'
-'179','val_179','1'
-'179','val_179','1'
-'180','val_180','1'
-'181','val_181','1'
-'183','val_183','1'
-'186','val_186','1'
-'187','val_187','1'
-'187','val_187','1'
-'187','val_187','1'
-'189','val_189','1'
-'190','val_190','1'
-'191','val_191','1'
-'191','val_191','1'
-'192','val_192','1'
-'193','val_193','1'
-'193','val_193','1'
-'193','val_193','1'
-'194','val_194','1'
-'195','val_195','1'
-'195','val_195','1'
-'196','val_196','1'
-'197','val_197','1'
-'197','val_197','1'
-'199','val_199','1'
-'199','val_199','1'
-'199','val_199','1'
-'200','val_200','1'
-'200','val_200','1'
-'201','val_201','1'
-'202','val_202','1'
-'203','val_203','1'
-'203','val_203','1'
-'205','val_205','1'
-'205','val_205','1'
-'207','val_207','1'
-'207','val_207','1'
-'208','val_208','1'
-'208','val_208','1'
-'208','val_208','1'
-'209','val_209','1'
-'209','val_209','1'
-'213','val_213','1'
-'213','val_213','1'
-'214','val_214','1'
-'216','val_216','1'
-'216','val_216','1'
-'217','val_217','1'
-'217','val_217','1'
-'218','val_218','1'
-'219','val_219','1'
-'219','val_219','1'
-'221','val_221','1'
-'221','val_221','1'
-'222','val_222','1'
-'223','val_223','1'
-'223','val_223','1'
-'224','val_224','1'
-'224','val_224','1'
-'226','val_226','1'
-'228','val_228','1'
-'229','val_229','1'
-'229','val_229','1'
-'230','val_230','1'
-'230','val_230','1'
-'230','val_230','1'
-'230','val_230','1'
-'230','val_230','1'
-'233','val_233','1'
-'233','val_233','1'
-'235','val_235','1'
-'237','val_237','1'
-'237','val_237','1'
-'238','val_238','1'
-'238','val_238','1'
-'239','val_239','1'
-'239','val_239','1'
-'241','val_241','1'
-'242','val_242','1'
-'242','val_242','1'
-'244','val_244','1'
-'247','val_247','1'
-'248','val_248','1'
-'249','val_249','1'
-'252','val_252','1'
-'255','val_255','1'
-'255','val_255','1'
-'256','val_256','1'
-'256','val_256','1'
-'257','val_257','1'
-'258','val_258','1'
-'260','val_260','1'
-'262','val_262','1'
-'263','val_263','1'
-'265','val_265','1'
-'265','val_265','1'
-'266','val_266','1'
-'272','val_272','1'
-'272','val_272','1'
-'273','val_273','1'
-'273','val_273','1'
-'273','val_273','1'
-'274','val_274','1'
-'275','val_275','1'
-'277','val_277','1'
-'277','val_277','1'
-'277','val_277','1'
-'277','val_277','1'
-'278','val_278','1'
-'278','val_278','1'
-'280','val_280','1'
-'280','val_280','1'
-'281','val_281','1'
-'281','val_281','1'
-'282','val_282','1'
-'282','val_282','1'
-'283','val_283','1'
-'284','val_284','1'
-'285','val_285','1'
-'286','val_286','1'
-'287','val_287','1'
-'288','val_288','1'
-'288','val_288','1'
-'289','val_289','1'
-'291','val_291','1'
-'292','val_292','1'
-'296','val_296','1'
-'298','val_298','1'
-'298','val_298','1'
-'298','val_298','1'
-'302','val_302','1'
-'305','val_305','1'
-'306','val_306','1'
-'307','val_307','1'
-'307','val_307','1'
-'308','val_308','1'
-'309','val_309','1'
-'309','val_309','1'
-'310','val_310','1'
-'311','val_311','1'
-'311','val_311','1'
-'311','val_311','1'
-'315','val_315','1'
-'316','val_316','1'
-'316','val_316','1'
-'316','val_316','1'
-'317','val_317','1'
-'317','val_317','1'
-'318','val_318','1'
-'318','val_318','1'
-'318','val_318','1'
-'321','val_321','1'
-'321','val_321','1'
-'322','val_322','1'
-'322','val_322','1'
-'323','val_323','1'
-'325','val_325','1'
-'325','val_325','1'
-'327','val_327','1'
-'327','val_327','1'
-'327','val_327','1'
-'331','val_331','1'
-'331','val_331','1'
-'332','val_332','1'
-'333','val_333','1'
-'333','val_333','1'
-'335','val_335','1'
-'336','val_336','1'
-'338','val_338','1'
-'339','val_339','1'
-'341','val_341','1'
-'342','val_342','1'
-'342','val_342','1'
-'344','val_344','1'
-'344','val_344','1'
-'345','val_345','1'
-'348','val_348','1'
-'348','val_348','1'
-'348','val_348','1'
-'348','val_348','1'
-'348','val_348','1'
-'351','val_351','1'
-'353','val_353','1'
-'353','val_353','1'
-'356','val_356','1'
-'360','val_360','1'
-'362','val_362','1'
-'364','val_364','1'
-'365','val_365','1'
-'366','val_366','1'
-'367','val_367','1'
-'367','val_367','1'
-'368','val_368','1'
-'369','val_369','1'
-'369','val_369','1'
-'369','val_369','1'
-'373','val_373','1'
-'374','val_374','1'
-'375','val_375','1'
-'377','val_377','1'
-'378','val_378','1'
-'379','val_379','1'
-'382','val_382','1'
-'382','val_382','1'
-'384','val_384','1'
-'384','val_384','1'
-'384','val_384','1'
-'386','val_386','1'
-'389','val_389','1'
-'392','val_392','1'
-'393','val_393','1'
-'394','val_394','1'
-'395','val_395','1'
-'395','val_395','1'
-'396','val_396','1'
-'396','val_396','1'
-'396','val_396','1'
-'397','val_397','1'
-'397','val_397','1'
-'399','val_399','1'
-'399','val_399','1'
-'400','val_400','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'402','val_402','1'
-'403','val_403','1'
-'403','val_403','1'
-'403','val_403','1'
-'404','val_404','1'
-'404','val_404','1'
-'406','val_406','1'
-'406','val_406','1'
-'406','val_406','1'
-'406','val_406','1'
-'407','val_407','1'
-'409','val_409','1'
-'409','val_409','1'
-'409','val_409','1'
-'411','val_411','1'
-'413','val_413','1'
-'413','val_413','1'
-'414','val_414','1'
-'414','val_414','1'
-'417','val_417','1'
-'417','val_417','1'
-'417','val_417','1'
-'418','val_418','1'
-'419','val_419','1'
-'421','val_421','1'
-'424','val_424','1'
-'424','val_424','1'
-'427','val_427','1'
-'429','val_429','1'
-'429','val_429','1'
-'430','val_430','1'
-'430','val_430','1'
-'430','val_430','1'
-'431','val_431','1'
-'431','val_431','1'
-'431','val_431','1'
-'432','val_432','1'
-'435','val_435','1'
-'436','val_436','1'
-'437','val_437','1'
-'438','val_438','1'
-'438','val_438','1'
-'438','val_438','1'
-'439','val_439','1'
-'439','val_439','1'
-'443','val_443','1'
-'444','val_444','1'
-'446','val_446','1'
-'448','val_448','1'
-'449','val_449','1'
-'452','val_452','1'
-'453','val_453','1'
-'454','val_454','1'
-'454','val_454','1'
-'454','val_454','1'
-'455','val_455','1'
-'457','val_457','1'
-'458','val_458','1'
-'458','val_458','1'
-'459','val_459','1'
-'459','val_459','1'
-'460','val_460','1'
-'462','val_462','1'
-'462','val_462','1'
-'463','val_463','1'
-'463','val_463','1'
-'466','val_466','1'
-'466','val_466','1'
-'466','val_466','1'
-'467','val_467','1'
-'468','val_468','1'
-'468','val_468','1'
-'468','val_468','1'
-'468','val_468','1'
-'469','val_469','1'
-'469','val_469','1'
-'469','val_469','1'
-'469','val_469','1'
-'469','val_469','1'
-'470','val_470','1'
-'472','val_472','1'
-'475','val_475','1'
-'477','val_477','1'
-'478','val_478','1'
-'478','val_478','1'
-'479','val_479','1'
-'480','val_480','1'
-'480','val_480','1'
-'480','val_480','1'
-'481','val_481','1'
-'482','val_482','1'
-'483','val_483','1'
-'484','val_484','1'
-'485','val_485','1'
-'487','val_487','1'
-'489','val_489','1'
-'489','val_489','1'
-'489','val_489','1'
-'489','val_489','1'
-'490','val_490','1'
-'491','val_491','1'
-'492','val_492','1'
-'492','val_492','1'
-'493','val_493','1'
-'494','val_494','1'
-'495','val_495','1'
-'496','val_496','1'
-'497','val_497','1'
-'498','val_498','1'
-'498','val_498','1'
-'498','val_498','1'
-500 rows selected 
->>>  SELECT * FROM test_table3 ORDER BY key;
-INFO  : Compiling commandqueryId=(!!{queryId}!!): SELECT * FROM test_table3 ORDER BY key
-INFO  : Semantic Analysis Completed
-INFO  : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:test_table3.key, type:int, comment:null), FieldSchema(name:test_table3.value, type:string, comment:null), FieldSchema(name:test_table3.ds, type:string, comment:null)], properties:null)
-INFO  : Completed compiling commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! seconds
-INFO  : Executing commandqueryId=(!!{queryId}!!): SELECT * FROM test_table3 ORDER BY key
-INFO  : PREHOOK: query: SELECT * FROM test_table3 ORDER BY key
-INFO  : PREHOOK: type: QUERY
-INFO  : PREHOOK: Input: smb_mapjoin_11@test_table3
-INFO  : PREHOOK: Input: smb_mapjoin_11@test_table3@ds=1
-INFO  : PREHOOK: Output: file:/!!ELIDED!!
-WARN  : Hive-on-MR is deprecated in Hive 2 and may not be available in the future versions. Consider using a different execution engine (i.e. spark, tez) or using Hive 1.X releases.
-INFO  : Query ID = !!{queryId}!!
-INFO  : Total jobs = 1
-INFO  : Launching Job 1 out of 1
-INFO  : Starting task [Stage-1:MAPRED] in serial mode
-INFO  : Number of reduce tasks determined at compile time: 1
-INFO  : In order to change the average load for a reducer (in bytes):
-INFO  :   set hive.exec.reducers.bytes.per.reducer=<number>
-INFO  : In order to limit the maximum number of reducers:
-INFO  :   set hive.exec.reducers.max=<number>
-INFO  : In order to set a constant number of reducers:
-INFO  :   set mapreduce.job.reduces=<number>
-DEBUG : Configuring job !!{jobId}}!! with file:/!!ELIDED!! as the submit dir
-DEBUG : adding the following namenodes' delegation tokens:[file:///]
-DEBUG : Creating splits at file:/!!ELIDED!!
-INFO  : number of splits:16
-INFO  : Submitting tokens for job: !!{jobId}}!!
-INFO  : The url to track the job: http://localhost:8080/
-INFO  : Job running in-process (local Hadoop)
-INFO  : Ended Job = !!{jobId}!!
-INFO  : POSTHOOK: query: SELECT * FROM test_table3 ORDER BY key
-INFO  : POSTHOOK: type: QUERY
-INFO  : POSTHOOK: Input: smb_mapjoin_11@test_table3
-INFO  : POSTHOOK: Input: smb_mapjoin_11@test_table3@ds=1
-INFO  : POSTHOOK: Output: file:/!!ELIDED!!
-INFO  : MapReduce Jobs Launched: 
-INFO  : Stage-Stage-1:  HDFS Read: 0 HDFS Write: 0 SUCCESS
-INFO  : Total MapReduce CPU Time Spent: 0 msec
-INFO  : Completed executing commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! seconds
-INFO  : OK
-DEBUG : Shutting down query SELECT * FROM test_table3 ORDER BY key
-'test_table3.key','test_table3.value','test_table3.ds'
-'0','val_0','1'
-'0','val_0','1'
-'0','val_0','1'
-'0','val_0','1'
-'0','val_0','1'
-'0','val_0','1'
-'0','val_0','1'
-'0','val_0','1'
-'0','val_0','1'
-'2','val_2','1'
-'4','val_4','1'
-'5','val_5','1'
-'5','val_5','1'
-'5','val_5','1'
-'5','val_5','1'
-'5','val_5','1'
-'5','val_5','1'
-'5','val_5','1'
-'5','val_5','1'
-'5','val_5','1'
-'8','val_8','1'
-'9','val_9','1'
-'10','val_10','1'
-'11','val_11','1'
-'12','val_12','1'
-'12','val_12','1'
-'12','val_12','1'
-'12','val_12','1'
-'15','val_15','1'
-'15','val_15','1'
-'15','val_15','1'
-'15','val_15','1'
-'17','val_17','1'
-'18','val_18','1'
-'18','val_18','1'
-'18','val_18','1'
-'18','val_18','1'
-'19','val_19','1'
-'20','val_20','1'
-'24','val_24','1'
-'24','val_24','1'
-'24','val_24','1'
-'24','val_24','1'
-'26','val_26','1'
-'26','val_26','1'
-'26','val_26','1'
-'26','val_26','1'
-'27','val_27','1'
-'28','val_28','1'
-'30','val_30','1'
-'33','val_33','1'
-'34','val_34','1'
-'35','val_35','1'
-'35','val_35','1'
-'35','val_35','1'
-'35','val_35','1'
-'35','val_35','1'
-'35','val_35','1'
-'35','val_35','1'
-'35','val_35','1'
-'35','val_35','1'
-'37','val_37','1'
-'37','val_37','1'
-'37','val_37','1'
-'37','val_37','1'
-'41','val_41','1'
-'42','val_42','1'
-'42','val_42','1'
-'42','val_42','1'
-'42','val_42','1'
-'43','val_43','1'
-'44','val_44','1'
-'47','val_47','1'
-'51','val_51','1'
-'51','val_51','1'
-'51','val_51','1'
-'51','val_51','1'
-'53','val_53','1'
-'54','val_54','1'
-'57','val_57','1'
-'58','val_58','1'
-'58','val_58','1'
-'58','val_58','1'
-'58','val_58','1'
-'64','val_64','1'
-'65','val_65','1'
-'66','val_66','1'
-'67','val_67','1'
-'67','val_67','1'
-'67','val_67','1'
-'67','val_67','1'
-'69','val_69','1'
-'70','val_70','1'
-'70','val_70','1'
-'70','val_70','1'
-'70','val_70','1'
-'70','val_70','1'
-'70','val_70','1'
-'70','val_70','1'
-'70','val_70','1'
-'70','val_70','1'
-'72','val_72','1'
-'72','val_72','1'
-'72','val_72','1'
-'72','val_72','1'
-'74','val_74','1'
-'76','val_76','1'
-'76','val_76','1'
-'76','val_76','1'
-'76','val_76','1'
-'77','val_77','1'
-'78','val_78','1'
-'80','val_80','1'
-'82','val_82','1'
-'83','val_83','1'
-'83','val_83','1'
-'83','val_83','1'
-'83','val_83','1'
-'84','val_84','1'
-'84','val_84','1'
-'84','val_84','1'
-'84','val_84','1'
-'85','val_85','1'
-'86','val_86','1'
-'87','val_87','1'
-'90','val_90','1'
-'90','val_90','1'
-'90','val_90','1'
-'90','val_90','1'
-'90','val_90','1'
-'90','val_90','1'
-'90','val_90','1'
-'90','val_90','1'
-'90','val_90','1'
-'92','val_92','1'
-'95','val_95','1'
-'95','val_95','1'
-'95','val_95','1'
-'95','val_95','1'
-'96','val_96','1'
-'97','val_97','1'
-'97','val_97','1'
-'97','val_97','1'
-'97','val_97','1'
-'98','val_98','1'
-'98','val_98','1'
-'98','val_98','1'
-'98','val_98','1'
-'100','val_100','1'
-'100','val_100','1'
-'100','val_100','1'
-'100','val_100','1'
-'103','val_103','1'
-'103','val_103','1'
-'103','val_103','1'
-'103','val_103','1'
-'104','val_104','1'
-'104','val_104','1'
-'104','val_104','1'
-'104','val_104','1'
-'105','val_105','1'
-'111','val_111','1'
-'113','val_113','1'
-'113','val_113','1'
-'113','val_113','1'
-'113','val_113','1'
-'114','val_114','1'
-'116','val_116','1'
-'118','val_118','1'
-'118','val_118','1'
-'118','val_118','1'
-'118','val_118','1'
-'119','val_119','1'
-'119','val_119','1'
-'119','val_119','1'
-'119','val_119','1'
-'119','val_119','1'
-'119','val_119','1'
-'119','val_119','1'
-'119','val_119','1'
-'119','val_119','1'
-'120','val_120','1'
-'120','val_120','1'
-'120','val_120','1'
-'120','val_120','1'
-'125','val_125','1'
-'125','val_125','1'
-'125','val_125','1'
-'125','val_125','1'
-'126','val_126','1'
-'128','val_128','1'
-'128','val_128','1'
-'128','val_128','1'
-'128','val_128','1'
-'128','val_128','1'
-'128','val_128','1'
-'128','val_128','1'
-'128','val_128','1'
-'128','val_128','1'
-'129','val_129','1'
-'129','val_129','1'
-'129','val_129','1'
-'129','val_129','1'
-'131','val_131','1'
-'133','val_133','1'
-'134','val_134','1'
-'134','val_134','1'
-'134','val_134','1'
-'134','val_134','1'
-'136','val_136','1'
-'137','val_137','1'
-'137','val_137','1'
-'137','val_137','1'
-'137','val_137','1'
-'138','val_138','1'
-'138','val_138','1'
-'138','val_138','1'
-'138','val_138','1'
-'138','val_138','1'
-'138','val_138','1'
-'138','val_138','1'
-'138','val_138','1'
-'138','val_138','1'
-'138','val_138','1'
-'138','val_138','1'
-'138','val_138','1'
-'138','val_138','1'
-'138','val_138','1'
-'138','val_138','1'
-'138','val_138','1'
-'143','val_143','1'
-'145','val_145','1'
-'146','val_146','1'
-'146','val_146','1'
-'146','val_146','1'
-'146','val_146','1'
-'149','val_149','1'
-'149','val_149','1'
-'149','val_149','1'
-'149','val_149','1'
-'150','val_150','1'
-'152','val_152','1'
-'152','val_152','1'
-'152','val_152','1'
-'152','val_152','1'
-'153','val_153','1'
-'155','val_155','1'
-'156','val_156','1'
-'157','val_157','1'
-'158','val_158','1'
-'160','val_160','1'
-'162','val_162','1'
-'163','val_163','1'
-'164','val_164','1'
-'164','val_164','1'
-'164','val_164','1'
-'164','val_164','1'
-'165','val_165','1'
-'165','val_165','1'
-'165','val_165','1'
-'165','val_165','1'
-'166','val_166','1'
-'167','val_167','1'
-'167','val_167','1'
-'167','val_167','1'
-'167','val_167','1'
-'167','val_167','1'
-'167','val_167','1'
-'167','val_167','1'
-'167','val_167','1'
-'167','val_167','1'
-'168','val_168','1'
-'169','val_169','1'
-'169','val_169','1'
-'169','val_169','1'
-'169','val_169','1'
-'169','val_169','1'
-'169','val_169','1'
-'169','val_169','1'
-'169','val_169','1'
-'169','val_169','1'
-'169','val_169','1'
-'169','val_169','1'
-'169','val_169','1'
-'169','val_169','1'
-'169','val_169','1'
-'169','val_169','1'
-'169','val_169','1'
-'170','val_170','1'
-'172','val_172','1'
-'172','val_172','1'
-'172','val_172','1'
-'172','val_172','1'
-'174','val_174','1'
-'174','val_174','1'
-'174','val_174','1'
-'174','val_174','1'
-'175','val_175','1'
-'175','val_175','1'
-'175','val_175','1'
-'175','val_175','1'
-'176','val_176','1'
-'176','val_176','1'
-'176','val_176','1'
-'176','val_176','1'
-'177','val_177','1'
-'178','val_178','1'
-'179','val_179','1'
-'179','val_179','1'
-'179','val_179','1'
-'179','val_179','1'
-'180','val_180','1'
-'181','val_181','1'
-'183','val_183','1'
-'186','val_186','1'
-'187','val_187','1'
-'187','val_187','1'
-'187','val_187','1'
-'187','val_187','1'
-'187','val_187','1'
-'187','val_187','1'
-'187','val_187','1'
-'187','val_187','1'
-'187','val_187','1'
-'189','val_189','1'
-'190','val_190','1'
-'191','val_191','1'
-'191','val_191','1'
-'191','val_191','1'
-'191','val_191','1'
-'192','val_192','1'
-'193','val_193','1'
-'193','val_193','1'
-'193','val_193','1'
-'193','val_193','1'
-'193','val_193','1'
-'193','val_193','1'
-'193','val_193','1'
-'193','val_193','1'
-'193','val_193','1'
-'194','val_194','1'
-'195','val_195','1'
-'195','val_195','1'
-'195','val_195','1'
-'195','val_195','1'
-'196','val_196','1'
-'197','val_197','1'
-'197','val_197','1'
-'197','val_197','1'
-'197','val_197','1'
-'199','val_199','1'
-'199','val_199','1'
-'199','val_199','1'
-'199','val_199','1'
-'199','val_199','1'
-'199','val_199','1'
-'199','val_199','1'
-'199','val_199','1'
-'199','val_199','1'
-'200','val_200','1'
-'200','val_200','1'
-'200','val_200','1'
-'200','val_200','1'
-'201','val_201','1'
-'202','val_202','1'
-'203','val_203','1'
-'203','val_203','1'
-'203','val_203','1'
-'203','val_203','1'
-'205','val_205','1'
-'205','val_205','1'
-'205','val_205','1'
-'205','val_205','1'
-'207','val_207','1'
-'207','val_207','1'
-'207','val_207','1'
-'207','val_207','1'
-'208','val_208','1'
-'208','val_208','1'
-'208','val_208','1'
-'208','val_208','1'
-'208','val_208','1'
-'208','val_208','1'
-'208','val_208','1'
-'208','val_208','1'
-'208','val_208','1'
-'209','val_209','1'
-'209','val_209','1'
-'209','val_209','1'
-'209','val_209','1'
-'213','val_213','1'
-'213','val_213','1'
-'213','val_213','1'
-'213','val_213','1'
-'214','val_214','1'
-'216','val_216','1'
-'216','val_216','1'
-'216','val_216','1'
-'216','val_216','1'
-'217','val_217','1'
-'217','val_217','1'
-'217','val_217','1'
-'217','val_217','1'
-'218','val_218','1'
-'219','val_219','1'
-'219','val_219','1'
-'219','val_219','1'
-'219','val_219','1'
-'221','val_221','1'
-'221','val_221','1'
-'221','val_221','1'
-'221','val_221','1'
-'222','val_222','1'
-'223','val_223','1'
-'223','val_223','1'
-'223','val_223','1'
-'223','val_223','1'
-'224','val_224','1'
-'224','val_224','1'
-'224','val_224','1'
-'224','val_224','1'
-'226','val_226','1'
-'228','val_228','1'
-'229','val_229','1'
-'229','val_229','1'
-'229','val_229','1'
-'229','val_229','1'
-'230','val_230','1'
-'230','val_230','1'
-'230','val_230','1'
-'230','val_230','1'
-'230','val_230','1'
-'230','val_230','1'
-'230','val_230','1'
-'230','val_230','1'
-'230','val_230','1'
-'230','val_230','1'
-'230','val_230','1'
-'230','val_230','1'
-'230','val_230','1'
-'230','val_230','1'
-'230','val_230','1'
-'230','val_230','1'
-'230','val_230','1'
-'230','val_230','1'
-'230','val_230','1'
-'230','val_230','1'
-'230','val_230','1'
-'230','val_230','1'
-'230','val_230','1'
-'230','val_230','1'
-'230','val_230','1'
-'233','val_233','1'
-'233','val_233','1'
-'233','val_233','1'
-'233','val_233','1'
-'235','val_235','1'
-'237','val_237','1'
-'237','val_237','1'
-'237','val_237','1'
-'237','val_237','1'
-'238','val_238','1'
-'238','val_238','1'
-'238','val_238','1'
-'238','val_238','1'
-'239','val_239','1'
-'239','val_239','1'
-'239','val_239','1'
-'239','val_239','1'
-'241','val_241','1'
-'242','val_242','1'
-'242','val_242','1'
-'242','val_242','1'
-'242','val_242','1'
-'244','val_244','1'
-'247','val_247','1'
-'248','val_248','1'
-'249','val_249','1'
-'252','val_252','1'
-'255','val_255','1'
-'255','val_255','1'
-'255','val_255','1'
-'255','val_255','1'
-'256','val_256','1'
-'256','val_256','1'
-'256','val_256','1'
-'256','val_256','1'
-'257','val_257','1'
-'258','val_258','1'
-'260','val_260','1'
-'262','val_262','1'
-'263','val_263','1'
-'265','val_265','1'
-'265','val_265','1'
-'265','val_265','1'
-'265','val_265','1'
-'266','val_266','1'
-'272','val_272','1'
-'272','val_272','1'
-'272','val_272','1'
-'272','val_272','1'
-'273','val_273','1'
-'273','val_273','1'
-'273','val_273','1'
-'273','val_273','1'
-'273','val_273','1'
-'273','val_273','1'
-'273','val_273','1'
-'273','val_273','1'
-'273','val_273','1'
-'274','val_274','1'
-'275','val_275','1'
-'277','val_277','1'
-'277','val_277','1'
-'277','val_277','1'
-'277','val_277','1'
-'277','val_277','1'
-'277','val_277','1'
-'277','val_277','1'
-'277','val_277','1'
-'277','val_277','1'
-'277','val_277','1'
-'277','val_277','1'
-'277','val_277','1'
-'277','val_277','1'
-'277','val_277','1'
-'277','val_277','1'
-'277','val_277','1'
-'278','val_278','1'
-'278','val_278','1'
-'278','val_278','1'
-'278','val_278','1'
-'280','val_280','1'
-'280','val_280','1'
-'280','val_280','1'
-'280','val_280','1'
-'281','val_281','1'
-'281','val_281','1'
-'281','val_281','1'
-'281','val_281','1'
-'282','val_282','1'
-'282','val_282','1'
-'282','val_282','1'
-'282','val_282','1'
-'283','val_283','1'
-'284','val_284','1'
-'285','val_285','1'
-'286','val_286','1'
-'287','val_287','1'
-'288','val_288','1'
-'288','val_288','1'
-'288','val_288','1'
-'288','val_288','1'
-'289','val_289','1'
-'291','val_291','1'
-'292','val_292','1'
-'296','val_296','1'
-'298','val_298','1'
-'298','val_298','1'
-'298','val_298','1'
-'298','val_298','1'
-'298','val_298','1'
-'298','val_298','1'
-'298','val_298','1'
-'298','val_298','1'
-'298','val_298','1'
-'302','val_302','1'
-'305','val_305','1'
-'306','val_306','1'
-'307','val_307','1'
-'307','val_307','1'
-'307','val_307','1'
-'307','val_307','1'
-'308','val_308','1'
-'309','val_309','1'
-'309','val_309','1'
-'309','val_309','1'
-'309','val_309','1'
-'310','val_310','1'
-'311','val_311','1'
-'311','val_311','1'
-'311','val_311','1'
-'311','val_311','1'
-'311','val_311','1'
-'311','val_311','1'
-'311','val_311','1'
-'311','val_311','1'
-'311','val_311','1'
-'315','val_315','1'
-'316','val_316','1'
-'316','val_316','1'
-'316','val_316','1'
-'316','val_316','1'
-'316','val_316','1'
-'316','val_316','1'
-'316','val_316','1'
-'316','val_316','1'
-'316','val_316','1'
-'317','val_317','1'
-'317','val_317','1'
-'317','val_317','1'
-'317','val_317','1'
-'318','val_318','1'
-'318','val_318','1'
-'318','val_318','1'
-'318','val_318','1'
-'318','val_318','1'
-'318','val_318','1'
-'318','val_318','1'
-'318','val_318','1'
-'318','val_318','1'
-'321','val_321','1'
-'321','val_321','1'
-'321','val_321','1'
-'321','val_321','1'
-'322','val_322','1'
-'322','val_322','1'
-'322','val_322','1'
-'322','val_322','1'
-'323','val_323','1'
-'325','val_325','1'
-'325','val_325','1'
-'325','val_325','1'
-'325','val_325','1'
-'327','val_327','1'
-'327','val_327','1'
-'327','val_327','1'
-'327','val_327','1'
-'327','val_327','1'
-'327','val_327','1'
-'327','val_327','1'
-'327','val_327','1'
-'327','val_327','1'
-'331','val_331','1'
-'331','val_331','1'
-'331','val_331','1'
-'331','val_331','1'
-'332','val_332','1'
-'333','val_333','1'
-'333','val_333','1'
-'333','val_333','1'
-'333','val_333','1'
-'335','val_335','1'
-'336','val_336','1'
-'338','val_338','1'
-'339','val_339','1'
-'341','val_341','1'
-'342','val_342','1'
-'342','val_342','1'
-'342','val_342','1'
-'342','val_342','1'
-'344','val_344','1'
-'344','val_344','1'
-'344','val_344','1'
-'344','val_344','1'
-'345','val_345','1'
-'348','val_348','1'
-'348','val_348','1'
-'348','val_348','1'
-'348','val_348','1'
-'348','val_348','1'
-'348','val_348','1'
-'348','val_348','1'
-'348','val_348','1'
-'348','val_348','1'
-'348','val_348','1'
-'348','val_348','1'
-'348','val_348','1'
-'348','val_348','1'
-'348','val_348','1'
-'348','val_348','1'
-'348','val_348','1'
-'348','val_348','1'
-'348','val_348','1'
-'348','val_348','1'
-'348','val_348','1'
-'348','val_348','1'
-'348','val_348','1'
-'348','val_348','1'
-'348','val_348','1'
-'348','val_348','1'
-'351','val_351','1'
-'353','val_353','1'
-'353','val_353','1'
-'353','val_353','1'
-'353','val_353','1'
-'356','val_356','1'
-'360','val_360','1'
-'362','val_362','1'
-'364','val_364','1'
-'365','val_365','1'
-'366','val_366','1'
-'367','val_367','1'
-'367','val_367','1'
-'367','val_367','1'
-'367','val_367','1'
-'368','val_368','1'
-'369','val_369','1'
-'369','val_369','1'
-'369','val_369','1'
-'369','val_369','1'
-'369','val_369','1'
-'369','val_369','1'
-'369','val_369','1'
-'369','val_369','1'
-'369','val_369','1'
-'373','val_373','1'
-'374','val_374','1'
-'375','val_375','1'
-'377','val_377','1'
-'378','val_378','1'
-'379','val_379','1'
-'382','val_382','1'
-'382','val_382','1'
-'382','val_382','1'
-'382','val_382','1'
-'384','val_384','1'
-'384','val_384','1'
-'384','val_384','1'
-'384','val_384','1'
-'384','val_384','1'
-'384','val_384','1'
-'384','val_384','1'
-'384','val_384','1'
-'384','val_384','1'
-'386','val_386','1'
-'389','val_389','1'
-'392','val_392','1'
-'393','val_393','1'
-'394','val_394','1'
-'395','val_395','1'
-'395','val_395','1'
-'395','val_395','1'
-'395','val_395','1'
-'396','val_396','1'
-'396','val_396','1'
-'396','val_396','1'
-'396','val_396','1'
-'396','val_396','1'
-'396','val_396','1'
-'396','val_396','1'
-'396','val_396','1'
-'396','val_396','1'
-'397','val_397','1'
-'397','val_397','1'
-'397','val_397','1'
-'397','val_397','1'
-'399','val_399','1'
-'399','val_399','1'
-'399','val_399','1'
-'399','val_399','1'
-'400','val_400','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'402','val_402','1'
-'403','val_403','1'
-'403','val_403','1'
-'403','val_403','1'
-'403','val_403','1'
-'403','val_403','1'
-'403','val_403','1'
-'403','val_403','1'
-'403','val_403','1'
-'403','val_403','1'
-'404','val_404','1'
-'404','val_404','1'
-'404','val_404','1'
-'404','val_404','1'
-'406','val_406','1'
-'406','val_406','1'
-'406','val_406','1'
-'406','val_406','1'
-'406','val_406','1'
-'406','val_406','1'
-'406','val_406','1'
-'406','val_406','1'
-'406','val_406','1'
-'406','val_406','1'
-'406','val_406','1'
-'406','val_406','1'
-'406','val_406','1'
-'406','val_406','1'
-'406','val_406','1'
-'406','val_406','1'
-'407','val_407','1'
-'409','val_409','1'
-'409','val_409','1'
-'409','val_409','1'
-'409','val_409','1'
-'409','val_409','1'
-'409','val_409','1'
-'409','val_409','1'
-'409','val_409','1'
-'409','val_409','1'
-'411','val_411','1'
-'413','val_413','1'
-'413','val_413','1'
-'413','val_413','1'
-'413','val_413','1'
-'414','val_414','1'
-'414','val_414','1'
-'414','val_414','1'
-'414','val_414','1'
-'417','val_417','1'
-'417','val_417','1'
-'417','val_417','1'
-'417','val_417','1'
-'417','val_417','1'
-'417','val_417','1'
-'417','val_417','1'
-'417','val_417','1'
-'417','val_417','1'
-'418','val_418','1'
-'419','val_419','1'
-'421','val_421','1'
-'424','val_424','1'
-'424','val_424','1'
-'424','val_424','1'
-'424','val_424','1'
-'427','val_427','1'
-'429','val_429','1'
-'429','val_429','1'
-'429','val_429','1'
-'429','val_429','1'
-'430','val_430','1'
-'430','val_430','1'
-'430','val_430','1'
-'430','val_430','1'
-'430','val_430','1'
-'430','val_430','1'
-'430','val_430','1'
-'430','val_430','1'
-'430','val_430','1'
-'431','val_431','1'
-'431','val_431','1'
-'431','val_431','1'
-'431','val_431','1'
-'431','val_431','1'
-'431','val_431','1'
-'431','val_431','1'
-'431','val_431','1'
-'431','val_431','1'
-'432','val_432','1'
-'435','val_435','1'
-'436','val_436','1'
-'437','val_437','1'
-'438','val_438','1'
-'438','val_438','1'
-'438','val_438','1'
-'438','val_438','1'
-'438','val_438','1'
-'438','val_438','1'
-'438','val_438','1'
-'438','val_438','1'
-'438','val_438','1'
-'439','val_439','1'
-'439','val_439','1'
-'439','val_439','1'
-'439','val_439','1'
-'443','val_443','1'
-'444','val_444','1'
-'446','val_446','1'
-'448','val_448','1'
-'449','val_449','1'
-'452','val_452','1'
-'453','val_453','1'
-'454','val_454','1'
-'454','val_454','1'
-'454','val_454','1'
-'454','val_454','1'
-'454','val_454','1'
-'454','val_454','1'
-'454','val_454','1'
-'454','val_454','1'
-'454','val_454','1'
-'455','val_455','1'
-'457','val_457','1'
-'458','val_458','1'
-'458','val_458','1'
-'458','val_458','1'
-'458','val_458','1'
-'459','val_459','1'
-'459','val_459','1'
-'459','val_459','1'
-'459','val_459','1'
-'460','val_460','1'
-'462','val_462','1'
-'462','val_462','1'
-'462','val_462','1'
-'462','val_462','1'
-'463','val_463','1'
-'463','val_463','1'
-'463','val_463','1'
-'463','val_463','1'
-'466','val_466','1'
-'466','val_466','1'
-'466','val_466','1'
-'466','val_466','1'
-'466','val_466','1'
-'466','val_466','1'
-'466','val_466','1'
-'466','val_466','1'
-'466','val_466','1'
-'467','val_467','1'
-'468','val_468','1'
-'468','val_468','1'
-'468','val_468','1'
-'468','val_468','1'
-'468','val_468','1'
-'468','val_468','1'
-'468','val_468','1'
-'468','val_468','1'
-'468','val_468','1'
-'468','val_468','1'
-'468','val_468','1'
-'468','val_468','1'
-'468','val_468','1'
-'468','val_468','1'
-'468','val_468','1'
-'468','val_468','1'
-'469','val_469','1'
-'469','val_469','1'
-'469','val_469','1'
-'469','val_469','1'
-'469','val_469','1'
-'469','val_469','1'
-'469','val_469','1'
-'469','val_469','1'
-'469','val_469','1'
-'469','val_469','1'
-'469','val_469','1'
-'469','val_469','1'
-'469','val_469','1'
-'469','val_469','1'
-'469','val_469','1'
-'469','val_469','1'
-'469','val_469','1'
-'469','val_469','1'
-'469','val_469','1'
-'469','val_469','1'
-'469','val_469','1'
-'469','val_469','1'
-'469','val_469','1'
-'469','val_469','1'
-'469','val_469','1'
-'470','val_470','1'
-'472','val_472','1'
-'475','val_475','1'
-'477','val_477','1'
-'478','val_478','1'
-'478','val_478','1'
-'478','val_478','1'
-'478','val_478','1'
-'479','val_479','1'
-'480','val_480','1'
-'480','val_480','1'
-'480','val_480','1'
-'480','val_480','1'
-'480','val_480','1'
-'480','val_480','1'
-'480','val_480','1'
-'480','val_480','1'
-'480','val_480','1'
-'481','val_481','1'
-'482','val_482','1'
-'483','val_483','1'
-'484','val_484','1'
-'485','val_485','1'
-'487','val_487','1'
-'489','val_489','1'
-'489','val_489','1'
-'489','val_489','1'
-'489','val_489','1'
-'489','val_489','1'
-'489','val_489','1'
-'489','val_489','1'
-'489','val_489','1'
-'489','val_489','1'
-'489','val_489','1'
-'489','val_489','1'
-'489','val_489','1'
-'489','val_489','1'
-'489','val_489','1'
-'489','val_489','1'
-'489','val_489','1'
-'490','val_490','1'
-'491','val_491','1'
-'492','val_492','1'
-'492','val_492','1'
-'492','val_492','1'
-'492','val_492','1'
-'493','val_493','1'
-'494','val_494','1'
-'495','val_495','1'
-'496','val_496','1'
-'497','val_497','1'
-'498','val_498','1'
-'498','val_498','1'
-'498','val_498','1'
-'498','val_498','1'
-'498','val_498','1'
-'498','val_498','1'
-'498','val_498','1'
-'498','val_498','1'
-'498','val_498','1'
-1,028 rows selected 
->>>  EXPLAIN EXTENDED SELECT * FROM test_table1 TABLESAMPLE(BUCKET 2 OUT OF 16);
-INFO  : Compiling commandqueryId=(!!{queryId}!!): EXPLAIN EXTENDED SELECT * FROM test_table1 TABLESAMPLE(BUCKET 2 OUT OF 16)
-INFO  : Semantic Analysis Completed
-INFO  : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:Explain, type:string, comment:null)], properties:null)
-INFO  : Completed compiling commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! seconds
-INFO  : Executing commandqueryId=(!!{queryId}!!): EXPLAIN EXTENDED SELECT * FROM test_table1 TABLESAMPLE(BUCKET 2 OUT OF 16)
-INFO  : PREHOOK: query: EXPLAIN EXTENDED SELECT * FROM test_table1 TABLESAMPLE(BUCKET 2 OUT OF 16)
-INFO  : PREHOOK: type: QUERY
-INFO  : Starting task [Stage-2:EXPLAIN] in serial mode
-INFO  : POSTHOOK: query: EXPLAIN EXTENDED SELECT * FROM test_table1 TABLESAMPLE(BUCKET 2 OUT OF 16)
-INFO  : POSTHOOK: type: QUERY
-INFO  : Completed executing commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! seconds
-INFO  : OK
-DEBUG : Shutting down query EXPLAIN EXTENDED SELECT * FROM test_table1 TABLESAMPLE(BUCKET 2 OUT OF 16)
-'Explain'
-'STAGE DEPENDENCIES:'
-'  Stage-1 is a root stage'
-'  Stage-0 depends on stages: Stage-1'
-''
-'STAGE PLANS:'
-'  Stage: Stage-1'
-'    Map Reduce'
-'      Map Operator Tree:'
-'          TableScan'
-'            alias: test_table1'
-'            Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE'
-'            GatherStats: false'
-'            Filter Operator'
-'              isSamplingPred: true'
-'              predicate: (((hash(key) & 2147483647) % 16) = 1) (type: boolean)'
-'              sampleDesc: BUCKET 2 OUT OF 16'
-'              Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE'
-'              Select Operator'
-'                expressions: key (type: int), value (type: string), ds (type: string)'
-'                outputColumnNames: _col0, _col1, _col2'
-'                Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE'
-'                File Output Operator'
-'                  compressed: false'
-'                  GlobalTableId: 0'
-'                  directory: file:/!!ELIDED!!
-'                  NumFilesPerFileSink: 1'
-'                  Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE'
-'                  Stats Publishing Key Prefix: file:/!!ELIDED!!
-'                  table:'
-'                      input format: org.apache.hadoop.mapred.SequenceFileInputFormat'
-'                      output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat'
-'                      properties:'
-'                        columns _col0,_col1,_col2'
-'                        columns.types int:string:string'
-'                        escape.delim \'
-'                        hive.serialization.extend.additional.nesting.levels true'
-'                        serialization.escape.crlf 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:'
-'        file:/!!ELIDED!! [test_table1]'
-'      Path -> Partition:'
-'        file:/!!ELIDED!! '
-'          Partition'
-'            base file name: 000001_0'
-'            input format: org.apache.hadoop.mapred.TextInputFormat'
-'            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-'            partition values:'
-'              ds 1'
-'            properties:'
-'              COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}'
-'              bucket_count 16'
-'              bucket_field_name key'
-'              column.name.delimiter ,'
-'              columns key,value'
-'              columns.comments '
-'              columns.types int:string'
-'              file.inputformat org.apache.hadoop.mapred.TextInputFormat'
-'              file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-'              location file:/!!ELIDED!!
-'              name smb_mapjoin_11.test_table1'
-'              numFiles 16'
-'              numRows 500'
-'              partition_columns ds'
-'              partition_columns.types string'
-'              rawDataSize 5312'
-'              serialization.ddl struct test_table1 { i32 key, string value}'
-'              serialization.format 1'
-'              serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-'              totalSize 5812'
-'              transient_lastDdlTime !!UNIXTIME!!'
-'            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:'
-'                SORTBUCKETCOLSPREFIX TRUE'
-'                bucket_count 16'
-'                bucket_field_name key'
-'                column.name.delimiter ,'
-'                columns key,value'
-'                columns.comments '
-'                columns.types int:string'
-'                file.inputformat org.apache.hadoop.mapred.TextInputFormat'
-'                file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-'                location file:/!!ELIDED!!
-'                name smb_mapjoin_11.test_table1'
-'                partition_columns ds'
-'                partition_columns.types string'
-'                serialization.ddl struct test_table1 { i32 key, string value}'
-'                serialization.format 1'
-'                serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-'                transient_lastDdlTime !!UNIXTIME!!'
-'              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-'              name: smb_mapjoin_11.test_table1'
-'            name: smb_mapjoin_11.test_table1'
-'      Truncated Path -> Alias:'
-'        /smb_mapjoin_11.db/test_table1/ds=1/000001_0 [test_table1]'
-''
-'  Stage: Stage-0'
-'    Fetch Operator'
-'      limit: -1'
-'      Processor Tree:'
-'        ListSink'
-''
-109 rows selected 
->>>  EXPLAIN EXTENDED SELECT * FROM test_table3 TABLESAMPLE(BUCKET 2 OUT OF 16);
-INFO  : Compiling commandqueryId=(!!{queryId}!!): EXPLAIN EXTENDED SELECT * FROM test_table3 TABLESAMPLE(BUCKET 2 OUT OF 16)
-INFO  : Semantic Analysis Completed
-INFO  : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:Explain, type:string, comment:null)], properties:null)
-INFO  : Completed compiling commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! seconds
-INFO  : Executing commandqueryId=(!!{queryId}!!): EXPLAIN EXTENDED SELECT * FROM test_table3 TABLESAMPLE(BUCKET 2 OUT OF 16)
-INFO  : PREHOOK: query: EXPLAIN EXTENDED SELECT * FROM test_table3 TABLESAMPLE(BUCKET 2 OUT OF 16)
-INFO  : PREHOOK: type: QUERY
-INFO  : Starting task [Stage-2:EXPLAIN] in serial mode
-INFO  : POSTHOOK: query: EXPLAIN EXTENDED SELECT * FROM test_table3 TABLESAMPLE(BUCKET 2 OUT OF 16)
-INFO  : POSTHOOK: type: QUERY
-INFO  : Completed executing commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! seconds
-INFO  : OK
-DEBUG : Shutting down query EXPLAIN EXTENDED SELECT * FROM test_table3 TABLESAMPLE(BUCKET 2 OUT OF 16)
-'Explain'
-'STAGE DEPENDENCIES:'
-'  Stage-1 is a root stage'
-'  Stage-0 depends on stages: Stage-1'
-''
-'STAGE PLANS:'
-'  Stage: Stage-1'
-'    Map Reduce'
-'      Map Operator Tree:'
-'          TableScan'
-'            alias: test_table3'
-'            Statistics: Num rows: 1028 Data size: 10968 Basic stats: COMPLETE Column stats: NONE'
-'            GatherStats: false'
-'            Filter Operator'
-'              isSamplingPred: true'
-'              predicate: (((hash(key) & 2147483647) % 16) = 1) (type: boolean)'
-'              sampleDesc: BUCKET 2 OUT OF 16'
-'              Statistics: Num rows: 514 Data size: 5484 Basic stats: COMPLETE Column stats: NONE'
-'              Select Operator'
-'                expressions: key (type: int), value (type: string), ds (type: string)'
-'                outputColumnNames: _col0, _col1, _col2'
-'                Statistics: Num rows: 514 Data size: 5484 Basic stats: COMPLETE Column stats: NONE'
-'                File Output Operator'
-'                  compressed: false'
-'                  GlobalTableId: 0'
-'                  directory: file:/!!ELIDED!!
-'                  NumFilesPerFileSink: 1'
-'                  Statistics: Num rows: 514 Data size: 5484 Basic stats: COMPLETE Column stats: NONE'
-'                  Stats Publishing Key Prefix: file:/!!ELIDED!!
-'                  table:'
-'                      input format: org.apache.hadoop.mapred.SequenceFileInputFormat'
-'                      output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat'
-'                      properties:'
-'                        columns _col0,_col1,_col2'
-'                        columns.types int:string:string'
-'                        escape.delim \'
-'                        hive.serialization.extend.additional.nesting.levels true'
-'                        serialization.escape.crlf 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:'
-'        file:/!!ELIDED!! [test_table3]'
-'      Path -> Partition:'
-'        file:/!!ELIDED!! '
-'          Partition'
-'            base file name: 000001_0'
-'            input format: org.apache.hadoop.mapred.TextInputFormat'
-'            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-'            partition values:'
-'              ds 1'
-'            properties:'
-'              COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}'
-'              bucket_count 16'
-'              bucket_field_name key'
-'              column.name.delimiter ,'
-'              columns key,value'
-'              columns.comments '
-'              columns.types int:string'
-'              file.inputformat org.apache.hadoop.mapred.TextInputFormat'
-'              file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-'              location file:/!!ELIDED!!
-'              name smb_mapjoin_11.test_table3'
-'              numFiles 16'
-'              numRows 1028'
-'              partition_columns ds'
-'              partition_columns.types string'
-'              rawDataSize 10968'
-'              serialization.ddl struct test_table3 { i32 key, string value}'
-'              serialization.format 1'
-'              serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-'              totalSize 11996'
-'              transient_lastDdlTime !!UNIXTIME!!'
-'            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 16'
-'                bucket_field_name key'
-'                column.name.delimiter ,'
-'                columns key,value'
-'                columns.comments '
-'                columns.types int:string'
-'                file.inputformat org.apache.hadoop.mapred.TextInputFormat'
-'                file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
-'                location file:/!!ELIDED!!
-'                name smb_mapjoin_11.test_table3'
-'                partition_columns ds'
-'                partition_columns.types string'
-'                serialization.ddl struct test_table3 { i32 key, string value}'
-'                serialization.format 1'
-'                serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-'                transient_lastDdlTime !!UNIXTIME!!'
-'              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
-'              name: smb_mapjoin_11.test_table3'
-'            name: smb_mapjoin_11.test_table3'
-'      Truncated Path -> Alias:'
-'        /smb_mapjoin_11.db/test_table3/ds=1/000001_0 [test_table3]'
-''
-'  Stage: Stage-0'
-'    Fetch Operator'
-'      limit: -1'
-'      Processor Tree:'
-'        ListSink'
-''
-108 rows selected 
->>>  SELECT * FROM test_table1 TABLESAMPLE(BUCKET 2 OUT OF 16);
-INFO  : Compiling commandqueryId=(!!{queryId}!!): SELECT * FROM test_table1 TABLESAMPLE(BUCKET 2 OUT OF 16)
-INFO  : Semantic Analysis Completed
-INFO  : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:test_table1.key, type:int, comment:null), FieldSchema(name:test_table1.value, type:string, comment:null), FieldSchema(name:test_table1.ds, type:string, comment:null)], properties:null)
-INFO  : Completed compiling commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! seconds
-INFO  : Executing commandqueryId=(!!{queryId}!!): SELECT * FROM test_table1 TABLESAMPLE(BUCKET 2 OUT OF 16)
-INFO  : PREHOOK: query: SELECT * FROM test_table1 TABLESAMPLE(BUCKET 2 OUT OF 16)
-INFO  : PREHOOK: type: QUERY
-INFO  : PREHOOK: Input: smb_mapjoin_11@test_table1
-INFO  : PREHOOK: Input: smb_mapjoin_11@test_table1@ds=1
-INFO  : PREHOOK: Output: file:/!!ELIDED!!
-WARN  : Hive-on-MR is deprecated in Hive 2 and may not be available in the future versions. Consider using a different execution engine (i.e. spark, tez) or using Hive 1.X releases.
-INFO  : Query ID = !!{queryId}!!
-INFO  : Total jobs = 1
-INFO  : Launching Job 1 out of 1
-INFO  : Starting task [Stage-1:MAPRED] in serial mode
-INFO  : Number of reduce tasks is set to 0 since there's no reduce operator
-DEBUG : Configuring job !!{jobId}}!! with file:/!!ELIDED!! as the submit dir
-DEBUG : adding the following namenodes' delegation tokens:[file:///]
-DEBUG : Creating splits at file:/!!ELIDED!!
-INFO  : number of splits:1
-INFO  : Submitting tokens for job: !!{jobId}}!!
-INFO  : The url to track the job: http://localhost:8080/
-INFO  : Job running in-process (local Hadoop)
-INFO  : Ended Job = !!{jobId}!!
-INFO  : POSTHOOK: query: SELECT * FROM test_table1 TABLESAMPLE(BUCKET 2 OUT OF 16)
-INFO  : POSTHOOK: type: QUERY
-INFO  : POSTHOOK: Input: smb_mapjoin_11@test_table1
-INFO  : POSTHOOK: Input: smb_mapjoin_11@test_table1@ds=1
-INFO  : POSTHOOK: Output: file:/!!ELIDED!!
-INFO  : MapReduce Jobs Launched: 
-INFO  : Stage-Stage-1:  HDFS Read: 0 HDFS Write: 0 SUCCESS
-INFO  : Total MapReduce CPU Time Spent: 0 msec
-INFO  : Completed executing commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! seconds
-INFO  : OK
-DEBUG : Shutting down query SELECT * FROM test_table1 TABLESAMPLE(BUCKET 2 OUT OF 16)
-'test_table1.key','test_table1.value','test_table1.ds'
-'17','val_17','1'
-'33','val_33','1'
-'65','val_65','1'
-'97','val_97','1'
-'97','val_97','1'
-'113','val_113','1'
-'113','val_113','1'
-'129','val_129','1'
-'129','val_129','1'
-'145','val_145','1'
-'177','val_177','1'
-'193','val_193','1'
-'193','val_193','1'
-'193','val_193','1'
-'209','val_209','1'
-'209','val_209','1'
-'241','val_241','1'
-'257','val_257','1'
-'273','val_273','1'
-'273','val_273','1'
-'273','val_273','1'
-'289','val_289','1'
-'305','val_305','1'
-'321','val_321','1'
-'321','val_321','1'
-'353','val_353','1'
-'353','val_353','1'
-'369','val_369','1'
-'369','val_369','1'
-'369','val_369','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'417','val_417','1'
-'417','val_417','1'
-'417','val_417','1'
-'449','val_449','1'
-'481','val_481','1'
-'497','val_497','1'
-41 rows selected 
->>>  SELECT * FROM test_table3 TABLESAMPLE(BUCKET 2 OUT OF 16);
-INFO  : Compiling commandqueryId=(!!{queryId}!!): SELECT * FROM test_table3 TABLESAMPLE(BUCKET 2 OUT OF 16)
-INFO  : Semantic Analysis Completed
-INFO  : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:test_table3.key, type:int, comment:null), FieldSchema(name:test_table3.value, type:string, comment:null), FieldSchema(name:test_table3.ds, type:string, comment:null)], properties:null)
-INFO  : Completed compiling commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! seconds
-INFO  : Executing commandqueryId=(!!{queryId}!!): SELECT * FROM test_table3 TABLESAMPLE(BUCKET 2 OUT OF 16)
-INFO  : PREHOOK: query: SELECT * FROM test_table3 TABLESAMPLE(BUCKET 2 OUT OF 16)
-INFO  : PREHOOK: type: QUERY
-INFO  : PREHOOK: Input: smb_mapjoin_11@test_table3
-INFO  : PREHOOK: Input: smb_mapjoin_11@test_table3@ds=1
-INFO  : PREHOOK: Output: file:/!!ELIDED!!
-WARN  : Hive-on-MR is deprecated in Hive 2 and may not be available in the future versions. Consider using a different execution engine (i.e. spark, tez) or using Hive 1.X releases.
-INFO  : Query ID = !!{queryId}!!
-INFO  : Total jobs = 1
-INFO  : Launching Job 1 out of 1
-INFO  : Starting task [Stage-1:MAPRED] in serial mode
-INFO  : Number of reduce tasks is set to 0 since there's no reduce operator
-DEBUG : Configuring job !!{jobId}}!! with file:/!!ELIDED!! as the submit dir
-DEBUG : adding the following namenodes' delegation tokens:[file:///]
-DEBUG : Creating splits at file:/!!ELIDED!!
-INFO  : number of splits:1
-INFO  : Submitting tokens for job: !!{jobId}}!!
-INFO  : The url to track the job: http://localhost:8080/
-INFO  : Job running in-process (local Hadoop)
-INFO  : Ended Job = !!{jobId}!!
-INFO  : POSTHOOK: query: SELECT * FROM test_table3 TABLESAMPLE(BUCKET 2 OUT OF 16)
-INFO  : POSTHOOK: type: QUERY
-INFO  : POSTHOOK: Input: smb_mapjoin_11@test_table3
-INFO  : POSTHOOK: Input: smb_mapjoin_11@test_table3@ds=1
-INFO  : POSTHOOK: Output: file:/!!ELIDED!!
-INFO  : MapReduce Jobs Launched: 
-INFO  : Stage-Stage-1:  HDFS Read: 0 HDFS Write: 0 SUCCESS
-INFO  : Total MapReduce CPU Time Spent: 0 msec
-INFO  : Completed executing commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! seconds
-INFO  : OK
-DEBUG : Shutting down query SELECT * FROM test_table3 TABLESAMPLE(BUCKET 2 OUT OF 16)
-'test_table3.key','test_table3.value','test_table3.ds'
-'497','val_497','1'
-'481','val_481','1'
-'449','val_449','1'
-'417','val_417','1'
-'417','val_417','1'
-'417','val_417','1'
-'417','val_417','1'
-'417','val_417','1'
-'417','val_417','1'
-'417','val_417','1'
-'417','val_417','1'
-'417','val_417','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'401','val_401','1'
-'369','val_369','1'
-'369','val_369','1'
-'369','val_369','1'
-'369','val_369','1'
-'369','val_369','1'
-'369','val_369','1'
-'369','val_369','1'
-'369','val_369','1'
-'369','val_369','1'
-'353','val_353','1'
-'353','val_353','1'
-'353','val_353','1'
-'353','val_353','1'
-'321','val_321','1'
-'321','val_321','1'
-'321','val_321','1'
-'321','val_321','1'
-'305','val_305','1'
-'289','val_289','1'
-'273','val_273','1'
-'273','val_273','1'
-'273','val_273','1'
-'273','val_273','1'
-'273','val_273','1'
-'273','val_273','1'
-'273','val_273','1'
-'273','val_273','1'
-'273','val_273','1'
-'257','val_257','1'
-'241','val_241','1'
-'209','val_209','1'
-'209','val_209','1'
-'209','val_209','1'
-'209','val_209','1'
-'193','val_193','1'
-'193','val_193','1'
-'193','val_193','1'
-'193','val_193','1'
-'193','val_193','1'
-'193','val_193','1'
-'193','val_193','1'
-'193','val_193','1'
-'193','val_193','1'
-'177','val_177','1'
-'145','val_145','1'
-'129','val_129','1'
-'129','val_129','1'
-'129','val_129','1'
-'129','val_129','1'
-'113','val_113','1'
-'113','val_113','1'
-'113','val_113','1'
-'113','val_113','1'
-'97','val_97','1'
-'97','val_97','1'
-'97','val_97','1'
-'97','val_97','1'
-'65','val_65','1'
-'33','val_33','1'
-'17','val_17','1'
-97 rows selected 
->>>  
->>>  -- Join data from a sampled bucket to verify the data is bucketed
->>>  SELECT COUNT(*) FROM test_table3 TABLESAMPLE(BUCKET 2 OUT OF 16) a JOIN test_table1 TABLESAMPLE(BUCKET 2 OUT OF 16) b ON a.key = b.key AND a.ds = '1' AND b.ds='1';
-INFO  : Compiling commandqueryId=(!!{queryId}!!): SELECT COUNT(*) FROM test_table3 TABLESAMPLE(BUCKET 2 OUT OF 16) a JOIN test_table1 TABLESAMPLE(BUCKET 2 OUT OF 16) b ON a.key = b.key AND a.ds = '1' AND b.ds='1'
-INFO  : Semantic Analysis Completed
-INFO  : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:_c0, type:bigint, comment:null)], properties:null)
-INFO  : Completed compiling commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! seconds
-INFO  : Executing commandqueryId=(!!{queryId}!!): SELECT COUNT(*) FROM test_table3 TABLESAMPLE(BUCKET 2 OUT OF 16) a JOIN test_table1 TABLESAMPLE(BUCKET 2 OUT OF 16) b ON a.key = b.key AND a.ds = '1' AND b.ds='1'
-INFO  : PREHOOK: query: SELECT COUNT(*) FROM test_table3 TABLESAMPLE(BUCKET 2 OUT OF 16) a JOIN test_table1 TABLESAMPLE(BUCKET 2 OUT OF 16) b ON a.key = b.key AND a.ds = '1' AND b.ds='1'
-INFO  : PREHOOK: type: QUERY
-INFO  : PREHOOK: Input: smb_mapjoin_11@test_table1
-INFO  : PREHOOK: Input: smb_mapjoin_11@test_table1@ds=1
-INFO  : PREHOOK: Input: smb_mapjoin_11@test_table3
-INFO  : PREHOOK: Input: smb_mapjoin_11@test_table3@ds=1
-INFO  : PREHOOK: Output: file:/!!ELIDED!!
-WARN  : Hive-on-MR is deprecated in Hive 2 and may not be available in the future versions. Consider using a different execution engine (i.e. spark, tez) or using Hive 1.X releases.
-INFO  : Query ID = !!{queryId}!!
-INFO  : Total jobs = 2
-INFO  : Launching Job 1 out of 2
-INFO  : Starting task [Stage-1:MAPRED] in serial mode
-INFO  : Number of reduce tasks not specified. Estimated from input data size: 1
-INFO  : In order to change the average load for a reducer (in bytes):
-INFO  :   set hive.exec.reducers.bytes.per.reducer=<number>
-INFO  : In order to limit the maximum number of reducers:
-INFO  :   set hive.exec.reducers.max=<number>
-INFO  : In order to set a constant number of reducers:
-INFO  :   set mapreduce.job.reduces=<number>
-DEBUG : Configuring job !!{jobId}}!! with file:/!!ELIDED!! as the submit dir
-DEBUG : adding the following namenodes' delegation tokens:[file:///]
-DEBUG : Creating splits at file:/!!ELIDED!!
-INFO  : number of splits:2
-INFO  : Submitting tokens for job: !!{jobId}}!!
-INFO  : The url to track the job: http://localhost:8080/
-INFO  : Job running in-process (local Hadoop)
-INFO  : Ended Job = !!{jobId}!!
-INFO  : Launching Job 2 out of 2
-INFO  : Starting task [Stage-2:MAPRED] in serial mode
-INFO  : Number of reduce tasks determined at compile time: 1
-INFO  : In order to change the average load for a reducer (in bytes):
-INFO  :   set hive.exec.reducers.bytes.per.reducer=<number>
-INFO  : In order to limit the maximum number of reducers:
-INFO  :   set hive.exec.reducers.max=<number>
-INFO  : In order to set a constant number of reducers:
-INFO  :   set mapreduce.job.reduces=<number>
-DEBUG : Configuring job !!{jobId}}!! with file:/!!ELIDED!! as the submit dir
-DEBUG : adding the following namenodes' delegation tokens:[file:///]
-DEBUG : Creating splits at file:/!!ELIDED!!
-INFO  : number of splits:1
-INFO  : Submitting tokens for job: !!{jobId}}!!
-INFO  : The url to track the job: http://localhost:8080/
-INFO  : Job running in-process (local Hadoop)
-INFO  : Ended Job = !!{jobId}!!
-INFO  : POSTHOOK: query: SELECT COUNT(*) FROM test_table3 TABLESAMPLE(BUCKET 2 OUT OF 16) a JOIN test_table1 TABLESAMPLE(BUCKET 2 OUT OF 16) b ON a.key = b.key AND a.ds = '1' AND b.ds='1'
-INFO  : POSTHOOK: type: QUERY
-INFO  : POSTHOOK: Input: smb_mapjoin_11@test_table1
-INFO  : POSTHOOK: Input: smb_mapjoin_11@test_table1@ds=1
-INFO  : POSTHOOK: Input: smb_mapjoin_11@test_table3
-INFO  : POSTHOOK: Input: smb_mapjoin_11@test_table3@ds=1
-INFO  : POSTHOOK: Output: file:/!!ELIDED!!
-INFO  : MapReduce Jobs Launched: 
-INFO  : Stage-Stage-1:  HDFS Read: 0 HDFS Write: 0 SUCCESS
-INFO  : Stage-Stage-2:  HDFS Read: 0 HDFS Write: 0 SUCCESS
-INFO  : Total MapReduce CPU Time Spent: 0 msec
-INFO  : Completed executing commandqueryId=(!!{queryId}!!); Time taken: !!ELIDED!! seconds
-INFO  : OK
-DEBUG : Shutting down query SELECT COUNT(*) FROM test_table3 TABLESAMPLE(BUCKET 2 OUT OF 16) a JOIN test_table1 TABLESAMPLE(BUCKET 2 OUT OF 16) b ON a.key = b.key AND a.ds = '1' AND b.ds='1'
-'_c0'
-'293'
-1 row selected 
->>>  
->>>  !record
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-0 depends on stages: Stage-1
+  Stage-2 depends on stages: Stage-0
+
+STAGE PLANS:
+  Stage: Stage-1
+    Map Reduce
+      Map Operator Tree:
+          TableScan
+            alias: a
+            Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+            G

<TRUNCATED>

Mime
View raw message