http://git-wip-us.apache.org/repos/asf/kylin/blob/c6c67197/examples/test_case_data/localmeta/data/DEFAULT.TEST_COUNTRY.csv ---------------------------------------------------------------------- diff --git a/examples/test_case_data/localmeta/data/DEFAULT.TEST_COUNTRY.csv b/examples/test_case_data/localmeta/data/DEFAULT.TEST_COUNTRY.csv new file mode 100644 index 0000000..aced0e3 --- /dev/null +++ b/examples/test_case_data/localmeta/data/DEFAULT.TEST_COUNTRY.csv @@ -0,0 +1,244 @@ +AD,42.546245,1.601554,Andorra +AE,23.424076,53.847818,United Arab Emirates +AF,33.93911,67.709953,Afghanistan +AG,17.060816,-61.796428,Antigua and Barbuda +AI,18.220554,-63.068615,Anguilla +AL,41.153332,20.168331,Albania +AM,40.069099,45.038189,Armenia +AN,12.226079,-69.060087,Netherlands Antilles +AO,-11.202692,17.873887,Angola +AQ,-75.250973,-0.071389,Antarctica +AR,-38.416097,-63.616672,Argentina +AS,-14.270972,-170.132217,American Samoa +AT,47.516231,14.550072,Austria +AU,-25.274398,133.775136,Australia +AW,12.52111,-69.968338,Aruba +AZ,40.143105,47.576927,Azerbaijan +BA,43.915886,17.679076,Bosnia and Herzegovina +BB,13.193887,-59.543198,Barbados +BD,23.684994,90.356331,Bangladesh +BE,50.503887,4.469936,Belgium +BF,12.238333,-1.561593,Burkina Faso +BG,42.733883,25.48583,Bulgaria +BH,25.930414,50.637772,Bahrain +BI,-3.373056,29.918886,Burundi +BJ,9.30769,2.315834,Benin +BM,32.321384,-64.75737,Bermuda +BN,4.535277,114.727669,Brunei +BO,-16.290154,-63.588653,Bolivia +BR,-14.235004,-51.92528,Brazil +BS,25.03428,-77.39628,Bahamas +BT,27.514162,90.433601,Bhutan +BV,-54.423199,3.413194,Bouvet Island +BW,-22.328474,24.684866,Botswana +BY,53.709807,27.953389,Belarus +BZ,17.189877,-88.49765,Belize +CA,56.130366,-106.346771,Canada +CC,-12.164165,96.870956,Cocos [Keeling] Islands +CD,-4.038333,21.758664,Congo [DRC] +CF,6.611111,20.939444,Central African Republic +CG,-0.228021,15.827659,Congo [Republic] +CH,46.818188,8.227512,Switzerland +CI,7.539989,-5.54708,C?te d'Ivoire +CK,-21.236736,-159.777671,Cook Islands +CL,-35.675147,-71.542969,Chile +CM,7.369722,12.354722,Cameroon +CN,35.86166,104.195397,China +CO,4.570868,-74.297333,Colombia +CR,9.748917,-83.753428,Costa Rica +CU,21.521757,-77.781167,Cuba +CV,16.002082,-24.013197,Cape Verde +CX,-10.447525,105.690449,Christmas Island +CY,35.126413,33.429859,Cyprus +CZ,49.817492,15.472962,Czech Republic +DE,51.165691,10.451526,Germany +DJ,11.825138,42.590275,Djibouti +DK,56.26392,9.501785,Denmark +DM,15.414999,-61.370976,Dominica +DO,18.735693,-70.162651,Dominican Republic +DZ,28.033886,1.659626,Algeria +EC,-1.831239,-78.183406,Ecuador +EE,58.595272,25.013607,Estonia +EG,26.820553,30.802498,Egypt +EH,24.215527,-12.885834,Western Sahara +ER,15.179384,39.782334,Eritrea +ES,40.463667,-3.74922,Spain +ET,9.145,40.489673,Ethiopia +FI,61.92411,25.748151,Finland +FJ,-16.578193,179.414413,Fiji +FK,-51.796253,-59.523613,Falkland Islands [Islas Malvinas] +FM,7.425554,150.550812,Micronesia +FO,61.892635,-6.911806,Faroe Islands +FR,46.227638,2.213749,France +GA,-0.803689,11.609444,Gabon +GB,55.378051,-3.435973,United Kingdom +GD,12.262776,-61.604171,Grenada +GE,42.315407,43.356892,Georgia +GF,3.933889,-53.125782,French Guiana +GG,49.465691,-2.585278,Guernsey +GH,7.946527,-1.023194,Ghana +GI,36.137741,-5.345374,Gibraltar +GL,71.706936,-42.604303,Greenland +GM,13.443182,-15.310139,Gambia +GN,9.945587,-9.696645,Guinea +GP,16.995971,-62.067641,Guadeloupe +GQ,1.650801,10.267895,Equatorial Guinea +GR,39.074208,21.824312,Greece +GS,-54.429579,-36.587909,South Georgia and the South Sandwich Islands +GT,15.783471,-90.230759,Guatemala +GU,13.444304,144.793731,Guam +GW,11.803749,-15.180413,Guinea-Bissau +GY,4.860416,-58.93018,Guyana +GZ,31.354676,34.308825,Gaza Strip +HK,22.396428,114.109497,Hong Kong +HM,-53.08181,73.504158,Heard Island and McDonald Islands +HN,15.199999,-86.241905,Honduras +HR,45.1,15.2,Croatia +HT,18.971187,-72.285215,Haiti +HU,47.162494,19.503304,Hungary +ID,-0.789275,113.921327,Indonesia +IE,53.41291,-8.24389,Ireland +IL,31.046051,34.851612,Israel +IM,54.236107,-4.548056,Isle of Man +IN,20.593684,78.96288,India +IO,-6.343194,71.876519,British Indian Ocean Territory +IQ,33.223191,43.679291,Iraq +IR,32.427908,53.688046,Iran +IS,64.963051,-19.020835,Iceland +IT,41.87194,12.56738,Italy +JE,49.214439,-2.13125,Jersey +JM,18.109581,-77.297508,Jamaica +JO,30.585164,36.238414,Jordan +JP,36.204824,138.252924,Japan +KE,-0.023559,37.906193,Kenya +KG,41.20438,74.766098,Kyrgyzstan +KH,12.565679,104.990963,Cambodia +KI,-3.370417,-168.734039,Kiribati +KM,-11.875001,43.872219,Comoros +KN,17.357822,-62.782998,Saint Kitts and Nevis +KP,40.339852,127.510093,North Korea +KR,35.907757,127.766922,South Korea +KW,29.31166,47.481766,Kuwait +KY,19.513469,-80.566956,Cayman Islands +KZ,48.019573,66.923684,Kazakhstan +LA,19.85627,102.495496,Laos +LB,33.854721,35.862285,Lebanon +LC,13.909444,-60.978893,Saint Lucia +LI,47.166,9.555373,Liechtenstein +LK,7.873054,80.771797,Sri Lanka +LR,6.428055,-9.429499,Liberia +LS,-29.609988,28.233608,Lesotho +LT,55.169438,23.881275,Lithuania +LU,49.815273,6.129583,Luxembourg +LV,56.879635,24.603189,Latvia +LY,26.3351,17.228331,Libya +MA,31.791702,-7.09262,Morocco +MC,43.750298,7.412841,Monaco +MD,47.411631,28.369885,Moldova +ME,42.708678,19.37439,Montenegro +MG,-18.766947,46.869107,Madagascar +MH,7.131474,171.184478,Marshall Islands +MK,41.608635,21.745275,Macedonia [FYROM] +ML,17.570692,-3.996166,Mali +MM,21.913965,95.956223,Myanmar [Burma] +MN,46.862496,103.846656,Mongolia +MO,22.198745,113.543873,Macau +MP,17.33083,145.38469,Northern Mariana Islands +MQ,14.641528,-61.024174,Martinique +MR,21.00789,-10.940835,Mauritania +MS,16.742498,-62.187366,Montserrat +MT,35.937496,14.375416,Malta +MU,-20.348404,57.552152,Mauritius +MV,3.202778,73.22068,Maldives +MW,-13.254308,34.301525,Malawi +MX,23.634501,-102.552784,Mexico +MY,4.210484,101.975766,Malaysia +MZ,-18.665695,35.529562,Mozambique +NA,-22.95764,18.49041,Namibia +NC,-20.904305,165.618042,New Caledonia +NE,17.607789,8.081666,Niger +NF,-29.040835,167.954712,Norfolk Island +NG,9.081999,8.675277,Nigeria +NI,12.865416,-85.207229,Nicaragua +NL,52.132633,5.291266,Netherlands +NO,60.472024,8.468946,Norway +NP,28.394857,84.124008,Nepal +NR,-0.522778,166.931503,Nauru +NU,-19.054445,-169.867233,Niue +NZ,-40.900557,174.885971,New Zealand +OM,21.512583,55.923255,Oman +PA,8.537981,-80.782127,Panama +PE,-9.189967,-75.015152,Peru +PF,-17.679742,-149.406843,French Polynesia +PG,-6.314993,143.95555,Papua New Guinea +PH,12.879721,121.774017,Philippines +PK,30.375321,69.345116,Pakistan +PL,51.919438,19.145136,Poland +PM,46.941936,-56.27111,Saint Pierre and Miquelon +PN,-24.703615,-127.439308,Pitcairn Islands +PR,18.220833,-66.590149,Puerto Rico +PS,31.952162,35.233154,Palestinian Territories +PT,39.399872,-8.224454,Portugal +PW,7.51498,134.58252,Palau +PY,-23.442503,-58.443832,Paraguay +QA,25.354826,51.183884,Qatar +RE,-21.115141,55.536384,R��union +RO,45.943161,24.96676,Romania +RS,44.016521,21.005859,Serbia +RU,61.52401,105.318756,Russia +RW,-1.940278,29.873888,Rwanda +SA,23.885942,45.079162,Saudi Arabia +SB,-9.64571,160.156194,Solomon Islands +SC,-4.679574,55.491977,Seychelles +SD,12.862807,30.217636,Sudan +SE,60.128161,18.643501,Sweden +SG,1.352083,103.819836,Singapore +SH,-24.143474,-10.030696,Saint Helena +SI,46.151241,14.995463,Slovenia +SJ,77.553604,23.670272,Svalbard and Jan Mayen +SK,48.669026,19.699024,Slovakia +SL,8.460555,-11.779889,Sierra Leone +SM,43.94236,12.457777,San Marino +SN,14.497401,-14.452362,Senegal +SO,5.152149,46.199616,Somalia +SR,3.919305,-56.027783,Suriname +ST,0.18636,6.613081,S?o Tom�� and Pr��ncipe +SV,13.794185,-88.89653,El Salvador +SY,34.802075,38.996815,Syria +SZ,-26.522503,31.465866,Swaziland +TC,21.694025,-71.797928,Turks and Caicos Islands +TD,15.454166,18.732207,Chad +TF,-49.280366,69.348557,French Southern Territories +TG,8.619543,0.824782,Togo +TH,15.870032,100.992541,Thailand +TJ,38.861034,71.276093,Tajikistan +TK,-8.967363,-171.855881,Tokelau +TL,-8.874217,125.727539,Timor-Leste +TM,38.969719,59.556278,Turkmenistan +TN,33.886917,9.537499,Tunisia +TO,-21.178986,-175.198242,Tonga +TR,38.963745,35.243322,Turkey +TT,10.691803,-61.222503,Trinidad and Tobago +TV,-7.109535,177.64933,Tuvalu +TW,23.69781,120.960515,Taiwan +TZ,-6.369028,34.888822,Tanzania +UA,48.379433,31.16558,Ukraine +UG,1.373333,32.290275,Uganda +US,37.09024,-95.712891,United States +UY,-32.522779,-55.765835,Uruguay +UZ,41.377491,64.585262,Uzbekistan +VA,41.902916,12.453389,Vatican City +VC,12.984305,-61.287228,Saint Vincent and the Grenadines +VE,6.42375,-66.58973,Venezuela +VG,18.420695,-64.639968,British Virgin Islands +VI,18.335765,-64.896335,U.S. Virgin Islands +VN,14.058324,108.277199,Vietnam +VU,-15.376706,166.959158,Vanuatu +WF,-13.768752,-177.156097,Wallis and Futuna +WS,-13.759029,-172.104629,Samoa +XK,42.602636,20.902977,Kosovo +YE,15.552727,48.516388,Yemen +YT,-12.8275,45.166244,Mayotte +ZA,-30.559482,22.937506,South Africa +ZM,-13.133897,27.849332,Zambia +ZW,-19.015438,29.154857,Zimbabwe
http://git-wip-us.apache.org/repos/asf/kylin/blob/c6c67197/examples/test_case_data/localmeta/model_desc/ci_inner_join_model.json ---------------------------------------------------------------------- diff --git a/examples/test_case_data/localmeta/model_desc/ci_inner_join_model.json b/examples/test_case_data/localmeta/model_desc/ci_inner_join_model.json index d37bb5f..19cf721 100644 --- a/examples/test_case_data/localmeta/model_desc/ci_inner_join_model.json +++ b/examples/test_case_data/localmeta/model_desc/ci_inner_join_model.json @@ -17,6 +17,34 @@ } }, { + "table": "DEFAULT.TEST_ACCOUNT", + "alias": "BUYER_ACCOUNT", + "kind": "FACT", + "join": { + "type": "INNER", + "primary_key": [ + "BUYER_ACCOUNT.ACCOUNT_ID" + ], + "foreign_key": [ + "TEST_ORDER.BUYER_ID" + ] + } + }, + { + "table": "DEFAULT.TEST_ACCOUNT", + "alias": "SELLER_ACCOUNT", + "kind": "FACT", + "join": { + "type": "INNER", + "primary_key": [ + "SELLER_ACCOUNT.ACCOUNT_ID" + ], + "foreign_key": [ + "TEST_KYLIN_FACT.SELLER_ID" + ] + } + }, + { "table": "EDW.TEST_CAL_DT", "join": { "type": "INNER", @@ -65,11 +93,37 @@ "TEST_KYLIN_FACT.SLR_SEGMENT_CD" ] } + }, + { + "table": "DEFAULT.TEST_COUNTRY", + "alias": "BUYER_COUNTRY", + "join": { + "type": "INNER", + "primary_key": [ + "BUYER_COUNTRY.COUNTRY" + ], + "foreign_key": [ + "BUYER_ACCOUNT.ACCOUNT_COUNTRY" + ] + } + }, + { + "table": "DEFAULT.TEST_COUNTRY", + "alias": "SELLER_COUNTRY", + "join": { + "type": "INNER", + "primary_key": [ + "SELLER_COUNTRY.COUNTRY" + ], + "foreign_key": [ + "SELLER_ACCOUNT.ACCOUNT_COUNTRY" + ] + } } ], "dimensions": [ { - "table": "DEFAULT.TEST_KYLIN_FACT", + "table": "TEST_KYLIN_FACT", "columns": [ "TRANS_ID", "ORDER_ID", @@ -83,7 +137,7 @@ ] }, { - "table": "DEFAULT.TEST_ORDER", + "table": "TEST_ORDER", "columns": [ "ORDER_ID", "BUYER_ID", @@ -93,7 +147,27 @@ ] }, { - "table": "DEFAULT.TEST_CATEGORY_GROUPINGS", + "table": "BUYER_ACCOUNT", + "columns": [ + "ACCOUNT_ID", + "ACCOUNT_BUYER_LEVEL", + "ACCOUNT_SELLER_LEVEL", + "ACCOUNT_COUNTRY", + "ACCOUNT_CONTACT" + ] + }, + { + "table": "SELLER_ACCOUNT", + "columns": [ + "ACCOUNT_ID", + "ACCOUNT_BUYER_LEVEL", + "ACCOUNT_SELLER_LEVEL", + "ACCOUNT_COUNTRY", + "ACCOUNT_CONTACT" + ] + }, + { + "table": "TEST_CATEGORY_GROUPINGS", "columns": [ "LEAF_CATEG_ID", "SITE_ID", @@ -107,7 +181,7 @@ ] }, { - "table": "EDW.TEST_SITES", + "table": "TEST_SITES", "columns": [ "SITE_ID", "SITE_NAME", @@ -115,18 +189,32 @@ ] }, { - "table": "EDW.TEST_SELLER_TYPE_DIM", + "table": "TEST_SELLER_TYPE_DIM", "columns": [ "SELLER_TYPE_CD", "SELLER_TYPE_DESC" ] }, { - "table": "EDW.TEST_CAL_DT", + "table": "TEST_CAL_DT", "columns": [ "CAL_DT", "WEEK_BEG_DT" ] + }, + { + "table": "BUYER_COUNTRY", + "columns": [ + "COUNTRY", + "NAME" + ] + }, + { + "table": "SELLER_COUNTRY", + "columns": [ + "COUNTRY", + "NAME" + ] } ], "metrics": [ http://git-wip-us.apache.org/repos/asf/kylin/blob/c6c67197/examples/test_case_data/localmeta/model_desc/ci_left_join_model.json ---------------------------------------------------------------------- diff --git a/examples/test_case_data/localmeta/model_desc/ci_left_join_model.json b/examples/test_case_data/localmeta/model_desc/ci_left_join_model.json index e0f88a7..1b08aaf 100644 --- a/examples/test_case_data/localmeta/model_desc/ci_left_join_model.json +++ b/examples/test_case_data/localmeta/model_desc/ci_left_join_model.json @@ -17,6 +17,34 @@ } }, { + "table": "DEFAULT.TEST_ACCOUNT", + "alias": "BUYER_ACCOUNT", + "kind": "FACT", + "join": { + "type": "LEFT", + "primary_key": [ + "BUYER_ACCOUNT.ACCOUNT_ID" + ], + "foreign_key": [ + "TEST_ORDER.BUYER_ID" + ] + } + }, + { + "table": "DEFAULT.TEST_ACCOUNT", + "alias": "SELLER_ACCOUNT", + "kind": "FACT", + "join": { + "type": "LEFT", + "primary_key": [ + "SELLER_ACCOUNT.ACCOUNT_ID" + ], + "foreign_key": [ + "TEST_KYLIN_FACT.SELLER_ID" + ] + } + }, + { "table": "EDW.TEST_CAL_DT", "join": { "type": "LEFT", @@ -65,11 +93,37 @@ "TEST_KYLIN_FACT.SLR_SEGMENT_CD" ] } + }, + { + "table": "DEFAULT.TEST_COUNTRY", + "alias": "BUYER_COUNTRY", + "join": { + "type": "LEFT", + "primary_key": [ + "BUYER_COUNTRY.COUNTRY" + ], + "foreign_key": [ + "BUYER_ACCOUNT.ACCOUNT_COUNTRY" + ] + } + }, + { + "table": "DEFAULT.TEST_COUNTRY", + "alias": "SELLER_COUNTRY", + "join": { + "type": "LEFT", + "primary_key": [ + "SELLER_COUNTRY.COUNTRY" + ], + "foreign_key": [ + "SELLER_ACCOUNT.ACCOUNT_COUNTRY" + ] + } } ], "dimensions": [ { - "table": "DEFAULT.TEST_KYLIN_FACT", + "table": "TEST_KYLIN_FACT", "columns": [ "TRANS_ID", "ORDER_ID", @@ -83,7 +137,7 @@ ] }, { - "table": "DEFAULT.TEST_ORDER", + "table": "TEST_ORDER", "columns": [ "ORDER_ID", "BUYER_ID", @@ -93,7 +147,27 @@ ] }, { - "table": "DEFAULT.TEST_CATEGORY_GROUPINGS", + "table": "BUYER_ACCOUNT", + "columns": [ + "ACCOUNT_ID", + "ACCOUNT_BUYER_LEVEL", + "ACCOUNT_SELLER_LEVEL", + "ACCOUNT_COUNTRY", + "ACCOUNT_CONTACT" + ] + }, + { + "table": "SELLER_ACCOUNT", + "columns": [ + "ACCOUNT_ID", + "ACCOUNT_BUYER_LEVEL", + "ACCOUNT_SELLER_LEVEL", + "ACCOUNT_COUNTRY", + "ACCOUNT_CONTACT" + ] + }, + { + "table": "TEST_CATEGORY_GROUPINGS", "columns": [ "LEAF_CATEG_ID", "SITE_ID", @@ -107,7 +181,7 @@ ] }, { - "table": "EDW.TEST_SITES", + "table": "TEST_SITES", "columns": [ "SITE_ID", "SITE_NAME", @@ -115,18 +189,32 @@ ] }, { - "table": "EDW.TEST_SELLER_TYPE_DIM", + "table": "TEST_SELLER_TYPE_DIM", "columns": [ "SELLER_TYPE_CD", "SELLER_TYPE_DESC" ] }, { - "table": "EDW.TEST_CAL_DT", + "table": "TEST_CAL_DT", "columns": [ "CAL_DT", "WEEK_BEG_DT" ] + }, + { + "table": "BUYER_COUNTRY", + "columns": [ + "COUNTRY", + "NAME" + ] + }, + { + "table": "SELLER_COUNTRY", + "columns": [ + "COUNTRY", + "NAME" + ] } ], "metrics": [ http://git-wip-us.apache.org/repos/asf/kylin/blob/c6c67197/examples/test_case_data/localmeta/model_desc/test_kylin_snowflake_sales_model.json ---------------------------------------------------------------------- diff --git a/examples/test_case_data/localmeta/model_desc/test_kylin_snowflake_sales_model.json b/examples/test_case_data/localmeta/model_desc/test_kylin_snowflake_sales_model.json deleted file mode 100644 index 84c6979..0000000 --- a/examples/test_case_data/localmeta/model_desc/test_kylin_snowflake_sales_model.json +++ /dev/null @@ -1,87 +0,0 @@ -{ - "uuid" : "0928468a-9fab-4185-9a14-6f2e7c74823f", - "name" : "test_kylin_snowflake_sales_model", - "lookups" : [ { - "table" : "SNOWTEST.KYLIN_CAL_DT", - "join" : { - "type" : "inner", - "primary_key" : [ "CAL_DT" ], - "foreign_key" : [ "PART_DT" ] - } - }, { - "table" : "SNOWTEST.KYLIN_CATEGORY_GROUPINGS", - "join" : { - "type" : "inner", - "primary_key" : [ "LEAF_CATEG_ID", "SITE_ID" ], - "foreign_key" : [ "LEAF_CATEG_ID", "LSTG_SITE_ID" ] - } - }, { - "table" : "SNOWTEST.KYLIN_ACCOUNT", - "alias" : "BUYER_ACCOUNT", - "join" : { - "type" : "inner", - "primary_key" : [ "ACCOUNT_ID" ], - "foreign_key" : [ "BUYER_ID" ] - } - }, { - "table" : "SNOWTEST.KYLIN_ACCOUNT", - "alias" : "SELLER_ACCOUNT", - "join" : { - "type" : "inner", - "primary_key" : [ "ACCOUNT_ID" ], - "foreign_key" : [ "SELLER_ID" ] - } - }, { - "table" : "SNOWTEST.KYLIN_COUNTRY", - "alias" : "BUYER_COUNTRY", - "join" : { - "type" : "inner", - "primary_key" : [ "COUNTRY" ], - "foreign_key" : [ "BUYER_ACCOUNT.ACCOUNT_COUNTRY" ] - } - }, { - "table" : "SNOWTEST.KYLIN_COUNTRY", - "alias" : "SELLER_COUNTRY", - "join" : { - "type" : "inner", - "primary_key" : [ "COUNTRY" ], - "foreign_key" : [ "SELLER_ACCOUNT.ACCOUNT_COUNTRY" ] - } - }], - "dimensions" : [ { - "table" : "SNOWTEST.KYLIN_SALES", - "columns" : [ "TRANS_ID", "SELLER_ID", "BUYER_ID", "PART_DT", "LEAF_CATEG_ID", "LSTG_FORMAT_NAME", "LSTG_SITE_ID", "OPS_USER_ID", "OPS_REGION" ] - }, { - "table" : "SNOWTEST.KYLIN_CAL_DT", - "columns" : ["CAL_DT", "WEEK_BEG_DT"] - }, { - "table" : "SNOWTEST.KYLIN_CATEGORY_GROUPINGS", - "columns" : [ "USER_DEFINED_FIELD1", "USER_DEFINED_FIELD3", "META_CATEG_NAME", "CATEG_LVL2_NAME", "CATEG_LVL3_NAME", "LEAF_CATEG_ID", "SITE_ID" ] - }, { - "table" : "BUYER_ACCOUNT", - "columns" : [ "ACCOUNT_ID", "ACCOUNT_BUYER_LEVEL", "ACCOUNT_SELLER_LEVEL", "ACCOUNT_COUNTRY", "ACCOUNT_CONTACT" ] - }, { - "table" : "SELLER_ACCOUNT", - "columns" : [ "ACCOUNT_ID", "ACCOUNT_BUYER_LEVEL", "ACCOUNT_SELLER_LEVEL", "ACCOUNT_COUNTRY", "ACCOUNT_CONTACT" ] - }, { - "table" : "BUYER_COUNTRY", - "columns" : [ "COUNTRY", "NAME" ] - }, { - "table" : "SELLER_COUNTRY", - "columns" : [ "COUNTRY", "NAME" ] - } ], - "metrics": [ - "PRICE", - "ITEM_COUNT", - "SELLER_ID", - "LSTG_FORMAT_NAME" - ], - "last_modified" : 1422435345362, - "fact_table" : "SNOWTEST.KYLIN_SALES", - "filter_condition" : null, - "partition_desc" : { - "partition_date_column" : "SNOWTEST.KYLIN_SALES.PART_DT", - "partition_date_start" : 1325376000000, - "partition_type" : "APPEND" - } -} http://git-wip-us.apache.org/repos/asf/kylin/blob/c6c67197/examples/test_case_data/localmeta/table/DEFAULT.TEST_ACCOUNT.json ---------------------------------------------------------------------- diff --git a/examples/test_case_data/localmeta/table/DEFAULT.TEST_ACCOUNT.json b/examples/test_case_data/localmeta/table/DEFAULT.TEST_ACCOUNT.json new file mode 100644 index 0000000..89e265b --- /dev/null +++ b/examples/test_case_data/localmeta/table/DEFAULT.TEST_ACCOUNT.json @@ -0,0 +1,34 @@ +{ + "uuid" : "f386e39e-40d7-44c2-9eb3-41b365632231", + + "name" : "TEST_ACCOUNT", + "data_gen" : "2000", + + "columns" : [ { + "id" : "1", + "name" : "ACCOUNT_ID", + "datatype" : "bigint", + "data_gen" : "ID|10000000" + }, { + "id" : "2", + "name" : "ACCOUNT_BUYER_LEVEL", + "datatype" : "int", + "data_gen" : "RAND||0|5" + }, { + "id" : "3", + "name" : "ACCOUNT_SELLER_LEVEL", + "datatype" : "int", + "data_gen" : "RAND||0|5" + }, { + "id" : "4", + "name" : "ACCOUNT_COUNTRY", + "datatype" : "string", + "data_gen" : "CN|FR|GB|GE|JP|IT|RU|US" + }, { + "id" : "5", + "name" : "ACCOUNT_CONTACT", + "datatype" : "string" + } ], + "database" : "DEFAULT", + "last_modified" : 0 +} \ No newline at end of file http://git-wip-us.apache.org/repos/asf/kylin/blob/c6c67197/examples/test_case_data/localmeta/table/DEFAULT.TEST_COUNTRY.json ---------------------------------------------------------------------- diff --git a/examples/test_case_data/localmeta/table/DEFAULT.TEST_COUNTRY.json b/examples/test_case_data/localmeta/table/DEFAULT.TEST_COUNTRY.json new file mode 100644 index 0000000..202182b --- /dev/null +++ b/examples/test_case_data/localmeta/table/DEFAULT.TEST_COUNTRY.json @@ -0,0 +1,24 @@ +{ + "uuid" : "e286e39e-40d7-44c2-8fa2-41b365632882", + + "name" : "TEST_COUNTRY", + "columns" : [ { + "id" : "1", + "name" : "COUNTRY", + "datatype" : "string" + }, { + "id" : "2", + "name" : "LATITUDE", + "datatype" : "double" + }, { + "id" : "3", + "name" : "LONGITUDE", + "datatype" : "double" + }, { + "id" : "4", + "name" : "NAME", + "datatype" : "string" + } ], + "database" : "DEFAULT", + "last_modified" : 0 +} \ No newline at end of file http://git-wip-us.apache.org/repos/asf/kylin/blob/c6c67197/examples/test_case_data/localmeta/table/DEFAULT.TEST_KYLIN_COUNTRY.json ---------------------------------------------------------------------- diff --git a/examples/test_case_data/localmeta/table/DEFAULT.TEST_KYLIN_COUNTRY.json b/examples/test_case_data/localmeta/table/DEFAULT.TEST_KYLIN_COUNTRY.json deleted file mode 100644 index acf5470..0000000 --- a/examples/test_case_data/localmeta/table/DEFAULT.TEST_KYLIN_COUNTRY.json +++ /dev/null @@ -1,24 +0,0 @@ -{ - "uuid" : "e286e39e-40d7-44c2-8fa2-41b365632882", - - "name" : "TEST_KYLIN_COUNTRY", - "columns" : [ { - "id" : "1", - "name" : "COUNTRY", - "datatype" : "string" - }, { - "id" : "2", - "name" : "LATITUDE", - "datatype" : "double" - }, { - "id" : "3", - "name" : "LONGITUDE", - "datatype" : "double" - }, { - "id" : "4", - "name" : "NAME", - "datatype" : "string" - } ], - "database" : "DEFAULT", - "last_modified" : 0 -} \ No newline at end of file http://git-wip-us.apache.org/repos/asf/kylin/blob/c6c67197/examples/test_case_data/localmeta/table/SNOWTEST.KYLIN_ACCOUNT.json ---------------------------------------------------------------------- diff --git a/examples/test_case_data/localmeta/table/SNOWTEST.KYLIN_ACCOUNT.json b/examples/test_case_data/localmeta/table/SNOWTEST.KYLIN_ACCOUNT.json deleted file mode 100644 index 8d39cbc..0000000 --- a/examples/test_case_data/localmeta/table/SNOWTEST.KYLIN_ACCOUNT.json +++ /dev/null @@ -1,28 +0,0 @@ -{ - "uuid" : "f386e39e-40d7-44c2-9eb3-41b365632231", - - "name" : "KYLIN_ACCOUNT", - "columns" : [ { - "id" : "1", - "name" : "ACCOUNT_ID", - "datatype" : "bigint" - }, { - "id" : "2", - "name" : "ACCOUNT_BUYER_LEVEL", - "datatype" : "int" - }, { - "id" : "3", - "name" : "ACCOUNT_SELLER_LEVEL", - "datatype" : "int" - }, { - "id" : "4", - "name" : "ACCOUNT_COUNTRY", - "datatype" : "string" - }, { - "id" : "5", - "name" : "ACCOUNT_CONTACT", - "datatype" : "string" - } ], - "database" : "SNOWTEST", - "last_modified" : 0 -} \ No newline at end of file http://git-wip-us.apache.org/repos/asf/kylin/blob/c6c67197/examples/test_case_data/localmeta/table/SNOWTEST.KYLIN_CAL_DT.json ---------------------------------------------------------------------- diff --git a/examples/test_case_data/localmeta/table/SNOWTEST.KYLIN_CAL_DT.json b/examples/test_case_data/localmeta/table/SNOWTEST.KYLIN_CAL_DT.json deleted file mode 100644 index d186f76..0000000 --- a/examples/test_case_data/localmeta/table/SNOWTEST.KYLIN_CAL_DT.json +++ /dev/null @@ -1,408 +0,0 @@ -{ - "uuid" : "0ff420eb-79ad-40bd-bca9-12d8cd05c60a", - - "name" : "KYLIN_CAL_DT", - "columns" : [ { - "id" : "1", - "name" : "CAL_DT", - "datatype" : "date" - }, { - "id" : "2", - "name" : "YEAR_BEG_DT", - "datatype" : "date" - }, { - "id" : "3", - "name" : "QTR_BEG_DT", - "datatype" : "date" - }, { - "id" : "4", - "name" : "MONTH_BEG_DT", - "datatype" : "date" - }, { - "id" : "5", - "name" : "WEEK_BEG_DT", - "datatype" : "date" - }, { - "id" : "6", - "name" : "AGE_FOR_YEAR_ID", - "datatype" : "smallint" - }, { - "id" : "7", - "name" : "AGE_FOR_QTR_ID", - "datatype" : "smallint" - }, { - "id" : "8", - "name" : "AGE_FOR_MONTH_ID", - "datatype" : "smallint" - }, { - "id" : "9", - "name" : "AGE_FOR_WEEK_ID", - "datatype" : "smallint" - }, { - "id" : "10", - "name" : "AGE_FOR_DT_ID", - "datatype" : "smallint" - }, { - "id" : "11", - "name" : "AGE_FOR_RTL_YEAR_ID", - "datatype" : "smallint" - }, { - "id" : "12", - "name" : "AGE_FOR_RTL_QTR_ID", - "datatype" : "smallint" - }, { - "id" : "13", - "name" : "AGE_FOR_RTL_MONTH_ID", - "datatype" : "smallint" - }, { - "id" : "14", - "name" : "AGE_FOR_RTL_WEEK_ID", - "datatype" : "smallint" - }, { - "id" : "15", - "name" : "AGE_FOR_CS_WEEK_ID", - "datatype" : "smallint" - }, { - "id" : "16", - "name" : "DAY_OF_CAL_ID", - "datatype" : "int" - }, { - "id" : "17", - "name" : "DAY_OF_YEAR_ID", - "datatype" : "smallint" - }, { - "id" : "18", - "name" : "DAY_OF_QTR_ID", - "datatype" : "smallint" - }, { - "id" : "19", - "name" : "DAY_OF_MONTH_ID", - "datatype" : "smallint" - }, { - "id" : "20", - "name" : "DAY_OF_WEEK_ID", - "datatype" : "int" - }, { - "id" : "21", - "name" : "WEEK_OF_YEAR_ID", - "datatype" : "tinyint" - }, { - "id" : "22", - "name" : "WEEK_OF_CAL_ID", - "datatype" : "int" - }, { - "id" : "23", - "name" : "MONTH_OF_QTR_ID", - "datatype" : "tinyint" - }, { - "id" : "24", - "name" : "MONTH_OF_YEAR_ID", - "datatype" : "tinyint" - }, { - "id" : "25", - "name" : "MONTH_OF_CAL_ID", - "datatype" : "smallint" - }, { - "id" : "26", - "name" : "QTR_OF_YEAR_ID", - "datatype" : "tinyint" - }, { - "id" : "27", - "name" : "QTR_OF_CAL_ID", - "datatype" : "smallint" - }, { - "id" : "28", - "name" : "YEAR_OF_CAL_ID", - "datatype" : "smallint" - }, { - "id" : "29", - "name" : "YEAR_END_DT", - "datatype" : "string" - }, { - "id" : "30", - "name" : "QTR_END_DT", - "datatype" : "string" - }, { - "id" : "31", - "name" : "MONTH_END_DT", - "datatype" : "string" - }, { - "id" : "32", - "name" : "WEEK_END_DT", - "datatype" : "string" - }, { - "id" : "33", - "name" : "CAL_DT_NAME", - "datatype" : "string" - }, { - "id" : "34", - "name" : "CAL_DT_DESC", - "datatype" : "string" - }, { - "id" : "35", - "name" : "CAL_DT_SHORT_NAME", - "datatype" : "string" - }, { - "id" : "36", - "name" : "YTD_YN_ID", - "datatype" : "tinyint" - }, { - "id" : "37", - "name" : "QTD_YN_ID", - "datatype" : "tinyint" - }, { - "id" : "38", - "name" : "MTD_YN_ID", - "datatype" : "tinyint" - }, { - "id" : "39", - "name" : "WTD_YN_ID", - "datatype" : "tinyint" - }, { - "id" : "40", - "name" : "SEASON_BEG_DT", - "datatype" : "string" - }, { - "id" : "41", - "name" : "DAY_IN_YEAR_COUNT", - "datatype" : "smallint" - }, { - "id" : "42", - "name" : "DAY_IN_QTR_COUNT", - "datatype" : "tinyint" - }, { - "id" : "43", - "name" : "DAY_IN_MONTH_COUNT", - "datatype" : "tinyint" - }, { - "id" : "44", - "name" : "DAY_IN_WEEK_COUNT", - "datatype" : "tinyint" - }, { - "id" : "45", - "name" : "RTL_YEAR_BEG_DT", - "datatype" : "string" - }, { - "id" : "46", - "name" : "RTL_QTR_BEG_DT", - "datatype" : "string" - }, { - "id" : "47", - "name" : "RTL_MONTH_BEG_DT", - "datatype" : "string" - }, { - "id" : "48", - "name" : "RTL_WEEK_BEG_DT", - "datatype" : "string" - }, { - "id" : "49", - "name" : "CS_WEEK_BEG_DT", - "datatype" : "string" - }, { - "id" : "50", - "name" : "CAL_DATE", - "datatype" : "string" - }, { - "id" : "51", - "name" : "DAY_OF_WEEK", - "datatype" : "string" - }, { - "id" : "52", - "name" : "MONTH_ID", - "datatype" : "string" - }, { - "id" : "53", - "name" : "PRD_DESC", - "datatype" : "string" - }, { - "id" : "54", - "name" : "PRD_FLAG", - "datatype" : "string" - }, { - "id" : "55", - "name" : "PRD_ID", - "datatype" : "string" - }, { - "id" : "56", - "name" : "PRD_IND", - "datatype" : "string" - }, { - "id" : "57", - "name" : "QTR_DESC", - "datatype" : "string" - }, { - "id" : "58", - "name" : "QTR_ID", - "datatype" : "string" - }, { - "id" : "59", - "name" : "QTR_IND", - "datatype" : "string" - }, { - "id" : "60", - "name" : "RETAIL_WEEK", - "datatype" : "string" - }, { - "id" : "61", - "name" : "RETAIL_YEAR", - "datatype" : "string" - }, { - "id" : "62", - "name" : "RETAIL_START_DATE", - "datatype" : "string" - }, { - "id" : "63", - "name" : "RETAIL_WK_END_DATE", - "datatype" : "string" - }, { - "id" : "64", - "name" : "WEEK_IND", - "datatype" : "string" - }, { - "id" : "65", - "name" : "WEEK_NUM_DESC", - "datatype" : "string" - }, { - "id" : "66", - "name" : "WEEK_BEG_DATE", - "datatype" : "string" - }, { - "id" : "67", - "name" : "WEEK_END_DATE", - "datatype" : "string" - }, { - "id" : "68", - "name" : "WEEK_IN_YEAR_ID", - "datatype" : "string" - }, { - "id" : "69", - "name" : "WEEK_ID", - "datatype" : "string" - }, { - "id" : "70", - "name" : "WEEK_BEG_END_DESC_MDY", - "datatype" : "string" - }, { - "id" : "71", - "name" : "WEEK_BEG_END_DESC_MD", - "datatype" : "string" - }, { - "id" : "72", - "name" : "YEAR_ID", - "datatype" : "string" - }, { - "id" : "73", - "name" : "YEAR_IND", - "datatype" : "string" - }, { - "id" : "74", - "name" : "CAL_DT_MNS_1YEAR_DT", - "datatype" : "string" - }, { - "id" : "75", - "name" : "CAL_DT_MNS_2YEAR_DT", - "datatype" : "string" - }, { - "id" : "76", - "name" : "CAL_DT_MNS_1QTR_DT", - "datatype" : "string" - }, { - "id" : "77", - "name" : "CAL_DT_MNS_2QTR_DT", - "datatype" : "string" - }, { - "id" : "78", - "name" : "CAL_DT_MNS_1MONTH_DT", - "datatype" : "string" - }, { - "id" : "79", - "name" : "CAL_DT_MNS_2MONTH_DT", - "datatype" : "string" - }, { - "id" : "80", - "name" : "CAL_DT_MNS_1WEEK_DT", - "datatype" : "string" - }, { - "id" : "81", - "name" : "CAL_DT_MNS_2WEEK_DT", - "datatype" : "string" - }, { - "id" : "82", - "name" : "CURR_CAL_DT_MNS_1YEAR_YN_ID", - "datatype" : "tinyint" - }, { - "id" : "83", - "name" : "CURR_CAL_DT_MNS_2YEAR_YN_ID", - "datatype" : "tinyint" - }, { - "id" : "84", - "name" : "CURR_CAL_DT_MNS_1QTR_YN_ID", - "datatype" : "tinyint" - }, { - "id" : "85", - "name" : "CURR_CAL_DT_MNS_2QTR_YN_ID", - "datatype" : "tinyint" - }, { - "id" : "86", - "name" : "CURR_CAL_DT_MNS_1MONTH_YN_ID", - "datatype" : "tinyint" - }, { - "id" : "87", - "name" : "CURR_CAL_DT_MNS_2MONTH_YN_ID", - "datatype" : "tinyint" - }, { - "id" : "88", - "name" : "CURR_CAL_DT_MNS_1WEEK_YN_IND", - "datatype" : "tinyint" - }, { - "id" : "89", - "name" : "CURR_CAL_DT_MNS_2WEEK_YN_IND", - "datatype" : "tinyint" - }, { - "id" : "90", - "name" : "RTL_MONTH_OF_RTL_YEAR_ID", - "datatype" : "string" - }, { - "id" : "91", - "name" : "RTL_QTR_OF_RTL_YEAR_ID", - "datatype" : "tinyint" - }, { - "id" : "92", - "name" : "RTL_WEEK_OF_RTL_YEAR_ID", - "datatype" : "tinyint" - }, { - "id" : "93", - "name" : "SEASON_OF_YEAR_ID", - "datatype" : "tinyint" - }, { - "id" : "94", - "name" : "YTM_YN_ID", - "datatype" : "tinyint" - }, { - "id" : "95", - "name" : "YTQ_YN_ID", - "datatype" : "tinyint" - }, { - "id" : "96", - "name" : "YTW_YN_ID", - "datatype" : "tinyint" - }, { - "id" : "97", - "name" : "KYLIN_CAL_DT_CRE_DATE", - "datatype" : "string" - }, { - "id" : "98", - "name" : "KYLIN_CAL_DT_CRE_USER", - "datatype" : "string" - }, { - "id" : "99", - "name" : "KYLIN_CAL_DT_UPD_DATE", - "datatype" : "string" - }, { - "id" : "100", - "name" : "KYLIN_CAL_DT_UPD_USER", - "datatype" : "string" - } ], - "database" : "SNOWTEST", - "last_modified" : 0 -} \ No newline at end of file http://git-wip-us.apache.org/repos/asf/kylin/blob/c6c67197/examples/test_case_data/localmeta/table/SNOWTEST.KYLIN_CATEGORY_GROUPINGS.json ---------------------------------------------------------------------- diff --git a/examples/test_case_data/localmeta/table/SNOWTEST.KYLIN_CATEGORY_GROUPINGS.json b/examples/test_case_data/localmeta/table/SNOWTEST.KYLIN_CATEGORY_GROUPINGS.json deleted file mode 100644 index c101bd1..0000000 --- a/examples/test_case_data/localmeta/table/SNOWTEST.KYLIN_CATEGORY_GROUPINGS.json +++ /dev/null @@ -1,152 +0,0 @@ -{ - "uuid" : "952d11b5-69d9-45d1-92af-227489485e3f", - - "name" : "KYLIN_CATEGORY_GROUPINGS", - "columns" : [ { - "id" : "1", - "name" : "LEAF_CATEG_ID", - "datatype" : "bigint" - }, { - "id" : "2", - "name" : "LEAF_CATEG_NAME", - "datatype" : "string" - }, { - "id" : "3", - "name" : "SITE_ID", - "datatype" : "int" - }, { - "id" : "4", - "name" : "CATEG_BUSN_MGR", - "datatype" : "string" - }, { - "id" : "5", - "name" : "CATEG_BUSN_UNIT", - "datatype" : "string" - }, { - "id" : "6", - "name" : "REGN_CATEG", - "datatype" : "string" - }, { - "id" : "7", - "name" : "USER_DEFINED_FIELD1", - "datatype" : "string" - }, { - "id" : "8", - "name" : "USER_DEFINED_FIELD3", - "datatype" : "string" - }, { - "id" : "9", - "name" : "KYLIN_GROUPINGS_CRE_DATE", - "datatype" : "string" - }, { - "id" : "10", - "name" : "KYLIN_GROUPINGS_UPD_DATE", - "datatype" : "string" - }, { - "id" : "11", - "name" : "KYLIN_GROUPINGS_CRE_USER", - "datatype" : "string" - }, { - "id" : "12", - "name" : "KYLIN_GROUPINGS_UPD_USER", - "datatype" : "string" - }, { - "id" : "13", - "name" : "META_CATEG_ID", - "datatype" : "decimal" - }, { - "id" : "14", - "name" : "META_CATEG_NAME", - "datatype" : "string" - }, { - "id" : "15", - "name" : "CATEG_LVL2_ID", - "datatype" : "decimal" - }, { - "id" : "16", - "name" : "CATEG_LVL3_ID", - "datatype" : "decimal" - }, { - "id" : "17", - "name" : "CATEG_LVL4_ID", - "datatype" : "decimal" - }, { - "id" : "18", - "name" : "CATEG_LVL5_ID", - "datatype" : "decimal" - }, { - "id" : "19", - "name" : "CATEG_LVL6_ID", - "datatype" : "decimal" - }, { - "id" : "20", - "name" : "CATEG_LVL7_ID", - "datatype" : "decimal" - }, { - "id" : "21", - "name" : "CATEG_LVL2_NAME", - "datatype" : "string" - }, { - "id" : "22", - "name" : "CATEG_LVL3_NAME", - "datatype" : "string" - }, { - "id" : "23", - "name" : "CATEG_LVL4_NAME", - "datatype" : "string" - }, { - "id" : "24", - "name" : "CATEG_LVL5_NAME", - "datatype" : "string" - }, { - "id" : "25", - "name" : "CATEG_LVL6_NAME", - "datatype" : "string" - }, { - "id" : "26", - "name" : "CATEG_LVL7_NAME", - "datatype" : "string" - }, { - "id" : "27", - "name" : "CATEG_FLAGS", - "datatype" : "decimal" - }, { - "id" : "28", - "name" : "ADULT_CATEG_YN", - "datatype" : "string" - }, { - "id" : "29", - "name" : "DOMAIN_ID", - "datatype" : "decimal" - }, { - "id" : "30", - "name" : "USER_DEFINED_FIELD5", - "datatype" : "string" - }, { - "id" : "31", - "name" : "VCS_ID", - "datatype" : "decimal" - }, { - "id" : "32", - "name" : "GCS_ID", - "datatype" : "decimal" - }, { - "id" : "33", - "name" : "MOVE_TO", - "datatype" : "decimal" - }, { - "id" : "34", - "name" : "SAP_CATEGORY_ID", - "datatype" : "decimal" - }, { - "id" : "35", - "name" : "SRC_ID", - "datatype" : "tinyint" - }, { - "id" : "36", - "name" : "BSNS_VRTCL_NAME", - "datatype" : "string" - } ], - "database" : "SNOWTEST", - "last_modified" : 0 -} \ No newline at end of file http://git-wip-us.apache.org/repos/asf/kylin/blob/c6c67197/examples/test_case_data/localmeta/table/SNOWTEST.KYLIN_COUNTRY.json ---------------------------------------------------------------------- diff --git a/examples/test_case_data/localmeta/table/SNOWTEST.KYLIN_COUNTRY.json b/examples/test_case_data/localmeta/table/SNOWTEST.KYLIN_COUNTRY.json deleted file mode 100644 index 2f4d723..0000000 --- a/examples/test_case_data/localmeta/table/SNOWTEST.KYLIN_COUNTRY.json +++ /dev/null @@ -1,24 +0,0 @@ -{ - "uuid" : "e286e39e-40d7-44c2-8fa2-41b365632882", - - "name" : "KYLIN_COUNTRY", - "columns" : [ { - "id" : "1", - "name" : "COUNTRY", - "datatype" : "string" - }, { - "id" : "2", - "name" : "LATITUDE", - "datatype" : "double" - }, { - "id" : "3", - "name" : "LONGITUDE", - "datatype" : "double" - }, { - "id" : "4", - "name" : "NAME", - "datatype" : "string" - } ], - "database" : "SNOWTEST", - "last_modified" : 0 -} \ No newline at end of file http://git-wip-us.apache.org/repos/asf/kylin/blob/c6c67197/examples/test_case_data/localmeta/table/SNOWTEST.KYLIN_SALES.json ---------------------------------------------------------------------- diff --git a/examples/test_case_data/localmeta/table/SNOWTEST.KYLIN_SALES.json b/examples/test_case_data/localmeta/table/SNOWTEST.KYLIN_SALES.json deleted file mode 100644 index a9dcc08..0000000 --- a/examples/test_case_data/localmeta/table/SNOWTEST.KYLIN_SALES.json +++ /dev/null @@ -1,56 +0,0 @@ -{ - "uuid" : "e286e39e-40d7-44c2-8fa2-41b365522771", - - "name" : "KYLIN_SALES", - "columns" : [ { - "id" : "1", - "name" : "TRANS_ID", - "datatype" : "bigint" - }, { - "id" : "2", - "name" : "PART_DT", - "datatype" : "date" - }, { - "id" : "3", - "name" : "LSTG_FORMAT_NAME", - "datatype" : "string" - }, { - "id" : "4", - "name" : "LEAF_CATEG_ID", - "datatype" : "bigint" - }, { - "id" : "5", - "name" : "LSTG_SITE_ID", - "datatype" : "int" - }, { - "id" : "6", - "name" : "SLR_SEGMENT_CD", - "datatype" : "smallint" - }, { - "id" : "7", - "name" : "PRICE", - "datatype" : "decimal(19,4)" - }, { - "id" : "8", - "name" : "ITEM_COUNT", - "datatype" : "bigint" - }, { - "id" : "9", - "name" : "SELLER_ID", - "datatype" : "bigint" - }, { - "id" : "10", - "name" : "BUYER_ID", - "datatype" : "bigint" - }, { - "id" : "11", - "name" : "OPS_USER_ID", - "datatype" : "string" - }, { - "id" : "12", - "name" : "OPS_REGION", - "datatype" : "string" - } ], - "database" : "SNOWTEST", - "last_modified" : 0 -} http://git-wip-us.apache.org/repos/asf/kylin/blob/c6c67197/kylin-it/src/test/java/org/apache/kylin/query/H2Database.java ---------------------------------------------------------------------- diff --git a/kylin-it/src/test/java/org/apache/kylin/query/H2Database.java b/kylin-it/src/test/java/org/apache/kylin/query/H2Database.java index 3966c3a..c449837 100644 --- a/kylin-it/src/test/java/org/apache/kylin/query/H2Database.java +++ b/kylin-it/src/test/java/org/apache/kylin/query/H2Database.java @@ -40,7 +40,16 @@ public class H2Database { @SuppressWarnings("unused") private static final Logger logger = LoggerFactory.getLogger(H2Database.class); - private static final String[] ALL_TABLES = new String[] { "edw.test_cal_dt", "default.test_category_groupings", "default.test_kylin_fact", "default.test_order", "edw.test_seller_type_dim", "edw.test_sites", "default.streaming_table" }; + private static final String[] ALL_TABLES = new String[] { // + "edw.test_cal_dt", // + "default.test_category_groupings", // + "default.test_kylin_fact", // + "default.test_order", // + "edw.test_seller_type_dim", // + "edw.test_sites", // + "default.test_account", // + "default.test_country", // + "default.streaming_table" }; private static final Map<String, String> javaToH2DataTypeMapping = new HashMap<String, String>(); static {
