You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by jc...@apache.org on 2019/01/04 00:24:27 UTC
[28/35] hive git commit: HIVE-16957: Support CTAS for auto gather
column stats (Jesus Camacho Rodriguez, reviewed by Ashutosh Chauhan)
http://git-wip-us.apache.org/repos/asf/hive/blob/138b00ca/ql/src/test/results/clientpositive/llap/llap_acid2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/llap_acid2.q.out b/ql/src/test/results/clientpositive/llap/llap_acid2.q.out
index c3e9c2a..eaae3e8 100644
--- a/ql/src/test/results/clientpositive/llap/llap_acid2.q.out
+++ b/ql/src/test/results/clientpositive/llap/llap_acid2.q.out
@@ -49,7 +49,10 @@ select cint, cbigint, cfloat, cdouble,
cint as c1, cbigint as c2, cfloat as c3, cdouble as c4,
cint as c8, cbigint as c7, cfloat as c6, cdouble as c5,
cstring1, cfloat as c9, cast("1.123" as decimal(10,3))as c10,
- cast("1.123456789" as decimal(38,18)) as c11 from alltypesorc order by cdouble asc limit 30
+ cast("1.123456789" as decimal(38,18)) as c11
+from alltypesorc
+order by cint, cbigint, cfloat, cdouble, cstring1
+limit 30
PREHOOK: type: QUERY
PREHOOK: Input: default@alltypesorc
PREHOOK: Output: default@orc_llap_n2
@@ -58,7 +61,10 @@ select cint, cbigint, cfloat, cdouble,
cint as c1, cbigint as c2, cfloat as c3, cdouble as c4,
cint as c8, cbigint as c7, cfloat as c6, cdouble as c5,
cstring1, cfloat as c9, cast("1.123" as decimal(10,3))as c10,
- cast("1.123456789" as decimal(38,18)) as c11 from alltypesorc order by cdouble asc limit 30
+ cast("1.123456789" as decimal(38,18)) as c11
+from alltypesorc
+order by cint, cbigint, cfloat, cdouble, cstring1
+limit 30
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alltypesorc
POSTHOOK: Output: default@orc_llap_n2
@@ -91,7 +97,10 @@ select cint, cbigint, cfloat, cdouble,
cint as c1, cbigint as c2, cfloat as c3, cdouble as c4,
cint as c8, cbigint as c7, cfloat as c6, cdouble as c5,
cstring1, cfloat as c9, cast("3.321" as decimal(10,3))as c10,
- cast("9.987654321" as decimal(38,18)) as c11 from alltypesorc order by cdouble asc limit 30
+ cast("9.987654321" as decimal(38,18)) as c11
+from alltypesorc
+order by cint, cbigint, cfloat, cdouble, cstring1
+limit 30
PREHOOK: type: QUERY
PREHOOK: Input: default@alltypesorc
PREHOOK: Output: default@orc_llap_n2
@@ -100,7 +109,10 @@ select cint, cbigint, cfloat, cdouble,
cint as c1, cbigint as c2, cfloat as c3, cdouble as c4,
cint as c8, cbigint as c7, cfloat as c6, cdouble as c5,
cstring1, cfloat as c9, cast("3.321" as decimal(10,3))as c10,
- cast("9.987654321" as decimal(38,18)) as c11 from alltypesorc order by cdouble asc limit 30
+ cast("9.987654321" as decimal(38,18)) as c11
+from alltypesorc
+order by cint, cbigint, cfloat, cdouble, cstring1
+limit 30
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alltypesorc
POSTHOOK: Output: default@orc_llap_n2
@@ -167,7 +179,10 @@ select cint, cbigint, cfloat, cdouble,
cint as c1, cbigint as c2, cfloat as c3, cdouble as c4,
cint as c8, cbigint as c7, cfloat as c6, cdouble as c5,
cstring1, cfloat as c9, cast("1.123" as decimal(10,3))as c10,
- cast("1.123456789" as decimal(38,18)) as c11 from alltypesorc order by cdouble asc limit 30
+ cast("1.123456789" as decimal(38,18)) as c11
+from alltypesorc
+order by cint, cbigint, cfloat, cdouble, cstring1
+limit 30
PREHOOK: type: QUERY
PREHOOK: Input: default@alltypesorc
PREHOOK: Output: default@orc_llap2
@@ -176,7 +191,10 @@ select cint, cbigint, cfloat, cdouble,
cint as c1, cbigint as c2, cfloat as c3, cdouble as c4,
cint as c8, cbigint as c7, cfloat as c6, cdouble as c5,
cstring1, cfloat as c9, cast("1.123" as decimal(10,3))as c10,
- cast("1.123456789" as decimal(38,18)) as c11 from alltypesorc order by cdouble asc limit 30
+ cast("1.123456789" as decimal(38,18)) as c11
+from alltypesorc
+order by cint, cbigint, cfloat, cdouble, cstring1
+limit 30
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alltypesorc
POSTHOOK: Output: default@orc_llap2
@@ -222,66 +240,66 @@ POSTHOOK: query: select cstring1 from orc_llap_n2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_llap_n2
#### A masked pattern was here ####
-N016jPED08o
-Q1JAdUlCVORmR0Q5X5Vf5u6
-eNsh5tYa
-5j7GJ8OCXgMVIcK7
-uJGHsW3cd073NGFITyQ
-G1u0pUmU6ehCm
-mk6lShdOa8kXT8i7mLd3fK
-u5C7glqT5XqtO0JE2686lk1
-h4omSc1jcLLwW
-tFY2ng51v
-vmAT10eeE47fgH20pLi
-uN803aW
-qqbDw46IgGds4
-32v414p63Jv1B4tO1xy
-73xdw4X
-d3o1712a03n20qvi62U7
-eQ80MW0h728I204P87YXc
-KHtD2A2hp6OjFgS73gdgE
-nI30tm7U55O0gI
-LSJtFA66
-mby00c
-meGb5
-pM6Gt05s1YJeii
-LR2AKy0dPt8vFdIV5760jriw
-1B3WMD5LSk65B2Moa
-xTlDv24JYv4s
-28Oe6r21yux7Lk47
-7wH3hBKdO55Xq3gEEe0
-5QLs0LVK1g
-ET3d4F2I4lV
-N016jPED08o
-Q1JAdUlCVORmR0Q5X5Vf5u6
-eNsh5tYa
-5j7GJ8OCXgMVIcK7
-uJGHsW3cd073NGFITyQ
-G1u0pUmU6ehCm
-mk6lShdOa8kXT8i7mLd3fK
-u5C7glqT5XqtO0JE2686lk1
-h4omSc1jcLLwW
-tFY2ng51v
-vmAT10eeE47fgH20pLi
-uN803aW
-qqbDw46IgGds4
-32v414p63Jv1B4tO1xy
-73xdw4X
-d3o1712a03n20qvi62U7
-eQ80MW0h728I204P87YXc
-KHtD2A2hp6OjFgS73gdgE
-nI30tm7U55O0gI
-LSJtFA66
-mby00c
-meGb5
-pM6Gt05s1YJeii
-LR2AKy0dPt8vFdIV5760jriw
-1B3WMD5LSk65B2Moa
-xTlDv24JYv4s
-28Oe6r21yux7Lk47
-7wH3hBKdO55Xq3gEEe0
-5QLs0LVK1g
-ET3d4F2I4lV
+0RrH6XDA1
+0RrH6XDA1
+0iqrc5
+0iqrc5
+0ruyd6Y50JpdGRf6HqD
+0ruyd6Y50JpdGRf6HqD
+2W4Kg220OcCy065HG60k6e
+2W4Kg220OcCy065HG60k6e
+2uLyD28144vklju213J1mr
+2uLyD28144vklju213J1mr
+41A0nYX72UOSfxO4053xy
+41A0nYX72UOSfxO4053xy
+47INeW44yvsne46Mu
+47INeW44yvsne46Mu
+8GIqX3tvNqrgH
+8GIqX3tvNqrgH
+8u8tR858jC01y8Ft66nYRnb6
+8u8tR858jC01y8Ft66nYRnb6
+8x6mobxQl6Ef0Hl1
+8x6mobxQl6Ef0Hl1
+A34p7oRr2WvUJNf
+A34p7oRr2WvUJNf
+Anj0oF
+Anj0oF
+B553840U1H2b1M06l6N81
+B553840U1H2b1M06l6N81
+F3u1yJaQywofxCCM4v4jScY
+F3u1yJaQywofxCCM4v4jScY
+HBtg2r6pR16VC73
+HBtg2r6pR16VC73
+IbgbUvP5
+IbgbUvP5
+PUn1YVC
+PUn1YVC
+aD88uS2N8DmqPlvjOa7F46i7
+aD88uS2N8DmqPlvjOa7F46i7
+aY3tpnr6wfvmWMG0U881
+aY3tpnr6wfvmWMG0U881
+aw724t8c5558x2xneC624
+aw724t8c5558x2xneC624
+dPbX4jd1v47r1bB6506si
+dPbX4jd1v47r1bB6506si
+dPkN74F7
+dPkN74F7
+iUR3Q
+iUR3Q
+jWVP6gOkq12mdh
+jWVP6gOkq12mdh
+k17Am8uPHWk02cEf1jet
+k17Am8uPHWk02cEf1jet
+k7i5RkMq88H0s
+k7i5RkMq88H0s
+oj1YrV5Wa
+oj1YrV5Wa
+s5O357fO5pF0
+s5O357fO5pF0
+us1gH35lcpND
+us1gH35lcpND
+vW36C22KS75R
+vW36C22KS75R
PREHOOK: query: select cfloat2, cint from orc_llap_n2
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_llap_n2
@@ -290,66 +308,66 @@ POSTHOOK: query: select cfloat2, cint from orc_llap_n2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_llap_n2
#### A masked pattern was here ####
-NULL -838810013
-NULL 246423894
-NULL 708885482
-NULL 186967185
-NULL -595277064
-NULL 584923170
-NULL 518213127
-NULL -334595454
-NULL 241008004
-NULL 185212032
-NULL -738747840
-NULL -971543377
-NULL 940448896
-NULL -324030556
-NULL -899422227
-11.0 835111400
-11.0 -775326158
-11.0 653630202
-11.0 779427499
-11.0 797003983
-11.0 31832752
-11.0 783790031
-11.0 -898241885
-11.0 NULL
-11.0 -646295381
-11.0 130912195
-11.0 -391573084
-11.0 385623629
-11.0 681126962
-11.0 25892751
-NULL -838810013
-NULL 246423894
-NULL 708885482
-NULL 186967185
-NULL -595277064
-NULL 584923170
-NULL 518213127
-NULL -334595454
-NULL 241008004
-NULL 185212032
-NULL -738747840
-NULL -971543377
-NULL 940448896
-NULL -324030556
-NULL -899422227
-11.0 835111400
-11.0 -775326158
-11.0 653630202
-11.0 779427499
-11.0 797003983
-11.0 31832752
-11.0 783790031
-11.0 -898241885
-11.0 NULL
-11.0 -646295381
-11.0 130912195
-11.0 -391573084
-11.0 385623629
-11.0 681126962
-11.0 25892751
+-51.0 -1064718136
+-51.0 -1064718136
+-51.0 -1064981602
+-51.0 -1064981602
+-51.0 -1065775394
+-51.0 -1065775394
+-51.0 -1066684273
+-51.0 -1066684273
+-51.0 -1067683781
+-51.0 -1067683781
+-51.0 -1071480828
+-51.0 -1071480828
+11.0 -1064623720
+11.0 -1064623720
+11.0 -1067874703
+11.0 -1067874703
+11.0 -1068336533
+11.0 -1068336533
+11.0 -1069097390
+11.0 -1069097390
+11.0 -1069103950
+11.0 -1069103950
+11.0 -1069736047
+11.0 -1069736047
+11.0 -1072910839
+11.0 -1072910839
+11.0 -1073279343
+11.0 -1073279343
+8.0 -1068206466
+8.0 -1068206466
+8.0 -1068247011
+8.0 -1068247011
+8.0 -1071363017
+8.0 -1071363017
+NULL -1064949302
+NULL -1064949302
+NULL -1065117869
+NULL -1065117869
+NULL -1066226047
+NULL -1066226047
+NULL -1066922682
+NULL -1066922682
+NULL -1067386090
+NULL -1067386090
+NULL -1068623584
+NULL -1068623584
+NULL -1069109166
+NULL -1069109166
+NULL -1069512165
+NULL -1069512165
+NULL -1070551679
+NULL -1070551679
+NULL -1070883071
+NULL -1070883071
+NULL -1072076362
+NULL -1072076362
+NULL -1072081801
+NULL -1072081801
+NULL -1073051226
+NULL -1073051226
PREHOOK: query: select * from orc_llap_n2
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_llap_n2
@@ -358,66 +376,66 @@ POSTHOOK: query: select * from orc_llap_n2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_llap_n2
#### A masked pattern was here ####
--838810013 1864027286 NULL NULL -838810013 1864027286 NULL NULL -838810013 1864027286 NULL NULL N016jPED08o NULL 3.321 9.9876543210
-246423894 -1645852809 NULL NULL 246423894 -1645852809 NULL NULL 246423894 -1645852809 NULL NULL Q1JAdUlCVORmR0Q5X5Vf5u6 NULL 3.321 9.9876543210
-708885482 -1645852809 NULL NULL 708885482 -1645852809 NULL NULL 708885482 -1645852809 NULL NULL eNsh5tYa NULL 3.321 9.9876543210
-186967185 -1645852809 NULL NULL 186967185 -1645852809 NULL NULL 186967185 -1645852809 NULL NULL 5j7GJ8OCXgMVIcK7 NULL 3.321 9.9876543210
--595277064 -1645852809 NULL NULL -595277064 -1645852809 NULL NULL -595277064 -1645852809 NULL NULL uJGHsW3cd073NGFITyQ NULL 3.321 9.9876543210
-584923170 -1645852809 NULL NULL 584923170 -1645852809 NULL NULL 584923170 -1645852809 NULL NULL G1u0pUmU6ehCm NULL 3.321 9.9876543210
-518213127 -1645852809 NULL NULL 518213127 -1645852809 NULL NULL 518213127 -1645852809 NULL NULL mk6lShdOa8kXT8i7mLd3fK NULL 3.321 9.9876543210
--334595454 -1645852809 NULL NULL -334595454 -1645852809 NULL NULL -334595454 -1645852809 NULL NULL u5C7glqT5XqtO0JE2686lk1 NULL 3.321 9.9876543210
-241008004 -1645852809 NULL NULL 241008004 -1645852809 NULL NULL 241008004 -1645852809 NULL NULL h4omSc1jcLLwW NULL 3.321 9.9876543210
-185212032 -1645852809 NULL NULL 185212032 -1645852809 NULL NULL 185212032 -1645852809 NULL NULL tFY2ng51v NULL 3.321 9.9876543210
--738747840 -1645852809 NULL NULL -738747840 -1645852809 NULL NULL -738747840 -1645852809 NULL NULL vmAT10eeE47fgH20pLi NULL 3.321 9.9876543210
--971543377 -1645852809 NULL NULL -971543377 -1645852809 NULL NULL -971543377 -1645852809 NULL NULL uN803aW NULL 3.321 9.9876543210
-940448896 -1645852809 NULL NULL 940448896 -1645852809 NULL NULL 940448896 -1645852809 NULL NULL qqbDw46IgGds4 NULL 3.321 9.9876543210
--324030556 -1645852809 NULL NULL -324030556 -1645852809 NULL NULL -324030556 -1645852809 NULL NULL 32v414p63Jv1B4tO1xy NULL 3.321 9.9876543210
--899422227 -1645852809 NULL NULL -899422227 -1645852809 NULL NULL -899422227 -1645852809 NULL NULL 73xdw4X NULL 3.321 9.9876543210
-835111400 1964238982 11.0 NULL 835111400 1964238982 11.0 NULL 835111400 1964238982 11.0 NULL d3o1712a03n20qvi62U7 11.0 3.321 9.9876543210
--775326158 -1289793978 11.0 NULL -775326158 -1289793978 11.0 NULL -775326158 -1289793978 11.0 NULL eQ80MW0h728I204P87YXc 11.0 3.321 9.9876543210
-653630202 1281184487 11.0 NULL 653630202 1281184487 11.0 NULL 653630202 1281184487 11.0 NULL KHtD2A2hp6OjFgS73gdgE 11.0 3.321 9.9876543210
-779427499 1326393090 11.0 NULL 779427499 1326393090 11.0 NULL 779427499 1326393090 11.0 NULL nI30tm7U55O0gI 11.0 3.321 9.9876543210
-797003983 1186689849 11.0 NULL 797003983 1186689849 11.0 NULL 797003983 1186689849 11.0 NULL LSJtFA66 11.0 3.321 9.9876543210
-31832752 1854212271 11.0 NULL 31832752 1854212271 11.0 NULL 31832752 1854212271 11.0 NULL mby00c 11.0 3.321 9.9876543210
-783790031 -1482854823 11.0 NULL 783790031 -1482854823 11.0 NULL 783790031 -1482854823 11.0 NULL meGb5 11.0 3.321 9.9876543210
--898241885 -1785664982 11.0 NULL -898241885 -1785664982 11.0 NULL -898241885 -1785664982 11.0 NULL pM6Gt05s1YJeii 11.0 3.321 9.9876543210
-NULL -1083386085 11.0 NULL NULL -1083386085 11.0 NULL NULL -1083386085 11.0 NULL LR2AKy0dPt8vFdIV5760jriw 11.0 3.321 9.9876543210
--646295381 -1654635859 11.0 NULL -646295381 -1654635859 11.0 NULL -646295381 -1654635859 11.0 NULL 1B3WMD5LSk65B2Moa 11.0 3.321 9.9876543210
-130912195 -1286145901 11.0 NULL 130912195 -1286145901 11.0 NULL 130912195 -1286145901 11.0 NULL xTlDv24JYv4s 11.0 3.321 9.9876543210
--391573084 -236100834 11.0 NULL -391573084 -236100834 11.0 NULL -391573084 -236100834 11.0 NULL 28Oe6r21yux7Lk47 11.0 3.321 9.9876543210
-385623629 236101682 11.0 NULL 385623629 236101682 11.0 NULL 385623629 236101682 11.0 NULL 7wH3hBKdO55Xq3gEEe0 11.0 3.321 9.9876543210
-681126962 993392163 11.0 NULL 681126962 993392163 11.0 NULL 681126962 993392163 11.0 NULL 5QLs0LVK1g 11.0 3.321 9.9876543210
-25892751 -1978674520 11.0 NULL 25892751 -1978674520 11.0 NULL 25892751 -1978674520 11.0 NULL ET3d4F2I4lV 11.0 3.321 9.9876543210
--838810013 1864027286 NULL NULL -838810013 1864027286 NULL NULL -838810013 1864027286 NULL NULL N016jPED08o NULL 1.123 1.1234567890
-246423894 -1645852809 NULL NULL 246423894 -1645852809 NULL NULL 246423894 -1645852809 NULL NULL Q1JAdUlCVORmR0Q5X5Vf5u6 NULL 1.123 1.1234567890
-708885482 -1645852809 NULL NULL 708885482 -1645852809 NULL NULL 708885482 -1645852809 NULL NULL eNsh5tYa NULL 1.123 1.1234567890
-186967185 -1645852809 NULL NULL 186967185 -1645852809 NULL NULL 186967185 -1645852809 NULL NULL 5j7GJ8OCXgMVIcK7 NULL 1.123 1.1234567890
--595277064 -1645852809 NULL NULL -595277064 -1645852809 NULL NULL -595277064 -1645852809 NULL NULL uJGHsW3cd073NGFITyQ NULL 1.123 1.1234567890
-584923170 -1645852809 NULL NULL 584923170 -1645852809 NULL NULL 584923170 -1645852809 NULL NULL G1u0pUmU6ehCm NULL 1.123 1.1234567890
-518213127 -1645852809 NULL NULL 518213127 -1645852809 NULL NULL 518213127 -1645852809 NULL NULL mk6lShdOa8kXT8i7mLd3fK NULL 1.123 1.1234567890
--334595454 -1645852809 NULL NULL -334595454 -1645852809 NULL NULL -334595454 -1645852809 NULL NULL u5C7glqT5XqtO0JE2686lk1 NULL 1.123 1.1234567890
-241008004 -1645852809 NULL NULL 241008004 -1645852809 NULL NULL 241008004 -1645852809 NULL NULL h4omSc1jcLLwW NULL 1.123 1.1234567890
-185212032 -1645852809 NULL NULL 185212032 -1645852809 NULL NULL 185212032 -1645852809 NULL NULL tFY2ng51v NULL 1.123 1.1234567890
--738747840 -1645852809 NULL NULL -738747840 -1645852809 NULL NULL -738747840 -1645852809 NULL NULL vmAT10eeE47fgH20pLi NULL 1.123 1.1234567890
--971543377 -1645852809 NULL NULL -971543377 -1645852809 NULL NULL -971543377 -1645852809 NULL NULL uN803aW NULL 1.123 1.1234567890
-940448896 -1645852809 NULL NULL 940448896 -1645852809 NULL NULL 940448896 -1645852809 NULL NULL qqbDw46IgGds4 NULL 1.123 1.1234567890
--324030556 -1645852809 NULL NULL -324030556 -1645852809 NULL NULL -324030556 -1645852809 NULL NULL 32v414p63Jv1B4tO1xy NULL 1.123 1.1234567890
--899422227 -1645852809 NULL NULL -899422227 -1645852809 NULL NULL -899422227 -1645852809 NULL NULL 73xdw4X NULL 1.123 1.1234567890
-835111400 1964238982 11.0 NULL 835111400 1964238982 11.0 NULL 835111400 1964238982 11.0 NULL d3o1712a03n20qvi62U7 11.0 1.123 1.1234567890
--775326158 -1289793978 11.0 NULL -775326158 -1289793978 11.0 NULL -775326158 -1289793978 11.0 NULL eQ80MW0h728I204P87YXc 11.0 1.123 1.1234567890
-653630202 1281184487 11.0 NULL 653630202 1281184487 11.0 NULL 653630202 1281184487 11.0 NULL KHtD2A2hp6OjFgS73gdgE 11.0 1.123 1.1234567890
-779427499 1326393090 11.0 NULL 779427499 1326393090 11.0 NULL 779427499 1326393090 11.0 NULL nI30tm7U55O0gI 11.0 1.123 1.1234567890
-797003983 1186689849 11.0 NULL 797003983 1186689849 11.0 NULL 797003983 1186689849 11.0 NULL LSJtFA66 11.0 1.123 1.1234567890
-31832752 1854212271 11.0 NULL 31832752 1854212271 11.0 NULL 31832752 1854212271 11.0 NULL mby00c 11.0 1.123 1.1234567890
-783790031 -1482854823 11.0 NULL 783790031 -1482854823 11.0 NULL 783790031 -1482854823 11.0 NULL meGb5 11.0 1.123 1.1234567890
--898241885 -1785664982 11.0 NULL -898241885 -1785664982 11.0 NULL -898241885 -1785664982 11.0 NULL pM6Gt05s1YJeii 11.0 1.123 1.1234567890
-NULL -1083386085 11.0 NULL NULL -1083386085 11.0 NULL NULL -1083386085 11.0 NULL LR2AKy0dPt8vFdIV5760jriw 11.0 1.123 1.1234567890
--646295381 -1654635859 11.0 NULL -646295381 -1654635859 11.0 NULL -646295381 -1654635859 11.0 NULL 1B3WMD5LSk65B2Moa 11.0 1.123 1.1234567890
-130912195 -1286145901 11.0 NULL 130912195 -1286145901 11.0 NULL 130912195 -1286145901 11.0 NULL xTlDv24JYv4s 11.0 1.123 1.1234567890
--391573084 -236100834 11.0 NULL -391573084 -236100834 11.0 NULL -391573084 -236100834 11.0 NULL 28Oe6r21yux7Lk47 11.0 1.123 1.1234567890
-385623629 236101682 11.0 NULL 385623629 236101682 11.0 NULL 385623629 236101682 11.0 NULL 7wH3hBKdO55Xq3gEEe0 11.0 1.123 1.1234567890
-681126962 993392163 11.0 NULL 681126962 993392163 11.0 NULL 681126962 993392163 11.0 NULL 5QLs0LVK1g 11.0 1.123 1.1234567890
-25892751 -1978674520 11.0 NULL 25892751 -1978674520 11.0 NULL 25892751 -1978674520 11.0 NULL ET3d4F2I4lV 11.0 1.123 1.1234567890
+-1064623720 -1894858490 11.0 NULL -1064623720 -1894858490 11.0 NULL -1064623720 -1894858490 11.0 NULL 47INeW44yvsne46Mu 11.0 1.123 1.1234567890
+-1064623720 -1894858490 11.0 NULL -1064623720 -1894858490 11.0 NULL -1064623720 -1894858490 11.0 NULL 47INeW44yvsne46Mu 11.0 3.321 9.9876543210
+-1064718136 156403402 -51.0 NULL -1064718136 156403402 -51.0 NULL -1064718136 156403402 -51.0 NULL k7i5RkMq88H0s -51.0 1.123 1.1234567890
+-1064718136 156403402 -51.0 NULL -1064718136 156403402 -51.0 NULL -1064718136 156403402 -51.0 NULL k7i5RkMq88H0s -51.0 3.321 9.9876543210
+-1064949302 -1645852809 NULL 6454.0 -1064949302 -1645852809 NULL 6454.0 -1064949302 -1645852809 NULL 6454.0 8u8tR858jC01y8Ft66nYRnb6 NULL 1.123 1.1234567890
+-1064949302 -1645852809 NULL 6454.0 -1064949302 -1645852809 NULL 6454.0 -1064949302 -1645852809 NULL 6454.0 8u8tR858jC01y8Ft66nYRnb6 NULL 3.321 9.9876543210
+-1064981602 -1444011153 -51.0 NULL -1064981602 -1444011153 -51.0 NULL -1064981602 -1444011153 -51.0 NULL aY3tpnr6wfvmWMG0U881 -51.0 1.123 1.1234567890
+-1064981602 -1444011153 -51.0 NULL -1064981602 -1444011153 -51.0 NULL -1064981602 -1444011153 -51.0 NULL aY3tpnr6wfvmWMG0U881 -51.0 3.321 9.9876543210
+-1065117869 -1887561756 NULL 2538.0 -1065117869 -1887561756 NULL 2538.0 -1065117869 -1887561756 NULL 2538.0 jWVP6gOkq12mdh NULL 1.123 1.1234567890
+-1065117869 -1887561756 NULL 2538.0 -1065117869 -1887561756 NULL 2538.0 -1065117869 -1887561756 NULL 2538.0 jWVP6gOkq12mdh NULL 3.321 9.9876543210
+-1065775394 -1331703092 -51.0 NULL -1065775394 -1331703092 -51.0 NULL -1065775394 -1331703092 -51.0 NULL aD88uS2N8DmqPlvjOa7F46i7 -51.0 1.123 1.1234567890
+-1065775394 -1331703092 -51.0 NULL -1065775394 -1331703092 -51.0 NULL -1065775394 -1331703092 -51.0 NULL aD88uS2N8DmqPlvjOa7F46i7 -51.0 3.321 9.9876543210
+-1066226047 1864027286 NULL -9439.0 -1066226047 1864027286 NULL -9439.0 -1066226047 1864027286 NULL -9439.0 8GIqX3tvNqrgH NULL 1.123 1.1234567890
+-1066226047 1864027286 NULL -9439.0 -1066226047 1864027286 NULL -9439.0 -1066226047 1864027286 NULL -9439.0 8GIqX3tvNqrgH NULL 3.321 9.9876543210
+-1066684273 2034191923 -51.0 NULL -1066684273 2034191923 -51.0 NULL -1066684273 2034191923 -51.0 NULL 2W4Kg220OcCy065HG60k6e -51.0 1.123 1.1234567890
+-1066684273 2034191923 -51.0 NULL -1066684273 2034191923 -51.0 NULL -1066684273 2034191923 -51.0 NULL 2W4Kg220OcCy065HG60k6e -51.0 3.321 9.9876543210
+-1066922682 -1645852809 NULL -9987.0 -1066922682 -1645852809 NULL -9987.0 -1066922682 -1645852809 NULL -9987.0 0RrH6XDA1 NULL 1.123 1.1234567890
+-1066922682 -1645852809 NULL -9987.0 -1066922682 -1645852809 NULL -9987.0 -1066922682 -1645852809 NULL -9987.0 0RrH6XDA1 NULL 3.321 9.9876543210
+-1067386090 -1887561756 NULL -3977.0 -1067386090 -1887561756 NULL -3977.0 -1067386090 -1887561756 NULL -3977.0 HBtg2r6pR16VC73 NULL 1.123 1.1234567890
+-1067386090 -1887561756 NULL -3977.0 -1067386090 -1887561756 NULL -3977.0 -1067386090 -1887561756 NULL -3977.0 HBtg2r6pR16VC73 NULL 3.321 9.9876543210
+-1067683781 1750003656 -51.0 NULL -1067683781 1750003656 -51.0 NULL -1067683781 1750003656 -51.0 NULL IbgbUvP5 -51.0 1.123 1.1234567890
+-1067683781 1750003656 -51.0 NULL -1067683781 1750003656 -51.0 NULL -1067683781 1750003656 -51.0 NULL IbgbUvP5 -51.0 3.321 9.9876543210
+-1067874703 -1742615956 11.0 NULL -1067874703 -1742615956 11.0 NULL -1067874703 -1742615956 11.0 NULL us1gH35lcpND 11.0 1.123 1.1234567890
+-1067874703 -1742615956 11.0 NULL -1067874703 -1742615956 11.0 NULL -1067874703 -1742615956 11.0 NULL us1gH35lcpND 11.0 3.321 9.9876543210
+-1068206466 1240583144 8.0 NULL -1068206466 1240583144 8.0 NULL -1068206466 1240583144 8.0 NULL F3u1yJaQywofxCCM4v4jScY 8.0 1.123 1.1234567890
+-1068206466 1240583144 8.0 NULL -1068206466 1240583144 8.0 NULL -1068206466 1240583144 8.0 NULL F3u1yJaQywofxCCM4v4jScY 8.0 3.321 9.9876543210
+-1068247011 -729456614 8.0 NULL -1068247011 -729456614 8.0 NULL -1068247011 -729456614 8.0 NULL dPbX4jd1v47r1bB6506si 8.0 1.123 1.1234567890
+-1068247011 -729456614 8.0 NULL -1068247011 -729456614 8.0 NULL -1068247011 -729456614 8.0 NULL dPbX4jd1v47r1bB6506si 8.0 3.321 9.9876543210
+-1068336533 925708299 11.0 NULL -1068336533 925708299 11.0 NULL -1068336533 925708299 11.0 NULL PUn1YVC 11.0 1.123 1.1234567890
+-1068336533 925708299 11.0 NULL -1068336533 925708299 11.0 NULL -1068336533 925708299 11.0 NULL PUn1YVC 11.0 3.321 9.9876543210
+-1068623584 -1887561756 NULL -14005.0 -1068623584 -1887561756 NULL -14005.0 -1068623584 -1887561756 NULL -14005.0 s5O357fO5pF0 NULL 1.123 1.1234567890
+-1068623584 -1887561756 NULL -14005.0 -1068623584 -1887561756 NULL -14005.0 -1068623584 -1887561756 NULL -14005.0 s5O357fO5pF0 NULL 3.321 9.9876543210
+-1069097390 -1858556598 11.0 NULL -1069097390 -1858556598 11.0 NULL -1069097390 -1858556598 11.0 NULL B553840U1H2b1M06l6N81 11.0 1.123 1.1234567890
+-1069097390 -1858556598 11.0 NULL -1069097390 -1858556598 11.0 NULL -1069097390 -1858556598 11.0 NULL B553840U1H2b1M06l6N81 11.0 3.321 9.9876543210
+-1069103950 -927759444 11.0 NULL -1069103950 -927759444 11.0 NULL -1069103950 -927759444 11.0 NULL 41A0nYX72UOSfxO4053xy 11.0 1.123 1.1234567890
+-1069103950 -927759444 11.0 NULL -1069103950 -927759444 11.0 NULL -1069103950 -927759444 11.0 NULL 41A0nYX72UOSfxO4053xy 11.0 3.321 9.9876543210
+-1069109166 -1645852809 NULL 8390.0 -1069109166 -1645852809 NULL 8390.0 -1069109166 -1645852809 NULL 8390.0 vW36C22KS75R NULL 1.123 1.1234567890
+-1069109166 -1645852809 NULL 8390.0 -1069109166 -1645852809 NULL 8390.0 -1069109166 -1645852809 NULL 8390.0 vW36C22KS75R NULL 3.321 9.9876543210
+-1069512165 -1645852809 NULL 11417.0 -1069512165 -1645852809 NULL 11417.0 -1069512165 -1645852809 NULL 11417.0 8x6mobxQl6Ef0Hl1 NULL 1.123 1.1234567890
+-1069512165 -1645852809 NULL 11417.0 -1069512165 -1645852809 NULL 11417.0 -1069512165 -1645852809 NULL 11417.0 8x6mobxQl6Ef0Hl1 NULL 3.321 9.9876543210
+-1069736047 -453772520 11.0 NULL -1069736047 -453772520 11.0 NULL -1069736047 -453772520 11.0 NULL k17Am8uPHWk02cEf1jet 11.0 1.123 1.1234567890
+-1069736047 -453772520 11.0 NULL -1069736047 -453772520 11.0 NULL -1069736047 -453772520 11.0 NULL k17Am8uPHWk02cEf1jet 11.0 3.321 9.9876543210
+-1070551679 1864027286 NULL -947.0 -1070551679 1864027286 NULL -947.0 -1070551679 1864027286 NULL -947.0 iUR3Q NULL 1.123 1.1234567890
+-1070551679 1864027286 NULL -947.0 -1070551679 1864027286 NULL -947.0 -1070551679 1864027286 NULL -947.0 iUR3Q NULL 3.321 9.9876543210
+-1070883071 -1645852809 NULL -741.0 -1070883071 -1645852809 NULL -741.0 -1070883071 -1645852809 NULL -741.0 0ruyd6Y50JpdGRf6HqD NULL 1.123 1.1234567890
+-1070883071 -1645852809 NULL -741.0 -1070883071 -1645852809 NULL -741.0 -1070883071 -1645852809 NULL -741.0 0ruyd6Y50JpdGRf6HqD NULL 3.321 9.9876543210
+-1071363017 1349676361 8.0 NULL -1071363017 1349676361 8.0 NULL -1071363017 1349676361 8.0 NULL Anj0oF 8.0 1.123 1.1234567890
+-1071363017 1349676361 8.0 NULL -1071363017 1349676361 8.0 NULL -1071363017 1349676361 8.0 NULL Anj0oF 8.0 3.321 9.9876543210
+-1071480828 -1401575336 -51.0 NULL -1071480828 -1401575336 -51.0 NULL -1071480828 -1401575336 -51.0 NULL aw724t8c5558x2xneC624 -51.0 1.123 1.1234567890
+-1071480828 -1401575336 -51.0 NULL -1071480828 -1401575336 -51.0 NULL -1071480828 -1401575336 -51.0 NULL aw724t8c5558x2xneC624 -51.0 3.321 9.9876543210
+-1072076362 1864027286 NULL -5470.0 -1072076362 1864027286 NULL -5470.0 -1072076362 1864027286 NULL -5470.0 2uLyD28144vklju213J1mr NULL 1.123 1.1234567890
+-1072076362 1864027286 NULL -5470.0 -1072076362 1864027286 NULL -5470.0 -1072076362 1864027286 NULL -5470.0 2uLyD28144vklju213J1mr NULL 3.321 9.9876543210
+-1072081801 1864027286 NULL 8373.0 -1072081801 1864027286 NULL 8373.0 -1072081801 1864027286 NULL 8373.0 dPkN74F7 NULL 1.123 1.1234567890
+-1072081801 1864027286 NULL 8373.0 -1072081801 1864027286 NULL 8373.0 -1072081801 1864027286 NULL 8373.0 dPkN74F7 NULL 3.321 9.9876543210
+-1072910839 2048385991 11.0 NULL -1072910839 2048385991 11.0 NULL -1072910839 2048385991 11.0 NULL 0iqrc5 11.0 1.123 1.1234567890
+-1072910839 2048385991 11.0 NULL -1072910839 2048385991 11.0 NULL -1072910839 2048385991 11.0 NULL 0iqrc5 11.0 3.321 9.9876543210
+-1073051226 -1887561756 NULL -7382.0 -1073051226 -1887561756 NULL -7382.0 -1073051226 -1887561756 NULL -7382.0 A34p7oRr2WvUJNf NULL 1.123 1.1234567890
+-1073051226 -1887561756 NULL -7382.0 -1073051226 -1887561756 NULL -7382.0 -1073051226 -1887561756 NULL -7382.0 A34p7oRr2WvUJNf NULL 3.321 9.9876543210
+-1073279343 -1595604468 11.0 NULL -1073279343 -1595604468 11.0 NULL -1073279343 -1595604468 11.0 NULL oj1YrV5Wa 11.0 1.123 1.1234567890
+-1073279343 -1595604468 11.0 NULL -1073279343 -1595604468 11.0 NULL -1073279343 -1595604468 11.0 NULL oj1YrV5Wa 11.0 3.321 9.9876543210
PREHOOK: query: select cstring1 from orc_llap2
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_llap2
@@ -426,36 +444,36 @@ POSTHOOK: query: select cstring1 from orc_llap2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_llap2
#### A masked pattern was here ####
-Q1JAdUlCVORmR0Q5X5Vf5u6
-eNsh5tYa
-5j7GJ8OCXgMVIcK7
-uJGHsW3cd073NGFITyQ
-G1u0pUmU6ehCm
-mk6lShdOa8kXT8i7mLd3fK
-u5C7glqT5XqtO0JE2686lk1
-h4omSc1jcLLwW
-tFY2ng51v
-vmAT10eeE47fgH20pLi
-uN803aW
-qqbDw46IgGds4
-32v414p63Jv1B4tO1xy
-73xdw4X
-d3o1712a03n20qvi62U7
-eQ80MW0h728I204P87YXc
-KHtD2A2hp6OjFgS73gdgE
-nI30tm7U55O0gI
-LSJtFA66
-mby00c
-meGb5
-pM6Gt05s1YJeii
-LR2AKy0dPt8vFdIV5760jriw
-1B3WMD5LSk65B2Moa
-xTlDv24JYv4s
-28Oe6r21yux7Lk47
-7wH3hBKdO55Xq3gEEe0
-5QLs0LVK1g
-ET3d4F2I4lV
-testvalue
+0RrH6XDA1
+0iqrc5
+0ruyd6Y50JpdGRf6HqD
+2W4Kg220OcCy065HG60k6e
+2uLyD28144vklju213J1mr
+41A0nYX72UOSfxO4053xy
+47INeW44yvsne46Mu
+8GIqX3tvNqrgH
+8u8tR858jC01y8Ft66nYRnb6
+8x6mobxQl6Ef0Hl1
+A34p7oRr2WvUJNf
+Anj0oF
+B553840U1H2b1M06l6N81
+F3u1yJaQywofxCCM4v4jScY
+HBtg2r6pR16VC73
+IbgbUvP5
+PUn1YVC
+aD88uS2N8DmqPlvjOa7F46i7
+aY3tpnr6wfvmWMG0U881
+aw724t8c5558x2xneC624
+dPbX4jd1v47r1bB6506si
+dPkN74F7
+iUR3Q
+jWVP6gOkq12mdh
+k17Am8uPHWk02cEf1jet
+k7i5RkMq88H0s
+oj1YrV5Wa
+s5O357fO5pF0
+us1gH35lcpND
+vW36C22KS75R
PREHOOK: query: select cfloat2, cint from orc_llap2
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_llap2
@@ -464,36 +482,36 @@ POSTHOOK: query: select cfloat2, cint from orc_llap2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_llap2
#### A masked pattern was here ####
-NULL 246423894
-NULL 708885482
-NULL 186967185
-NULL -595277064
-NULL 584923170
-NULL 518213127
-NULL -334595454
-NULL 241008004
-NULL 185212032
-NULL -738747840
-NULL -971543377
-NULL 940448896
-NULL -324030556
-NULL -899422227
-11.0 835111400
-11.0 -775326158
-11.0 653630202
-11.0 779427499
-11.0 797003983
-11.0 31832752
-11.0 783790031
-11.0 -898241885
-11.0 NULL
-11.0 -646295381
-11.0 130912195
-11.0 -391573084
-11.0 385623629
-11.0 681126962
-11.0 25892751
-NULL -838810013
+-51.0 -1064718136
+-51.0 -1064981602
+-51.0 -1065775394
+-51.0 -1066684273
+-51.0 -1067683781
+-51.0 -1071480828
+11.0 -1064623720
+11.0 -1067874703
+11.0 -1068336533
+11.0 -1069097390
+11.0 -1069103950
+11.0 -1069736047
+11.0 -1072910839
+11.0 -1073279343
+8.0 -1068206466
+8.0 -1068247011
+8.0 -1071363017
+NULL -1064949302
+NULL -1065117869
+NULL -1066226047
+NULL -1066922682
+NULL -1067386090
+NULL -1068623584
+NULL -1069109166
+NULL -1069512165
+NULL -1070551679
+NULL -1070883071
+NULL -1072076362
+NULL -1072081801
+NULL -1073051226
PREHOOK: query: select * from orc_llap2
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_llap2
@@ -502,36 +520,36 @@ POSTHOOK: query: select * from orc_llap2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_llap2
#### A masked pattern was here ####
-246423894 -1645852809 NULL NULL 246423894 -1645852809 NULL NULL 246423894 -1645852809 NULL NULL Q1JAdUlCVORmR0Q5X5Vf5u6 NULL 1.123 1.1234567890
-708885482 -1645852809 NULL NULL 708885482 -1645852809 NULL NULL 708885482 -1645852809 NULL NULL eNsh5tYa NULL 1.123 1.1234567890
-186967185 -1645852809 NULL NULL 186967185 -1645852809 NULL NULL 186967185 -1645852809 NULL NULL 5j7GJ8OCXgMVIcK7 NULL 1.123 1.1234567890
--595277064 -1645852809 NULL NULL -595277064 -1645852809 NULL NULL -595277064 -1645852809 NULL NULL uJGHsW3cd073NGFITyQ NULL 1.123 1.1234567890
-584923170 -1645852809 NULL NULL 584923170 -1645852809 NULL NULL 584923170 -1645852809 NULL NULL G1u0pUmU6ehCm NULL 1.123 1.1234567890
-518213127 -1645852809 NULL NULL 518213127 -1645852809 NULL NULL 518213127 -1645852809 NULL NULL mk6lShdOa8kXT8i7mLd3fK NULL 1.123 1.1234567890
--334595454 -1645852809 NULL NULL -334595454 -1645852809 NULL NULL -334595454 -1645852809 NULL NULL u5C7glqT5XqtO0JE2686lk1 NULL 1.123 1.1234567890
-241008004 -1645852809 NULL NULL 241008004 -1645852809 NULL NULL 241008004 -1645852809 NULL NULL h4omSc1jcLLwW NULL 1.123 1.1234567890
-185212032 -1645852809 NULL NULL 185212032 -1645852809 NULL NULL 185212032 -1645852809 NULL NULL tFY2ng51v NULL 1.123 1.1234567890
--738747840 -1645852809 NULL NULL -738747840 -1645852809 NULL NULL -738747840 -1645852809 NULL NULL vmAT10eeE47fgH20pLi NULL 1.123 1.1234567890
--971543377 -1645852809 NULL NULL -971543377 -1645852809 NULL NULL -971543377 -1645852809 NULL NULL uN803aW NULL 1.123 1.1234567890
-940448896 -1645852809 NULL NULL 940448896 -1645852809 NULL NULL 940448896 -1645852809 NULL NULL qqbDw46IgGds4 NULL 1.123 1.1234567890
--324030556 -1645852809 NULL NULL -324030556 -1645852809 NULL NULL -324030556 -1645852809 NULL NULL 32v414p63Jv1B4tO1xy NULL 1.123 1.1234567890
--899422227 -1645852809 NULL NULL -899422227 -1645852809 NULL NULL -899422227 -1645852809 NULL NULL 73xdw4X NULL 1.123 1.1234567890
-835111400 1964238982 11.0 NULL 835111400 1964238982 11.0 NULL 835111400 1964238982 11.0 NULL d3o1712a03n20qvi62U7 11.0 1.123 1.1234567890
--775326158 -1289793978 11.0 NULL -775326158 -1289793978 11.0 NULL -775326158 -1289793978 11.0 NULL eQ80MW0h728I204P87YXc 11.0 1.123 1.1234567890
-653630202 1281184487 11.0 NULL 653630202 1281184487 11.0 NULL 653630202 1281184487 11.0 NULL KHtD2A2hp6OjFgS73gdgE 11.0 1.123 1.1234567890
-779427499 1326393090 11.0 NULL 779427499 1326393090 11.0 NULL 779427499 1326393090 11.0 NULL nI30tm7U55O0gI 11.0 1.123 1.1234567890
-797003983 1186689849 11.0 NULL 797003983 1186689849 11.0 NULL 797003983 1186689849 11.0 NULL LSJtFA66 11.0 1.123 1.1234567890
-31832752 1854212271 11.0 NULL 31832752 1854212271 11.0 NULL 31832752 1854212271 11.0 NULL mby00c 11.0 1.123 1.1234567890
-783790031 -1482854823 11.0 NULL 783790031 -1482854823 11.0 NULL 783790031 -1482854823 11.0 NULL meGb5 11.0 1.123 1.1234567890
--898241885 -1785664982 11.0 NULL -898241885 -1785664982 11.0 NULL -898241885 -1785664982 11.0 NULL pM6Gt05s1YJeii 11.0 1.123 1.1234567890
-NULL -1083386085 11.0 NULL NULL -1083386085 11.0 NULL NULL -1083386085 11.0 NULL LR2AKy0dPt8vFdIV5760jriw 11.0 1.123 1.1234567890
--646295381 -1654635859 11.0 NULL -646295381 -1654635859 11.0 NULL -646295381 -1654635859 11.0 NULL 1B3WMD5LSk65B2Moa 11.0 1.123 1.1234567890
-130912195 -1286145901 11.0 NULL 130912195 -1286145901 11.0 NULL 130912195 -1286145901 11.0 NULL xTlDv24JYv4s 11.0 1.123 1.1234567890
--391573084 -236100834 11.0 NULL -391573084 -236100834 11.0 NULL -391573084 -236100834 11.0 NULL 28Oe6r21yux7Lk47 11.0 1.123 1.1234567890
-385623629 236101682 11.0 NULL 385623629 236101682 11.0 NULL 385623629 236101682 11.0 NULL 7wH3hBKdO55Xq3gEEe0 11.0 1.123 1.1234567890
-681126962 993392163 11.0 NULL 681126962 993392163 11.0 NULL 681126962 993392163 11.0 NULL 5QLs0LVK1g 11.0 1.123 1.1234567890
-25892751 -1978674520 11.0 NULL 25892751 -1978674520 11.0 NULL 25892751 -1978674520 11.0 NULL ET3d4F2I4lV 11.0 1.123 1.1234567890
--838810013 1864027286 NULL NULL -838810013 1864027286 NULL NULL -838810013 1864027286 NULL NULL testvalue NULL 3.321 9.9876543210
+-1064623720 -1894858490 11.0 NULL -1064623720 -1894858490 11.0 NULL -1064623720 -1894858490 11.0 NULL 47INeW44yvsne46Mu 11.0 1.123 1.1234567890
+-1064718136 156403402 -51.0 NULL -1064718136 156403402 -51.0 NULL -1064718136 156403402 -51.0 NULL k7i5RkMq88H0s -51.0 1.123 1.1234567890
+-1064949302 -1645852809 NULL 6454.0 -1064949302 -1645852809 NULL 6454.0 -1064949302 -1645852809 NULL 6454.0 8u8tR858jC01y8Ft66nYRnb6 NULL 1.123 1.1234567890
+-1064981602 -1444011153 -51.0 NULL -1064981602 -1444011153 -51.0 NULL -1064981602 -1444011153 -51.0 NULL aY3tpnr6wfvmWMG0U881 -51.0 1.123 1.1234567890
+-1065117869 -1887561756 NULL 2538.0 -1065117869 -1887561756 NULL 2538.0 -1065117869 -1887561756 NULL 2538.0 jWVP6gOkq12mdh NULL 1.123 1.1234567890
+-1065775394 -1331703092 -51.0 NULL -1065775394 -1331703092 -51.0 NULL -1065775394 -1331703092 -51.0 NULL aD88uS2N8DmqPlvjOa7F46i7 -51.0 1.123 1.1234567890
+-1066226047 1864027286 NULL -9439.0 -1066226047 1864027286 NULL -9439.0 -1066226047 1864027286 NULL -9439.0 8GIqX3tvNqrgH NULL 1.123 1.1234567890
+-1066684273 2034191923 -51.0 NULL -1066684273 2034191923 -51.0 NULL -1066684273 2034191923 -51.0 NULL 2W4Kg220OcCy065HG60k6e -51.0 1.123 1.1234567890
+-1066922682 -1645852809 NULL -9987.0 -1066922682 -1645852809 NULL -9987.0 -1066922682 -1645852809 NULL -9987.0 0RrH6XDA1 NULL 1.123 1.1234567890
+-1067386090 -1887561756 NULL -3977.0 -1067386090 -1887561756 NULL -3977.0 -1067386090 -1887561756 NULL -3977.0 HBtg2r6pR16VC73 NULL 1.123 1.1234567890
+-1067683781 1750003656 -51.0 NULL -1067683781 1750003656 -51.0 NULL -1067683781 1750003656 -51.0 NULL IbgbUvP5 -51.0 1.123 1.1234567890
+-1067874703 -1742615956 11.0 NULL -1067874703 -1742615956 11.0 NULL -1067874703 -1742615956 11.0 NULL us1gH35lcpND 11.0 1.123 1.1234567890
+-1068206466 1240583144 8.0 NULL -1068206466 1240583144 8.0 NULL -1068206466 1240583144 8.0 NULL F3u1yJaQywofxCCM4v4jScY 8.0 1.123 1.1234567890
+-1068247011 -729456614 8.0 NULL -1068247011 -729456614 8.0 NULL -1068247011 -729456614 8.0 NULL dPbX4jd1v47r1bB6506si 8.0 1.123 1.1234567890
+-1068336533 925708299 11.0 NULL -1068336533 925708299 11.0 NULL -1068336533 925708299 11.0 NULL PUn1YVC 11.0 1.123 1.1234567890
+-1068623584 -1887561756 NULL -14005.0 -1068623584 -1887561756 NULL -14005.0 -1068623584 -1887561756 NULL -14005.0 s5O357fO5pF0 NULL 1.123 1.1234567890
+-1069097390 -1858556598 11.0 NULL -1069097390 -1858556598 11.0 NULL -1069097390 -1858556598 11.0 NULL B553840U1H2b1M06l6N81 11.0 1.123 1.1234567890
+-1069103950 -927759444 11.0 NULL -1069103950 -927759444 11.0 NULL -1069103950 -927759444 11.0 NULL 41A0nYX72UOSfxO4053xy 11.0 1.123 1.1234567890
+-1069109166 -1645852809 NULL 8390.0 -1069109166 -1645852809 NULL 8390.0 -1069109166 -1645852809 NULL 8390.0 vW36C22KS75R NULL 1.123 1.1234567890
+-1069512165 -1645852809 NULL 11417.0 -1069512165 -1645852809 NULL 11417.0 -1069512165 -1645852809 NULL 11417.0 8x6mobxQl6Ef0Hl1 NULL 1.123 1.1234567890
+-1069736047 -453772520 11.0 NULL -1069736047 -453772520 11.0 NULL -1069736047 -453772520 11.0 NULL k17Am8uPHWk02cEf1jet 11.0 1.123 1.1234567890
+-1070551679 1864027286 NULL -947.0 -1070551679 1864027286 NULL -947.0 -1070551679 1864027286 NULL -947.0 iUR3Q NULL 1.123 1.1234567890
+-1070883071 -1645852809 NULL -741.0 -1070883071 -1645852809 NULL -741.0 -1070883071 -1645852809 NULL -741.0 0ruyd6Y50JpdGRf6HqD NULL 1.123 1.1234567890
+-1071363017 1349676361 8.0 NULL -1071363017 1349676361 8.0 NULL -1071363017 1349676361 8.0 NULL Anj0oF 8.0 1.123 1.1234567890
+-1071480828 -1401575336 -51.0 NULL -1071480828 -1401575336 -51.0 NULL -1071480828 -1401575336 -51.0 NULL aw724t8c5558x2xneC624 -51.0 1.123 1.1234567890
+-1072076362 1864027286 NULL -5470.0 -1072076362 1864027286 NULL -5470.0 -1072076362 1864027286 NULL -5470.0 2uLyD28144vklju213J1mr NULL 1.123 1.1234567890
+-1072081801 1864027286 NULL 8373.0 -1072081801 1864027286 NULL 8373.0 -1072081801 1864027286 NULL 8373.0 dPkN74F7 NULL 1.123 1.1234567890
+-1072910839 2048385991 11.0 NULL -1072910839 2048385991 11.0 NULL -1072910839 2048385991 11.0 NULL 0iqrc5 11.0 1.123 1.1234567890
+-1073051226 -1887561756 NULL -7382.0 -1073051226 -1887561756 NULL -7382.0 -1073051226 -1887561756 NULL -7382.0 A34p7oRr2WvUJNf NULL 1.123 1.1234567890
+-1073279343 -1595604468 11.0 NULL -1073279343 -1595604468 11.0 NULL -1073279343 -1595604468 11.0 NULL oj1YrV5Wa 11.0 1.123 1.1234567890
PREHOOK: query: DROP TABLE orc_llap_n2
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@orc_llap_n2
http://git-wip-us.apache.org/repos/asf/hive/blob/138b00ca/ql/src/test/results/clientpositive/llap/llap_nullscan.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/llap_nullscan.q.out b/ql/src/test/results/clientpositive/llap/llap_nullscan.q.out
index 515b340..3404cdb 100644
--- a/ql/src/test/results/clientpositive/llap/llap_nullscan.q.out
+++ b/ql/src/test/results/clientpositive/llap/llap_nullscan.q.out
@@ -47,22 +47,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src_orc_n1
- Statistics: Num rows: 10 Data size: 7360 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 3580 Basic stats: COMPLETE Column stats: COMPLETE
GatherStats: false
Filter Operator
isSamplingPred: false
predicate: false (type: boolean)
- Statistics: Num rows: 1 Data size: 736 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 358 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: string), value (type: string), ds (type: string), hr (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 1 Data size: 736 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 358 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
GlobalTableId: 0
directory: hdfs://### HDFS PATH ###
NumFilesPerFileSink: 1
- Statistics: Num rows: 1 Data size: 736 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 358 Basic stats: COMPLETE Column stats: COMPLETE
Stats Publishing Key Prefix: hdfs://### HDFS PATH ###
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -89,7 +89,7 @@ STAGE PLANS:
input format: org.apache.hadoop.hive.ql.io.OneNullRowInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
properties:
- COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
+ COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"ds":"true","hr":"true","key":"true","value":"true"}}
bucket_count -1
bucketing_version 2
column.name.delimiter ,
@@ -112,7 +112,7 @@ STAGE PLANS:
input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
properties:
- COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
+ COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"ds":"true","hr":"true","key":"true","value":"true"}}
bucket_count -1
bucketing_version 2
column.name.delimiter ,
@@ -177,29 +177,29 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src_orc_n1
- Statistics: Num rows: 10 Data size: 1840 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 870 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: false (type: boolean)
- Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 87 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 87 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 87 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 10 Data size: 1840 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 870 Basic stats: COMPLETE Column stats: COMPLETE
Limit
Number of rows: 0
- Statistics: Num rows: 0 Data size: 0 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 87 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
sort order:
- Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 87 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: string)
Execution mode: vectorized, llap
LLAP IO: all inputs
@@ -213,10 +213,10 @@ STAGE PLANS:
0 _col0 (type: string)
1 _col0 (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 1 Data size: 202 Basic stats: PARTIAL Column stats: NONE
+ Statistics: Num rows: 1 Data size: 174 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 202 Basic stats: PARTIAL Column stats: NONE
+ Statistics: Num rows: 1 Data size: 174 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -227,15 +227,15 @@ STAGE PLANS:
Select Operator
expressions: VALUE._col0 (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 87 Basic stats: COMPLETE Column stats: COMPLETE
Limit
Number of rows: 0
- Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 87 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 87 Basic stats: COMPLETE Column stats: COMPLETE
Stage: Stage-0
Fetch Operator
@@ -278,18 +278,18 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src_orc_n1
- Statistics: Num rows: 10 Data size: 1840 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 870 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: false (type: boolean)
- Statistics: Num rows: 1 Data size: 184 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 87 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count(key)
mode: hash
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 192 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 192 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: bigint)
Execution mode: vectorized, llap
LLAP IO: no inputs
@@ -297,19 +297,19 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src_orc_n1
- Statistics: Num rows: 10 Data size: 1840 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 870 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: string)
outputColumnNames: key
- Statistics: Num rows: 10 Data size: 1840 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 870 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count(key)
mode: hash
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 192 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
sort order:
- Statistics: Num rows: 1 Data size: 192 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: bigint)
Execution mode: vectorized, llap
LLAP IO: all inputs
@@ -320,10 +320,10 @@ STAGE PLANS:
aggregations: count(VALUE._col0)
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 192 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 2 Data size: 384 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -335,10 +335,10 @@ STAGE PLANS:
aggregations: count(VALUE._col0)
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 192 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 2 Data size: 384 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -388,15 +388,15 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s1
- Statistics: Num rows: 10 Data size: 7360 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 3580 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: false (type: boolean)
- Statistics: Num rows: 1 Data size: 736 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 358 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: value (type: string)
sort order: +
Map-reduce partition columns: value (type: string)
- Statistics: Num rows: 1 Data size: 736 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 358 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: key (type: string), ds (type: string), hr (type: string)
Execution mode: vectorized, llap
LLAP IO: no inputs
@@ -404,15 +404,15 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: s2
- Statistics: Num rows: 10 Data size: 7360 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 3580 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: false (type: boolean)
- Statistics: Num rows: 1 Data size: 736 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 358 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: value (type: string)
sort order: +
Map-reduce partition columns: value (type: string)
- Statistics: Num rows: 1 Data size: 736 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 358 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: key (type: string), ds (type: string), hr (type: string)
Execution mode: vectorized, llap
LLAP IO: no inputs
@@ -426,14 +426,14 @@ STAGE PLANS:
0 value (type: string)
1 value (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col7, _col8, _col9, _col10
- Statistics: Num rows: 1 Data size: 809 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 716 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col7 (type: string), _col8 (type: string), _col9 (type: string), _col10 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
- Statistics: Num rows: 1 Data size: 809 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 716 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 809 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 716 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
http://git-wip-us.apache.org/repos/asf/hive/blob/138b00ca/ql/src/test/results/clientpositive/llap/llap_partitioned.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/llap_partitioned.q.out b/ql/src/test/results/clientpositive/llap/llap_partitioned.q.out
index 7e6e88b..529543c 100644
--- a/ql/src/test/results/clientpositive/llap/llap_partitioned.q.out
+++ b/ql/src/test/results/clientpositive/llap/llap_partitioned.q.out
@@ -2374,7 +2374,7 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: llap_temp_table_n0
- Statistics: Num rows: 1509 Data size: 984410 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1509 Data size: 250448 Basic stats: COMPLETE Column stats: COMPLETE
TableScan Vectorization:
native: true
vectorizationSchemaColumns: [0:ctinyint:tinyint, 1:cint:int, 2:cchar1:char(255), 3:cvchar1:varchar(255), 4:ROW__ID:struct<writeid:bigint,bucketid:int,rowid:bigint>]
@@ -2385,7 +2385,7 @@ STAGE PLANS:
className: VectorSelectOperator
native: true
projectedOutputColumnNums: [0, 1, 2, 3]
- Statistics: Num rows: 1509 Data size: 984410 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1509 Data size: 250448 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: sum(hash(ctinyint,cint,cchar1,cvchar1))
Group By Vectorization:
@@ -2397,7 +2397,7 @@ STAGE PLANS:
projectedOutputColumnNums: [0]
mode: hash
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 694 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
sort order:
Reduce Sink Vectorization:
@@ -2405,7 +2405,7 @@ STAGE PLANS:
native: true
nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true, No PTF TopN IS true, No DISTINCT columns IS true, BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true
valueColumns: 0:bigint
- Statistics: Num rows: 1 Data size: 694 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: bigint)
Execution mode: vectorized, llap
LLAP IO: no inputs
@@ -2451,13 +2451,13 @@ STAGE PLANS:
projectedOutputColumnNums: [0]
mode: mergepartial
outputColumnNames: _col0
- Statistics: Num rows: 1 Data size: 694 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
File Sink Vectorization:
className: VectorFileSinkOperator
native: false
- Statistics: Num rows: 1 Data size: 694 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
http://git-wip-us.apache.org/repos/asf/hive/blob/138b00ca/ql/src/test/results/clientpositive/llap/llap_udf.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/llap_udf.q.out b/ql/src/test/results/clientpositive/llap/llap_udf.q.out
index 292c0f9..62f9cd2 100644
--- a/ql/src/test/results/clientpositive/llap/llap_udf.q.out
+++ b/ql/src/test/results/clientpositive/llap/llap_udf.q.out
@@ -41,14 +41,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src_orc_n0
- Statistics: Num rows: 500 Data size: 87584 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: evaluate_npe(key) (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 500 Data size: 87584 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92000 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 500 Data size: 87584 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92000 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -108,14 +108,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src_orc_n0
- Statistics: Num rows: 500 Data size: 87584 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: GenericUDFTestGetJavaString(key) (type: string), GenericUDFTestGetJavaString(key) (type: string), evaluate_npe(key) (type: string)
outputColumnNames: _col0, _col1, _col2
- Statistics: Num rows: 500 Data size: 87584 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 276000 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 500 Data size: 87584 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 276000 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -152,19 +152,20 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src_orc_n0
- Statistics: Num rows: 500 Data size: 87584 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: evaluate_npe(key) (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 500 Data size: 87584 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92000 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 500 Data size: 87584 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92000 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- Execution mode: vectorized
+ Execution mode: vectorized, llap
+ LLAP IO: all inputs
Stage: Stage-0
Fetch Operator
@@ -203,14 +204,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src_orc_n0
- Statistics: Num rows: 500 Data size: 87584 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: GenericUDFTestGetJavaString(key) (type: string), evaluate_npe(key) (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 87584 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 184000 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 500 Data size: 87584 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 184000 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -255,14 +256,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src_orc_n0
- Statistics: Num rows: 500 Data size: 87584 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: evaluate_npe(key) (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 500 Data size: 87584 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92000 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 500 Data size: 87584 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92000 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -298,14 +299,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src_orc_n0
- Statistics: Num rows: 500 Data size: 87584 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: GenericUDFTestGetJavaString(key) (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 500 Data size: 87584 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92000 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 500 Data size: 87584 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 92000 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
http://git-wip-us.apache.org/repos/asf/hive/blob/138b00ca/ql/src/test/results/clientpositive/llap/llapdecider.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/llapdecider.q.out b/ql/src/test/results/clientpositive/llap/llapdecider.q.out
index 8f482a7..228520c 100644
--- a/ql/src/test/results/clientpositive/llap/llapdecider.q.out
+++ b/ql/src/test/results/clientpositive/llap/llapdecider.q.out
@@ -113,48 +113,49 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src_orc_n2
- Statistics: Num rows: 500 Data size: 175168 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: string), value (type: string)
outputColumnNames: key, value
- Statistics: Num rows: 500 Data size: 175168 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count(value)
keys: key (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 175168 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 23750 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 500 Data size: 175168 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 23750 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: bigint)
- Execution mode: vectorized
+ Execution mode: vectorized, llap
+ LLAP IO: all inputs
Reducer 2
- Execution mode: vectorized
+ Execution mode: vectorized, llap
Reduce Operator Tree:
Group By Operator
aggregations: count(VALUE._col0)
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 87584 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 23750 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col1 (type: bigint)
sort order: +
- Statistics: Num rows: 250 Data size: 87584 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 23750 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: string)
Reducer 3
- Execution mode: vectorized
+ Execution mode: vectorized, llap
Reduce Operator Tree:
Select Operator
expressions: VALUE._col0 (type: string), KEY.reducesinkkey0 (type: bigint)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 87584 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 23750 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 250 Data size: 87584 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 23750 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -191,22 +192,22 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: src_orc_n2
- Statistics: Num rows: 500 Data size: 175168 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: key (type: string), value (type: string)
outputColumnNames: key, value
- Statistics: Num rows: 500 Data size: 175168 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: count(value)
keys: key (type: string)
mode: hash
outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 175168 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 23750 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 500 Data size: 175168 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 23750 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: bigint)
Execution mode: vectorized, llap
LLAP IO: all inputs
@@ -218,11 +219,11 @@ STAGE PLANS:
keys: KEY._col0 (type: string)
mode: mergepartial
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 87584 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 23750 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col1 (type: bigint)
sort order: +
- Statistics: Num rows: 250 Data size: 87584 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 23750 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: string)
Reducer 3
Execution mode: vectorized, llap
@@ -230,10 +231,10 @@ STAGE PLANS:
Select Operator
expressions: VALUE._col0 (type: string), KEY.reducesinkkey0 (type: bigint)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 250 Data size: 87584 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 23750 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 250 Data size: 87584 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 250 Data size: 23750 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
http://git-wip-us.apache.org/repos/asf/hive/blob/138b00ca/ql/src/test/results/clientpositive/llap/materialized_view_create.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_create.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_create.q.out
index 14bf676..1540483 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_create.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_create.q.out
@@ -45,7 +45,7 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MATERIALIZED_VIEW
Table Parameters:
- COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+ COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"a\":\"true\",\"b\":\"true\",\"c\":\"true\"}}
bucketing_version 2
numFiles 1
numRows 5
@@ -107,7 +107,7 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MATERIALIZED_VIEW
Table Parameters:
- COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+ COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"a\":\"true\",\"c\":\"true\"}}
bucketing_version 2
numFiles 1
numRows 5
@@ -243,7 +243,7 @@ PREHOOK: query: show tblproperties cmv_mat_view5
PREHOOK: type: SHOW_TBLPROPERTIES
POSTHOOK: query: show tblproperties cmv_mat_view5
POSTHOOK: type: SHOW_TBLPROPERTIES
-COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
+COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"a":"true","b":"true","c":"true","d":"true","f":"true"}}
bucketing_version 2
key value
numFiles 1
http://git-wip-us.apache.org/repos/asf/hive/blob/138b00ca/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite.q.out b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite.q.out
index 69bdbea..6bf9ee5 100644
--- a/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite.q.out
+++ b/ql/src/test/results/clientpositive/llap/materialized_view_create_rewrite.q.out
@@ -28,16 +28,6 @@ POSTHOOK: Lineage: cmv_basetable_n10.a SCRIPT []
POSTHOOK: Lineage: cmv_basetable_n10.b SCRIPT []
POSTHOOK: Lineage: cmv_basetable_n10.c SCRIPT []
POSTHOOK: Lineage: cmv_basetable_n10.d SCRIPT []
-PREHOOK: query: analyze table cmv_basetable_n10 compute statistics for columns
-PREHOOK: type: ANALYZE_TABLE
-PREHOOK: Input: default@cmv_basetable_n10
-PREHOOK: Output: default@cmv_basetable_n10
-#### A masked pattern was here ####
-POSTHOOK: query: analyze table cmv_basetable_n10 compute statistics for columns
-POSTHOOK: type: ANALYZE_TABLE
-POSTHOOK: Input: default@cmv_basetable_n10
-POSTHOOK: Output: default@cmv_basetable_n10
-#### A masked pattern was here ####
PREHOOK: query: create materialized view cmv_mat_view_n10
as select a, b, c from cmv_basetable_n10 where a = 2
PREHOOK: type: CREATE_MATERIALIZED_VIEW
@@ -64,7 +54,7 @@ PREHOOK: query: show tblproperties cmv_mat_view_n10
PREHOOK: type: SHOW_TBLPROPERTIES
POSTHOOK: query: show tblproperties cmv_mat_view_n10
POSTHOOK: type: SHOW_TBLPROPERTIES
-COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
+COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"a":"true","b":"true","c":"true"}}
bucketing_version 2
numFiles 1
numFilesErasureCoded 0
@@ -98,7 +88,7 @@ PREHOOK: query: show tblproperties cmv_mat_view2_n4
PREHOOK: type: SHOW_TBLPROPERTIES
POSTHOOK: query: show tblproperties cmv_mat_view2_n4
POSTHOOK: type: SHOW_TBLPROPERTIES
-COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"}
+COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"a":"true","c":"true"}}
bucketing_version 2
numFiles 1
numFilesErasureCoded 0
@@ -354,10 +344,10 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: default.cmv_mat_view2_n4
- Statistics: Num rows: 2 Data size: 232 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 232 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
sort order:
- Statistics: Num rows: 2 Data size: 232 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 232 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: a (type: int), c (type: decimal(10,2))
Execution mode: llap
LLAP IO: all inputs
@@ -371,14 +361,14 @@ STAGE PLANS:
0
1
outputColumnNames: _col0, _col1, _col5
- Statistics: Num rows: 2 Data size: 458 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 456 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col0 (type: int), _col1 (type: decimal(10,2)), _col0 (type: int), _col5 (type: decimal(10,2))
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 2 Data size: 458 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 464 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 2 Data size: 458 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 2 Data size: 464 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat