http://git-wip-us.apache.org/repos/asf/trafodion/blob/319abf81/core/sql/regress/hive/EXPECTED001 ---------------------------------------------------------------------- diff --git a/core/sql/regress/hive/EXPECTED001 b/core/sql/regress/hive/EXPECTED001 index 7c2ca04..9ec460e 100644 --- a/core/sql/regress/hive/EXPECTED001 +++ b/core/sql/regress/hive/EXPECTED001 @@ -1158,21 +1158,21 @@ T_TIME >> >>select * from store ; -S_STORE_SK S_STORE_ID S_REC_START_DATE S_REC_END_DATE S_CLOSED_DATE_SK S_STORE_NAME S_NUMBER_EMPLOYEES S_FLOOR_SPACE S_HOURS S_MANAGER S_MARKET_ID S_GEOGRAPHY_CLASS S_MARKET_DESC S_MARKET_MANAGER S_DIVISION_ID S_DIVISION_NAME S_COMPANY_ID S_COMPANY_NAME S_STREET_NUMBER S_STREET_NAME S_STREET_TYPE S_SUITE_NUMBER S_CITY S_COUNTY S_STATE S_ZIP S_COUNTRY S_GMT_OFFSET S_TAX_PRECENTAGE ------------ -------------------- -------------------------- -------------------------- ---------------- -------------------- ------------------ ------------- -------------------- -------------------- ----------- -------------------- -------------------- -------------------- ------------- -------------------- ------------ -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------- ---------------- +S_STORE_SK S_STORE_ID S_REC_START_DATE S_REC_END_DATE S_CLOSED_DATE_SK S_STORE_NAME S_NUMBER_EMPLOYEES S_FLOOR_SPACE S_HOURS S_MANAGER S_MARKET_ID S_GEOGRAPHY_CLASS S_MARKET_DESC S_MARKET_MANAGER S_DIVISION_ID S_DIVISION_NAME S_COMPANY_ID S_COMPANY_NAME S_STREET_NUMBER S_STREET_NAME S_STREET_TYPE S_SUITE_NUMBER S_CITY S_COUNTY S_STATE S_ZIP S_COUNTRY S_GMT_OFFSET S_TAX_PRECENTAGE +----------- -------------------- ----------------------------- ----------------------------- ---------------- -------------------- ------------------ ------------- -------------------- -------------------- ----------- -------------------- -------------------- -------------------- ------------- -------------------- ------------ -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------- ---------------- - 1 AAAAAAAABAAAAAAA 1997-03-13 00:00:00.000000 ? 2451189 ought 245 5250760 8AM-4PM William Ward 2 Unknown Enough high areas st Charles Bartley 1 Unknown 1 Unknown 767 Spring Wy Suite 250 Midway Williamson County TN 31904 United States -5.0000000E+000 2.9999999E-002 - 2 AAAAAAAACAAAAAAA 1997-03-13 00:00:00.000000 2000-03-12 00:00:00.000000 ? able 236 5285950 8AM-4PM Scott Smith 8 Unknown Parliamentary candid David Lamontagne 1 Unknown 1 Unknown 255 Sycamore Dr. Suite 410 Midway Williamson County TN 31904 United States -5.0000000E+000 2.9999999E-002 - 3 AAAAAAAACAAAAAAA 2000-03-13 00:00:00.000000 ? ? able 236 7557959 8AM-4PM Scott Smith 7 Unknown Impossible, true arm David Lamontagne 1 Unknown 1 Unknown 877 Park Laurel Road Suite T Midway Williamson County TN 31904 United States -5.0000000E+000 2.9999999E-002 - 4 AAAAAAAAEAAAAAAA 1997-03-13 00:00:00.000000 1999-03-13 00:00:00.000000 2451044 ese 218 9341467 8AM-4PM Edwin Adams 4 Unknown Events would achieve Thomas Pollack 1 Unknown 1 Unknown 27 Lake Ln Suite 260 Midway Williamson County TN 31904 United States -5.0000000E+000 2.9999999E-002 - 5 AAAAAAAAEAAAAAAA 1999-03-14 00:00:00.000000 2001-03-12 00:00:00.000000 2450910 anti 288 9078805 8AM-4PM Edwin Adams 8 Unknown Events would achieve Thomas Pollack 1 Unknown 1 Unknown 27 Lee 6th Court Suite 80 Fairview Williamson County TN 35709 United States -5.0000000E+000 2.9999999E-002 - 6 AAAAAAAAEAAAAAAA 2001-03-13 00:00:00.000000 ? ? cally 229 9026222 8AM-4PM Edwin Adams 10 Unknown Events would achieve Thomas Pollack 1 Unknown 1 Unknown 220 6th Lane Suite 140 Midway Williamson County TN 31904 United States -5.0000000E+000 2.9999999E-002 - 7 AAAAAAAAHAAAAAAA 1997-03-13 00:00:00.000000 ? ? ation 297 8954883 8AM-4PM David Thomas 9 Unknown Architects coul Thomas Benton 1 Unknown 1 Unknown 811 Lee Circle Suite T Midway Williamson County TN 31904 United States -5.0000000E+000 9.9999997E-003 - 8 AAAAAAAAIAAAAAAA 1997-03-13 00:00:00.000000 2000-03-12 00:00:00.000000 ? eing 278 6995995 8AM-4PM Brett Yates 2 Unknown Various bars make mo Dean Morrison 1 Unknown 1 Unknown 226 12th Lane Suite D Fairview Williamson County TN 35709 United States -5.0000000E+000 7.9999998E-002 - 9 AAAAAAAAIAAAAAAA 2000-03-13 00:00:00.000000 ? ? eing 271 6995995 8AM-4PM Brett Yates 2 Unknown Formal, psychologica Dean Morrison 1 Unknown 1 Unknown 226 Hill Boulevard Suite 190 Midway Williamson County TN 31904 United States -5.0000000E+000 7.9999998E-002 - 10 AAAAAAAAKAAAAAAA 1997-03-13 00:00:00.000000 1999-03-13 00:00:00.000000 ? bar 294 9294113 8AM-4PM Raymond Jacobs 8 Unknown Little expectations Michael Wilson 1 Unknown 1 Unknown 175 4th Court Suite C Midway Williamson County TN 31904 United States -5.0000000E+000 5.9999998E-002 - 11 AAAAAAAAKAAAAAAA 1999-03-14 00:00:00.000000 2001-03-12 00:00:00.000000 ? ought 294 9294113 8AM-4PM Raymond Jacobs 6 Unknown Mysterious employe Michael Wilson 1 Unknown 1 Unknown 175 Park Green Court Suite 160 Midway Williamson County TN 31904 United States -5.0000000E+000 1.0999999E-002 - 12 AAAAAAAAKAAAAAAA 2001-03-13 00:00:00.000000 ? ? ought 294 5219562 8AM-12AM Robert Thompson 6 Unknown Events develop i Dustin Kelly 1 Unknown 1 Unknown 337 College Boulevard Suite 100 Fairview Williamson County TN 31904 United States -5.0000000E+000 9.9999997E-003 + 1 AAAAAAAABAAAAAAA 1997-03-13 00:00:00.000000000 ? 2451189 ought 245 5250760 8AM-4PM William Ward 2 Unknown Enough high areas st Charles Bartley 1 Unknown 1 Unknown 767 Spring Wy Suite 250 Midway Williamson County TN 31904 United States -5.0000000E+000 2.9999999E-002 + 2 AAAAAAAACAAAAAAA 1997-03-13 00:00:00.000000000 2000-03-12 00:00:00.000000000 ? able 236 5285950 8AM-4PM Scott Smith 8 Unknown Parliamentary candid David Lamontagne 1 Unknown 1 Unknown 255 Sycamore Dr. Suite 410 Midway Williamson County TN 31904 United States -5.0000000E+000 2.9999999E-002 + 3 AAAAAAAACAAAAAAA 2000-03-13 00:00:00.000000000 ? ? able 236 7557959 8AM-4PM Scott Smith 7 Unknown Impossible, true arm David Lamontagne 1 Unknown 1 Unknown 877 Park Laurel Road Suite T Midway Williamson County TN 31904 United States -5.0000000E+000 2.9999999E-002 + 4 AAAAAAAAEAAAAAAA 1997-03-13 00:00:00.000000000 1999-03-13 00:00:00.000000000 2451044 ese 218 9341467 8AM-4PM Edwin Adams 4 Unknown Events would achieve Thomas Pollack 1 Unknown 1 Unknown 27 Lake Ln Suite 260 Midway Williamson County TN 31904 United States -5.0000000E+000 2.9999999E-002 + 5 AAAAAAAAEAAAAAAA 1999-03-14 00:00:00.000000000 2001-03-12 00:00:00.000000000 2450910 anti 288 9078805 8AM-4PM Edwin Adams 8 Unknown Events would achieve Thomas Pollack 1 Unknown 1 Unknown 27 Lee 6th Court Suite 80 Fairview Williamson County TN 35709 United States -5.0000000E+000 2.9999999E-002 + 6 AAAAAAAAEAAAAAAA 2001-03-13 00:00:00.000000000 ? ? cally 229 9026222 8AM-4PM Edwin Adams 10 Unknown Events would achieve Thomas Pollack 1 Unknown 1 Unknown 220 6th Lane Suite 140 Midway Williamson County TN 31904 United States -5.0000000E+000 2.9999999E-002 + 7 AAAAAAAAHAAAAAAA 1997-03-13 00:00:00.000000000 ? ? ation 297 8954883 8AM-4PM David Thomas 9 Unknown Architects coul Thomas Benton 1 Unknown 1 Unknown 811 Lee Circle Suite T Midway Williamson County TN 31904 United States -5.0000000E+000 9.9999997E-003 + 8 AAAAAAAAIAAAAAAA 1997-03-13 00:00:00.000000000 2000-03-12 00:00:00.000000000 ? eing 278 6995995 8AM-4PM Brett Yates 2 Unknown Various bars make mo Dean Morrison 1 Unknown 1 Unknown 226 12th Lane Suite D Fairview Williamson County TN 35709 United States -5.0000000E+000 7.9999998E-002 + 9 AAAAAAAAIAAAAAAA 2000-03-13 00:00:00.000000000 ? ? eing 271 6995995 8AM-4PM Brett Yates 2 Unknown Formal, psychologica Dean Morrison 1 Unknown 1 Unknown 226 Hill Boulevard Suite 190 Midway Williamson County TN 31904 United States -5.0000000E+000 7.9999998E-002 + 10 AAAAAAAAKAAAAAAA 1997-03-13 00:00:00.000000000 1999-03-13 00:00:00.000000000 ? bar 294 9294113 8AM-4PM Raymond Jacobs 8 Unknown Little expectations Michael Wilson 1 Unknown 1 Unknown 175 4th Court Suite C Midway Williamson County TN 31904 United States -5.0000000E+000 5.9999998E-002 + 11 AAAAAAAAKAAAAAAA 1999-03-14 00:00:00.000000000 2001-03-12 00:00:00.000000000 ? ought 294 9294113 8AM-4PM Raymond Jacobs 6 Unknown Mysterious employe Michael Wilson 1 Unknown 1 Unknown 175 Park Green Court Suite 160 Midway Williamson County TN 31904 United States -5.0000000E+000 1.0999999E-002 + 12 AAAAAAAAKAAAAAAA 2001-03-13 00:00:00.000000000 ? ? ought 294 5219562 8AM-12AM Robert Thompson 6 Unknown Events develop i Dustin Kelly 1 Unknown 1 Unknown 337 College Boulevard Suite 100 Fairview Williamson County TN 31904 United States -5.0000000E+000 9.9999997E-003 --- 12 row(s) selected. >> @@ -1180,374 +1180,374 @@ S_STORE_SK S_STORE_ID S_REC_START_DATE S_REC_END_DATE *** WARNING[6008] Statistics for column (D_DATE) from table HIVE.HIVE.DATE_DIM were not available. As a result, the access path chosen might not be the best possible. -D_DATE --------------------------- +D_DATE +----------------------------- -2099-01-02 00:00:00.000000 -2099-01-03 00:00:00.000000 -2099-01-04 00:00:00.000000 -2099-01-05 00:00:00.000000 -2099-01-06 00:00:00.000000 -2099-01-07 00:00:00.000000 -2099-01-08 00:00:00.000000 -2099-01-09 00:00:00.000000 -2099-01-10 00:00:00.000000 -2099-01-11 00:00:00.000000 -2099-01-12 00:00:00.000000 -2099-01-13 00:00:00.000000 -2099-01-14 00:00:00.000000 -2099-01-15 00:00:00.000000 -2099-01-16 00:00:00.000000 -2099-01-17 00:00:00.000000 -2099-01-18 00:00:00.000000 -2099-01-19 00:00:00.000000 -2099-01-20 00:00:00.000000 -2099-01-21 00:00:00.000000 -2099-01-22 00:00:00.000000 -2099-01-23 00:00:00.000000 -2099-01-24 00:00:00.000000 -2099-01-25 00:00:00.000000 -2099-01-26 00:00:00.000000 -2099-01-27 00:00:00.000000 -2099-01-28 00:00:00.000000 -2099-01-29 00:00:00.000000 -2099-01-30 00:00:00.000000 -2099-01-31 00:00:00.000000 -2099-02-01 00:00:00.000000 -2099-02-02 00:00:00.000000 -2099-02-03 00:00:00.000000 -2099-02-04 00:00:00.000000 -2099-02-05 00:00:00.000000 -2099-02-06 00:00:00.000000 -2099-02-07 00:00:00.000000 -2099-02-08 00:00:00.000000 -2099-02-09 00:00:00.000000 -2099-02-10 00:00:00.000000 -2099-02-11 00:00:00.000000 -2099-02-12 00:00:00.000000 -2099-02-13 00:00:00.000000 -2099-02-14 00:00:00.000000 -2099-02-15 00:00:00.000000 -2099-02-16 00:00:00.000000 -2099-02-17 00:00:00.000000 -2099-02-18 00:00:00.000000 -2099-02-19 00:00:00.000000 -2099-02-20 00:00:00.000000 -2099-02-21 00:00:00.000000 -2099-02-22 00:00:00.000000 -2099-02-23 00:00:00.000000 -2099-02-24 00:00:00.000000 -2099-02-25 00:00:00.000000 -2099-02-26 00:00:00.000000 -2099-02-27 00:00:00.000000 -2099-02-28 00:00:00.000000 -2099-03-01 00:00:00.000000 -2099-03-02 00:00:00.000000 -2099-03-03 00:00:00.000000 -2099-03-04 00:00:00.000000 -2099-03-05 00:00:00.000000 -2099-03-06 00:00:00.000000 -2099-03-07 00:00:00.000000 -2099-03-08 00:00:00.000000 -2099-03-09 00:00:00.000000 -2099-03-10 00:00:00.000000 -2099-03-11 00:00:00.000000 -2099-03-12 00:00:00.000000 -2099-03-13 00:00:00.000000 -2099-03-14 00:00:00.000000 -2099-03-15 00:00:00.000000 -2099-03-16 00:00:00.000000 -2099-03-17 00:00:00.000000 -2099-03-18 00:00:00.000000 -2099-03-19 00:00:00.000000 -2099-03-20 00:00:00.000000 -2099-03-21 00:00:00.000000 -2099-03-22 00:00:00.000000 -2099-03-23 00:00:00.000000 -2099-03-24 00:00:00.000000 -2099-03-25 00:00:00.000000 -2099-03-26 00:00:00.000000 -2099-03-27 00:00:00.000000 -2099-03-28 00:00:00.000000 -2099-03-29 00:00:00.000000 -2099-03-30 00:00:00.000000 -2099-03-31 00:00:00.000000 -2099-04-01 00:00:00.000000 -2099-04-02 00:00:00.000000 -2099-04-03 00:00:00.000000 -2099-04-04 00:00:00.000000 -2099-04-05 00:00:00.000000 -2099-04-06 00:00:00.000000 -2099-04-07 00:00:00.000000 -2099-04-08 00:00:00.000000 -2099-04-09 00:00:00.000000 -2099-04-10 00:00:00.000000 -2099-04-11 00:00:00.000000 -2099-04-12 00:00:00.000000 -2099-04-13 00:00:00.000000 -2099-04-14 00:00:00.000000 -2099-04-15 00:00:00.000000 -2099-04-16 00:00:00.000000 -2099-04-17 00:00:00.000000 -2099-04-18 00:00:00.000000 -2099-04-19 00:00:00.000000 -2099-04-20 00:00:00.000000 -2099-04-21 00:00:00.000000 -2099-04-22 00:00:00.000000 -2099-04-23 00:00:00.000000 -2099-04-24 00:00:00.000000 -2099-04-25 00:00:00.000000 -2099-04-26 00:00:00.000000 -2099-04-27 00:00:00.000000 -2099-04-28 00:00:00.000000 -2099-04-29 00:00:00.000000 -2099-04-30 00:00:00.000000 -2099-05-01 00:00:00.000000 -2099-05-02 00:00:00.000000 -2099-05-03 00:00:00.000000 -2099-05-04 00:00:00.000000 -2099-05-05 00:00:00.000000 -2099-05-06 00:00:00.000000 -2099-05-07 00:00:00.000000 -2099-05-08 00:00:00.000000 -2099-05-09 00:00:00.000000 -2099-05-10 00:00:00.000000 -2099-05-11 00:00:00.000000 -2099-05-12 00:00:00.000000 -2099-05-13 00:00:00.000000 -2099-05-14 00:00:00.000000 -2099-05-15 00:00:00.000000 -2099-05-16 00:00:00.000000 -2099-05-17 00:00:00.000000 -2099-05-18 00:00:00.000000 -2099-05-19 00:00:00.000000 -2099-05-20 00:00:00.000000 -2099-05-21 00:00:00.000000 -2099-05-22 00:00:00.000000 -2099-05-23 00:00:00.000000 -2099-05-24 00:00:00.000000 -2099-05-25 00:00:00.000000 -2099-05-26 00:00:00.000000 -2099-05-27 00:00:00.000000 -2099-05-28 00:00:00.000000 -2099-05-29 00:00:00.000000 -2099-05-30 00:00:00.000000 -2099-05-31 00:00:00.000000 -2099-06-01 00:00:00.000000 -2099-06-02 00:00:00.000000 -2099-06-03 00:00:00.000000 -2099-06-04 00:00:00.000000 -2099-06-05 00:00:00.000000 -2099-06-06 00:00:00.000000 -2099-06-07 00:00:00.000000 -2099-06-08 00:00:00.000000 -2099-06-09 00:00:00.000000 -2099-06-10 00:00:00.000000 -2099-06-11 00:00:00.000000 -2099-06-12 00:00:00.000000 -2099-06-13 00:00:00.000000 -2099-06-14 00:00:00.000000 -2099-06-15 00:00:00.000000 -2099-06-16 00:00:00.000000 -2099-06-17 00:00:00.000000 -2099-06-18 00:00:00.000000 -2099-06-19 00:00:00.000000 -2099-06-20 00:00:00.000000 -2099-06-21 00:00:00.000000 -2099-06-22 00:00:00.000000 -2099-06-23 00:00:00.000000 -2099-06-24 00:00:00.000000 -2099-06-25 00:00:00.000000 -2099-06-26 00:00:00.000000 -2099-06-27 00:00:00.000000 -2099-06-28 00:00:00.000000 -2099-06-29 00:00:00.000000 -2099-06-30 00:00:00.000000 -2099-07-01 00:00:00.000000 -2099-07-02 00:00:00.000000 -2099-07-03 00:00:00.000000 -2099-07-04 00:00:00.000000 -2099-07-05 00:00:00.000000 -2099-07-06 00:00:00.000000 -2099-07-07 00:00:00.000000 -2099-07-08 00:00:00.000000 -2099-07-09 00:00:00.000000 -2099-07-10 00:00:00.000000 -2099-07-11 00:00:00.000000 -2099-07-12 00:00:00.000000 -2099-07-13 00:00:00.000000 -2099-07-14 00:00:00.000000 -2099-07-15 00:00:00.000000 -2099-07-16 00:00:00.000000 -2099-07-17 00:00:00.000000 -2099-07-18 00:00:00.000000 -2099-07-19 00:00:00.000000 -2099-07-20 00:00:00.000000 -2099-07-21 00:00:00.000000 -2099-07-22 00:00:00.000000 -2099-07-23 00:00:00.000000 -2099-07-24 00:00:00.000000 -2099-07-25 00:00:00.000000 -2099-07-26 00:00:00.000000 -2099-07-27 00:00:00.000000 -2099-07-28 00:00:00.000000 -2099-07-29 00:00:00.000000 -2099-07-30 00:00:00.000000 -2099-07-31 00:00:00.000000 -2099-08-01 00:00:00.000000 -2099-08-02 00:00:00.000000 -2099-08-03 00:00:00.000000 -2099-08-04 00:00:00.000000 -2099-08-05 00:00:00.000000 -2099-08-06 00:00:00.000000 -2099-08-07 00:00:00.000000 -2099-08-08 00:00:00.000000 -2099-08-09 00:00:00.000000 -2099-08-10 00:00:00.000000 -2099-08-11 00:00:00.000000 -2099-08-12 00:00:00.000000 -2099-08-13 00:00:00.000000 -2099-08-14 00:00:00.000000 -2099-08-15 00:00:00.000000 -2099-08-16 00:00:00.000000 -2099-08-17 00:00:00.000000 -2099-08-18 00:00:00.000000 -2099-08-19 00:00:00.000000 -2099-08-20 00:00:00.000000 -2099-08-21 00:00:00.000000 -2099-08-22 00:00:00.000000 -2099-08-23 00:00:00.000000 -2099-08-24 00:00:00.000000 -2099-08-25 00:00:00.000000 -2099-08-26 00:00:00.000000 -2099-08-27 00:00:00.000000 -2099-08-28 00:00:00.000000 -2099-08-29 00:00:00.000000 -2099-08-30 00:00:00.000000 -2099-08-31 00:00:00.000000 -2099-09-01 00:00:00.000000 -2099-09-02 00:00:00.000000 -2099-09-03 00:00:00.000000 -2099-09-04 00:00:00.000000 -2099-09-05 00:00:00.000000 -2099-09-06 00:00:00.000000 -2099-09-07 00:00:00.000000 -2099-09-08 00:00:00.000000 -2099-09-09 00:00:00.000000 -2099-09-10 00:00:00.000000 -2099-09-11 00:00:00.000000 -2099-09-12 00:00:00.000000 -2099-09-13 00:00:00.000000 -2099-09-14 00:00:00.000000 -2099-09-15 00:00:00.000000 -2099-09-16 00:00:00.000000 -2099-09-17 00:00:00.000000 -2099-09-18 00:00:00.000000 -2099-09-19 00:00:00.000000 -2099-09-20 00:00:00.000000 -2099-09-21 00:00:00.000000 -2099-09-22 00:00:00.000000 -2099-09-23 00:00:00.000000 -2099-09-24 00:00:00.000000 -2099-09-25 00:00:00.000000 -2099-09-26 00:00:00.000000 -2099-09-27 00:00:00.000000 -2099-09-28 00:00:00.000000 -2099-09-29 00:00:00.000000 -2099-09-30 00:00:00.000000 -2099-10-01 00:00:00.000000 -2099-10-02 00:00:00.000000 -2099-10-03 00:00:00.000000 -2099-10-04 00:00:00.000000 -2099-10-05 00:00:00.000000 -2099-10-06 00:00:00.000000 -2099-10-07 00:00:00.000000 -2099-10-08 00:00:00.000000 -2099-10-09 00:00:00.000000 -2099-10-10 00:00:00.000000 -2099-10-11 00:00:00.000000 -2099-10-12 00:00:00.000000 -2099-10-13 00:00:00.000000 -2099-10-14 00:00:00.000000 -2099-10-15 00:00:00.000000 -2099-10-16 00:00:00.000000 -2099-10-17 00:00:00.000000 -2099-10-18 00:00:00.000000 -2099-10-19 00:00:00.000000 -2099-10-20 00:00:00.000000 -2099-10-21 00:00:00.000000 -2099-10-22 00:00:00.000000 -2099-10-23 00:00:00.000000 -2099-10-24 00:00:00.000000 -2099-10-25 00:00:00.000000 -2099-10-26 00:00:00.000000 -2099-10-27 00:00:00.000000 -2099-10-28 00:00:00.000000 -2099-10-29 00:00:00.000000 -2099-10-30 00:00:00.000000 -2099-10-31 00:00:00.000000 -2099-11-01 00:00:00.000000 -2099-11-02 00:00:00.000000 -2099-11-03 00:00:00.000000 -2099-11-04 00:00:00.000000 -2099-11-05 00:00:00.000000 -2099-11-06 00:00:00.000000 -2099-11-07 00:00:00.000000 -2099-11-08 00:00:00.000000 -2099-11-09 00:00:00.000000 -2099-11-10 00:00:00.000000 -2099-11-11 00:00:00.000000 -2099-11-12 00:00:00.000000 -2099-11-13 00:00:00.000000 -2099-11-14 00:00:00.000000 -2099-11-15 00:00:00.000000 -2099-11-16 00:00:00.000000 -2099-11-17 00:00:00.000000 -2099-11-18 00:00:00.000000 -2099-11-19 00:00:00.000000 -2099-11-20 00:00:00.000000 -2099-11-21 00:00:00.000000 -2099-11-22 00:00:00.000000 -2099-11-23 00:00:00.000000 -2099-11-24 00:00:00.000000 -2099-11-25 00:00:00.000000 -2099-11-26 00:00:00.000000 -2099-11-27 00:00:00.000000 -2099-11-28 00:00:00.000000 -2099-11-29 00:00:00.000000 -2099-11-30 00:00:00.000000 -2099-12-01 00:00:00.000000 -2099-12-02 00:00:00.000000 -2099-12-03 00:00:00.000000 -2099-12-04 00:00:00.000000 -2099-12-05 00:00:00.000000 -2099-12-06 00:00:00.000000 -2099-12-07 00:00:00.000000 -2099-12-08 00:00:00.000000 -2099-12-09 00:00:00.000000 -2099-12-10 00:00:00.000000 -2099-12-11 00:00:00.000000 -2099-12-12 00:00:00.000000 -2099-12-13 00:00:00.000000 -2099-12-14 00:00:00.000000 -2099-12-15 00:00:00.000000 -2099-12-16 00:00:00.000000 -2099-12-17 00:00:00.000000 -2099-12-18 00:00:00.000000 -2099-12-19 00:00:00.000000 -2099-12-20 00:00:00.000000 -2099-12-21 00:00:00.000000 -2099-12-22 00:00:00.000000 -2099-12-23 00:00:00.000000 -2099-12-24 00:00:00.000000 -2099-12-25 00:00:00.000000 -2099-12-26 00:00:00.000000 -2099-12-27 00:00:00.000000 -2099-12-28 00:00:00.000000 -2099-12-29 00:00:00.000000 -2099-12-30 00:00:00.000000 -2099-12-31 00:00:00.000000 -2100-01-01 00:00:00.000000 +2099-01-02 00:00:00.000000000 +2099-01-03 00:00:00.000000000 +2099-01-04 00:00:00.000000000 +2099-01-05 00:00:00.000000000 +2099-01-06 00:00:00.000000000 +2099-01-07 00:00:00.000000000 +2099-01-08 00:00:00.000000000 +2099-01-09 00:00:00.000000000 +2099-01-10 00:00:00.000000000 +2099-01-11 00:00:00.000000000 +2099-01-12 00:00:00.000000000 +2099-01-13 00:00:00.000000000 +2099-01-14 00:00:00.000000000 +2099-01-15 00:00:00.000000000 +2099-01-16 00:00:00.000000000 +2099-01-17 00:00:00.000000000 +2099-01-18 00:00:00.000000000 +2099-01-19 00:00:00.000000000 +2099-01-20 00:00:00.000000000 +2099-01-21 00:00:00.000000000 +2099-01-22 00:00:00.000000000 +2099-01-23 00:00:00.000000000 +2099-01-24 00:00:00.000000000 +2099-01-25 00:00:00.000000000 +2099-01-26 00:00:00.000000000 +2099-01-27 00:00:00.000000000 +2099-01-28 00:00:00.000000000 +2099-01-29 00:00:00.000000000 +2099-01-30 00:00:00.000000000 +2099-01-31 00:00:00.000000000 +2099-02-01 00:00:00.000000000 +2099-02-02 00:00:00.000000000 +2099-02-03 00:00:00.000000000 +2099-02-04 00:00:00.000000000 +2099-02-05 00:00:00.000000000 +2099-02-06 00:00:00.000000000 +2099-02-07 00:00:00.000000000 +2099-02-08 00:00:00.000000000 +2099-02-09 00:00:00.000000000 +2099-02-10 00:00:00.000000000 +2099-02-11 00:00:00.000000000 +2099-02-12 00:00:00.000000000 +2099-02-13 00:00:00.000000000 +2099-02-14 00:00:00.000000000 +2099-02-15 00:00:00.000000000 +2099-02-16 00:00:00.000000000 +2099-02-17 00:00:00.000000000 +2099-02-18 00:00:00.000000000 +2099-02-19 00:00:00.000000000 +2099-02-20 00:00:00.000000000 +2099-02-21 00:00:00.000000000 +2099-02-22 00:00:00.000000000 +2099-02-23 00:00:00.000000000 +2099-02-24 00:00:00.000000000 +2099-02-25 00:00:00.000000000 +2099-02-26 00:00:00.000000000 +2099-02-27 00:00:00.000000000 +2099-02-28 00:00:00.000000000 +2099-03-01 00:00:00.000000000 +2099-03-02 00:00:00.000000000 +2099-03-03 00:00:00.000000000 +2099-03-04 00:00:00.000000000 +2099-03-05 00:00:00.000000000 +2099-03-06 00:00:00.000000000 +2099-03-07 00:00:00.000000000 +2099-03-08 00:00:00.000000000 +2099-03-09 00:00:00.000000000 +2099-03-10 00:00:00.000000000 +2099-03-11 00:00:00.000000000 +2099-03-12 00:00:00.000000000 +2099-03-13 00:00:00.000000000 +2099-03-14 00:00:00.000000000 +2099-03-15 00:00:00.000000000 +2099-03-16 00:00:00.000000000 +2099-03-17 00:00:00.000000000 +2099-03-18 00:00:00.000000000 +2099-03-19 00:00:00.000000000 +2099-03-20 00:00:00.000000000 +2099-03-21 00:00:00.000000000 +2099-03-22 00:00:00.000000000 +2099-03-23 00:00:00.000000000 +2099-03-24 00:00:00.000000000 +2099-03-25 00:00:00.000000000 +2099-03-26 00:00:00.000000000 +2099-03-27 00:00:00.000000000 +2099-03-28 00:00:00.000000000 +2099-03-29 00:00:00.000000000 +2099-03-30 00:00:00.000000000 +2099-03-31 00:00:00.000000000 +2099-04-01 00:00:00.000000000 +2099-04-02 00:00:00.000000000 +2099-04-03 00:00:00.000000000 +2099-04-04 00:00:00.000000000 +2099-04-05 00:00:00.000000000 +2099-04-06 00:00:00.000000000 +2099-04-07 00:00:00.000000000 +2099-04-08 00:00:00.000000000 +2099-04-09 00:00:00.000000000 +2099-04-10 00:00:00.000000000 +2099-04-11 00:00:00.000000000 +2099-04-12 00:00:00.000000000 +2099-04-13 00:00:00.000000000 +2099-04-14 00:00:00.000000000 +2099-04-15 00:00:00.000000000 +2099-04-16 00:00:00.000000000 +2099-04-17 00:00:00.000000000 +2099-04-18 00:00:00.000000000 +2099-04-19 00:00:00.000000000 +2099-04-20 00:00:00.000000000 +2099-04-21 00:00:00.000000000 +2099-04-22 00:00:00.000000000 +2099-04-23 00:00:00.000000000 +2099-04-24 00:00:00.000000000 +2099-04-25 00:00:00.000000000 +2099-04-26 00:00:00.000000000 +2099-04-27 00:00:00.000000000 +2099-04-28 00:00:00.000000000 +2099-04-29 00:00:00.000000000 +2099-04-30 00:00:00.000000000 +2099-05-01 00:00:00.000000000 +2099-05-02 00:00:00.000000000 +2099-05-03 00:00:00.000000000 +2099-05-04 00:00:00.000000000 +2099-05-05 00:00:00.000000000 +2099-05-06 00:00:00.000000000 +2099-05-07 00:00:00.000000000 +2099-05-08 00:00:00.000000000 +2099-05-09 00:00:00.000000000 +2099-05-10 00:00:00.000000000 +2099-05-11 00:00:00.000000000 +2099-05-12 00:00:00.000000000 +2099-05-13 00:00:00.000000000 +2099-05-14 00:00:00.000000000 +2099-05-15 00:00:00.000000000 +2099-05-16 00:00:00.000000000 +2099-05-17 00:00:00.000000000 +2099-05-18 00:00:00.000000000 +2099-05-19 00:00:00.000000000 +2099-05-20 00:00:00.000000000 +2099-05-21 00:00:00.000000000 +2099-05-22 00:00:00.000000000 +2099-05-23 00:00:00.000000000 +2099-05-24 00:00:00.000000000 +2099-05-25 00:00:00.000000000 +2099-05-26 00:00:00.000000000 +2099-05-27 00:00:00.000000000 +2099-05-28 00:00:00.000000000 +2099-05-29 00:00:00.000000000 +2099-05-30 00:00:00.000000000 +2099-05-31 00:00:00.000000000 +2099-06-01 00:00:00.000000000 +2099-06-02 00:00:00.000000000 +2099-06-03 00:00:00.000000000 +2099-06-04 00:00:00.000000000 +2099-06-05 00:00:00.000000000 +2099-06-06 00:00:00.000000000 +2099-06-07 00:00:00.000000000 +2099-06-08 00:00:00.000000000 +2099-06-09 00:00:00.000000000 +2099-06-10 00:00:00.000000000 +2099-06-11 00:00:00.000000000 +2099-06-12 00:00:00.000000000 +2099-06-13 00:00:00.000000000 +2099-06-14 00:00:00.000000000 +2099-06-15 00:00:00.000000000 +2099-06-16 00:00:00.000000000 +2099-06-17 00:00:00.000000000 +2099-06-18 00:00:00.000000000 +2099-06-19 00:00:00.000000000 +2099-06-20 00:00:00.000000000 +2099-06-21 00:00:00.000000000 +2099-06-22 00:00:00.000000000 +2099-06-23 00:00:00.000000000 +2099-06-24 00:00:00.000000000 +2099-06-25 00:00:00.000000000 +2099-06-26 00:00:00.000000000 +2099-06-27 00:00:00.000000000 +2099-06-28 00:00:00.000000000 +2099-06-29 00:00:00.000000000 +2099-06-30 00:00:00.000000000 +2099-07-01 00:00:00.000000000 +2099-07-02 00:00:00.000000000 +2099-07-03 00:00:00.000000000 +2099-07-04 00:00:00.000000000 +2099-07-05 00:00:00.000000000 +2099-07-06 00:00:00.000000000 +2099-07-07 00:00:00.000000000 +2099-07-08 00:00:00.000000000 +2099-07-09 00:00:00.000000000 +2099-07-10 00:00:00.000000000 +2099-07-11 00:00:00.000000000 +2099-07-12 00:00:00.000000000 +2099-07-13 00:00:00.000000000 +2099-07-14 00:00:00.000000000 +2099-07-15 00:00:00.000000000 +2099-07-16 00:00:00.000000000 +2099-07-17 00:00:00.000000000 +2099-07-18 00:00:00.000000000 +2099-07-19 00:00:00.000000000 +2099-07-20 00:00:00.000000000 +2099-07-21 00:00:00.000000000 +2099-07-22 00:00:00.000000000 +2099-07-23 00:00:00.000000000 +2099-07-24 00:00:00.000000000 +2099-07-25 00:00:00.000000000 +2099-07-26 00:00:00.000000000 +2099-07-27 00:00:00.000000000 +2099-07-28 00:00:00.000000000 +2099-07-29 00:00:00.000000000 +2099-07-30 00:00:00.000000000 +2099-07-31 00:00:00.000000000 +2099-08-01 00:00:00.000000000 +2099-08-02 00:00:00.000000000 +2099-08-03 00:00:00.000000000 +2099-08-04 00:00:00.000000000 +2099-08-05 00:00:00.000000000 +2099-08-06 00:00:00.000000000 +2099-08-07 00:00:00.000000000 +2099-08-08 00:00:00.000000000 +2099-08-09 00:00:00.000000000 +2099-08-10 00:00:00.000000000 +2099-08-11 00:00:00.000000000 +2099-08-12 00:00:00.000000000 +2099-08-13 00:00:00.000000000 +2099-08-14 00:00:00.000000000 +2099-08-15 00:00:00.000000000 +2099-08-16 00:00:00.000000000 +2099-08-17 00:00:00.000000000 +2099-08-18 00:00:00.000000000 +2099-08-19 00:00:00.000000000 +2099-08-20 00:00:00.000000000 +2099-08-21 00:00:00.000000000 +2099-08-22 00:00:00.000000000 +2099-08-23 00:00:00.000000000 +2099-08-24 00:00:00.000000000 +2099-08-25 00:00:00.000000000 +2099-08-26 00:00:00.000000000 +2099-08-27 00:00:00.000000000 +2099-08-28 00:00:00.000000000 +2099-08-29 00:00:00.000000000 +2099-08-30 00:00:00.000000000 +2099-08-31 00:00:00.000000000 +2099-09-01 00:00:00.000000000 +2099-09-02 00:00:00.000000000 +2099-09-03 00:00:00.000000000 +2099-09-04 00:00:00.000000000 +2099-09-05 00:00:00.000000000 +2099-09-06 00:00:00.000000000 +2099-09-07 00:00:00.000000000 +2099-09-08 00:00:00.000000000 +2099-09-09 00:00:00.000000000 +2099-09-10 00:00:00.000000000 +2099-09-11 00:00:00.000000000 +2099-09-12 00:00:00.000000000 +2099-09-13 00:00:00.000000000 +2099-09-14 00:00:00.000000000 +2099-09-15 00:00:00.000000000 +2099-09-16 00:00:00.000000000 +2099-09-17 00:00:00.000000000 +2099-09-18 00:00:00.000000000 +2099-09-19 00:00:00.000000000 +2099-09-20 00:00:00.000000000 +2099-09-21 00:00:00.000000000 +2099-09-22 00:00:00.000000000 +2099-09-23 00:00:00.000000000 +2099-09-24 00:00:00.000000000 +2099-09-25 00:00:00.000000000 +2099-09-26 00:00:00.000000000 +2099-09-27 00:00:00.000000000 +2099-09-28 00:00:00.000000000 +2099-09-29 00:00:00.000000000 +2099-09-30 00:00:00.000000000 +2099-10-01 00:00:00.000000000 +2099-10-02 00:00:00.000000000 +2099-10-03 00:00:00.000000000 +2099-10-04 00:00:00.000000000 +2099-10-05 00:00:00.000000000 +2099-10-06 00:00:00.000000000 +2099-10-07 00:00:00.000000000 +2099-10-08 00:00:00.000000000 +2099-10-09 00:00:00.000000000 +2099-10-10 00:00:00.000000000 +2099-10-11 00:00:00.000000000 +2099-10-12 00:00:00.000000000 +2099-10-13 00:00:00.000000000 +2099-10-14 00:00:00.000000000 +2099-10-15 00:00:00.000000000 +2099-10-16 00:00:00.000000000 +2099-10-17 00:00:00.000000000 +2099-10-18 00:00:00.000000000 +2099-10-19 00:00:00.000000000 +2099-10-20 00:00:00.000000000 +2099-10-21 00:00:00.000000000 +2099-10-22 00:00:00.000000000 +2099-10-23 00:00:00.000000000 +2099-10-24 00:00:00.000000000 +2099-10-25 00:00:00.000000000 +2099-10-26 00:00:00.000000000 +2099-10-27 00:00:00.000000000 +2099-10-28 00:00:00.000000000 +2099-10-29 00:00:00.000000000 +2099-10-30 00:00:00.000000000 +2099-10-31 00:00:00.000000000 +2099-11-01 00:00:00.000000000 +2099-11-02 00:00:00.000000000 +2099-11-03 00:00:00.000000000 +2099-11-04 00:00:00.000000000 +2099-11-05 00:00:00.000000000 +2099-11-06 00:00:00.000000000 +2099-11-07 00:00:00.000000000 +2099-11-08 00:00:00.000000000 +2099-11-09 00:00:00.000000000 +2099-11-10 00:00:00.000000000 +2099-11-11 00:00:00.000000000 +2099-11-12 00:00:00.000000000 +2099-11-13 00:00:00.000000000 +2099-11-14 00:00:00.000000000 +2099-11-15 00:00:00.000000000 +2099-11-16 00:00:00.000000000 +2099-11-17 00:00:00.000000000 +2099-11-18 00:00:00.000000000 +2099-11-19 00:00:00.000000000 +2099-11-20 00:00:00.000000000 +2099-11-21 00:00:00.000000000 +2099-11-22 00:00:00.000000000 +2099-11-23 00:00:00.000000000 +2099-11-24 00:00:00.000000000 +2099-11-25 00:00:00.000000000 +2099-11-26 00:00:00.000000000 +2099-11-27 00:00:00.000000000 +2099-11-28 00:00:00.000000000 +2099-11-29 00:00:00.000000000 +2099-11-30 00:00:00.000000000 +2099-12-01 00:00:00.000000000 +2099-12-02 00:00:00.000000000 +2099-12-03 00:00:00.000000000 +2099-12-04 00:00:00.000000000 +2099-12-05 00:00:00.000000000 +2099-12-06 00:00:00.000000000 +2099-12-07 00:00:00.000000000 +2099-12-08 00:00:00.000000000 +2099-12-09 00:00:00.000000000 +2099-12-10 00:00:00.000000000 +2099-12-11 00:00:00.000000000 +2099-12-12 00:00:00.000000000 +2099-12-13 00:00:00.000000000 +2099-12-14 00:00:00.000000000 +2099-12-15 00:00:00.000000000 +2099-12-16 00:00:00.000000000 +2099-12-17 00:00:00.000000000 +2099-12-18 00:00:00.000000000 +2099-12-19 00:00:00.000000000 +2099-12-20 00:00:00.000000000 +2099-12-21 00:00:00.000000000 +2099-12-22 00:00:00.000000000 +2099-12-23 00:00:00.000000000 +2099-12-24 00:00:00.000000000 +2099-12-25 00:00:00.000000000 +2099-12-26 00:00:00.000000000 +2099-12-27 00:00:00.000000000 +2099-12-28 00:00:00.000000000 +2099-12-29 00:00:00.000000000 +2099-12-30 00:00:00.000000000 +2099-12-31 00:00:00.000000000 +2100-01-01 00:00:00.000000000 --- 365 row(s) selected. >>
http://git-wip-us.apache.org/repos/asf/trafodion/blob/319abf81/core/sql/regress/hive/EXPECTED004 ---------------------------------------------------------------------- diff --git a/core/sql/regress/hive/EXPECTED004 b/core/sql/regress/hive/EXPECTED004 index 5458c3b..99174ee 100644 --- a/core/sql/regress/hive/EXPECTED004 +++ b/core/sql/regress/hive/EXPECTED004 @@ -546,21 +546,21 @@ CA_ADDRESS_SK CA_ADDRESS_ID CA_STREET_NUMBER CA_STREET_N --- 100 row(s) selected. >>select * from hive.ins_store order by S_STORE_SK; -S_STORE_SK S_STORE_ID S_REC_START_DATE S_REC_END_DATE S_CLOSED_DATE_SK S_STORE_NAME S_NUMBER_EMPLOYEES S_FLOOR_SPACE S_HOURS S_MANAGER S_MARKET_ID S_GEOGRAPHY_CLASS S_MARKET_DESC S_MARKET_MANAGER S_DIVISION_ID S_DIVISION_NAME S_COMPANY_ID S_COMPANY_NAME S_STREET_NUMBER S_STREET_NAME S_STREET_TYPE S_SUITE_NUMBER S_CITY S_COUNTY S_STATE S_ZIP S_COUNTRY S_GMT_OFFSET S_TAX_PRECENTAGE ------------ ------------------------- -------------------------- -------------------------- ---------------- ------------------------- ------------------ ------------- ------------------------- ------------------------- ----------- ------------------------- ------------------------- ------------------------- ------------- ------------------------- ------------ ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- --------------- ---------------- +S_STORE_SK S_STORE_ID S_REC_START_DATE S_REC_END_DATE S_CLOSED_DATE_SK S_STORE_NAME S_NUMBER_EMPLOYEES S_FLOOR_SPACE S_HOURS S_MANAGER S_MARKET_ID S_GEOGRAPHY_CLASS S_MARKET_DESC S_MARKET_MANAGER S_DIVISION_ID S_DIVISION_NAME S_COMPANY_ID S_COMPANY_NAME S_STREET_NUMBER S_STREET_NAME S_STREET_TYPE S_SUITE_NUMBER S_CITY S_COUNTY S_STATE S_ZIP S_COUNTRY S_GMT_OFFSET S_TAX_PRECENTAGE +----------- ------------------------- ----------------------------- ----------------------------- ---------------- ------------------------- ------------------ ------------- ------------------------- ------------------------- ----------- ------------------------- ------------------------- ------------------------- ------------- ------------------------- ------------ ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- --------------- ---------------- - 1 AAAAAAAABAAAAAAA 1997-03-13 00:00:00.000000 ? 2451189 ought 245 5250760 8AM-4PM William Ward 2 Unknown Enough high areas stop ex Charles Bartley 1 Unknown 1 Unknown 767 Spring Wy Suite 250 Midway Williamson County TN 31904 United States -5.0000000E+000 2.9999999E-002 - 2 AAAAAAAACAAAAAAA 1997-03-13 00:00:00.000000 2000-03-12 00:00:00.000000 ? able 236 5285950 8AM-4PM Scott Smith 8 Unknown Parliamentary candidates David Lamontagne 1 Unknown 1 Unknown 255 Sycamore Dr. Suite 410 Midway Williamson County TN 31904 United States -5.0000000E+000 2.9999999E-002 - 3 AAAAAAAACAAAAAAA 2000-03-13 00:00:00.000000 ? ? able 236 7557959 8AM-4PM Scott Smith 7 Unknown Impossible, true arms can David Lamontagne 1 Unknown 1 Unknown 877 Park Laurel Road Suite T Midway Williamson County TN 31904 United States -5.0000000E+000 2.9999999E-002 - 4 AAAAAAAAEAAAAAAA 1997-03-13 00:00:00.000000 1999-03-13 00:00:00.000000 2451044 ese 218 9341467 8AM-4PM Edwin Adams 4 Unknown Events would achieve othe Thomas Pollack 1 Unknown 1 Unknown 27 Lake Ln Suite 260 Midway Williamson County TN 31904 United States -5.0000000E+000 2.9999999E-002 - 5 AAAAAAAAEAAAAAAA 1999-03-14 00:00:00.000000 2001-03-12 00:00:00.000000 2450910 anti 288 9078805 8AM-4PM Edwin Adams 8 Unknown Events would achieve othe Thomas Pollack 1 Unknown 1 Unknown 27 Lee 6th Court Suite 80 Fairview Williamson County TN 35709 United States -5.0000000E+000 2.9999999E-002 - 6 AAAAAAAAEAAAAAAA 2001-03-13 00:00:00.000000 ? ? cally 229 9026222 8AM-4PM Edwin Adams 10 Unknown Events would achieve othe Thomas Pollack 1 Unknown 1 Unknown 220 6th Lane Suite 140 Midway Williamson County TN 31904 United States -5.0000000E+000 2.9999999E-002 - 7 AAAAAAAAHAAAAAAA 1997-03-13 00:00:00.000000 ? ? ation 297 8954883 8AM-4PM David Thomas 9 Unknown Architects coul Thomas Benton 1 Unknown 1 Unknown 811 Lee Circle Suite T Midway Williamson County TN 31904 United States -5.0000000E+000 9.9999997E-003 - 8 AAAAAAAAIAAAAAAA 1997-03-13 00:00:00.000000 2000-03-12 00:00:00.000000 ? eing 278 6995995 8AM-4PM Brett Yates 2 Unknown Various bars make most. D Dean Morrison 1 Unknown 1 Unknown 226 12th Lane Suite D Fairview Williamson County TN 35709 United States -5.0000000E+000 7.9999998E-002 - 9 AAAAAAAAIAAAAAAA 2000-03-13 00:00:00.000000 ? ? eing 271 6995995 8AM-4PM Brett Yates 2 Unknown Formal, psychological pou Dean Morrison 1 Unknown 1 Unknown 226 Hill Boulevard Suite 190 Midway Williamson County TN 31904 United States -5.0000000E+000 7.9999998E-002 - 10 AAAAAAAAKAAAAAAA 1997-03-13 00:00:00.000000 1999-03-13 00:00:00.000000 ? bar 294 9294113 8AM-4PM Raymond Jacobs 8 Unknown Little expectations inclu Michael Wilson 1 Unknown 1 Unknown 175 4th Court Suite C Midway Williamson County TN 31904 United States -5.0000000E+000 5.9999998E-002 - 11 AAAAAAAAKAAAAAAA 1999-03-14 00:00:00.000000 2001-03-12 00:00:00.000000 ? ought 294 9294113 8AM-4PM Raymond Jacobs 6 Unknown Mysterious employe Michael Wilson 1 Unknown 1 Unknown 175 Park Green Court Suite 160 Midway Williamson County TN 31904 United States -5.0000000E+000 1.0999999E-002 - 12 AAAAAAAAKAAAAAAA 2001-03-13 00:00:00.000000 ? ? ought 294 5219562 8AM-12AM Robert Thompson 6 Unknown Events develop i Dustin Kelly 1 Unknown 1 Unknown 337 College Boulevard Suite 100 Fairview Williamson County TN 31904 United States -5.0000000E+000 9.9999997E-003 + 1 AAAAAAAABAAAAAAA 1997-03-13 00:00:00.000000000 ? 2451189 ought 245 5250760 8AM-4PM William Ward 2 Unknown Enough high areas stop ex Charles Bartley 1 Unknown 1 Unknown 767 Spring Wy Suite 250 Midway Williamson County TN 31904 United States -5.0000000E+000 2.9999999E-002 + 2 AAAAAAAACAAAAAAA 1997-03-13 00:00:00.000000000 2000-03-12 00:00:00.000000000 ? able 236 5285950 8AM-4PM Scott Smith 8 Unknown Parliamentary candidates David Lamontagne 1 Unknown 1 Unknown 255 Sycamore Dr. Suite 410 Midway Williamson County TN 31904 United States -5.0000000E+000 2.9999999E-002 + 3 AAAAAAAACAAAAAAA 2000-03-13 00:00:00.000000000 ? ? able 236 7557959 8AM-4PM Scott Smith 7 Unknown Impossible, true arms can David Lamontagne 1 Unknown 1 Unknown 877 Park Laurel Road Suite T Midway Williamson County TN 31904 United States -5.0000000E+000 2.9999999E-002 + 4 AAAAAAAAEAAAAAAA 1997-03-13 00:00:00.000000000 1999-03-13 00:00:00.000000000 2451044 ese 218 9341467 8AM-4PM Edwin Adams 4 Unknown Events would achieve othe Thomas Pollack 1 Unknown 1 Unknown 27 Lake Ln Suite 260 Midway Williamson County TN 31904 United States -5.0000000E+000 2.9999999E-002 + 5 AAAAAAAAEAAAAAAA 1999-03-14 00:00:00.000000000 2001-03-12 00:00:00.000000000 2450910 anti 288 9078805 8AM-4PM Edwin Adams 8 Unknown Events would achieve othe Thomas Pollack 1 Unknown 1 Unknown 27 Lee 6th Court Suite 80 Fairview Williamson County TN 35709 United States -5.0000000E+000 2.9999999E-002 + 6 AAAAAAAAEAAAAAAA 2001-03-13 00:00:00.000000000 ? ? cally 229 9026222 8AM-4PM Edwin Adams 10 Unknown Events would achieve othe Thomas Pollack 1 Unknown 1 Unknown 220 6th Lane Suite 140 Midway Williamson County TN 31904 United States -5.0000000E+000 2.9999999E-002 + 7 AAAAAAAAHAAAAAAA 1997-03-13 00:00:00.000000000 ? ? ation 297 8954883 8AM-4PM David Thomas 9 Unknown Architects coul Thomas Benton 1 Unknown 1 Unknown 811 Lee Circle Suite T Midway Williamson County TN 31904 United States -5.0000000E+000 9.9999997E-003 + 8 AAAAAAAAIAAAAAAA 1997-03-13 00:00:00.000000000 2000-03-12 00:00:00.000000000 ? eing 278 6995995 8AM-4PM Brett Yates 2 Unknown Various bars make most. D Dean Morrison 1 Unknown 1 Unknown 226 12th Lane Suite D Fairview Williamson County TN 35709 United States -5.0000000E+000 7.9999998E-002 + 9 AAAAAAAAIAAAAAAA 2000-03-13 00:00:00.000000000 ? ? eing 271 6995995 8AM-4PM Brett Yates 2 Unknown Formal, psychological pou Dean Morrison 1 Unknown 1 Unknown 226 Hill Boulevard Suite 190 Midway Williamson County TN 31904 United States -5.0000000E+000 7.9999998E-002 + 10 AAAAAAAAKAAAAAAA 1997-03-13 00:00:00.000000000 1999-03-13 00:00:00.000000000 ? bar 294 9294113 8AM-4PM Raymond Jacobs 8 Unknown Little expectations inclu Michael Wilson 1 Unknown 1 Unknown 175 4th Court Suite C Midway Williamson County TN 31904 United States -5.0000000E+000 5.9999998E-002 + 11 AAAAAAAAKAAAAAAA 1999-03-14 00:00:00.000000000 2001-03-12 00:00:00.000000000 ? ought 294 9294113 8AM-4PM Raymond Jacobs 6 Unknown Mysterious employe Michael Wilson 1 Unknown 1 Unknown 175 Park Green Court Suite 160 Midway Williamson County TN 31904 United States -5.0000000E+000 1.0999999E-002 + 12 AAAAAAAAKAAAAAAA 2001-03-13 00:00:00.000000000 ? ? ought 294 5219562 8AM-12AM Robert Thompson 6 Unknown Events develop i Dustin Kelly 1 Unknown 1 Unknown 337 College Boulevard Suite 100 Fairview Williamson County TN 31904 United States -5.0000000E+000 9.9999997E-003 --- 12 row(s) selected. >>log; http://git-wip-us.apache.org/repos/asf/trafodion/blob/319abf81/core/sql/regress/hive/EXPECTED005 ---------------------------------------------------------------------- diff --git a/core/sql/regress/hive/EXPECTED005 b/core/sql/regress/hive/EXPECTED005 index 6521790..da4a7ca 100644 --- a/core/sql/regress/hive/EXPECTED005 +++ b/core/sql/regress/hive/EXPECTED005 @@ -72,7 +72,7 @@ *** WARNING[8597] Statement was automatically retried 1 time(s). Delay before each retry was 0 seconds. See next entry for the error that caused this retry. -*** WARNING[8436] Mismatch detected between compiletime and runtime hive table definitions. DataModMismatchDetails: compiledModTS = 1521763081810, failedModTS = 1521763182817, failedLoc = hdfs://localhost:24200/user/trafodion/hive/exttables/customer_ddl +*** WARNING[8436] Mismatch detected between compiletime and runtime hive table definitions. DataModMismatchDetails: compiledModTS = 1524000329220, failedModTS = 1524000432893, failedLoc = hdfs://localhost:24200/user/trafodion/hive/exttables/customer_ddl C_PREFERRED_CUST_FLAG (EXPR) ------------------------- -------------------- @@ -108,7 +108,7 @@ Y 9525 *** WARNING[8597] Statement was automatically retried 1 time(s). Delay before each retry was 0 seconds. See next entry for the error that caused this retry. -*** WARNING[8436] Mismatch detected between compiletime and runtime hive table definitions. DataModMismatchDetails: compiledModTS = 1521763081810, failedModTS = 1521763182817, failedLoc = hdfs://localhost:24200/user/trafodion/hive/exttables/customer_ddl +*** WARNING[8436] Mismatch detected between compiletime and runtime hive table definitions. DataModMismatchDetails: compiledModTS = 1524000329220, failedModTS = 1524000432893, failedLoc = hdfs://localhost:24200/user/trafodion/hive/exttables/customer_ddl C_PREFERRED_CUST_FLAG (EXPR) ------------------------- -------------------- @@ -177,7 +177,7 @@ Y 9525 *** WARNING[8597] Statement was automatically retried 1 time(s). Delay before each retry was 0 seconds. See next entry for the error that caused this retry. -*** WARNING[8436] Mismatch detected between compiletime and runtime hive table definitions. DataModMismatchDetails: compiledModTS = 1521763188079, failedModTS = 1521763198786, failedLoc = hdfs://localhost:24200/user/hive/warehouse/newtable +*** WARNING[8436] Mismatch detected between compiletime and runtime hive table definitions. DataModMismatchDetails: compiledModTS = 1524000445498, failedModTS = 1524000461054, failedLoc = hdfs://localhost:24200/user/hive/warehouse/newtable A ------------------------- @@ -227,7 +227,7 @@ xyz *** WARNING[8597] Statement was automatically retried 1 time(s). Delay before each retry was 0 seconds. See next entry for the error that caused this retry. -*** WARNING[8436] Mismatch detected between compiletime and runtime hive table definitions. DataModMismatchDetails: compiledModTS = 1521763182817, failedModTS = 1521763227396, failedLoc = hdfs://localhost:24200/user/trafodion/hive/exttables/customer_ddl +*** WARNING[8436] Mismatch detected between compiletime and runtime hive table definitions. DataModMismatchDetails: compiledModTS = 1524000432893, failedModTS = 1524000495227, failedLoc = hdfs://localhost:24200/user/trafodion/hive/exttables/customer_ddl C_PREFERRED_CUST_FLAG (EXPR) ------------------------- -------------------- @@ -242,7 +242,7 @@ Y 18984 *** WARNING[8597] Statement was automatically retried 1 time(s). Delay before each retry was 0 seconds. See next entry for the error that caused this retry. -*** WARNING[8436] Mismatch detected between compiletime and runtime hive table definitions. DataModMismatchDetails: compiledModTS = 1521763182817, failedModTS = 1521763227396, failedLoc = hdfs://localhost:24200/user/trafodion/hive/exttables/customer_ddl +*** WARNING[8436] Mismatch detected between compiletime and runtime hive table definitions. DataModMismatchDetails: compiledModTS = 1524000432893, failedModTS = 1524000495227, failedLoc = hdfs://localhost:24200/user/trafodion/hive/exttables/customer_ddl C_PREFERRED_CUST_FLAG (EXPR) ------------------------- -------------------- @@ -298,7 +298,7 @@ Y 18984 *** WARNING[8597] Statement was automatically retried 1 time(s). Delay before each retry was 0 seconds. See next entry for the error that caused this retry. -*** WARNING[8436] Mismatch detected between compiletime and runtime hive table definitions. DataModMismatchDetails: compiledModTS = 1521763223181, failedModTS = 1521763236557, failedLoc = hdfs://localhost:24200/user/hive/warehouse/newtable +*** WARNING[8436] Mismatch detected between compiletime and runtime hive table definitions. DataModMismatchDetails: compiledModTS = 1524000489960, failedModTS = 1524000504793, failedLoc = hdfs://localhost:24200/user/hive/warehouse/newtable A B ----------- ------------------------- @@ -456,10 +456,10 @@ ID CHAPTER ENGLISH TRANSLATOR >> >>select * from tbl_type; -TINT SM I BIG STR F D T DT VC D10 D18 D181 D30 ----- ------ ----------- -------------------- ------------------------- --------------- ------------------------- -------------------------- ---------- ---------------------------------------- -------------------- ------------ -------------------- ------------------------------- +TINT SM I BIG STR F D T DT VC D10 D18 D181 D30 +---- ------ ----------- -------------------- ------------------------- --------------- ------------------------- ----------------------------- ---------- ---------------------------------------- -------------------- ------------ -------------------- ------------------------------- - 101 202 203 204 two hundred 2.0000000E+002 2.00000000000000000E+002 2022-02-02 22:22:22.222222 2022-02-02 varchar 1234567890 123456.11 12345 11111111111111111111111111111 + 101 202 203 204 two hundred 2.0000000E+002 2.00000000000000000E+002 2022-02-02 22:22:22.222222000 2022-02-02 varchar 1234567890 123456.11 12345 11111111111111111111111111111 --- 1 row(s) selected. >>insert into tbl_type_temp select * from tbl_type; @@ -467,10 +467,10 @@ TINT SM I BIG STR F --- 1 row(s) inserted. >>select * from tbl_type_temp; -TINT SM I BIG STR F D T DT VC D10 D18 D181 D30 ----- ------ ----------- -------------------- ------------------------- --------------- ------------------------- -------------------------- ---------- ---------------------------------------- -------------------- ------------ -------------------- ------------------------------- +TINT SM I BIG STR F D T DT VC D10 D18 D181 D30 +---- ------ ----------- -------------------- ------------------------- --------------- ------------------------- ----------------------------- ---------- ---------------------------------------- -------------------- ------------ -------------------- ------------------------------- - 101 202 203 204 two hundred 2.0000000E+002 2.00000000000000000E+002 2022-02-02 22:22:22.222222 2022-02-02 varchar 1234567890 123456.11 12345 11111111111111111111111111111 + 101 202 203 204 two hundred 2.0000000E+002 2.00000000000000000E+002 2022-02-02 22:22:22.222222000 2022-02-02 varchar 1234567890 123456.11 12345 11111111111111111111111111111 --- 1 row(s) selected. >> @@ -571,17 +571,17 @@ C1 C2 --- SQL operation complete. >>select * from tbl_bad; -C1 C2 C3 C4 C5 C6 C7 C8 ------------ -------------------- ------------------------- --------------- ------ -------------------------- ------------------------- ---- +C1 C2 C3 C4 C5 C6 C7 C8 +----------- -------------------- ------------------------- --------------- ------ ----------------------------- ------------------------- ---- - ? ? c ? ? ? ? ? - ? ? c ? ? 2017-01-01 10:10:10.000000 1.01000000000000000E+000 1 - ? ? ? ? ? ? ? - 1 1 averylongstring -1.0000000E+000 0 2017-01-01 10:10:10.000000 1.00010000000000000E+002 1 - 2 2 good 1.1000000E+000 2 2017-01-01 10:10:10.000000 2.00000000000000000E+002 100 - 3 3 good 1.0000000E+000 2 2017-01-01 10:10:10.000000 2.10000000000000000E+002 10 - ? 4294967295 good 3.3999999E+038 ? 2017-01-01 10:10:10.000000 1.69999999999999968E+308 10 - 0 9999999999 bad ? ? ? ? ? + ? ? c ? ? ? ? ? + ? ? c ? ? 2017-01-01 10:10:10.000000000 1.01000000000000000E+000 1 + ? ? ? ? ? ? ? + 1 1 averylongstring -1.0000000E+000 0 2017-01-01 10:10:10.000000000 1.00010000000000000E+002 1 + 2 2 good 1.1000000E+000 2 2017-01-01 10:10:10.000000000 2.00000000000000000E+002 100 + 3 3 good 1.0000000E+000 2 2017-01-01 10:10:10.000000000 2.10000000000000000E+002 10 + ? 4294967295 good 3.3999999E+038 ? 2017-01-01 10:10:10.000000000 1.69999999999999968E+308 10 + 0 9999999999 bad ? ? ? ? ? --- 8 row(s) selected. >>cqd HIVE_SCAN_SPECIAL_MODE reset; @@ -617,18 +617,18 @@ C1 C2 C3 C4 C --- 1 row(s) selected. >>load with continue on error into trafodion.seabase.traf_tbl_bad select * >>from tbl_bad; Task: LOAD Status: Started Object: TRAFODION.SEABASE.TRAF_TBL_BAD -Task: CLEANUP Status: Started Time: 2018-03-23 00:02:16.72820 -Task: CLEANUP Status: Ended Time: 2018-03-23 00:02:16.87954 -Task: CLEANUP Status: Ended Elapsed Time: 00:00:00.015 -Task: LOADING DATA Status: Started Time: 2018-03-23 00:02:16.88001 +Task: CLEANUP Status: Started Time: 2018-04-17 21:30:30.17299 +Task: CLEANUP Status: Ended Time: 2018-04-17 21:30:30.33510 +Task: CLEANUP Status: Ended Elapsed Time: 00:00:00.016 +Task: LOADING DATA Status: Started Time: 2018-04-17 21:30:30.33587 Rows Processed: 8 Error Rows: 5 -Task: LOADING DATA Status: Ended Time: 2018-03-23 00:02:16.505744 -Task: LOADING DATA Status: Ended Elapsed Time: 00:00:00.418 -Task: COMPLETION Status: Started Time: 2018-03-23 00:02:16.505804 +Task: LOADING DATA Status: Ended Time: 2018-04-17 21:30:30.809691 +Task: LOADING DATA Status: Ended Elapsed Time: 00:00:00.776 +Task: COMPLETION Status: Started Time: 2018-04-17 21:30:30.809733 Rows Loaded: 3 -Task: COMPLETION Status: Ended Time: 2018-03-23 00:02:17.132726 -Task: COMPLETION Status: Ended Elapsed Time: 00:00:00.627 +Task: COMPLETION Status: Ended Time: 2018-04-17 21:30:32.497372 +Task: COMPLETION Status: Ended Elapsed Time: 00:00:01.688 --- 3 row(s) loaded. >>select count(*) from trafodion.seabase.traf_tbl_bad; @@ -644,19 +644,19 @@ Task: COMPLETION Status: Ended Elapsed Time: 00:00:00.627 --- 3 row(s) deleted. >>load with log error rows into trafodion.seabase.traf_tbl_bad select * from >>tbl_bad; Task: LOAD Status: Started Object: TRAFODION.SEABASE.TRAF_TBL_BAD -Task: CLEANUP Status: Started Time: 2018-03-23 00:02:18.222742 -Task: CLEANUP Status: Ended Time: 2018-03-23 00:02:18.238737 -Task: CLEANUP Status: Ended Elapsed Time: 00:00:00.016 - Logging Location: /user/trafodion/bulkload/logs/ERR_TRAFODION.SEABASE.TRAF_TBL_BAD_20180323_000218 -Task: LOADING DATA Status: Started Time: 2018-03-23 00:02:18.238844 +Task: CLEANUP Status: Started Time: 2018-04-17 21:30:34.62175 +Task: CLEANUP Status: Ended Time: 2018-04-17 21:30:34.95962 +Task: CLEANUP Status: Ended Elapsed Time: 00:00:00.034 + Logging Location: /user/trafodion/bulkload/logs/ERR_TRAFODION.SEABASE.TRAF_TBL_BAD_20180417_213034 +Task: LOADING DATA Status: Started Time: 2018-04-17 21:30:34.96045 Rows Processed: 8 Error Rows: 5 -Task: LOADING DATA Status: Ended Time: 2018-03-23 00:02:18.652144 -Task: LOADING DATA Status: Ended Elapsed Time: 00:00:00.413 -Task: COMPLETION Status: Started Time: 2018-03-23 00:02:18.652182 +Task: LOADING DATA Status: Ended Time: 2018-04-17 21:30:34.749466 +Task: LOADING DATA Status: Ended Elapsed Time: 00:00:00.653 +Task: COMPLETION Status: Started Time: 2018-04-17 21:30:34.749557 Rows Loaded: 3 -Task: COMPLETION Status: Ended Time: 2018-03-23 00:02:19.268334 -Task: COMPLETION Status: Ended Elapsed Time: 00:00:00.616 +Task: COMPLETION Status: Ended Time: 2018-04-17 21:30:36.463082 +Task: COMPLETION Status: Ended Elapsed Time: 00:00:01.714 --- 3 row(s) loaded. >>select count(*) from trafodion.seabase.traf_tbl_bad; @@ -669,19 +669,19 @@ Task: COMPLETION Status: Ended Elapsed Time: 00:00:00.616 --- 1 row(s) selected. >>load with log error rows to '/user/trafodion/bulkload/logs/TEST005' into >>trafodion.seabase.traf_tbl_bad select * from tbl_bad; Task: LOAD Status: Started Object: TRAFODION.SEABASE.TRAF_TBL_BAD -Task: CLEANUP Status: Started Time: 2018-03-23 00:02:20.268608 -Task: CLEANUP Status: Ended Time: 2018-03-23 00:02:20.278195 -Task: CLEANUP Status: Ended Elapsed Time: 00:00:00.010 - Logging Location: /user/trafodion/bulkload/logs/TEST005/ERR_TRAFODION.SEABASE.TRAF_TBL_BAD_20180323_000220 -Task: LOADING DATA Status: Started Time: 2018-03-23 00:02:20.278249 +Task: CLEANUP Status: Started Time: 2018-04-17 21:30:37.570724 +Task: CLEANUP Status: Ended Time: 2018-04-17 21:30:37.589220 +Task: CLEANUP Status: Ended Elapsed Time: 00:00:00.018 + Logging Location: /user/trafodion/bulkload/logs/TEST005/ERR_TRAFODION.SEABASE.TRAF_TBL_BAD_20180417_213037 +Task: LOADING DATA Status: Started Time: 2018-04-17 21:30:37.589297 Rows Processed: 8 Error Rows: 5 -Task: LOADING DATA Status: Ended Time: 2018-03-23 00:02:20.743348 -Task: LOADING DATA Status: Ended Elapsed Time: 00:00:00.465 -Task: COMPLETION Status: Started Time: 2018-03-23 00:02:20.743404 +Task: LOADING DATA Status: Ended Time: 2018-04-17 21:30:38.347109 +Task: LOADING DATA Status: Ended Elapsed Time: 00:00:00.758 +Task: COMPLETION Status: Started Time: 2018-04-17 21:30:38.347176 Rows Loaded: 3 -Task: COMPLETION Status: Ended Time: 2018-03-23 00:02:21.350084 -Task: COMPLETION Status: Ended Elapsed Time: 00:00:00.607 +Task: COMPLETION Status: Ended Time: 2018-04-17 21:30:39.529916 +Task: COMPLETION Status: Ended Elapsed Time: 00:00:01.183 --- 3 row(s) loaded. >>select count(*) from trafodion.seabase.traf_tbl_bad; @@ -697,10 +697,10 @@ Task: COMPLETION Status: Ended Elapsed Time: 00:00:00.607 --- 6 row(s) deleted. >>load with stop after 3 error rows into trafodion.seabase.traf_tbl_bad select >>* from tbl_bad; Task: LOAD Status: Started Object: TRAFODION.SEABASE.TRAF_TBL_BAD -Task: CLEANUP Status: Started Time: 2018-03-23 00:02:22.398357 -Task: CLEANUP Status: Ended Time: 2018-03-23 00:02:22.409109 -Task: CLEANUP Status: Ended Elapsed Time: 00:00:00.011 -Task: LOADING DATA Status: Started Time: 2018-03-23 00:02:22.409145 +Task: CLEANUP Status: Started Time: 2018-04-17 21:30:40.704547 +Task: CLEANUP Status: Ended Time: 2018-04-17 21:30:40.720665 +Task: CLEANUP Status: Ended Elapsed Time: 00:00:00.016 +Task: LOADING DATA Status: Started Time: 2018-04-17 21:30:40.720710 *** ERROR[8113] The maximum number of error rows is exceeded. @@ -715,11 +715,11 @@ Task: LOADING DATA Status: Started Time: 2018-03-23 00:02:22.409145 --- 1 row(s) selected. >>load with log error rows, stop after 3 error rows into >>trafodion.seabase.traf_tbl_bad select * from tbl_bad; Task: LOAD Status: Started Object: TRAFODION.SEABASE.TRAF_TBL_BAD -Task: CLEANUP Status: Started Time: 2018-03-23 00:02:23.773372 -Task: CLEANUP Status: Ended Time: 2018-03-23 00:02:23.788799 +Task: CLEANUP Status: Started Time: 2018-04-17 21:30:42.388257 +Task: CLEANUP Status: Ended Time: 2018-04-17 21:30:42.403671 Task: CLEANUP Status: Ended Elapsed Time: 00:00:00.015 - Logging Location: /user/trafodion/bulkload/logs/ERR_TRAFODION.SEABASE.TRAF_TBL_BAD_20180323_000223 -Task: LOADING DATA Status: Started Time: 2018-03-23 00:02:23.788861 + Logging Location: /user/trafodion/bulkload/logs/ERR_TRAFODION.SEABASE.TRAF_TBL_BAD_20180417_213042 +Task: LOADING DATA Status: Started Time: 2018-04-17 21:30:42.403732 *** ERROR[8113] The maximum number of error rows is exceeded. @@ -807,7 +807,7 @@ Task: LOADING DATA Status: Started Time: 2018-03-23 00:02:23.788861 *** WARNING[8597] Statement was automatically retried 1 time(s). Delay before each retry was 0 seconds. See next entry for the error that caused this retry. -*** WARNING[8436] Mismatch detected between compiletime and runtime hive table definitions. DataModMismatchDetails: compiledModTS = 1521763369777, failedModTS = 1521763389102, failedLoc = hdfs://localhost:24200/user/hive/warehouse/thive +*** WARNING[8436] Mismatch detected between compiletime and runtime hive table definitions. DataModMismatchDetails: compiledModTS = 1524000680068, failedModTS = 1524000711893, failedLoc = hdfs://localhost:24200/user/hive/warehouse/thive A ----------- @@ -842,7 +842,7 @@ A *** WARNING[8597] Statement was automatically retried 1 time(s). Delay before each retry was 0 seconds. See next entry for the error that caused this retry. -*** WARNING[8436] Mismatch detected between compiletime and runtime hive table definitions. DataModMismatchDetails: compiledModTS = 1521763391527, failedModTS = 1521763411540, failedLoc = hdfs://localhost:24200/user/hive/warehouse/thive +*** WARNING[8436] Mismatch detected between compiletime and runtime hive table definitions. DataModMismatchDetails: compiledModTS = 1524000718505, failedModTS = 1524000757890, failedLoc = hdfs://localhost:24200/user/hive/warehouse/thive A ----------- @@ -869,7 +869,7 @@ A B *** WARNING[8597] Statement was automatically retried 1 time(s). Delay before each retry was 0 seconds. See next entry for the error that caused this retry. -*** WARNING[8436] Mismatch detected between compiletime and runtime hive table definitions. DataModMismatchDetails: compiledModTS = 1521763411540, failedModTS = 1521763418274, failedLoc = hdfs://localhost:24200/user/hive/warehouse/thive +*** WARNING[8436] Mismatch detected between compiletime and runtime hive table definitions. DataModMismatchDetails: compiledModTS = 1524000757890, failedModTS = 1524000765860, failedLoc = hdfs://localhost:24200/user/hive/warehouse/thive --- 0 row(s) selected. >>insert into hive.hive.thive values (10, 20); @@ -893,7 +893,7 @@ A B *** WARNING[8597] Statement was automatically retried 1 time(s). Delay before each retry was 0 seconds. See next entry for the error that caused this retry. -*** WARNING[8436] Mismatch detected between compiletime and runtime hive table definitions. DataModMismatchDetails: compiledModTS = 1521763422992, failedModTS = 1521763425613, failedLoc = hdfs://localhost:24200/user/hive/warehouse/thive +*** WARNING[8436] Mismatch detected between compiletime and runtime hive table definitions. DataModMismatchDetails: compiledModTS = 1524000771393, failedModTS = 1524000775345, failedLoc = hdfs://localhost:24200/user/hive/warehouse/thive --- 0 row(s) selected. >> @@ -984,7 +984,7 @@ t005part.a t005part.b t005part.c >>invoke hive.hive.thive_insert_smallint; -- Definition of hive table THIVE_INSERT_SMALLINT --- Definition current Fri Mar 23 00:07:13 2018 +-- Definition current Tue Apr 17 21:37:23 2018 ( A SMALLINT @@ -1091,7 +1091,7 @@ A >>invoke hive.hive.thive_insert_varchar; -- Definition of hive table THIVE_INSERT_VARCHAR --- Definition current Fri Mar 23 00:07:23 2018 +-- Definition current Tue Apr 17 21:37:40 2018 ( A VARCHAR(1 CHAR) CHARACTER SET UTF8 COLLATE
