Author: prasanthj
Date: Mon Feb 23 09:51:15 2015
New Revision: 1661629
URL: http://svn.apache.org/r1661629
Log:
HIVE-9751: LLAP: Fix issue with reading last row group of string column
(Prasanth Jayachandran)
Added:
hive/branches/llap/ql/src/test/queries/clientpositive/orc_llap2.q
hive/branches/llap/ql/src/test/results/clientpositive/orc_llap2.q.out
Modified:
hive/branches/llap/llap-server/src/java/org/apache/hadoop/hive/llap/io/decode/orc/stream/readers/CharacterStreamReader.java
hive/branches/llap/llap-server/src/java/org/apache/hadoop/hive/llap/io/decode/orc/stream/readers/StringStreamReader.java
hive/branches/llap/llap-server/src/java/org/apache/hadoop/hive/llap/io/encoded/OrcEncodedDataProducer.java
hive/branches/llap/ql/src/java/org/apache/hadoop/hive/ql/io/orc/RecordReaderImpl.java
hive/branches/llap/ql/src/test/queries/clientpositive/orc_llap.q
hive/branches/llap/ql/src/test/results/clientpositive/orc_llap.q.out
Modified:
hive/branches/llap/llap-server/src/java/org/apache/hadoop/hive/llap/io/decode/orc/stream/readers/CharacterStreamReader.java
URL:
http://svn.apache.org/viewvc/hive/branches/llap/llap-server/src/java/org/apache/hadoop/hive/llap/io/decode/orc/stream/readers/CharacterStreamReader.java?rev=1661629&r1=1661628&r2=1661629&view=diff
==============================================================================
---
hive/branches/llap/llap-server/src/java/org/apache/hadoop/hive/llap/io/decode/orc/stream/readers/CharacterStreamReader.java
(original)
+++
hive/branches/llap/llap-server/src/java/org/apache/hadoop/hive/llap/io/decode/orc/stream/readers/CharacterStreamReader.java
Mon Feb 23 09:51:15 2015
@@ -64,7 +64,7 @@ public class CharacterStreamReader exten
if (isFileCompressed) {
index.getNext();
}
- present.seek(index);
+ reader.present.seek(index);
}
if (isDictionaryEncoding) {
Modified:
hive/branches/llap/llap-server/src/java/org/apache/hadoop/hive/llap/io/decode/orc/stream/readers/StringStreamReader.java
URL:
http://svn.apache.org/viewvc/hive/branches/llap/llap-server/src/java/org/apache/hadoop/hive/llap/io/decode/orc/stream/readers/StringStreamReader.java?rev=1661629&r1=1661628&r2=1661629&view=diff
==============================================================================
---
hive/branches/llap/llap-server/src/java/org/apache/hadoop/hive/llap/io/decode/orc/stream/readers/StringStreamReader.java
(original)
+++
hive/branches/llap/llap-server/src/java/org/apache/hadoop/hive/llap/io/decode/orc/stream/readers/StringStreamReader.java
Mon Feb 23 09:51:15 2015
@@ -53,7 +53,7 @@ public class StringStreamReader extends
if (isFileCompressed) {
index.getNext();
}
- present.seek(index);
+ reader.present.seek(index);
}
if (isDictionaryEncoding) {
Modified:
hive/branches/llap/llap-server/src/java/org/apache/hadoop/hive/llap/io/encoded/OrcEncodedDataProducer.java
URL:
http://svn.apache.org/viewvc/hive/branches/llap/llap-server/src/java/org/apache/hadoop/hive/llap/io/encoded/OrcEncodedDataProducer.java?rev=1661629&r1=1661628&r2=1661629&view=diff
==============================================================================
---
hive/branches/llap/llap-server/src/java/org/apache/hadoop/hive/llap/io/encoded/OrcEncodedDataProducer.java
(original)
+++
hive/branches/llap/llap-server/src/java/org/apache/hadoop/hive/llap/io/encoded/OrcEncodedDataProducer.java
Mon Feb 23 09:51:15 2015
@@ -126,7 +126,7 @@ public class OrcEncodedDataProducer impl
metadata = getOrReadFileMetadata();
int bufferSize = metadata.getCompressionBufferSize();
int minAllocSize = HiveConf.getIntVar(conf,
HiveConf.ConfVars.LLAP_ORC_CACHE_MIN_ALLOC);
- if (bufferSize != minAllocSize) {
+ if (bufferSize < minAllocSize) {
throw new IOException("ORC compression buffer size (" + bufferSize +
") is smaller than" +
" LLAP low-level cache minimum allocation size (" + minAllocSize
+ "). Decrease the" +
" value for " +
HiveConf.ConfVars.LLAP_ORC_CACHE_MIN_ALLOC.toString());
Modified:
hive/branches/llap/ql/src/java/org/apache/hadoop/hive/ql/io/orc/RecordReaderImpl.java
URL:
http://svn.apache.org/viewvc/hive/branches/llap/ql/src/java/org/apache/hadoop/hive/ql/io/orc/RecordReaderImpl.java?rev=1661629&r1=1661628&r2=1661629&view=diff
==============================================================================
---
hive/branches/llap/ql/src/java/org/apache/hadoop/hive/ql/io/orc/RecordReaderImpl.java
(original)
+++
hive/branches/llap/ql/src/java/org/apache/hadoop/hive/ql/io/orc/RecordReaderImpl.java
Mon Feb 23 09:51:15 2015
@@ -262,7 +262,7 @@ public class RecordReaderImpl implements
public abstract static class TreeReader {
protected final int columnId;
- protected BitFieldReader present = null;
+ public BitFieldReader present = null;
protected boolean valuePresent = false;
public TreeReader(int columnId) throws IOException {
Modified: hive/branches/llap/ql/src/test/queries/clientpositive/orc_llap.q
URL:
http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/queries/clientpositive/orc_llap.q?rev=1661629&r1=1661628&r2=1661629&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/queries/clientpositive/orc_llap.q (original)
+++ hive/branches/llap/ql/src/test/queries/clientpositive/orc_llap.q Mon Feb 23
09:51:15 2015
@@ -38,5 +38,7 @@ from alltypesorc cross join cross_number
select count(*) from orc_llap;
SET hive.llap.io.enabled=true;
-
-select cint, csmallint, cbigint from orc_llap where cint > 10 and cbigint is
not null order by cbigint limit 1000;
+select sum(hash(*)) from (select cint, csmallint, cbigint from orc_llap where
cint > 10 and cbigint is not null order by cbigint limit 1000) tmp;
+SET hive.llap.io.enabled=false;
+select sum(hash(*)) from (select cint, csmallint, cbigint from orc_llap where
cint > 10 and cbigint is not null order by cbigint limit 1000) tmp;
+
Added: hive/branches/llap/ql/src/test/queries/clientpositive/orc_llap2.q
URL:
http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/queries/clientpositive/orc_llap2.q?rev=1661629&view=auto
==============================================================================
--- hive/branches/llap/ql/src/test/queries/clientpositive/orc_llap2.q (added)
+++ hive/branches/llap/ql/src/test/queries/clientpositive/orc_llap2.q Mon Feb
23 09:51:15 2015
@@ -0,0 +1,43 @@
+SET hive.vectorized.execution.enabled=true;
+
+SET hive.llap.io.enabled=false;
+SET hive.llap.io.cache.orc.arena.size=16777216;
+SET hive.llap.io.cache.orc.size=67108864;
+SET hive.llap.io.cache.orc.alloc.min=32768;
+SET hive.llap.io.use.lrfu=false;
+SET hive.llap.io.cache.direct=false;
+
+SET hive.exec.orc.default.buffer.size=32768;
+SET hive.exec.orc.default.row.index.stride=1000;
+
+CREATE TABLE orc_llap(
+ ctinyint TINYINT,
+ csmallint SMALLINT,
+ cint INT,
+ cbigint BIGINT,
+ cfloat FLOAT,
+ cdouble DOUBLE,
+ cstring1 STRING,
+ cstring2 STRING,
+ ctimestamp1 TIMESTAMP,
+ ctimestamp2 TIMESTAMP,
+ cboolean1 BOOLEAN,
+ cboolean2 BOOLEAN)
+ STORED AS ORC;
+
+create table cross_numbers(i int);
+
+insert into table cross_numbers
+select distinct csmallint
+from alltypesorc where csmallint > 0 order by csmallint limit 10;
+
+insert into table orc_llap
+select ctinyint + i, csmallint + i, cint + i, cbigint + i, cfloat + i, cdouble
+ i, cstring1, cstring2, ctimestamp1, ctimestamp2, cboolean1, cboolean2
+from alltypesorc cross join cross_numbers;
+
+select count(*) from orc_llap;
+
+SET hive.llap.io.enabled=true;
+select sum(hash(*)) from (select * from orc_llap where cint > 10 and cbigint
is not null order by cbigint limit 1000) tmp;
+SET hive.llap.io.enabled=false;
+select sum(hash(*)) from (select * from orc_llap where cint > 10 and cbigint
is not null order by cbigint limit 1000) tmp;
Modified: hive/branches/llap/ql/src/test/results/clientpositive/orc_llap.q.out
URL:
http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/orc_llap.q.out?rev=1661629&r1=1661628&r2=1661629&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/orc_llap.q.out
(original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/orc_llap.q.out Mon
Feb 23 09:51:15 2015
@@ -89,1011 +89,21 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_llap
#### A masked pattern was here ####
122880
-PREHOOK: query: select cint, csmallint, cbigint from orc_llap where cint > 10
and cbigint is not null order by cbigint limit 1000
+PREHOOK: query: select sum(hash(*)) from (select cint, csmallint, cbigint from
orc_llap where cint > 10 and cbigint is not null order by cbigint limit 1000)
tmp
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_llap
#### A masked pattern was here ####
-POSTHOOK: query: select cint, csmallint, cbigint from orc_llap where cint > 10
and cbigint is not null order by cbigint limit 1000
+POSTHOOK: query: select sum(hash(*)) from (select cint, csmallint, cbigint
from orc_llap where cint > 10 and cbigint is not null order by cbigint limit
1000) tmp
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_llap
#### A masked pattern was here ####
-921562736 NULL -2145884698
-921562737 NULL -2145884697
-921562738 NULL -2145884696
-921562739 NULL -2145884695
-921562748 NULL -2145884686
-921562749 NULL -2145884685
-921562754 NULL -2145884680
-921562761 NULL -2145884673
-921562763 NULL -2145884671
-921562766 NULL -2145884668
-977700130 NULL -2144905786
-977700131 NULL -2144905785
-977700132 NULL -2144905784
-977700133 NULL -2144905783
-977700142 NULL -2144905774
-977700143 NULL -2144905773
-977700148 NULL -2144905768
-977700155 NULL -2144905761
-977700157 NULL -2144905759
-977700160 NULL -2144905756
-593251638 NULL -2139708455
-593251639 NULL -2139708454
-593251640 NULL -2139708453
-593251641 NULL -2139708452
-593251650 NULL -2139708443
-593251651 NULL -2139708442
-593251656 NULL -2139708437
-593251663 NULL -2139708430
-593251665 NULL -2139708428
-593251668 NULL -2139708425
-1053814443 NULL -2136196389
-1053814444 NULL -2136196388
-1053814445 NULL -2136196387
-1053814446 NULL -2136196386
-1053814455 NULL -2136196377
-1053814456 NULL -2136196376
-1053814461 NULL -2136196371
-1053814468 NULL -2136196364
-1053814470 NULL -2136196362
-1053814473 NULL -2136196359
-227615593 NULL -2130544860
-227615594 NULL -2130544859
-227615595 NULL -2130544858
-227615596 NULL -2130544857
-227615605 NULL -2130544848
-227615606 NULL -2130544847
-227615611 NULL -2130544842
-227615618 NULL -2130544835
-227615620 NULL -2130544833
-227615623 NULL -2130544830
-504864581 NULL -2125392648
-504864582 NULL -2125392647
-504864583 NULL -2125392646
-504864584 NULL -2125392645
-504864593 NULL -2125392636
-504864594 NULL -2125392635
-504864599 NULL -2125392630
-504864606 NULL -2125392623
-504864608 NULL -2125392621
-504864611 NULL -2125392618
-361778979 NULL -2123011051
-361778980 NULL -2123011050
-361778981 NULL -2123011049
-361778982 NULL -2123011048
-361778991 NULL -2123011039
-361778992 NULL -2123011038
-361778997 NULL -2123011033
-361779004 NULL -2123011026
-361779006 NULL -2123011024
-361779009 NULL -2123011021
-518170433 NULL -2122540522
-518170434 NULL -2122540521
-518170435 NULL -2122540520
-518170436 NULL -2122540519
-518170445 NULL -2122540510
-518170446 NULL -2122540509
-518170451 NULL -2122540504
-518170458 NULL -2122540497
-518170460 NULL -2122540495
-518170463 NULL -2122540492
-98216977 NULL -2119619407
-98216978 NULL -2119619406
-98216979 NULL -2119619405
-98216980 NULL -2119619404
-98216989 NULL -2119619395
-98216990 NULL -2119619394
-98216995 NULL -2119619389
-98217002 NULL -2119619382
-98217004 NULL -2119619380
-98217007 NULL -2119619377
-769189415 NULL -2119162838
-769189416 NULL -2119162837
-769189417 NULL -2119162836
-769189418 NULL -2119162835
-769189427 NULL -2119162826
-769189428 NULL -2119162825
-769189433 NULL -2119162820
-769189440 NULL -2119162813
-769189442 NULL -2119162811
-769189445 NULL -2119162808
-349385767 NULL -2117373364
-349385768 NULL -2117373363
-349385769 NULL -2117373362
-349385770 NULL -2117373361
-349385779 NULL -2117373352
-349385780 NULL -2117373351
-349385785 NULL -2117373346
-349385792 NULL -2117373339
-349385794 NULL -2117373337
-349385797 NULL -2117373334
-757909190 NULL -2117187745
-757909191 NULL -2117187744
-757909192 NULL -2117187743
-757909193 NULL -2117187742
-757909202 NULL -2117187733
-757909203 NULL -2117187732
-757909208 NULL -2117187727
-757909215 NULL -2117187720
-757909217 NULL -2117187718
-757909220 NULL -2117187715
-545201247 NULL -2109755168
-545201248 NULL -2109755167
-545201249 NULL -2109755166
-545201250 NULL -2109755165
-545201259 NULL -2109755156
-545201260 NULL -2109755155
-545201265 NULL -2109755150
-545201272 NULL -2109755143
-545201274 NULL -2109755141
-545201277 NULL -2109755138
-1000909514 NULL -2099539948
-1000909515 NULL -2099539947
-1000909516 NULL -2099539946
-1000909517 NULL -2099539945
-1000909526 NULL -2099539936
-1000909527 NULL -2099539935
-1000909532 NULL -2099539930
-1000909539 NULL -2099539923
-1000909541 NULL -2099539921
-1000909544 NULL -2099539918
-356416567 NULL -2099309296
-356416568 NULL -2099309295
-356416569 NULL -2099309294
-356416570 NULL -2099309293
-356416579 NULL -2099309284
-356416580 NULL -2099309283
-356416585 NULL -2099309278
-356416592 NULL -2099309271
-356416594 NULL -2099309269
-356416597 NULL -2099309266
-403739242 NULL -2098720813
-403739243 NULL -2098720812
-403739244 NULL -2098720811
-403739245 NULL -2098720810
-403739254 NULL -2098720801
-403739255 NULL -2098720800
-403739260 NULL -2098720795
-403739267 NULL -2098720788
-403739269 NULL -2098720786
-403739272 NULL -2098720783
-161945947 NULL -2098450935
-161945948 NULL -2098450934
-161945949 NULL -2098450933
-161945950 NULL -2098450932
-161945959 NULL -2098450923
-161945960 NULL -2098450922
-161945965 NULL -2098450917
-161945972 NULL -2098450910
-161945974 NULL -2098450908
-161945977 NULL -2098450905
-374172527 NULL -2096772370
-374172528 NULL -2096772369
-374172529 NULL -2096772368
-374172530 NULL -2096772367
-374172539 NULL -2096772358
-374172540 NULL -2096772357
-374172545 NULL -2096772352
-374172552 NULL -2096772345
-374172554 NULL -2096772343
-374172557 NULL -2096772340
-51356628 NULL -2090881688
-51356629 NULL -2090881687
-51356630 NULL -2090881686
-51356631 NULL -2090881685
-51356640 NULL -2090881676
-51356641 NULL -2090881675
-51356646 NULL -2090881670
-51356653 NULL -2090881663
-51356655 NULL -2090881661
-51356658 NULL -2090881658
-746020222 NULL -2090192074
-746020223 NULL -2090192073
-746020224 NULL -2090192072
-746020225 NULL -2090192071
-746020234 NULL -2090192062
-746020235 NULL -2090192061
-746020240 NULL -2090192056
-746020247 NULL -2090192049
-746020249 NULL -2090192047
-746020252 NULL -2090192044
-1019277013 NULL -2083819829
-1019277014 NULL -2083819828
-1019277015 NULL -2083819827
-1019277016 NULL -2083819826
-1019277025 NULL -2083819817
-1019277026 NULL -2083819816
-1019277031 NULL -2083819811
-1019277038 NULL -2083819804
-1019277040 NULL -2083819802
-1019277043 NULL -2083819799
-612450114 NULL -2083370936
-612450115 NULL -2083370935
-612450116 NULL -2083370934
-612450117 NULL -2083370933
-612450126 NULL -2083370924
-612450127 NULL -2083370923
-612450132 NULL -2083370918
-612450139 NULL -2083370911
-612450141 NULL -2083370909
-612450144 NULL -2083370906
-586789132 NULL -2079907563
-586789133 NULL -2079907562
-586789134 NULL -2079907561
-586789135 NULL -2079907560
-586789144 NULL -2079907551
-586789145 NULL -2079907550
-586789150 NULL -2079907545
-586789157 NULL -2079907538
-586789159 NULL -2079907536
-586789162 NULL -2079907533
-473005884 NULL -2078031722
-473005885 NULL -2078031721
-473005886 NULL -2078031720
-473005887 NULL -2078031719
-473005896 NULL -2078031710
-473005897 NULL -2078031709
-473005902 NULL -2078031704
-473005909 NULL -2078031697
-473005911 NULL -2078031695
-473005914 NULL -2078031692
-169019478 NULL -2076830111
-169019479 NULL -2076830110
-169019480 NULL -2076830109
-169019481 NULL -2076830108
-169019490 NULL -2076830099
-169019491 NULL -2076830098
-169019496 NULL -2076830093
-169019503 NULL -2076830086
-169019505 NULL -2076830084
-169019508 NULL -2076830081
-266020660 NULL -2075197468
-266020661 NULL -2075197467
-266020662 NULL -2075197466
-266020663 NULL -2075197465
-266020672 NULL -2075197456
-266020673 NULL -2075197455
-266020678 NULL -2075197450
-266020685 NULL -2075197443
-266020687 NULL -2075197441
-266020690 NULL -2075197438
-51219135 NULL -2068271974
-51219136 NULL -2068271973
-51219137 NULL -2068271972
-51219138 NULL -2068271971
-51219147 NULL -2068271962
-51219148 NULL -2068271961
-51219153 NULL -2068271956
-51219160 NULL -2068271949
-51219162 NULL -2068271947
-51219165 NULL -2068271944
-985529176 NULL -2066819044
-985529177 NULL -2066819043
-985529178 NULL -2066819042
-985529179 NULL -2066819041
-985529188 NULL -2066819032
-985529189 NULL -2066819031
-985529194 NULL -2066819026
-985529201 NULL -2066819019
-985529203 NULL -2066819017
-985529206 NULL -2066819014
-202874113 NULL -2063507705
-202874114 NULL -2063507704
-202874115 NULL -2063507703
-202874116 NULL -2063507702
-202874125 NULL -2063507693
-202874126 NULL -2063507692
-202874131 NULL -2063507687
-202874138 NULL -2063507680
-202874140 NULL -2063507678
-202874143 NULL -2063507675
-350384776 NULL -2063125857
-350384777 NULL -2063125856
-350384778 NULL -2063125855
-350384779 NULL -2063125854
-350384788 NULL -2063125845
-350384789 NULL -2063125844
-350384794 NULL -2063125839
-350384801 NULL -2063125832
-350384803 NULL -2063125830
-350384806 NULL -2063125827
-787055815 NULL -2062321880
-787055816 NULL -2062321879
-787055817 NULL -2062321878
-787055818 NULL -2062321877
-787055827 NULL -2062321868
-787055828 NULL -2062321867
-787055833 NULL -2062321862
-787055840 NULL -2062321855
-787055842 NULL -2062321853
-787055845 NULL -2062321850
-205298675 NULL -2059679200
-205298676 NULL -2059679199
-205298677 NULL -2059679198
-205298678 NULL -2059679197
-205298687 NULL -2059679188
-205298688 NULL -2059679187
-205298693 NULL -2059679182
-205298700 NULL -2059679175
-205298702 NULL -2059679173
-205298705 NULL -2059679170
-208372636 NULL -2053631357
-208372637 NULL -2053631356
-208372638 NULL -2053631355
-208372639 NULL -2053631354
-208372648 NULL -2053631345
-208372649 NULL -2053631344
-208372654 NULL -2053631339
-208372661 NULL -2053631332
-208372663 NULL -2053631330
-208372666 NULL -2053631327
-217843447 NULL -2052623043
-217843448 NULL -2052623042
-217843449 NULL -2052623041
-217843450 NULL -2052623040
-217843459 NULL -2052623031
-217843460 NULL -2052623030
-217843465 NULL -2052623025
-217843472 NULL -2052623018
-217843474 NULL -2052623016
-217843477 NULL -2052623013
-896393246 NULL -2040480667
-896393247 NULL -2040480666
-896393248 NULL -2040480665
-896393249 NULL -2040480664
-896393258 NULL -2040480655
-896393259 NULL -2040480654
-896393264 NULL -2040480649
-896393271 NULL -2040480642
-896393273 NULL -2040480640
-896393276 NULL -2040480637
-828625496 NULL -2040118000
-828625497 NULL -2040117999
-828625498 NULL -2040117998
-828625499 NULL -2040117997
-828625508 NULL -2040117988
-828625509 NULL -2040117987
-828625514 NULL -2040117982
-828625521 NULL -2040117975
-828625523 NULL -2040117973
-828625526 NULL -2040117970
-646295042 NULL -2039050323
-646295043 NULL -2039050322
-646295044 NULL -2039050321
-646295045 NULL -2039050320
-646295054 NULL -2039050311
-646295055 NULL -2039050310
-646295060 NULL -2039050305
-646295067 NULL -2039050298
-646295069 NULL -2039050296
-646295072 NULL -2039050293
-909725258 NULL -2037667308
-909725259 NULL -2037667307
-909725260 NULL -2037667306
-909725261 NULL -2037667305
-909725270 NULL -2037667296
-909725271 NULL -2037667295
-909725276 NULL -2037667290
-909725283 NULL -2037667283
-909725285 NULL -2037667281
-909725288 NULL -2037667278
-205146178 NULL -2037365347
-205146179 NULL -2037365346
-205146180 NULL -2037365345
-205146181 NULL -2037365344
-205146190 NULL -2037365335
-205146191 NULL -2037365334
-205146196 NULL -2037365329
-205146203 NULL -2037365322
-205146205 NULL -2037365320
-205146208 NULL -2037365317
-396201416 NULL -2037246363
-396201417 NULL -2037246362
-396201418 NULL -2037246361
-396201419 NULL -2037246360
-396201428 NULL -2037246351
-396201429 NULL -2037246350
-396201434 NULL -2037246345
-396201441 NULL -2037246338
-396201443 NULL -2037246336
-396201446 NULL -2037246333
-266531961 NULL -2035733149
-266531962 NULL -2035733148
-266531963 NULL -2035733147
-266531964 NULL -2035733146
-266531973 NULL -2035733137
-266531974 NULL -2035733136
-266531979 NULL -2035733131
-266531986 NULL -2035733124
-266531988 NULL -2035733122
-266531991 NULL -2035733119
-999159111 NULL -2035386592
-999159112 NULL -2035386591
-999159113 NULL -2035386590
-999159114 NULL -2035386589
-999159123 NULL -2035386580
-999159124 NULL -2035386579
-999159129 NULL -2035386574
-999159136 NULL -2035386567
-999159138 NULL -2035386565
-999159141 NULL -2035386562
-990406521 NULL -2035083033
-990406522 NULL -2035083032
-990406523 NULL -2035083031
-990406524 NULL -2035083030
-990406533 NULL -2035083021
-990406534 NULL -2035083020
-990406539 NULL -2035083015
-990406546 NULL -2035083008
-990406548 NULL -2035083006
-990406551 NULL -2035083003
-43252882 NULL -2033911553
-43252883 NULL -2033911552
-43252884 NULL -2033911551
-43252885 NULL -2033911550
-43252894 NULL -2033911541
-43252895 NULL -2033911540
-43252900 NULL -2033911535
-43252907 NULL -2033911528
-43252909 NULL -2033911526
-43252912 NULL -2033911523
-244794367 NULL -2032257423
-244794368 NULL -2032257422
-244794369 NULL -2032257421
-244794370 NULL -2032257420
-244794379 NULL -2032257411
-244794380 NULL -2032257410
-244794385 NULL -2032257405
-244794392 NULL -2032257398
-244794394 NULL -2032257396
-244794397 NULL -2032257393
-680015830 NULL -2031087520
-680015831 NULL -2031087519
-680015832 NULL -2031087518
-680015833 NULL -2031087517
-680015842 NULL -2031087508
-680015843 NULL -2031087507
-680015848 NULL -2031087502
-680015855 NULL -2031087495
-680015857 NULL -2031087493
-680015860 NULL -2031087490
-21294126 NULL -2030915306
-21294127 NULL -2030915305
-21294128 NULL -2030915304
-21294129 NULL -2030915303
-21294138 NULL -2030915294
-21294139 NULL -2030915293
-21294144 NULL -2030915288
-21294151 NULL -2030915281
-21294153 NULL -2030915279
-21294156 NULL -2030915276
-193598329 NULL -2028995781
-193598330 NULL -2028995780
-193598331 NULL -2028995779
-193598332 NULL -2028995778
-193598341 NULL -2028995769
-193598342 NULL -2028995768
-193598347 NULL -2028995763
-193598354 NULL -2028995756
-193598356 NULL -2028995754
-193598359 NULL -2028995751
-820675347 NULL -2027837830
-820675348 NULL -2027837829
-820675349 NULL -2027837828
-820675350 NULL -2027837827
-820675359 NULL -2027837818
-820675360 NULL -2027837817
-820675365 NULL -2027837812
-820675372 NULL -2027837805
-820675374 NULL -2027837803
-820675377 NULL -2027837800
-232041688 NULL -2026556712
-232041689 NULL -2026556711
-232041690 NULL -2026556710
-232041691 NULL -2026556709
-232041700 NULL -2026556700
-232041701 NULL -2026556699
-232041706 NULL -2026556694
-232041713 NULL -2026556687
-232041715 NULL -2026556685
-232041718 NULL -2026556682
-353674565 NULL -2023416169
-353674566 NULL -2023416168
-353674567 NULL -2023416167
-353674568 NULL -2023416166
-353674577 NULL -2023416157
-353674578 NULL -2023416156
-353674583 NULL -2023416151
-353674590 NULL -2023416144
-353674592 NULL -2023416142
-353674595 NULL -2023416139
-204523268 NULL -2023100292
-204523269 NULL -2023100291
-204523270 NULL -2023100290
-204523271 NULL -2023100289
-204523280 NULL -2023100280
-204523281 NULL -2023100279
-204523286 NULL -2023100274
-204523293 NULL -2023100267
-204523295 NULL -2023100265
-204523298 NULL -2023100262
-459533135 NULL -2020317642
-459533136 NULL -2020317641
-459533137 NULL -2020317640
-459533138 NULL -2020317639
-459533147 NULL -2020317630
-459533148 NULL -2020317629
-459533153 NULL -2020317624
-459533160 NULL -2020317617
-459533162 NULL -2020317615
-459533165 NULL -2020317612
-446867970 NULL -2014884914
-446867971 NULL -2014884913
-446867972 NULL -2014884912
-446867973 NULL -2014884911
-446867982 NULL -2014884902
-446867983 NULL -2014884901
-446867988 NULL -2014884896
-446867995 NULL -2014884889
-446867997 NULL -2014884887
-446868000 NULL -2014884884
-558776211 NULL -2013188412
-558776212 NULL -2013188411
-558776213 NULL -2013188410
-558776214 NULL -2013188409
-558776223 NULL -2013188400
-558776224 NULL -2013188399
-558776229 NULL -2013188394
-558776236 NULL -2013188387
-558776238 NULL -2013188385
-558776241 NULL -2013188382
-375790538 NULL -2010391298
-375790539 NULL -2010391297
-375790540 NULL -2010391296
-375790541 NULL -2010391295
-375790550 NULL -2010391286
-375790551 NULL -2010391285
-375790556 NULL -2010391280
-375790563 NULL -2010391273
-375790565 NULL -2010391271
-375790568 NULL -2010391268
-620493869 NULL -2007193653
-620493870 NULL -2007193652
-620493871 NULL -2007193651
-620493872 NULL -2007193650
-620493881 NULL -2007193641
-620493882 NULL -2007193640
-620493887 NULL -2007193635
-620493894 NULL -2007193628
-620493896 NULL -2007193626
-620493899 NULL -2007193623
-448081043 NULL -2004909752
-448081044 NULL -2004909751
-448081045 NULL -2004909750
-448081046 NULL -2004909749
-448081055 NULL -2004909740
-448081056 NULL -2004909739
-448081061 NULL -2004909734
-448081068 NULL -2004909727
-448081070 NULL -2004909725
-448081073 NULL -2004909722
-781561011 NULL -2003783410
-781561012 NULL -2003783409
-781561013 NULL -2003783408
-781561014 NULL -2003783407
-781561023 NULL -2003783398
-781561024 NULL -2003783397
-781561029 NULL -2003783392
-781561036 NULL -2003783385
-781561038 NULL -2003783383
-781561041 NULL -2003783380
-830571575 NULL -2002780868
-830571576 NULL -2002780867
-830571577 NULL -2002780866
-830571578 NULL -2002780865
-830571587 NULL -2002780856
-830571588 NULL -2002780855
-830571593 NULL -2002780850
-830571600 NULL -2002780843
-830571602 NULL -2002780841
-830571605 NULL -2002780838
-798427548 NULL -2002392930
-798427549 NULL -2002392929
-798427550 NULL -2002392928
-798427551 NULL -2002392927
-798427560 NULL -2002392918
-798427561 NULL -2002392917
-798427566 NULL -2002392912
-798427573 NULL -2002392905
-798427575 NULL -2002392903
-798427578 NULL -2002392900
-778161305 NULL -2001378670
-778161306 NULL -2001378669
-778161307 NULL -2001378668
-778161308 NULL -2001378667
-778161317 NULL -2001378658
-778161318 NULL -2001378657
-778161323 NULL -2001378652
-778161330 NULL -2001378645
-778161332 NULL -2001378643
-778161335 NULL -2001378640
-256439610 NULL -1995486676
-256439611 NULL -1995486675
-256439612 NULL -1995486674
-256439613 NULL -1995486673
-256439622 NULL -1995486664
-256439623 NULL -1995486663
-256439628 NULL -1995486658
-256439635 NULL -1995486651
-256439637 NULL -1995486649
-256439640 NULL -1995486646
-151711552 NULL -1993645350
-151711553 NULL -1993645349
-151711554 NULL -1993645348
-151711555 NULL -1993645347
-151711564 NULL -1993645338
-151711565 NULL -1993645337
-151711570 NULL -1993645332
-151711577 NULL -1993645325
-151711579 NULL -1993645323
-151711582 NULL -1993645320
-898396478 NULL -1989382902
-898396479 NULL -1989382901
-898396480 NULL -1989382900
-898396481 NULL -1989382899
-898396490 NULL -1989382890
-898396491 NULL -1989382889
-898396496 NULL -1989382884
-898396503 NULL -1989382877
-898396505 NULL -1989382875
-898396508 NULL -1989382872
-851741767 NULL -1988497608
-851741768 NULL -1988497607
-851741769 NULL -1988497606
-851741770 NULL -1988497605
-851741779 NULL -1988497596
-851741780 NULL -1988497595
-851741785 NULL -1988497590
-851741792 NULL -1988497583
-851741794 NULL -1988497581
-851741797 NULL -1988497578
-59656799 NULL -1986126795
-59656800 NULL -1986126794
-59656801 NULL -1986126793
-59656802 NULL -1986126792
-59656811 NULL -1986126783
-59656812 NULL -1986126782
-59656817 NULL -1986126777
-59656824 NULL -1986126770
-59656826 NULL -1986126768
-59656829 NULL -1986126765
-584880465 NULL -1984984831
-584880466 NULL -1984984830
-584880467 NULL -1984984829
-584880468 NULL -1984984828
-584880477 NULL -1984984819
-584880478 NULL -1984984818
-584880483 NULL -1984984813
-584880490 NULL -1984984806
-584880492 NULL -1984984804
-584880495 NULL -1984984801
-1039781150 NULL -1982323988
-1039781151 NULL -1982323987
-1039781152 NULL -1982323986
-1039781153 NULL -1982323985
-1039781162 NULL -1982323976
-1039781163 NULL -1982323975
-1039781168 NULL -1982323970
-1039781175 NULL -1982323963
-1039781177 NULL -1982323961
-1039781180 NULL -1982323958
-25892758 NULL -1978674513
-25892759 NULL -1978674512
-25892760 NULL -1978674511
-25892761 NULL -1978674510
-25892770 NULL -1978674501
-25892771 NULL -1978674500
-25892776 NULL -1978674495
-25892783 NULL -1978674488
-25892785 NULL -1978674486
-25892788 NULL -1978674483
-166365533 NULL -1977764568
-166365534 NULL -1977764567
-166365535 NULL -1977764566
-166365536 NULL -1977764565
-166365545 NULL -1977764556
-166365546 NULL -1977764555
-166365551 NULL -1977764550
-166365558 NULL -1977764543
-166365560 NULL -1977764541
-166365563 NULL -1977764538
-267896802 NULL -1976210465
-267896803 NULL -1976210464
-267896804 NULL -1976210463
-267896805 NULL -1976210462
-267896814 NULL -1976210453
-267896815 NULL -1976210452
-267896820 NULL -1976210447
-267896827 NULL -1976210440
-267896829 NULL -1976210438
-267896832 NULL -1976210435
-331285184 NULL -1974509077
-331285185 NULL -1974509076
-331285186 NULL -1974509075
-331285187 NULL -1974509074
-331285196 NULL -1974509065
-331285197 NULL -1974509064
-331285202 NULL -1974509059
-331285209 NULL -1974509052
-331285211 NULL -1974509050
-331285214 NULL -1974509047
-964394150 NULL -1973978705
-964394151 NULL -1973978704
-964394152 NULL -1973978703
-964394153 NULL -1973978702
-964394162 NULL -1973978693
-964394163 NULL -1973978692
-964394168 NULL -1973978687
-964394175 NULL -1973978680
-964394177 NULL -1973978678
-964394180 NULL -1973978675
-131300397 NULL -1966900572
-131300398 NULL -1966900571
-131300399 NULL -1966900570
-131300400 NULL -1966900569
-131300409 NULL -1966900560
-131300410 NULL -1966900559
-131300415 NULL -1966900554
-131300422 NULL -1966900547
-131300424 NULL -1966900545
-131300427 NULL -1966900542
-790095652 NULL -1962738700
-790095653 NULL -1962738699
-790095654 NULL -1962738698
-790095655 NULL -1962738697
-790095664 NULL -1962738688
-790095665 NULL -1962738687
-790095670 NULL -1962738682
-790095677 NULL -1962738675
-790095679 NULL -1962738673
-790095682 NULL -1962738670
-558714710 NULL -1956635388
-558714711 NULL -1956635387
-558714712 NULL -1956635386
-558714713 NULL -1956635385
-558714722 NULL -1956635376
-558714723 NULL -1956635375
-558714728 NULL -1956635370
-558714735 NULL -1956635363
-558714737 NULL -1956635361
-558714740 NULL -1956635358
-236042653 NULL -1955845981
-236042654 NULL -1955845980
-236042655 NULL -1955845979
-236042656 NULL -1955845978
-236042665 NULL -1955845969
-236042666 NULL -1955845968
-236042671 NULL -1955845963
-236042678 NULL -1955845956
-236042680 NULL -1955845954
-236042683 NULL -1955845951
-999367974 NULL -1952989933
-999367975 NULL -1952989932
-999367976 NULL -1952989931
-999367977 NULL -1952989930
-999367986 NULL -1952989921
-999367987 NULL -1952989920
-999367992 NULL -1952989915
-999367999 NULL -1952989908
-999368001 NULL -1952989906
-999368004 NULL -1952989903
-304990484 NULL -1949825424
-304990485 NULL -1949825423
-304990486 NULL -1949825422
-304990487 NULL -1949825421
-304990496 NULL -1949825412
-304990497 NULL -1949825411
-304990502 NULL -1949825406
-304990509 NULL -1949825399
-304990511 NULL -1949825397
-304990514 NULL -1949825394
-724183458 NULL -1947113861
-724183459 NULL -1947113860
-724183460 NULL -1947113859
-724183461 NULL -1947113858
-724183470 NULL -1947113849
-724183471 NULL -1947113848
-724183476 NULL -1947113843
-724183483 NULL -1947113836
-724183485 NULL -1947113834
-724183488 NULL -1947113831
-283740016 NULL -1943283457
-283740017 NULL -1943283456
-283740018 NULL -1943283455
-283740019 NULL -1943283454
-283740028 NULL -1943283445
-283740029 NULL -1943283444
-283740034 NULL -1943283439
-283740041 NULL -1943283432
-283740043 NULL -1943283430
-283740046 NULL -1943283427
-1041485808 NULL -1942205087
-1041485809 NULL -1942205086
-1041485810 NULL -1942205085
-1041485811 NULL -1942205084
-1041485820 NULL -1942205075
-1041485821 NULL -1942205074
-1041485826 NULL -1942205069
-1041485833 NULL -1942205062
-1041485835 NULL -1942205060
-1041485838 NULL -1942205057
-1073680606 NULL -1939555007
-1073680607 NULL -1939555006
-1073680608 NULL -1939555005
-1073680609 NULL -1939555004
-1073680618 NULL -1939554995
-1073680619 NULL -1939554994
-1073680624 NULL -1939554989
-1073680631 NULL -1939554982
-1073680633 NULL -1939554980
-1073680636 NULL -1939554977
-359898933 NULL -1938555343
-359898934 NULL -1938555342
-359898935 NULL -1938555341
-359898936 NULL -1938555340
-359898945 NULL -1938555331
-359898946 NULL -1938555330
-359898951 NULL -1938555325
-359898958 NULL -1938555318
-359898960 NULL -1938555316
-359898963 NULL -1938555313
-510438191 NULL -1934421498
-510438192 NULL -1934421497
-510438193 NULL -1934421496
-510438194 NULL -1934421495
-510438203 NULL -1934421486
-510438204 NULL -1934421485
-510438209 NULL -1934421480
-510438216 NULL -1934421473
-510438218 NULL -1934421471
-510438221 NULL -1934421468
-1022230696 NULL -1931883057
-1022230697 NULL -1931883056
-1022230698 NULL -1931883055
-1022230699 NULL -1931883054
-1022230708 NULL -1931883045
-1022230709 NULL -1931883044
-1022230714 NULL -1931883039
-1022230721 NULL -1931883032
-1022230723 NULL -1931883030
-1022230726 NULL -1931883027
-587904580 NULL -1931436436
-587904581 NULL -1931436435
-587904582 NULL -1931436434
-587904583 NULL -1931436433
-587904592 NULL -1931436424
-587904593 NULL -1931436423
-587904598 NULL -1931436418
-587904605 NULL -1931436411
-587904607 NULL -1931436409
-587904610 NULL -1931436406
-747553889 NULL -1930467243
-747553890 NULL -1930467242
-747553891 NULL -1930467241
-747553892 NULL -1930467240
-747553901 NULL -1930467231
-747553902 NULL -1930467230
-747553907 NULL -1930467225
-747553914 NULL -1930467218
-747553916 NULL -1930467216
-747553919 NULL -1930467213
-523172873 NULL -1928034594
-523172874 NULL -1928034593
-523172875 NULL -1928034592
-523172876 NULL -1928034591
-523172885 NULL -1928034582
-523172886 NULL -1928034581
-523172891 NULL -1928034576
-523172898 NULL -1928034569
-523172900 NULL -1928034567
-523172903 NULL -1928034564
-715853440 NULL -1924864905
-715853441 NULL -1924864904
-715853442 NULL -1924864903
-715853443 NULL -1924864902
-715853452 NULL -1924864893
-715853453 NULL -1924864892
-715853458 NULL -1924864887
-715853465 NULL -1924864880
-715853467 NULL -1924864878
-715853470 NULL -1924864875
-416970597 NULL -1924227586
-416970598 NULL -1924227585
-416970599 NULL -1924227584
-416970600 NULL -1924227583
-416970609 NULL -1924227574
-416970610 NULL -1924227573
-416970615 NULL -1924227568
-416970622 NULL -1924227561
-416970624 NULL -1924227559
-416970627 NULL -1924227556
-275882969 NULL -1922849094
-275882970 NULL -1922849093
-275882971 NULL -1922849092
-275882972 NULL -1922849091
-275882981 NULL -1922849082
-275882982 NULL -1922849081
-275882987 NULL -1922849076
-275882994 NULL -1922849069
-275882996 NULL -1922849067
-275882999 NULL -1922849064
-239398208 NULL -1922755026
-239398209 NULL -1922755025
-239398210 NULL -1922755024
-239398211 NULL -1922755023
-239398220 NULL -1922755014
-239398221 NULL -1922755013
-239398226 NULL -1922755008
-239398233 NULL -1922755001
-239398235 NULL -1922754999
-239398238 NULL -1922754996
-207321897 NULL -1920826852
-207321898 NULL -1920826851
-207321899 NULL -1920826850
-207321900 NULL -1920826849
-207321909 NULL -1920826840
-207321910 NULL -1920826839
-207321915 NULL -1920826834
-207321922 NULL -1920826827
-207321924 NULL -1920826825
-207321927 NULL -1920826822
-121354669 NULL -1920696001
-121354670 NULL -1920696000
-121354671 NULL -1920695999
-121354672 NULL -1920695998
-121354681 NULL -1920695989
-121354682 NULL -1920695988
-121354687 NULL -1920695983
-121354694 NULL -1920695976
-121354696 NULL -1920695974
-121354699 NULL -1920695971
-521080744 NULL -1918433139
-521080745 NULL -1918433138
-521080746 NULL -1918433137
-521080747 NULL -1918433136
-521080756 NULL -1918433127
-521080757 NULL -1918433126
-521080762 NULL -1918433121
-521080769 NULL -1918433114
-521080771 NULL -1918433112
-521080774 NULL -1918433109
-521019762 NULL -1909738691
-521019763 NULL -1909738690
-521019764 NULL -1909738689
-521019765 NULL -1909738688
-521019774 NULL -1909738679
-521019775 NULL -1909738678
-521019780 NULL -1909738673
-521019787 NULL -1909738666
-521019789 NULL -1909738664
-521019792 NULL -1909738661
-6988 NULL -1908387372
-6989 NULL -1908387371
-6990 NULL -1908387370
-6991 NULL -1908387369
-7000 NULL -1908387360
-7001 NULL -1908387359
-7006 NULL -1908387354
-7013 NULL -1908387347
-7015 NULL -1908387345
-7018 NULL -1908387342
-733314790 NULL -1906954425
-733314791 NULL -1906954424
-733314792 NULL -1906954423
-733314793 NULL -1906954422
-733314802 NULL -1906954413
-733314803 NULL -1906954412
-733314808 NULL -1906954407
-733314815 NULL -1906954400
-733314817 NULL -1906954398
-733314820 NULL -1906954395
+239452960650
+PREHOOK: query: select sum(hash(*)) from (select cint, csmallint, cbigint from
orc_llap where cint > 10 and cbigint is not null order by cbigint limit 1000)
tmp
+PREHOOK: type: QUERY
+PREHOOK: Input: default@orc_llap
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from (select cint, csmallint, cbigint
from orc_llap where cint > 10 and cbigint is not null order by cbigint limit
1000) tmp
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@orc_llap
+#### A masked pattern was here ####
+239452960650
Added: hive/branches/llap/ql/src/test/results/clientpositive/orc_llap2.q.out
URL:
http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/orc_llap2.q.out?rev=1661629&view=auto
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/orc_llap2.q.out
(added)
+++ hive/branches/llap/ql/src/test/results/clientpositive/orc_llap2.q.out Mon
Feb 23 09:51:15 2015
@@ -0,0 +1,109 @@
+PREHOOK: query: CREATE TABLE orc_llap(
+ ctinyint TINYINT,
+ csmallint SMALLINT,
+ cint INT,
+ cbigint BIGINT,
+ cfloat FLOAT,
+ cdouble DOUBLE,
+ cstring1 STRING,
+ cstring2 STRING,
+ ctimestamp1 TIMESTAMP,
+ ctimestamp2 TIMESTAMP,
+ cboolean1 BOOLEAN,
+ cboolean2 BOOLEAN)
+ STORED AS ORC
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@orc_llap
+POSTHOOK: query: CREATE TABLE orc_llap(
+ ctinyint TINYINT,
+ csmallint SMALLINT,
+ cint INT,
+ cbigint BIGINT,
+ cfloat FLOAT,
+ cdouble DOUBLE,
+ cstring1 STRING,
+ cstring2 STRING,
+ ctimestamp1 TIMESTAMP,
+ ctimestamp2 TIMESTAMP,
+ cboolean1 BOOLEAN,
+ cboolean2 BOOLEAN)
+ STORED AS ORC
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@orc_llap
+PREHOOK: query: create table cross_numbers(i int)
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@cross_numbers
+POSTHOOK: query: create table cross_numbers(i int)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@cross_numbers
+PREHOOK: query: insert into table cross_numbers
+select distinct csmallint
+from alltypesorc where csmallint > 0 order by csmallint limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@cross_numbers
+POSTHOOK: query: insert into table cross_numbers
+select distinct csmallint
+from alltypesorc where csmallint > 0 order by csmallint limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@cross_numbers
+POSTHOOK: Lineage: cross_numbers.i EXPRESSION
[(alltypesorc)alltypesorc.FieldSchema(name:csmallint, type:smallint,
comment:null), ]
+Warning: Shuffle Join JOIN[7][tables = [$hdt$_0, $hdt$_1]] in Stage
'Stage-1:MAPRED' is a cross product
+PREHOOK: query: insert into table orc_llap
+select ctinyint + i, csmallint + i, cint + i, cbigint + i, cfloat + i, cdouble
+ i, cstring1, cstring2, ctimestamp1, ctimestamp2, cboolean1, cboolean2
+from alltypesorc cross join cross_numbers
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Input: default@cross_numbers
+PREHOOK: Output: default@orc_llap
+POSTHOOK: query: insert into table orc_llap
+select ctinyint + i, csmallint + i, cint + i, cbigint + i, cfloat + i, cdouble
+ i, cstring1, cstring2, ctimestamp1, ctimestamp2, cboolean1, cboolean2
+from alltypesorc cross join cross_numbers
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Input: default@cross_numbers
+POSTHOOK: Output: default@orc_llap
+POSTHOOK: Lineage: orc_llap.cbigint EXPRESSION
[(alltypesorc)alltypesorc.FieldSchema(name:cbigint, type:bigint, comment:null),
(cross_numbers)cross_numbers.FieldSchema(name:i, type:int, comment:null), ]
+POSTHOOK: Lineage: orc_llap.cboolean1 SIMPLE
[(alltypesorc)alltypesorc.FieldSchema(name:cboolean1, type:boolean,
comment:null), ]
+POSTHOOK: Lineage: orc_llap.cboolean2 SIMPLE
[(alltypesorc)alltypesorc.FieldSchema(name:cboolean2, type:boolean,
comment:null), ]
+POSTHOOK: Lineage: orc_llap.cdouble EXPRESSION
[(alltypesorc)alltypesorc.FieldSchema(name:cdouble, type:double, comment:null),
(cross_numbers)cross_numbers.FieldSchema(name:i, type:int, comment:null), ]
+POSTHOOK: Lineage: orc_llap.cfloat EXPRESSION
[(alltypesorc)alltypesorc.FieldSchema(name:cfloat, type:float, comment:null),
(cross_numbers)cross_numbers.FieldSchema(name:i, type:int, comment:null), ]
+POSTHOOK: Lineage: orc_llap.cint EXPRESSION
[(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null),
(cross_numbers)cross_numbers.FieldSchema(name:i, type:int, comment:null), ]
+POSTHOOK: Lineage: orc_llap.csmallint EXPRESSION
[(alltypesorc)alltypesorc.FieldSchema(name:csmallint, type:smallint,
comment:null), (cross_numbers)cross_numbers.FieldSchema(name:i, type:int,
comment:null), ]
+POSTHOOK: Lineage: orc_llap.cstring1 SIMPLE
[(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string,
comment:null), ]
+POSTHOOK: Lineage: orc_llap.cstring2 SIMPLE
[(alltypesorc)alltypesorc.FieldSchema(name:cstring2, type:string,
comment:null), ]
+POSTHOOK: Lineage: orc_llap.ctimestamp1 SIMPLE
[(alltypesorc)alltypesorc.FieldSchema(name:ctimestamp1, type:timestamp,
comment:null), ]
+POSTHOOK: Lineage: orc_llap.ctimestamp2 SIMPLE
[(alltypesorc)alltypesorc.FieldSchema(name:ctimestamp2, type:timestamp,
comment:null), ]
+POSTHOOK: Lineage: orc_llap.ctinyint EXPRESSION
[(alltypesorc)alltypesorc.FieldSchema(name:ctinyint, type:tinyint,
comment:null), (cross_numbers)cross_numbers.FieldSchema(name:i, type:int,
comment:null), ]
+PREHOOK: query: select count(*) from orc_llap
+PREHOOK: type: QUERY
+PREHOOK: Input: default@orc_llap
+#### A masked pattern was here ####
+POSTHOOK: query: select count(*) from orc_llap
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@orc_llap
+#### A masked pattern was here ####
+122880
+PREHOOK: query: select sum(hash(*)) from (select * from orc_llap where cint >
10 and cbigint is not null order by cbigint limit 1000) tmp
+PREHOOK: type: QUERY
+PREHOOK: Input: default@orc_llap
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from (select * from orc_llap where cint >
10 and cbigint is not null order by cbigint limit 1000) tmp
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@orc_llap
+#### A masked pattern was here ####
+-41726695000
+PREHOOK: query: select sum(hash(*)) from (select * from orc_llap where cint >
10 and cbigint is not null order by cbigint limit 1000) tmp
+PREHOOK: type: QUERY
+PREHOOK: Input: default@orc_llap
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from (select * from orc_llap where cint >
10 and cbigint is not null order by cbigint limit 1000) tmp
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@orc_llap
+#### A masked pattern was here ####
+-41726695000
