You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by an...@apache.org on 2016/05/28 01:13:01 UTC
[6/9] incubator-trafodion git commit: JIRA TRAFODION-2013 Hive null
values are now handled correctly.
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/1a549e0e/core/sql/regress/hive/EXPECTED001
----------------------------------------------------------------------
diff --git a/core/sql/regress/hive/EXPECTED001 b/core/sql/regress/hive/EXPECTED001
index b015023..45e3653 100644
--- a/core/sql/regress/hive/EXPECTED001
+++ b/core/sql/regress/hive/EXPECTED001
@@ -754,11 +754,11 @@ P_PROMO_SK P_PROMO_ID P_START_DATE_SK P_END_DATE_SK P_ITEM_SK
8 AAAAAAAAIAAAAAAA 2450350 2450409 304 1.0000000E+003 1 eing Y N N N N N N N Offences feel only o Unknown N
9 AAAAAAAAJAAAAAAA 2450192 2450248 3439 1.0000000E+003 1 n st Y N N N N N N N External forces shal Unknown N
10 AAAAAAAAKAAAAAAA 2450324 2450365 3314 1.0000000E+003 1 bar N N N N N N N N Only local achieveme Unknown N
- 11 AAAAAAAALAAAAAAA ? ? ? 1.0000000E+003 ? ought ? ? ? ? N ? N N Teachers shall not m Unknown N
+ 11 AAAAAAAALAAAAAAA ? ? ? 1.0000000E+003 ? ought N N N Teachers shall not m Unknown N
12 AAAAAAAAMAAAAAAA 2450153 2450169 6688 1.0000000E+003 1 able N N N N N N N N Also only times woul Unknown N
13 AAAAAAAANAAAAAAA 2450316 2450365 11354 1.0000000E+003 1 pri N N N N N N N N Years shall not go l Unknown N
14 AAAAAAAAOAAAAAAA 2450236 2450282 14480 1.0000000E+003 1 ese N N N N N N N N Adults would not del Unknown N
- 15 AAAAAAAAPAAAAAAA ? ? ? 1.0000000E+003 ? anti Y ? N N ? N N N Old elements would s Unknown N
+ 15 AAAAAAAAPAAAAAAA ? ? ? 1.0000000E+003 ? anti Y N N N N N Old elements would s Unknown N
16 AAAAAAAAABAAAAAA 2450342 2450351 11899 1.0000000E+003 1 cally Y N N N N N N N Sudden, wooden theor Unknown N
17 AAAAAAAABBAAAAAA 2450360 2450406 15529 1.0000000E+003 1 ation Y N N N N N N N Almost old churches Unknown N
18 AAAAAAAACBAAAAAA 2450581 2450592 8599 1.0000000E+003 1 eing Y N N N N N N N National communities Unknown N
@@ -771,7 +771,7 @@ P_PROMO_SK P_PROMO_ID P_START_DATE_SK P_END_DATE_SK P_ITEM_SK
25 AAAAAAAAJBAAAAAA 2450757 2450780 16328 1.0000000E+003 1 anti Y N N N N N N N Scenes might make hi Unknown N
26 AAAAAAAAKBAAAAAA 2450528 2450545 8600 1.0000000E+003 1 cally N N N N N N N N Legal discussions mu Unknown N
27 AAAAAAAALBAAAAAA 2450849 2450879 15421 1.0000000E+003 1 ation Y N N N N N N N Mental men go britis Unknown N
- 28 AAAAAAAAMBAAAAAA 2450816 2450856 1885 ? 1 ? N N N N N ? N N Successful opportuni Unknown ?
+ 28 AAAAAAAAMBAAAAAA 2450816 2450856 1885 ? 1 N N N N N N N Successful opportuni Unknown
29 AAAAAAAANBAAAAAA 2450696 2450732 14660 1.0000000E+003 1 n st Y N N N N N N N Residential, necessa Unknown N
30 AAAAAAAAOBAAAAAA 2450718 2450762 10987 1.0000000E+003 1 bar N N N N N N N N Flowers used to stop Unknown N
31 AAAAAAAAPBAAAAAA 2450848 2450880 11990 1.0000000E+003 1 ought Y N N N N N N N Broad times might sa Unknown N
@@ -801,7 +801,7 @@ P_PROMO_SK P_PROMO_ID P_START_DATE_SK P_END_DATE_SK P_ITEM_SK
55 AAAAAAAAHDAAAAAA 2450622 2450677 12104 1.0000000E+003 1 anti N N N N N N N N Recent, southern lis Unknown N
56 AAAAAAAAIDAAAAAA 2450838 2450888 17563 1.0000000E+003 1 cally Y N N N N N N N Procedures can call Unknown N
57 AAAAAAAAJDAAAAAA 2450834 2450842 12247 1.0000000E+003 1 ation Y N N N N N N N Hours discriminate t Unknown N
- 58 AAAAAAAAKDAAAAAA ? 2450797 12404 1.0000000E+003 ? eing Y N N N ? N ? ? ? ? ?
+ 58 AAAAAAAAKDAAAAAA ? 2450797 12404 1.0000000E+003 ? eing Y N N N N
59 AAAAAAAALDAAAAAA 2450273 2450322 5102 1.0000000E+003 1 n st N N N N N N N N Strong samples parti Unknown N
60 AAAAAAAAMDAAAAAA 2450646 2450676 12076 1.0000000E+003 1 bar Y N N N N N N N Yards write too only Unknown N
61 AAAAAAAANDAAAAAA 2450619 2450667 14864 1.0000000E+003 1 ought Y N N N N N N N Necessary men shall Unknown N
@@ -814,7 +814,7 @@ P_PROMO_SK P_PROMO_ID P_START_DATE_SK P_END_DATE_SK P_ITEM_SK
68 AAAAAAAAEEAAAAAA 2450851 2450893 1210 1.0000000E+003 1 eing Y N N N N N N N Reasonably additiona Unknown N
69 AAAAAAAAFEAAAAAA 2450202 2450219 7471 1.0000000E+003 1 n st N N N N N N N N All right able inter Unknown N
70 AAAAAAAAGEAAAAAA 2450679 2450735 3571 1.0000000E+003 1 bar Y N N N N N N N Commercial, cool cel Unknown N
- 71 AAAAAAAAHEAAAAAA 2450347 ? ? ? ? ? Y ? N ? N N N N Impossible programme ? ?
+ 71 AAAAAAAAHEAAAAAA 2450347 ? ? ? ? Y N N N N N Impossible programme
72 AAAAAAAAIEAAAAAA 2450347 2450373 6662 1.0000000E+003 1 able N N N N N N N N Beautiful, british t Unknown N
73 AAAAAAAAJEAAAAAA 2450578 2450637 9032 1.0000000E+003 1 pri Y N N N N N N N Tremendous, social t Unknown N
74 AAAAAAAAKEAAAAAA 2450425 2450456 13904 1.0000000E+003 1 ese N N N N N N N N Decent bodies grant Unknown N
@@ -844,7 +844,7 @@ P_PROMO_SK P_PROMO_ID P_START_DATE_SK P_END_DATE_SK P_ITEM_SK
98 AAAAAAAACGAAAAAA 2450384 2450387 10414 1.0000000E+003 1 eing Y N N N N N N N Periods shall not ne Unknown N
99 AAAAAAAADGAAAAAA 2450742 2450799 7544 1.0000000E+003 1 n st Y N N N N N N N White, easy shoulder Unknown N
100 AAAAAAAAEGAAAAAA 2450508 2450562 10645 1.0000000E+003 1 bar N N N N N N N N Villages go more. Mi Unknown N
- 101 AAAAAAAAFGAAAAAA ? 2450811 ? ? ? ? ? N N ? ? ? N N Reports would make a Unknown N
+ 101 AAAAAAAAFGAAAAAA ? 2450811 ? ? ? N N N N Reports would make a Unknown N
102 AAAAAAAAGGAAAAAA 2450608 2450614 9614 1.0000000E+003 1 able Y N N N N N N N Medieval fires may r Unknown N
103 AAAAAAAAHGAAAAAA 2450499 2450525 12688 1.0000000E+003 1 pri N N N N N N N N Still ready eyes wil Unknown N
104 AAAAAAAAIGAAAAAA 2450276 2450293 2461 1.0000000E+003 1 ese N N N N N N N N Years will sum alway Unknown N
@@ -939,8 +939,8 @@ P_PROMO_SK P_PROMO_ID P_START_DATE_SK P_END_DATE_SK P_ITEM_SK
193 AAAAAAAABMAAAAAA 2450259 2450309 8780 1.0000000E+003 1 pri Y N N N N N N N Terms should not kno Unknown N
194 AAAAAAAACMAAAAAA 2450664 2450723 289 1.0000000E+003 1 ese Y N N N N N N N Cultural deaths coul Unknown N
195 AAAAAAAADMAAAAAA 2450543 2450601 5167 1.0000000E+003 1 anti N N N N N N N N Conventions make imm Unknown N
- 196 AAAAAAAAEMAAAAAA 2450315 ? ? ? 1 ? Y ? ? N N ? ? N Able patients will l ? ?
- 197 AAAAAAAAFMAAAAAA 2450299 ? 10550 ? 1 ? ? N N N N ? ? ? ? Unknown ?
+ 196 AAAAAAAAEMAAAAAA 2450315 ? ? ? 1 Y N N N Able patients will l
+ 197 AAAAAAAAFMAAAAAA 2450299 ? 10550 ? 1 N N N N Unknown
198 AAAAAAAAGMAAAAAA 2450617 2450670 15439 1.0000000E+003 1 eing Y N N N N N N N German, crude expect Unknown N
199 AAAAAAAAHMAAAAAA 2450772 2450825 8587 1.0000000E+003 1 n st N N N N N N N N Powerful, considerab Unknown N
200 AAAAAAAAIMAAAAAA 2450215 2450237 12784 1.0000000E+003 1 bar N N N N N N N N Arts attend. Further Unknown N
@@ -957,7 +957,7 @@ P_PROMO_SK P_PROMO_ID P_START_DATE_SK P_END_DATE_SK P_ITEM_SK
211 AAAAAAAADNAAAAAA 2450646 2450649 7508 1.0000000E+003 1 ought Y N N N N N N N Public, running ladi Unknown N
212 AAAAAAAAENAAAAAA 2450781 2450834 10768 1.0000000E+003 1 able N N N N N N N N Good decades take. P Unknown N
213 AAAAAAAAFNAAAAAA 2450403 2450415 6350 1.0000000E+003 1 pri Y N N N N N N N However powerful cri Unknown N
- 214 AAAAAAAAGNAAAAAA ? 2450779 ? 1.0000000E+003 ? ? N ? ? ? ? ? N N Pupils will meet mil Unknown N
+ 214 AAAAAAAAGNAAAAAA ? 2450779 ? 1.0000000E+003 ? N N N Pupils will meet mil Unknown N
215 AAAAAAAAHNAAAAAA 2450235 2450252 5840 1.0000000E+003 1 anti Y N N N N N N N Apparent, experience Unknown N
216 AAAAAAAAINAAAAAA 2450885 2450898 13504 1.0000000E+003 1 cally N N N N N N N N Large, necessary car Unknown N
217 AAAAAAAAJNAAAAAA 2450265 2450316 466 1.0000000E+003 1 ation N N N N N N N N Also splendid terms Unknown N
@@ -968,7 +968,7 @@ P_PROMO_SK P_PROMO_ID P_START_DATE_SK P_END_DATE_SK P_ITEM_SK
222 AAAAAAAAONAAAAAA 2450336 2450378 122 1.0000000E+003 1 able Y N N N N N N N Ways help. Everywher Unknown N
223 AAAAAAAAPNAAAAAA 2450671 2450721 11452 1.0000000E+003 1 pri N N N N N N N N Earlier traditional Unknown N
224 AAAAAAAAAOAAAAAA 2450135 2450140 13534 1.0000000E+003 1 ese Y N N N N N N N Then general prefere Unknown N
- 225 AAAAAAAABOAAAAAA ? 2450434 6514 1.0000000E+003 ? anti ? N ? ? ? N ? ? Actual, very words u ? ?
+ 225 AAAAAAAABOAAAAAA ? 2450434 6514 1.0000000E+003 ? anti N N Actual, very words u
226 AAAAAAAACOAAAAAA 2450436 2450468 2848 1.0000000E+003 1 cally N N N N N N N N Signs must drink cer Unknown N
227 AAAAAAAADOAAAAAA 2450751 2450794 3697 1.0000000E+003 1 ation N N N N N N N N Arms can find social Unknown N
228 AAAAAAAAEOAAAAAA 2450337 2450354 11678 1.0000000E+003 1 eing Y N N N N N N N Most basic walls use Unknown N
@@ -993,7 +993,7 @@ P_PROMO_SK P_PROMO_ID P_START_DATE_SK P_END_DATE_SK P_ITEM_SK
247 AAAAAAAAHPAAAAAA 2450100 2450145 12976 1.0000000E+003 1 ation Y N N N N N N N Therefore distinguis Unknown N
248 AAAAAAAAIPAAAAAA 2450824 2450853 12451 1.0000000E+003 1 eing N N N N N N N N Other facts ensure l Unknown N
249 AAAAAAAAJPAAAAAA 2450467 2450523 4195 1.0000000E+003 1 n st Y N N N N N N N Wrong materials shou Unknown N
- 250 AAAAAAAAKPAAAAAA 2450606 ? ? ? 1 ? ? N N ? ? ? N N Private, political m Unknown ?
+ 250 AAAAAAAAKPAAAAAA 2450606 ? ? ? 1 N N N N Private, political m Unknown
251 AAAAAAAALPAAAAAA 2450150 2450181 9187 1.0000000E+003 1 ought N N N N N N N N Other quarters used Unknown N
252 AAAAAAAAMPAAAAAA 2450290 2450319 1292 1.0000000E+003 1 able N N N N N N N N Small characters cou Unknown N
253 AAAAAAAANPAAAAAA 2450337 2450364 13351 1.0000000E+003 1 pri Y N N N N N N N Similar, true friend Unknown N