hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From prasan...@apache.org
Subject svn commit: r1661629 - in /hive/branches/llap: llap-server/src/java/org/apache/hadoop/hive/llap/io/decode/orc/stream/readers/ llap-server/src/java/org/apache/hadoop/hive/llap/io/encoded/ ql/src/java/org/apache/hadoop/hive/ql/io/orc/ ql/src/test/queries...
Date Mon, 23 Feb 2015 09:51:16 GMT
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



Mime
View raw message