You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by pr...@apache.org on 2015/04/14 03:59:31 UTC
svn commit: r1673337 [4/10] - in /hive/trunk:
common/src/java/org/apache/hadoop/hive/common/type/
common/src/java/org/apache/hive/common/util/ itests/src/test/resources/
ql/src/java/org/apache/hadoop/hive/ql/exec/
ql/src/java/org/apache/hadoop/hive/ql/...
Modified: hive/trunk/ql/src/test/org/apache/hadoop/hive/ql/exec/vector/TestVectorizationContext.java
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/org/apache/hadoop/hive/ql/exec/vector/TestVectorizationContext.java?rev=1673337&r1=1673336&r2=1673337&view=diff
==============================================================================
--- hive/trunk/ql/src/test/org/apache/hadoop/hive/ql/exec/vector/TestVectorizationContext.java (original)
+++ hive/trunk/ql/src/test/org/apache/hadoop/hive/ql/exec/vector/TestVectorizationContext.java Tue Apr 14 01:59:29 2015
@@ -247,7 +247,7 @@ public class TestVectorizationContext {
children5.add(col6Expr);
modExpr.setChildren(children5);
- VectorizationContext vc = new VectorizationContext();
+ VectorizationContext vc = new VectorizationContext("name");
vc.addInitialColumn("col1");
vc.addInitialColumn("col2");
vc.addInitialColumn("col3");
@@ -297,7 +297,7 @@ public class TestVectorizationContext {
columns.add("col0");
columns.add("col1");
columns.add("col2");
- VectorizationContext vc = new VectorizationContext(columns);
+ VectorizationContext vc = new VectorizationContext("name", columns);
VectorExpression ve = vc.getVectorExpression(exprDesc, VectorExpressionDescriptor.Mode.FILTER);
@@ -322,7 +322,7 @@ public class TestVectorizationContext {
columns.add("col0");
columns.add("col1");
columns.add("col2");
- VectorizationContext vc = new VectorizationContext(columns);
+ VectorizationContext vc = new VectorizationContext("name", columns);
VectorExpression ve = vc.getVectorExpression(exprDesc, VectorExpressionDescriptor.Mode.FILTER);
@@ -341,7 +341,7 @@ public class TestVectorizationContext {
children1.add(col2Expr);
exprDesc.setChildren(children1);
- vc = new VectorizationContext(columns);
+ vc = new VectorizationContext("name", columns);
ve = vc.getVectorExpression(exprDesc, VectorExpressionDescriptor.Mode.FILTER);
@@ -360,7 +360,7 @@ public class TestVectorizationContext {
children1.add(col2Expr);
exprDesc.setChildren(children1);
- vc = new VectorizationContext(columns);
+ vc = new VectorizationContext("name", columns);
ve = vc.getVectorExpression(exprDesc, VectorExpressionDescriptor.Mode.FILTER);
@@ -378,7 +378,7 @@ public class TestVectorizationContext {
children1.add(col2Expr);
exprDesc.setChildren(children1);
- vc = new VectorizationContext(columns);
+ vc = new VectorizationContext("name", columns);
ve = vc.getVectorExpression(exprDesc, VectorExpressionDescriptor.Mode.FILTER);
@@ -395,7 +395,7 @@ public class TestVectorizationContext {
children1.add(col2Expr);
exprDesc.setChildren(children1);
- vc = new VectorizationContext(columns);
+ vc = new VectorizationContext("name", columns);
ve = vc.getVectorExpression(exprDesc, VectorExpressionDescriptor.Mode.FILTER);
@@ -412,7 +412,7 @@ public class TestVectorizationContext {
children1.add(col2Expr);
exprDesc.setChildren(children1);
- vc = new VectorizationContext(columns);
+ vc = new VectorizationContext("name", columns);
ve = vc.getVectorExpression(exprDesc, VectorExpressionDescriptor.Mode.FILTER);
@@ -434,7 +434,7 @@ public class TestVectorizationContext {
List<String> columns = new ArrayList<String>();
columns.add("col1");
- VectorizationContext vc = new VectorizationContext(columns);
+ VectorizationContext vc = new VectorizationContext("name", columns);
VectorExpression ve = vc.getVectorExpression(exprDesc, VectorExpressionDescriptor.Mode.PROJECTION);
@@ -480,7 +480,7 @@ public class TestVectorizationContext {
columns.add("col0");
columns.add("col1");
columns.add("col2");
- VectorizationContext vc = new VectorizationContext(columns);
+ VectorizationContext vc = new VectorizationContext("name", columns);
VectorExpression ve = vc.getVectorExpression(andExprDesc, VectorExpressionDescriptor.Mode.FILTER);
@@ -530,7 +530,7 @@ public class TestVectorizationContext {
List<String> columns = new ArrayList<String>();
columns.add("col1");
columns.add("col2");
- VectorizationContext vc = new VectorizationContext(columns);
+ VectorizationContext vc = new VectorizationContext("name", columns);
VectorExpression veAnd = vc.getVectorExpression(andExprDesc, VectorExpressionDescriptor.Mode.FILTER);
assertEquals(veAnd.getClass(), FilterExprAndExpr.class);
assertEquals(veAnd.getChildExpressions()[0].getClass(), FilterLongColGreaterLongScalar.class);
@@ -555,7 +555,7 @@ public class TestVectorizationContext {
orExprDesc.setChildren(children4);
//Allocate new Vectorization context to reset the intermediate columns.
- vc = new VectorizationContext(columns);
+ vc = new VectorizationContext("name", columns);
VectorExpression veOr = vc.getVectorExpression(orExprDesc, VectorExpressionDescriptor.Mode.FILTER);
assertEquals(veOr.getClass(), FilterExprOrExpr.class);
assertEquals(veOr.getChildExpressions()[0].getClass(), FilterLongColGreaterLongScalar.class);
@@ -596,7 +596,7 @@ public class TestVectorizationContext {
columns.add("col0");
columns.add("col1");
columns.add("col2");
- VectorizationContext vc = new VectorizationContext(columns);
+ VectorizationContext vc = new VectorizationContext("name", columns);
VectorExpression ve = vc.getVectorExpression(notExpr, VectorExpressionDescriptor.Mode.FILTER);
@@ -633,7 +633,7 @@ public class TestVectorizationContext {
List<String> columns = new ArrayList<String>();
columns.add("col1");
columns.add("col2");
- VectorizationContext vc = new VectorizationContext(columns);
+ VectorizationContext vc = new VectorizationContext("name", columns);
VectorExpression ve = vc.getVectorExpression(isNullExpr, VectorExpressionDescriptor.Mode.FILTER);
@@ -674,7 +674,7 @@ public class TestVectorizationContext {
List<String> columns = new ArrayList<String>();
columns.add("col1");
columns.add("col2");
- VectorizationContext vc = new VectorizationContext(columns);
+ VectorizationContext vc = new VectorizationContext("name", columns);
VectorExpression ve = vc.getVectorExpression(isNotNullExpr, VectorExpressionDescriptor.Mode.FILTER);
@@ -703,7 +703,7 @@ public class TestVectorizationContext {
List<String> columns = new ArrayList<String>();
columns.add("a");
- VectorizationContext vc = new VectorizationContext(columns);
+ VectorizationContext vc = new VectorizationContext("name", columns);
VectorExpression ve = vc.getVectorExpression(scalarMinusConstant, VectorExpressionDescriptor.Mode.PROJECTION);
assertEquals(ve.getClass(), LongScalarSubtractLongColumn.class);
@@ -726,7 +726,7 @@ public class TestVectorizationContext {
columns.add("col0");
columns.add("col1");
columns.add("col2");
- VectorizationContext vc = new VectorizationContext(columns);
+ VectorizationContext vc = new VectorizationContext("name", columns);
VectorExpression ve = vc.getVectorExpression(exprDesc, VectorExpressionDescriptor.Mode.FILTER);
@@ -744,7 +744,7 @@ public class TestVectorizationContext {
List<String> columns = new ArrayList<String>();
columns.add("col0");
columns.add("col1");
- VectorizationContext vc = new VectorizationContext(columns);
+ VectorizationContext vc = new VectorizationContext("name", columns);
VectorExpression ve = vc.getVectorExpression(negExprDesc, VectorExpressionDescriptor.Mode.PROJECTION);
@@ -762,7 +762,7 @@ public class TestVectorizationContext {
List<String> columns = new ArrayList<String>();
columns.add("col0");
columns.add("col1");
- VectorizationContext vc = new VectorizationContext(columns);
+ VectorizationContext vc = new VectorizationContext("name", columns);
VectorExpression ve = vc.getVectorExpression(negExprDesc, VectorExpressionDescriptor.Mode.PROJECTION);
@@ -787,7 +787,7 @@ public class TestVectorizationContext {
List<String> columns = new ArrayList<String>();
columns.add("a");
- VectorizationContext vc = new VectorizationContext(columns);
+ VectorizationContext vc = new VectorizationContext("name", columns);
VectorExpression ve = vc.getVectorExpression(scalarGreaterColExpr, VectorExpressionDescriptor.Mode.FILTER);
assertEquals(FilterLongScalarGreaterLongColumn.class, ve.getClass());
}
@@ -810,7 +810,7 @@ public class TestVectorizationContext {
List<String> columns = new ArrayList<String>();
columns.add("a");
- VectorizationContext vc = new VectorizationContext(columns);
+ VectorizationContext vc = new VectorizationContext("name", columns);
VectorExpression ve = vc.getVectorExpression(colEqualScalar, VectorExpressionDescriptor.Mode.FILTER);
assertEquals(FilterLongColEqualLongScalar.class, ve.getClass());
}
@@ -833,7 +833,7 @@ public class TestVectorizationContext {
List<String> columns = new ArrayList<String>();
columns.add("a");
- VectorizationContext vc = new VectorizationContext(columns);
+ VectorizationContext vc = new VectorizationContext("name", columns);
VectorExpression ve = vc.getVectorExpression(colEqualScalar, VectorExpressionDescriptor.Mode.PROJECTION);
assertEquals(LongColEqualLongScalar.class, ve.getClass());
}
@@ -850,7 +850,7 @@ public class TestVectorizationContext {
List<String> columns = new ArrayList<String>();
columns.add("b");
columns.add("a");
- VectorizationContext vc = new VectorizationContext(columns);
+ VectorizationContext vc = new VectorizationContext("name", columns);
GenericUDF stringLower = new GenericUDFLower();
stringUnary.setGenericUDF(stringLower);
@@ -860,7 +860,7 @@ public class TestVectorizationContext {
assertEquals(1, ((StringLower) ve).getColNum());
assertEquals(2, ((StringLower) ve).getOutputColumn());
- vc = new VectorizationContext(columns);
+ vc = new VectorizationContext("name", columns);
ExprNodeGenericFuncDesc anotherUnary = new ExprNodeGenericFuncDesc();
anotherUnary.setTypeInfo(TypeInfoFactory.stringTypeInfo);
@@ -895,7 +895,7 @@ public class TestVectorizationContext {
List<String> columns = new ArrayList<String>();
columns.add("b");
columns.add("a");
- VectorizationContext vc = new VectorizationContext(columns);
+ VectorizationContext vc = new VectorizationContext("name", columns);
// Sin(double)
GenericUDFBridge gudfBridge = new GenericUDFBridge("sin", false, UDFSin.class.getName());
@@ -986,7 +986,7 @@ public class TestVectorizationContext {
List<String> columns = new ArrayList<String>();
columns.add("b");
columns.add("a");
- VectorizationContext vc = new VectorizationContext(columns);
+ VectorizationContext vc = new VectorizationContext("name", columns);
//UDFYear
GenericUDFBridge gudfBridge = new GenericUDFBridge("year", false, UDFYear.class.getName());
@@ -1024,7 +1024,7 @@ public class TestVectorizationContext {
columns.add("col0");
columns.add("col1");
columns.add("col2");
- VectorizationContext vc = new VectorizationContext(columns);
+ VectorizationContext vc = new VectorizationContext("name", columns);
VectorExpression ve = vc.getVectorExpression(exprDesc, VectorExpressionDescriptor.Mode.FILTER);
assertTrue(ve instanceof FilterStringColumnBetween);
@@ -1050,7 +1050,7 @@ public class TestVectorizationContext {
exprDesc = new ExprNodeGenericFuncDesc(TypeInfoFactory.booleanTypeInfo, udf,
children1);
- vc = new VectorizationContext(columns);
+ vc = new VectorizationContext("name", columns);
ve = vc.getVectorExpression(exprDesc, VectorExpressionDescriptor.Mode.FILTER);
assertTrue(ve instanceof FilterCharColumnBetween);
@@ -1075,7 +1075,7 @@ public class TestVectorizationContext {
exprDesc = new ExprNodeGenericFuncDesc(TypeInfoFactory.booleanTypeInfo, udf,
children1);
- vc = new VectorizationContext(columns);
+ vc = new VectorizationContext("name", columns);
ve = vc.getVectorExpression(exprDesc, VectorExpressionDescriptor.Mode.FILTER);
assertTrue(ve instanceof FilterVarCharColumnBetween);
@@ -1144,7 +1144,7 @@ public class TestVectorizationContext {
columns.add("col0");
columns.add("col1");
columns.add("col2");
- VectorizationContext vc = new VectorizationContext(columns);
+ VectorizationContext vc = new VectorizationContext("name", columns);
VectorExpression ve = vc.getVectorExpression(exprDesc, VectorExpressionDescriptor.Mode.FILTER);
assertTrue(ve instanceof FilterStringColumnInList);
ve = vc.getVectorExpression(exprDesc, VectorExpressionDescriptor.Mode.PROJECTION);
@@ -1199,7 +1199,7 @@ public class TestVectorizationContext {
columns.add("col1");
columns.add("col2");
columns.add("col3");
- VectorizationContext vc = new VectorizationContext(columns);
+ VectorizationContext vc = new VectorizationContext("name", columns);
VectorExpression ve = vc.getVectorExpression(exprDesc);
assertTrue(ve instanceof IfExprLongColumnLongColumn);
Modified: hive/trunk/ql/src/test/org/apache/hadoop/hive/ql/io/orc/TestInputOutputFormat.java
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/org/apache/hadoop/hive/ql/io/orc/TestInputOutputFormat.java?rev=1673337&r1=1673336&r2=1673337&view=diff
==============================================================================
--- hive/trunk/ql/src/test/org/apache/hadoop/hive/ql/io/orc/TestInputOutputFormat.java (original)
+++ hive/trunk/ql/src/test/org/apache/hadoop/hive/ql/io/orc/TestInputOutputFormat.java Tue Apr 14 01:59:29 2015
@@ -1288,9 +1288,6 @@ public class TestInputOutputFormat {
}
mapWork.setPathToAliases(aliasMap);
mapWork.setPathToPartitionInfo(partMap);
- mapWork.setAllColumnVectorMaps(new HashMap<String, Map<String, Integer>>());
- mapWork.setAllScratchColumnVectorTypeMaps(new HashMap<String,
- Map<Integer, String>>());
// write the plan out
FileSystem localFs = FileSystem.getLocal(conf).getRaw();
Modified: hive/trunk/ql/src/test/org/apache/hadoop/hive/ql/optimizer/physical/TestVectorizer.java
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/org/apache/hadoop/hive/ql/optimizer/physical/TestVectorizer.java?rev=1673337&r1=1673336&r2=1673337&view=diff
==============================================================================
--- hive/trunk/ql/src/test/org/apache/hadoop/hive/ql/optimizer/physical/TestVectorizer.java (original)
+++ hive/trunk/ql/src/test/org/apache/hadoop/hive/ql/optimizer/physical/TestVectorizer.java Tue Apr 14 01:59:29 2015
@@ -52,7 +52,7 @@ public class TestVectorizer {
columns.add("col3");
//Generate vectorized expression
- vContext = new VectorizationContext(columns);
+ vContext = new VectorizationContext("name", columns);
}
@Description(name = "fake", value = "FAKE")
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/vector_aggregate_9.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/vector_aggregate_9.q.out?rev=1673337&r1=1673336&r2=1673337&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/vector_aggregate_9.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/vector_aggregate_9.q.out Tue Apr 14 01:59:29 2015
@@ -144,17 +144,13 @@ STAGE PLANS:
mode: mergepartial
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 1 Data size: 448 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: decimal(38,18)), _col1 (type: decimal(38,18)), _col2 (type: decimal(38,18)), _col3 (type: decimal(38,18))
- outputColumnNames: _col0, _col1, _col2, _col3
+ File Output Operator
+ compressed: false
Statistics: Num rows: 1 Data size: 448 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 1 Data size: 448 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Stage: Stage-0
Fetch Operator
@@ -170,4 +166,4 @@ POSTHOOK: query: select min(dc), max(dc)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@vectortab2korc
#### A masked pattern was here ####
--4997414117561.546875 4994550248722.298828 -10252745435816.024410 -5399023399.587163986308583465
+-4997414117561.546875 4994550248722.298828 -10252745435816.02441 -5399023399.587163986308583465
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/vector_char_2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/vector_char_2.q.out?rev=1673337&r1=1673336&r2=1673337&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/vector_char_2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/vector_char_2.q.out Tue Apr 14 01:59:29 2015
@@ -77,12 +77,12 @@ STAGE PLANS:
alias: char_2
Statistics: Num rows: 500 Data size: 99000 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: value (type: char(20)), key (type: char(10))
- outputColumnNames: value, key
+ expressions: value (type: char(20)), UDFToInteger(key) (type: int)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 500 Data size: 99000 Basic stats: COMPLETE Column stats: NONE
Group By Operator
- aggregations: sum(UDFToInteger(key)), count()
- keys: value (type: char(20))
+ aggregations: sum(_col1), count()
+ keys: _col0 (type: char(20))
mode: hash
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 500 Data size: 99000 Basic stats: COMPLETE Column stats: NONE
@@ -101,15 +101,11 @@ STAGE PLANS:
mode: mergepartial
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 250 Data size: 49500 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: char(20)), _col1 (type: bigint), _col2 (type: bigint)
- outputColumnNames: _col0, _col1, _col2
+ Reduce Output Operator
+ key expressions: _col0 (type: char(20))
+ sort order: +
Statistics: Num rows: 250 Data size: 49500 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- key expressions: _col0 (type: char(20))
- sort order: +
- Statistics: Num rows: 250 Data size: 49500 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: bigint), _col2 (type: bigint)
+ value expressions: _col1 (type: bigint), _col2 (type: bigint)
Execution mode: vectorized
Reducer 3
Reduce Operator Tree:
@@ -209,12 +205,12 @@ STAGE PLANS:
alias: char_2
Statistics: Num rows: 500 Data size: 99000 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: value (type: char(20)), key (type: char(10))
- outputColumnNames: value, key
+ expressions: value (type: char(20)), UDFToInteger(key) (type: int)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 500 Data size: 99000 Basic stats: COMPLETE Column stats: NONE
Group By Operator
- aggregations: sum(UDFToInteger(key)), count()
- keys: value (type: char(20))
+ aggregations: sum(_col1), count()
+ keys: _col0 (type: char(20))
mode: hash
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 500 Data size: 99000 Basic stats: COMPLETE Column stats: NONE
@@ -233,15 +229,11 @@ STAGE PLANS:
mode: mergepartial
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 250 Data size: 49500 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: char(20)), _col1 (type: bigint), _col2 (type: bigint)
- outputColumnNames: _col0, _col1, _col2
+ Reduce Output Operator
+ key expressions: _col0 (type: char(20))
+ sort order: -
Statistics: Num rows: 250 Data size: 49500 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- key expressions: _col0 (type: char(20))
- sort order: -
- Statistics: Num rows: 250 Data size: 49500 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: bigint), _col2 (type: bigint)
+ value expressions: _col1 (type: bigint), _col2 (type: bigint)
Execution mode: vectorized
Reducer 3
Reduce Operator Tree:
Added: hive/trunk/ql/src/test/results/clientpositive/tez/vector_date_1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/vector_date_1.q.out?rev=1673337&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/vector_date_1.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/vector_date_1.q.out Tue Apr 14 01:59:29 2015
@@ -0,0 +1,719 @@
+PREHOOK: query: drop table if exists vector_date_1
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table if exists vector_date_1
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table vector_date_1 (dt1 date, dt2 date) stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@vector_date_1
+POSTHOOK: query: create table vector_date_1 (dt1 date, dt2 date) stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@vector_date_1
+PREHOOK: query: insert into table vector_date_1
+ select null, null from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@vector_date_1
+POSTHOOK: query: insert into table vector_date_1
+ select null, null from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@vector_date_1
+POSTHOOK: Lineage: vector_date_1.dt1 EXPRESSION []
+POSTHOOK: Lineage: vector_date_1.dt2 EXPRESSION []
+PREHOOK: query: insert into table vector_date_1
+ select date '1999-12-31', date '2000-01-01' from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@vector_date_1
+POSTHOOK: query: insert into table vector_date_1
+ select date '1999-12-31', date '2000-01-01' from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@vector_date_1
+POSTHOOK: Lineage: vector_date_1.dt1 SIMPLE []
+POSTHOOK: Lineage: vector_date_1.dt2 SIMPLE []
+PREHOOK: query: insert into table vector_date_1
+ select date '2001-01-01', date '2001-06-01' from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@vector_date_1
+POSTHOOK: query: insert into table vector_date_1
+ select date '2001-01-01', date '2001-06-01' from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@vector_date_1
+POSTHOOK: Lineage: vector_date_1.dt1 SIMPLE []
+POSTHOOK: Lineage: vector_date_1.dt2 SIMPLE []
+PREHOOK: query: -- column-to-column comparison in select clause
+explain
+select
+ dt1, dt2,
+ -- should be all true
+ dt1 = dt1,
+ dt1 != dt2,
+ dt1 <= dt1,
+ dt1 <= dt2,
+ dt1 < dt2,
+ dt2 >= dt2,
+ dt2 >= dt1,
+ dt2 > dt1
+from vector_date_1 order by dt1
+PREHOOK: type: QUERY
+POSTHOOK: query: -- column-to-column comparison in select clause
+explain
+select
+ dt1, dt2,
+ -- should be all true
+ dt1 = dt1,
+ dt1 != dt2,
+ dt1 <= dt1,
+ dt1 <= dt2,
+ dt1 < dt2,
+ dt2 >= dt2,
+ dt2 >= dt1,
+ dt2 > dt1
+from vector_date_1 order by dt1
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Tez
+ Edges:
+ Reducer 2 <- Map 1 (SIMPLE_EDGE)
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: vector_date_1
+ Statistics: Num rows: 3 Data size: 224 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: dt1 (type: date), dt2 (type: date), (dt1 = dt1) (type: boolean), (dt1 <> dt2) (type: boolean), (dt1 <= dt1) (type: boolean), (dt1 <= dt2) (type: boolean), (dt1 < dt2) (type: boolean), (dt2 >= dt2) (type: boolean), (dt2 >= dt1) (type: boolean), (dt2 > dt1) (type: boolean)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
+ Statistics: Num rows: 3 Data size: 224 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: _col0 (type: date)
+ sort order: +
+ Statistics: Num rows: 3 Data size: 224 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col1 (type: date), _col2 (type: boolean), _col3 (type: boolean), _col4 (type: boolean), _col5 (type: boolean), _col6 (type: boolean), _col7 (type: boolean), _col8 (type: boolean), _col9 (type: boolean)
+ Execution mode: vectorized
+ Reducer 2
+ Reduce Operator Tree:
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: date), VALUE._col0 (type: date), VALUE._col1 (type: boolean), VALUE._col2 (type: boolean), VALUE._col3 (type: boolean), VALUE._col4 (type: boolean), VALUE._col5 (type: boolean), VALUE._col6 (type: boolean), VALUE._col7 (type: boolean), VALUE._col8 (type: boolean)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
+ Statistics: Num rows: 3 Data size: 224 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 3 Data size: 224 Basic stats: COMPLETE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ Execution mode: vectorized
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
+PREHOOK: query: select
+ dt1, dt2,
+ -- should be all true
+ dt1 = dt1,
+ dt1 != dt2,
+ dt1 <= dt1,
+ dt1 <= dt2,
+ dt1 < dt2,
+ dt2 >= dt2,
+ dt2 >= dt1,
+ dt2 > dt1
+from vector_date_1 order by dt1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@vector_date_1
+#### A masked pattern was here ####
+POSTHOOK: query: select
+ dt1, dt2,
+ -- should be all true
+ dt1 = dt1,
+ dt1 != dt2,
+ dt1 <= dt1,
+ dt1 <= dt2,
+ dt1 < dt2,
+ dt2 >= dt2,
+ dt2 >= dt1,
+ dt2 > dt1
+from vector_date_1 order by dt1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@vector_date_1
+#### A masked pattern was here ####
+NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
+1999-12-31 2000-01-01 true true true true true true true true
+2001-01-01 2001-06-01 true true true true true true true true
+PREHOOK: query: explain
+select
+ dt1, dt2,
+ -- should be all false
+ dt1 != dt1,
+ dt1 = dt2,
+ dt1 < dt1,
+ dt1 >= dt2,
+ dt1 > dt2,
+ dt2 > dt2,
+ dt2 <= dt1,
+ dt2 < dt1
+from vector_date_1 order by dt1
+PREHOOK: type: QUERY
+POSTHOOK: query: explain
+select
+ dt1, dt2,
+ -- should be all false
+ dt1 != dt1,
+ dt1 = dt2,
+ dt1 < dt1,
+ dt1 >= dt2,
+ dt1 > dt2,
+ dt2 > dt2,
+ dt2 <= dt1,
+ dt2 < dt1
+from vector_date_1 order by dt1
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Tez
+ Edges:
+ Reducer 2 <- Map 1 (SIMPLE_EDGE)
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: vector_date_1
+ Statistics: Num rows: 3 Data size: 224 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: dt1 (type: date), dt2 (type: date), (dt1 <> dt1) (type: boolean), (dt1 = dt2) (type: boolean), (dt1 < dt1) (type: boolean), (dt1 >= dt2) (type: boolean), (dt1 > dt2) (type: boolean), (dt2 > dt2) (type: boolean), (dt2 <= dt1) (type: boolean), (dt2 < dt1) (type: boolean)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
+ Statistics: Num rows: 3 Data size: 224 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: _col0 (type: date)
+ sort order: +
+ Statistics: Num rows: 3 Data size: 224 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col1 (type: date), _col2 (type: boolean), _col3 (type: boolean), _col4 (type: boolean), _col5 (type: boolean), _col6 (type: boolean), _col7 (type: boolean), _col8 (type: boolean), _col9 (type: boolean)
+ Execution mode: vectorized
+ Reducer 2
+ Reduce Operator Tree:
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: date), VALUE._col0 (type: date), VALUE._col1 (type: boolean), VALUE._col2 (type: boolean), VALUE._col3 (type: boolean), VALUE._col4 (type: boolean), VALUE._col5 (type: boolean), VALUE._col6 (type: boolean), VALUE._col7 (type: boolean), VALUE._col8 (type: boolean)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9
+ Statistics: Num rows: 3 Data size: 224 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 3 Data size: 224 Basic stats: COMPLETE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ Execution mode: vectorized
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
+PREHOOK: query: select
+ dt1, dt2,
+ -- should be all false
+ dt1 != dt1,
+ dt1 = dt2,
+ dt1 < dt1,
+ dt1 >= dt2,
+ dt1 > dt2,
+ dt2 > dt2,
+ dt2 <= dt1,
+ dt2 < dt1
+from vector_date_1 order by dt1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@vector_date_1
+#### A masked pattern was here ####
+POSTHOOK: query: select
+ dt1, dt2,
+ -- should be all false
+ dt1 != dt1,
+ dt1 = dt2,
+ dt1 < dt1,
+ dt1 >= dt2,
+ dt1 > dt2,
+ dt2 > dt2,
+ dt2 <= dt1,
+ dt2 < dt1
+from vector_date_1 order by dt1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@vector_date_1
+#### A masked pattern was here ####
+NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
+1999-12-31 2000-01-01 false false false false false false false false
+2001-01-01 2001-06-01 false false false false false false false false
+PREHOOK: query: -- column-to-literal/literal-to-column comparison in select clause
+explain
+select
+ dt1,
+ -- should be all true
+ dt1 != date '1970-01-01',
+ dt1 >= date '1970-01-01',
+ dt1 > date '1970-01-01',
+ dt1 <= date '2100-01-01',
+ dt1 < date '2100-01-01',
+ date '1970-01-01' != dt1,
+ date '1970-01-01' <= dt1,
+ date '1970-01-01' < dt1
+from vector_date_1 order by dt1
+PREHOOK: type: QUERY
+POSTHOOK: query: -- column-to-literal/literal-to-column comparison in select clause
+explain
+select
+ dt1,
+ -- should be all true
+ dt1 != date '1970-01-01',
+ dt1 >= date '1970-01-01',
+ dt1 > date '1970-01-01',
+ dt1 <= date '2100-01-01',
+ dt1 < date '2100-01-01',
+ date '1970-01-01' != dt1,
+ date '1970-01-01' <= dt1,
+ date '1970-01-01' < dt1
+from vector_date_1 order by dt1
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Tez
+ Edges:
+ Reducer 2 <- Map 1 (SIMPLE_EDGE)
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: vector_date_1
+ Statistics: Num rows: 3 Data size: 224 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: dt1 (type: date), (dt1 <> 1970-01-01) (type: boolean), (dt1 >= 1970-01-01) (type: boolean), (dt1 > 1970-01-01) (type: boolean), (dt1 <= 2100-01-01) (type: boolean), (dt1 < 2100-01-01) (type: boolean), (1970-01-01 <> dt1) (type: boolean), (1970-01-01 <= dt1) (type: boolean), (1970-01-01 < dt1) (type: boolean)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
+ Statistics: Num rows: 3 Data size: 224 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: _col0 (type: date)
+ sort order: +
+ Statistics: Num rows: 3 Data size: 224 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col1 (type: boolean), _col2 (type: boolean), _col3 (type: boolean), _col4 (type: boolean), _col5 (type: boolean), _col6 (type: boolean), _col7 (type: boolean), _col8 (type: boolean)
+ Execution mode: vectorized
+ Reducer 2
+ Reduce Operator Tree:
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: date), VALUE._col0 (type: boolean), VALUE._col1 (type: boolean), VALUE._col2 (type: boolean), VALUE._col3 (type: boolean), VALUE._col4 (type: boolean), VALUE._col5 (type: boolean), VALUE._col6 (type: boolean), VALUE._col7 (type: boolean)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
+ Statistics: Num rows: 3 Data size: 224 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 3 Data size: 224 Basic stats: COMPLETE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ Execution mode: vectorized
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
+PREHOOK: query: select
+ dt1,
+ -- should be all true
+ dt1 != date '1970-01-01',
+ dt1 >= date '1970-01-01',
+ dt1 > date '1970-01-01',
+ dt1 <= date '2100-01-01',
+ dt1 < date '2100-01-01',
+ date '1970-01-01' != dt1,
+ date '1970-01-01' <= dt1,
+ date '1970-01-01' < dt1
+from vector_date_1 order by dt1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@vector_date_1
+#### A masked pattern was here ####
+POSTHOOK: query: select
+ dt1,
+ -- should be all true
+ dt1 != date '1970-01-01',
+ dt1 >= date '1970-01-01',
+ dt1 > date '1970-01-01',
+ dt1 <= date '2100-01-01',
+ dt1 < date '2100-01-01',
+ date '1970-01-01' != dt1,
+ date '1970-01-01' <= dt1,
+ date '1970-01-01' < dt1
+from vector_date_1 order by dt1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@vector_date_1
+#### A masked pattern was here ####
+NULL NULL NULL NULL NULL NULL NULL NULL NULL
+1999-12-31 true true true true true true true true
+2001-01-01 true true true true true true true true
+PREHOOK: query: explain
+select
+ dt1,
+ -- should all be false
+ dt1 = date '1970-01-01',
+ dt1 <= date '1970-01-01',
+ dt1 < date '1970-01-01',
+ dt1 >= date '2100-01-01',
+ dt1 > date '2100-01-01',
+ date '1970-01-01' = dt1,
+ date '1970-01-01' >= dt1,
+ date '1970-01-01' > dt1
+from vector_date_1 order by dt1
+PREHOOK: type: QUERY
+POSTHOOK: query: explain
+select
+ dt1,
+ -- should all be false
+ dt1 = date '1970-01-01',
+ dt1 <= date '1970-01-01',
+ dt1 < date '1970-01-01',
+ dt1 >= date '2100-01-01',
+ dt1 > date '2100-01-01',
+ date '1970-01-01' = dt1,
+ date '1970-01-01' >= dt1,
+ date '1970-01-01' > dt1
+from vector_date_1 order by dt1
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Tez
+ Edges:
+ Reducer 2 <- Map 1 (SIMPLE_EDGE)
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: vector_date_1
+ Statistics: Num rows: 3 Data size: 224 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: dt1 (type: date), (dt1 = 1970-01-01) (type: boolean), (dt1 <= 1970-01-01) (type: boolean), (dt1 < 1970-01-01) (type: boolean), (dt1 >= 2100-01-01) (type: boolean), (dt1 > 2100-01-01) (type: boolean), (1970-01-01 = dt1) (type: boolean), (1970-01-01 >= dt1) (type: boolean), (1970-01-01 > dt1) (type: boolean)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
+ Statistics: Num rows: 3 Data size: 224 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ key expressions: _col0 (type: date)
+ sort order: +
+ Statistics: Num rows: 3 Data size: 224 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col1 (type: boolean), _col2 (type: boolean), _col3 (type: boolean), _col4 (type: boolean), _col5 (type: boolean), _col6 (type: boolean), _col7 (type: boolean), _col8 (type: boolean)
+ Execution mode: vectorized
+ Reducer 2
+ Reduce Operator Tree:
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: date), VALUE._col0 (type: boolean), VALUE._col1 (type: boolean), VALUE._col2 (type: boolean), VALUE._col3 (type: boolean), VALUE._col4 (type: boolean), VALUE._col5 (type: boolean), VALUE._col6 (type: boolean), VALUE._col7 (type: boolean)
+ outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
+ Statistics: Num rows: 3 Data size: 224 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 3 Data size: 224 Basic stats: COMPLETE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ Execution mode: vectorized
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
+PREHOOK: query: select
+ dt1,
+ -- should all be false
+ dt1 = date '1970-01-01',
+ dt1 <= date '1970-01-01',
+ dt1 < date '1970-01-01',
+ dt1 >= date '2100-01-01',
+ dt1 > date '2100-01-01',
+ date '1970-01-01' = dt1,
+ date '1970-01-01' >= dt1,
+ date '1970-01-01' > dt1
+from vector_date_1 order by dt1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@vector_date_1
+#### A masked pattern was here ####
+POSTHOOK: query: select
+ dt1,
+ -- should all be false
+ dt1 = date '1970-01-01',
+ dt1 <= date '1970-01-01',
+ dt1 < date '1970-01-01',
+ dt1 >= date '2100-01-01',
+ dt1 > date '2100-01-01',
+ date '1970-01-01' = dt1,
+ date '1970-01-01' >= dt1,
+ date '1970-01-01' > dt1
+from vector_date_1 order by dt1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@vector_date_1
+#### A masked pattern was here ####
+NULL NULL NULL NULL NULL NULL NULL NULL NULL
+1999-12-31 false false false false false false false false
+2001-01-01 false false false false false false false false
+PREHOOK: query: -- column-to-column comparisons in predicate
+-- all rows with non-null dt1 should be returned
+explain
+select
+ dt1, dt2
+from vector_date_1
+where
+ dt1 = dt1
+ and dt1 != dt2
+ and dt1 < dt2
+ and dt1 <= dt2
+ and dt2 > dt1
+ and dt2 >= dt1
+order by dt1
+PREHOOK: type: QUERY
+POSTHOOK: query: -- column-to-column comparisons in predicate
+-- all rows with non-null dt1 should be returned
+explain
+select
+ dt1, dt2
+from vector_date_1
+where
+ dt1 = dt1
+ and dt1 != dt2
+ and dt1 < dt2
+ and dt1 <= dt2
+ and dt2 > dt1
+ and dt2 >= dt1
+order by dt1
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Tez
+ Edges:
+ Reducer 2 <- Map 1 (SIMPLE_EDGE)
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: vector_date_1
+ Statistics: Num rows: 3 Data size: 224 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: ((((((dt1 = dt1) and (dt1 <> dt2)) and (dt1 < dt2)) and (dt1 <= dt2)) and (dt2 > dt1)) and (dt2 >= dt1)) (type: boolean)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Select Operator
+ expressions: dt1 (type: date), dt2 (type: date)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Reduce Output Operator
+ key expressions: _col0 (type: date)
+ sort order: +
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ value expressions: _col1 (type: date)
+ Execution mode: vectorized
+ Reducer 2
+ Reduce Operator Tree:
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: date), VALUE._col0 (type: date)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ Execution mode: vectorized
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
+PREHOOK: query: select
+ dt1, dt2
+from vector_date_1
+where
+ dt1 = dt1
+ and dt1 != dt2
+ and dt1 < dt2
+ and dt1 <= dt2
+ and dt2 > dt1
+ and dt2 >= dt1
+order by dt1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@vector_date_1
+#### A masked pattern was here ####
+POSTHOOK: query: select
+ dt1, dt2
+from vector_date_1
+where
+ dt1 = dt1
+ and dt1 != dt2
+ and dt1 < dt2
+ and dt1 <= dt2
+ and dt2 > dt1
+ and dt2 >= dt1
+order by dt1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@vector_date_1
+#### A masked pattern was here ####
+1999-12-31 2000-01-01
+2001-01-01 2001-06-01
+PREHOOK: query: -- column-to-literal/literal-to-column comparison in predicate
+-- only a single row should be returned
+explain
+select
+ dt1, dt2
+from vector_date_1
+where
+ dt1 = date '2001-01-01'
+ and date '2001-01-01' = dt1
+ and dt1 != date '1970-01-01'
+ and date '1970-01-01' != dt1
+ and dt1 > date '1970-01-01'
+ and dt1 >= date '1970-01-01'
+ and date '1970-01-01' < dt1
+ and date '1970-01-01' <= dt1
+order by dt1
+PREHOOK: type: QUERY
+POSTHOOK: query: -- column-to-literal/literal-to-column comparison in predicate
+-- only a single row should be returned
+explain
+select
+ dt1, dt2
+from vector_date_1
+where
+ dt1 = date '2001-01-01'
+ and date '2001-01-01' = dt1
+ and dt1 != date '1970-01-01'
+ and date '1970-01-01' != dt1
+ and dt1 > date '1970-01-01'
+ and dt1 >= date '1970-01-01'
+ and date '1970-01-01' < dt1
+ and date '1970-01-01' <= dt1
+order by dt1
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Tez
+ Edges:
+ Reducer 2 <- Map 1 (SIMPLE_EDGE)
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: vector_date_1
+ Statistics: Num rows: 3 Data size: 224 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: ((((((((dt1 = 2001-01-01) and (2001-01-01 = dt1)) and (dt1 <> 1970-01-01)) and (1970-01-01 <> dt1)) and (dt1 > 1970-01-01)) and (dt1 >= 1970-01-01)) and (1970-01-01 < dt1)) and (1970-01-01 <= dt1)) (type: boolean)
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Select Operator
+ expressions: dt2 (type: date)
+ outputColumnNames: _col1
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Reduce Output Operator
+ key expressions: 2001-01-01 (type: date)
+ sort order: +
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ value expressions: _col1 (type: date)
+ Execution mode: vectorized
+ Reducer 2
+ Reduce Operator Tree:
+ Select Operator
+ expressions: 2001-01-01 (type: date), VALUE._col0 (type: date)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ Execution mode: vectorized
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
+PREHOOK: query: select
+ dt1, dt2
+from vector_date_1
+where
+ dt1 = date '2001-01-01'
+ and date '2001-01-01' = dt1
+ and dt1 != date '1970-01-01'
+ and date '1970-01-01' != dt1
+ and dt1 > date '1970-01-01'
+ and dt1 >= date '1970-01-01'
+ and date '1970-01-01' < dt1
+ and date '1970-01-01' <= dt1
+order by dt1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@vector_date_1
+#### A masked pattern was here ####
+POSTHOOK: query: select
+ dt1, dt2
+from vector_date_1
+where
+ dt1 = date '2001-01-01'
+ and date '2001-01-01' = dt1
+ and dt1 != date '1970-01-01'
+ and date '1970-01-01' != dt1
+ and dt1 > date '1970-01-01'
+ and dt1 >= date '1970-01-01'
+ and date '1970-01-01' < dt1
+ and date '1970-01-01' <= dt1
+order by dt1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@vector_date_1
+#### A masked pattern was here ####
+2001-01-01 2001-06-01
+PREHOOK: query: drop table vector_date_1
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@vector_date_1
+PREHOOK: Output: default@vector_date_1
+POSTHOOK: query: drop table vector_date_1
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@vector_date_1
+POSTHOOK: Output: default@vector_date_1
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/vector_decimal_round.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/vector_decimal_round.q.out?rev=1673337&r1=1673336&r2=1673337&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/vector_decimal_round.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/vector_decimal_round.q.out Tue Apr 14 01:59:29 2015
@@ -114,18 +114,18 @@ STAGE PLANS:
alias: decimal_tbl_txt
Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: dec (type: decimal(10,0)), round(dec, -1) (type: decimal(11,0))
- outputColumnNames: _col0, _col1
+ expressions: dec (type: decimal(10,0))
+ outputColumnNames: _col0
Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: round(_col0, (- 1)) (type: decimal(11,0))
sort order: +
Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: decimal(10,0)), _col1 (type: decimal(11,0))
+ value expressions: _col0 (type: decimal(10,0))
Reducer 2
Reduce Operator Tree:
Select Operator
- expressions: VALUE._col0 (type: decimal(10,0)), VALUE._col1 (type: decimal(11,0))
+ expressions: VALUE._col0 (type: decimal(10,0)), KEY.reducesinkkey0 (type: decimal(11,0))
outputColumnNames: _col0, _col1
Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -264,18 +264,18 @@ STAGE PLANS:
alias: decimal_tbl_rc
Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: dec (type: decimal(10,0)), round(dec, -1) (type: decimal(11,0))
- outputColumnNames: _col0, _col1
+ expressions: dec (type: decimal(10,0))
+ outputColumnNames: _col0
Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: round(_col0, (- 1)) (type: decimal(11,0))
sort order: +
Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: decimal(10,0)), _col1 (type: decimal(11,0))
+ value expressions: _col0 (type: decimal(10,0))
Reducer 2
Reduce Operator Tree:
Select Operator
- expressions: VALUE._col0 (type: decimal(10,0)), VALUE._col1 (type: decimal(11,0))
+ expressions: VALUE._col0 (type: decimal(10,0)), KEY.reducesinkkey0 (type: decimal(11,0))
outputColumnNames: _col0, _col1
Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -415,19 +415,19 @@ STAGE PLANS:
alias: decimal_tbl_orc
Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: dec (type: decimal(10,0)), round(dec, -1) (type: decimal(11,0))
- outputColumnNames: _col0, _col1
+ expressions: dec (type: decimal(10,0))
+ outputColumnNames: _col0
Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: round(_col0, (- 1)) (type: decimal(11,0))
sort order: +
Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: decimal(10,0)), _col1 (type: decimal(11,0))
+ value expressions: _col0 (type: decimal(10,0))
Execution mode: vectorized
Reducer 2
Reduce Operator Tree:
Select Operator
- expressions: VALUE._col0 (type: decimal(10,0)), VALUE._col1 (type: decimal(11,0))
+ expressions: VALUE._col0 (type: decimal(10,0)), KEY.reducesinkkey0 (type: decimal(11,0))
outputColumnNames: _col0, _col1
Statistics: Num rows: 1 Data size: 112 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/vector_decimal_round_2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/vector_decimal_round_2.q.out?rev=1673337&r1=1673336&r2=1673337&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/vector_decimal_round_2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/vector_decimal_round_2.q.out Tue Apr 14 01:59:29 2015
@@ -121,7 +121,7 @@ FROM decimal_tbl_1_orc ORDER BY d
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_tbl_1_orc
#### A masked pattern was here ####
-55555 55555 55555.0 55555.00 55555.000 55560 55600 56000 60000 100000 0 0 0
+55555 55555 55555 55555 55555 55560 55600 56000 60000 100000 0 0 0
PREHOOK: query: create table decimal_tbl_2_orc (pos decimal(38,18), neg decimal(38,18))
STORED AS ORC
PREHOOK: type: CREATETABLE
@@ -240,7 +240,7 @@ FROM decimal_tbl_2_orc ORDER BY p
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_tbl_2_orc
#### A masked pattern was here ####
-125 125 125.3 125.32 125.315 125.3150 130 100 0 0 -125 -125 -125.3 -125.32 -125.315 -125.3150 -130 -100 0 0
+125 125 125.3 125.32 125.315 125.315 130 100 0 0 -125 -125 -125.3 -125.32 -125.315 -125.315 -130 -100 0 0
PREHOOK: query: create table decimal_tbl_3_orc (dec decimal(38,18))
STORED AS ORC
PREHOOK: type: CREATETABLE
@@ -402,7 +402,7 @@ FROM decimal_tbl_3_orc ORDER BY d
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_tbl_3_orc
#### A masked pattern was here ####
-0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 3.1 3.14 3.142 3.1416 3.14159 3.141593 3.1415927 3.14159265 3.141592654 3.1415926536 3.14159265359 3.141592653590 3.1415926535898 3.1415926535898 3.14159265358979 3.141592653589793 3.1415926535897930
+0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 3.1 3.14 3.142 3.1416 3.14159 3.141593 3.1415927 3.14159265 3.141592654 3.1415926536 3.14159265359 3.14159265359 3.1415926535898 3.1415926535898 3.14159265358979 3.141592653589793 3.141592653589793
PREHOOK: query: create table decimal_tbl_4_orc (pos decimal(38,18), neg decimal(38,18))
STORED AS ORC
PREHOOK: type: CREATETABLE
@@ -457,7 +457,7 @@ STAGE PLANS:
alias: decimal_tbl_4_orc
Statistics: Num rows: 1 Data size: 224 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: round(pos, 9) (type: decimal(30,9)), round(neg, 9) (type: decimal(30,9)), round(1809242.3151111344, 9) (type: decimal(17,9)), round((- 1809242.3151111344), 9) (type: decimal(17,9))
+ expressions: round(pos, 9) (type: decimal(30,9)), round(neg, 9) (type: decimal(30,9)), 1809242.315111134 (type: decimal(17,9)), -1809242.315111134 (type: decimal(17,9))
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 1 Data size: 224 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
@@ -465,6 +465,7 @@ STAGE PLANS:
sort order: +
Statistics: Num rows: 1 Data size: 224 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: decimal(30,9)), _col2 (type: decimal(17,9)), _col3 (type: decimal(17,9))
+ Execution mode: vectorized
Reducer 2
Reduce Operator Tree:
Select Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/vector_if_expr.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/vector_if_expr.q.out?rev=1673337&r1=1673336&r2=1673337&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/vector_if_expr.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/vector_if_expr.q.out Tue Apr 14 01:59:29 2015
@@ -19,18 +19,18 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: alltypesorc
- Statistics: Num rows: 12288 Data size: 377237 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 12288 Data size: 2641964 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (cboolean1 is not null and cboolean1) (type: boolean)
- Statistics: Num rows: 3072 Data size: 94309 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3072 Data size: 660491 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: cboolean1 (type: boolean), if(cboolean1, 'first', 'second') (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 3072 Data size: 94309 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3072 Data size: 660491 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: boolean)
sort order: +
- Statistics: Num rows: 3072 Data size: 94309 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3072 Data size: 660491 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Execution mode: vectorized
Reducer 2
@@ -38,10 +38,10 @@ STAGE PLANS:
Select Operator
expressions: KEY.reducesinkkey0 (type: boolean), VALUE._col0 (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 3072 Data size: 94309 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3072 Data size: 660491 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 3072 Data size: 94309 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 3072 Data size: 660491 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat