http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_cache/query02.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_cache/query02.sql b/query/src/test/resources/query/sql_cache/query02.sql deleted file mode 100644 index ae1a933..0000000 --- a/query/src/test/resources/query/sql_cache/query02.sql +++ /dev/null @@ -1,11 +0,0 @@ -select test_kylin_fact.lstg_format_name, test_kylin_fact.cal_dt,sum(test_kylin_fact.price) as GMV - , count(*) as TRANS_CNT - from test_kylin_fact -inner JOIN edw.test_cal_dt as test_cal_dt - ON test_kylin_fact.cal_dt = test_cal_dt.cal_dt - inner JOIN test_category_groupings - ON test_kylin_fact.leaf_categ_id = test_category_groupings.leaf_categ_id AND test_kylin_fact.lstg_site_id = test_category_groupings.site_id - inner JOIN edw.test_sites as test_sites - ON test_kylin_fact.lstg_site_id = test_sites.site_id - where test_kylin_fact.cal_dt < DATE '2012-10-10' AND test_kylin_fact.cal_dt > DATE '2012-01-01' - group by test_kylin_fact.lstg_format_name, test_kylin_fact.cal_dt
http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_cache/query03.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_cache/query03.sql b/query/src/test/resources/query/sql_cache/query03.sql deleted file mode 100644 index 421bde4..0000000 --- a/query/src/test/resources/query/sql_cache/query03.sql +++ /dev/null @@ -1,11 +0,0 @@ -select test_kylin_fact.lstg_format_name, test_kylin_fact.cal_dt,sum(test_kylin_fact.price) as GMV - , count(*) as TRANS_CNT - from test_kylin_fact -inner JOIN edw.test_cal_dt as test_cal_dt - ON test_kylin_fact.cal_dt = test_cal_dt.cal_dt - inner JOIN test_category_groupings - ON test_kylin_fact.leaf_categ_id = test_category_groupings.leaf_categ_id AND test_kylin_fact.lstg_site_id = test_category_groupings.site_id - inner JOIN edw.test_sites as test_sites - ON test_kylin_fact.lstg_site_id = test_sites.site_id - where test_kylin_fact.cal_dt < DATE '2013-02-10' AND test_kylin_fact.cal_dt > DATE '2012-01-01' - group by test_kylin_fact.lstg_format_name, test_kylin_fact.cal_dt http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_cache/query04.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_cache/query04.sql b/query/src/test/resources/query/sql_cache/query04.sql deleted file mode 100644 index c875e80..0000000 --- a/query/src/test/resources/query/sql_cache/query04.sql +++ /dev/null @@ -1,11 +0,0 @@ -select test_kylin_fact.lstg_format_name, test_kylin_fact.cal_dt,sum(test_kylin_fact.price) as GMV - , count(*) as TRANS_CNT - from test_kylin_fact -inner JOIN edw.test_cal_dt as test_cal_dt - ON test_kylin_fact.cal_dt = test_cal_dt.cal_dt - inner JOIN test_category_groupings - ON test_kylin_fact.leaf_categ_id = test_category_groupings.leaf_categ_id AND test_kylin_fact.lstg_site_id = test_category_groupings.site_id - inner JOIN edw.test_sites as test_sites - ON test_kylin_fact.lstg_site_id = test_sites.site_id - where test_kylin_fact.cal_dt < DATE '2013-10-10' AND test_kylin_fact.cal_dt > DATE '2012-01-01' - group by test_kylin_fact.lstg_format_name, test_kylin_fact.cal_dt http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_cache/query05.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_cache/query05.sql b/query/src/test/resources/query/sql_cache/query05.sql deleted file mode 100644 index 2b5ff24..0000000 --- a/query/src/test/resources/query/sql_cache/query05.sql +++ /dev/null @@ -1,11 +0,0 @@ -select test_kylin_fact.lstg_format_name, test_kylin_fact.cal_dt,sum(test_kylin_fact.price) as GMV - , count(*) as TRANS_CNT - from test_kylin_fact -inner JOIN edw.test_cal_dt as test_cal_dt - ON test_kylin_fact.cal_dt = test_cal_dt.cal_dt - inner JOIN test_category_groupings - ON test_kylin_fact.leaf_categ_id = test_category_groupings.leaf_categ_id AND test_kylin_fact.lstg_site_id = test_category_groupings.site_id - inner JOIN edw.test_sites as test_sites - ON test_kylin_fact.lstg_site_id = test_sites.site_id - where test_kylin_fact.cal_dt < DATE '2014-10-10' AND test_kylin_fact.cal_dt > DATE '2012-01-01' - group by test_kylin_fact.lstg_format_name, test_kylin_fact.cal_dt http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_cache/query06.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_cache/query06.sql b/query/src/test/resources/query/sql_cache/query06.sql deleted file mode 100644 index e1bee95..0000000 --- a/query/src/test/resources/query/sql_cache/query06.sql +++ /dev/null @@ -1,11 +0,0 @@ -select test_kylin_fact.lstg_format_name, test_kylin_fact.cal_dt,sum(test_kylin_fact.price) as GMV - , count(*) as TRANS_CNT - from test_kylin_fact -inner JOIN edw.test_cal_dt as test_cal_dt - ON test_kylin_fact.cal_dt = test_cal_dt.cal_dt - inner JOIN test_category_groupings - ON test_kylin_fact.leaf_categ_id = test_category_groupings.leaf_categ_id AND test_kylin_fact.lstg_site_id = test_category_groupings.site_id - inner JOIN edw.test_sites as test_sites - ON test_kylin_fact.lstg_site_id = test_sites.site_id - where test_kylin_fact.cal_dt < DATE '2013-10-10' AND test_kylin_fact.cal_dt > DATE '2013-09-10' - group by test_kylin_fact.lstg_format_name, test_kylin_fact.cal_dt http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_cache/query07.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_cache/query07.sql b/query/src/test/resources/query/sql_cache/query07.sql deleted file mode 100644 index b9e2821..0000000 --- a/query/src/test/resources/query/sql_cache/query07.sql +++ /dev/null @@ -1,11 +0,0 @@ -select test_kylin_fact.lstg_format_name, test_kylin_fact.cal_dt,sum(test_kylin_fact.price) as GMV - , count(*) as TRANS_CNT - from test_kylin_fact -inner JOIN edw.test_cal_dt as test_cal_dt - ON test_kylin_fact.cal_dt = test_cal_dt.cal_dt - inner JOIN test_category_groupings - ON test_kylin_fact.leaf_categ_id = test_category_groupings.leaf_categ_id AND test_kylin_fact.lstg_site_id = test_category_groupings.site_id - inner JOIN edw.test_sites as test_sites - ON test_kylin_fact.lstg_site_id = test_sites.site_id - where test_kylin_fact.cal_dt < DATE '2018-10-10' AND test_kylin_fact.cal_dt > DATE '2009-09-10' - group by test_kylin_fact.lstg_format_name, test_kylin_fact.cal_dt http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_cache/query08.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_cache/query08.sql b/query/src/test/resources/query/sql_cache/query08.sql deleted file mode 100644 index 308a5f3..0000000 --- a/query/src/test/resources/query/sql_cache/query08.sql +++ /dev/null @@ -1,11 +0,0 @@ -select test_kylin_fact.lstg_format_name, test_kylin_fact.cal_dt,sum(test_kylin_fact.price) as GMV - , count(*) as TRANS_CNT - from test_kylin_fact -inner JOIN edw.test_cal_dt as test_cal_dt - ON test_kylin_fact.cal_dt = test_cal_dt.cal_dt - inner JOIN test_category_groupings - ON test_kylin_fact.leaf_categ_id = test_category_groupings.leaf_categ_id AND test_kylin_fact.lstg_site_id = test_category_groupings.site_id - inner JOIN edw.test_sites as test_sites - ON test_kylin_fact.lstg_site_id = test_sites.site_id - where test_kylin_fact.cal_dt < DATE '2012-09-10' AND test_kylin_fact.cal_dt > DATE '2012-01-01' - group by test_kylin_fact.lstg_format_name, test_kylin_fact.cal_dt http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_cache/query09.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_cache/query09.sql b/query/src/test/resources/query/sql_cache/query09.sql deleted file mode 100644 index b9e2821..0000000 --- a/query/src/test/resources/query/sql_cache/query09.sql +++ /dev/null @@ -1,11 +0,0 @@ -select test_kylin_fact.lstg_format_name, test_kylin_fact.cal_dt,sum(test_kylin_fact.price) as GMV - , count(*) as TRANS_CNT - from test_kylin_fact -inner JOIN edw.test_cal_dt as test_cal_dt - ON test_kylin_fact.cal_dt = test_cal_dt.cal_dt - inner JOIN test_category_groupings - ON test_kylin_fact.leaf_categ_id = test_category_groupings.leaf_categ_id AND test_kylin_fact.lstg_site_id = test_category_groupings.site_id - inner JOIN edw.test_sites as test_sites - ON test_kylin_fact.lstg_site_id = test_sites.site_id - where test_kylin_fact.cal_dt < DATE '2018-10-10' AND test_kylin_fact.cal_dt > DATE '2009-09-10' - group by test_kylin_fact.lstg_format_name, test_kylin_fact.cal_dt http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_casewhen/query01.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_casewhen/query01.sql b/query/src/test/resources/query/sql_casewhen/query01.sql deleted file mode 100644 index ce6e81a..0000000 --- a/query/src/test/resources/query/sql_casewhen/query01.sql +++ /dev/null @@ -1,26 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -SELECT lstg_format_name -FROM test_kylin_fact -WHERE ( NOT ( ( CASE - WHEN ( lstg_format_name IS NULL ) THEN 1 - WHEN NOT ( lstg_format_name IS NULL ) THEN 0 - ELSE NULL - END ) <> 0 ) ) -GROUP BY lstg_format_name http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_casewhen/query02.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_casewhen/query02.sql b/query/src/test/resources/query/sql_casewhen/query02.sql deleted file mode 100644 index 697f423..0000000 --- a/query/src/test/resources/query/sql_casewhen/query02.sql +++ /dev/null @@ -1,22 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -SELECT "TEST_KYLIN_FACT"."LSTG_FORMAT_NAME" -FROM TEST_KYLIN_FACT -WHERE ((CASE WHEN ("TEST_KYLIN_FACT"."LSTG_FORMAT_NAME" = 'Auction') THEN 'Auction1' ELSE "TEST_KYLIN_FACT"."LSTG_FORMAT_NAME" END) = 'Auction1') -GROUP BY "TEST_KYLIN_FACT"."LSTG_FORMAT_NAME" http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_casewhen/query03.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_casewhen/query03.sql b/query/src/test/resources/query/sql_casewhen/query03.sql deleted file mode 100644 index 85c662a..0000000 --- a/query/src/test/resources/query/sql_casewhen/query03.sql +++ /dev/null @@ -1,25 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -SELECT "TEST_KYLIN_FACT"."LSTG_FORMAT_NAME" -FROM TEST_KYLIN_FACT -WHERE (CASE "TEST_KYLIN_FACT"."LSTG_FORMAT_NAME" - WHEN 'Auction' THEN '111' - WHEN 'FP-GTC' THEN '222' - ELSE '999' END) = '111' -GROUP BY "TEST_KYLIN_FACT"."LSTG_FORMAT_NAME" http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_casewhen/query55.sql.disable ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_casewhen/query55.sql.disable b/query/src/test/resources/query/sql_casewhen/query55.sql.disable deleted file mode 100644 index d29b60d..0000000 --- a/query/src/test/resources/query/sql_casewhen/query55.sql.disable +++ /dev/null @@ -1,22 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -SELECT (CASE WHEN ("TEST_KYLIN_FACT"."LSTG_FORMAT_NAME" IN ('Auction', 'FP-GTC')) THEN 'Auction' ELSE "TEST_KYLIN_FACT"."LSTG_FORMAT_NAME" END) AS "LSTG_FORMAT_NAME__group_", - SUM("TEST_KYLIN_FACT"."PRICE") AS "sum_PRICE_ok" -FROM "TEST_KYLIN_FACT" "TEST_KYLIN_FACT" -GROUP BY (CASE WHEN ("TEST_KYLIN_FACT"."LSTG_FORMAT_NAME" IN ('Auction', 'FP-GTC')) THEN 'Auction' ELSE "TEST_KYLIN_FACT"."LSTG_FORMAT_NAME" END) http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_casewhen/query56.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_casewhen/query56.sql b/query/src/test/resources/query/sql_casewhen/query56.sql deleted file mode 100644 index 7006fbf..0000000 --- a/query/src/test/resources/query/sql_casewhen/query56.sql +++ /dev/null @@ -1,22 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - - SELECT (CASE WHEN ("TEST_KYLIN_FACT"."LSTG_FORMAT_NAME" = 'Auction') THEN 'Auction2' ELSE "TEST_KYLIN_FACT"."LSTG_FORMAT_NAME" END) AS "LSTG_FORMAT_NAME__group_", - SUM("TEST_KYLIN_FACT"."PRICE") AS "sum_PRICE_ok" -FROM "TEST_KYLIN_FACT" "TEST_KYLIN_FACT" -GROUP BY (CASE WHEN ("TEST_KYLIN_FACT"."LSTG_FORMAT_NAME" = 'Auction') THEN 'Auction2' ELSE "TEST_KYLIN_FACT"."LSTG_FORMAT_NAME" END) http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_derived/query01.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_derived/query01.sql b/query/src/test/resources/query/sql_derived/query01.sql deleted file mode 100644 index c4b0aae..0000000 --- a/query/src/test/resources/query/sql_derived/query01.sql +++ /dev/null @@ -1,47 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -SELECT - test_kylin_fact.seller_id - ,test_cal_dt.week_beg_dt - ,test_category_groupings.meta_categ_name - ,test_category_groupings.categ_lvl2_name - ,test_category_groupings.categ_lvl3_name - ,test_kylin_fact.lstg_format_name - ,test_sites.site_name - ,test_sites.site_id - ,test_sites.cre_user - ,sum(test_kylin_fact.price) as GMV, count(*) as TRANS_CNT - FROM test_kylin_fact - inner JOIN edw.test_cal_dt as test_cal_dt - ON test_kylin_fact.cal_dt = test_cal_dt.cal_dt - inner JOIN test_category_groupings - ON test_kylin_fact.leaf_categ_id = test_category_groupings.leaf_categ_id AND test_kylin_fact.lstg_site_id = test_category_groupings.site_id - inner JOIN edw.test_sites as test_sites - ON test_kylin_fact.lstg_site_id = test_sites.site_id - where test_kylin_fact.seller_id = 10000002 - group by - test_kylin_fact.seller_id - ,test_cal_dt.week_beg_dt - ,test_category_groupings.meta_categ_name - ,test_category_groupings.categ_lvl2_name - ,test_category_groupings.categ_lvl3_name - ,test_kylin_fact.lstg_format_name - ,test_sites.site_name - ,test_sites.site_id - ,test_sites.cre_user http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_derived/query02.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_derived/query02.sql b/query/src/test/resources/query/sql_derived/query02.sql deleted file mode 100644 index 027cd9c..0000000 --- a/query/src/test/resources/query/sql_derived/query02.sql +++ /dev/null @@ -1,47 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -SELECT - test_kylin_fact.seller_id - ,test_cal_dt.week_beg_dt - ,test_category_groupings.meta_categ_name - ,test_category_groupings.categ_lvl2_name - ,test_category_groupings.categ_lvl3_name - ,test_kylin_fact.lstg_format_name - ,test_sites.site_name - ,test_sites.site_id - ,test_sites.cre_user - ,sum(test_kylin_fact.price) as GMV, count(*) as TRANS_CNT - FROM test_kylin_fact - inner JOIN edw.test_cal_dt as test_cal_dt - ON test_kylin_fact.cal_dt = test_cal_dt.cal_dt - inner JOIN test_category_groupings - ON test_kylin_fact.leaf_categ_id = test_category_groupings.leaf_categ_id AND test_kylin_fact.lstg_site_id = test_category_groupings.site_id - inner JOIN edw.test_sites as test_sites - ON test_kylin_fact.lstg_site_id = test_sites.site_id - where test_kylin_fact.seller_id = 10000002 and test_sites.site_id=0 - group by - test_kylin_fact.seller_id - ,test_cal_dt.week_beg_dt - ,test_category_groupings.meta_categ_name - ,test_category_groupings.categ_lvl2_name - ,test_category_groupings.categ_lvl3_name - ,test_kylin_fact.lstg_format_name - ,test_sites.site_name - ,test_sites.site_id - ,test_sites.cre_user http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_derived/query03.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_derived/query03.sql b/query/src/test/resources/query/sql_derived/query03.sql deleted file mode 100644 index 35736b9..0000000 --- a/query/src/test/resources/query/sql_derived/query03.sql +++ /dev/null @@ -1,21 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -SELECT distinct LSTG_FORMAT_NAME from test_kylin_fact - - http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_derived/query04.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_derived/query04.sql b/query/src/test/resources/query/sql_derived/query04.sql deleted file mode 100644 index dab5d0f..0000000 --- a/query/src/test/resources/query/sql_derived/query04.sql +++ /dev/null @@ -1,20 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -SELECT site_id, site_name, cre_user from edw.test_sites - http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_derived/query05.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_derived/query05.sql b/query/src/test/resources/query/sql_derived/query05.sql deleted file mode 100644 index 61a9b2c..0000000 --- a/query/src/test/resources/query/sql_derived/query05.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -SELECT test_sites.site_name, test_kylin_fact.lstg_format_name, sum(test_kylin_fact.price) as GMV, count(*) as TRANS_CNT - FROM test_kylin_fact -inner JOIN edw.test_cal_dt as test_cal_dt - ON test_kylin_fact.cal_dt = test_cal_dt.cal_dt - inner JOIN test_category_groupings - ON test_kylin_fact.leaf_categ_id = test_category_groupings.leaf_categ_id AND test_kylin_fact.lstg_site_id = test_category_groupings.site_id - inner JOIN edw.test_sites as test_sites - ON test_kylin_fact.lstg_site_id = test_sites.site_id - GROUP BY - test_sites.site_name, test_kylin_fact.lstg_format_name http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_derived/query06.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_derived/query06.sql b/query/src/test/resources/query/sql_derived/query06.sql deleted file mode 100644 index 0ea32b2..0000000 --- a/query/src/test/resources/query/sql_derived/query06.sql +++ /dev/null @@ -1,20 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -SELECT distinct cal_dt from test_kylin_fact - http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_derived/query07.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_derived/query07.sql b/query/src/test/resources/query/sql_derived/query07.sql deleted file mode 100644 index a27fbd1..0000000 --- a/query/src/test/resources/query/sql_derived/query07.sql +++ /dev/null @@ -1,22 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -select cal_dt, lstg_format_name, sum(price) as GMV - from test_kylin_fact - where cal_dt=date '2013-05-06' - group by cal_dt, lstg_format_name http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_derived/query08.sql.disabled ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_derived/query08.sql.disabled b/query/src/test/resources/query/sql_derived/query08.sql.disabled deleted file mode 100644 index c4e7d0c..0000000 --- a/query/src/test/resources/query/sql_derived/query08.sql.disabled +++ /dev/null @@ -1,19 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -select distinct leaf_categ_id, lstg_site_id from test_kylin_fact http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_derived/query09.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_derived/query09.sql b/query/src/test/resources/query/sql_derived/query09.sql deleted file mode 100644 index c0aacef..0000000 --- a/query/src/test/resources/query/sql_derived/query09.sql +++ /dev/null @@ -1,19 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -select distinct leaf_categ_id, site_id from test_category_groupings http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_derived/query10.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_derived/query10.sql b/query/src/test/resources/query/sql_derived/query10.sql deleted file mode 100644 index dd29659..0000000 --- a/query/src/test/resources/query/sql_derived/query10.sql +++ /dev/null @@ -1,44 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -SELECT - test_cal_dt.week_beg_dt - ,test_category_groupings.meta_categ_name - ,test_category_groupings.upd_user - ,test_category_groupings.upd_date - ,test_kylin_fact.leaf_categ_id - ,test_category_groupings.leaf_categ_id - ,test_kylin_fact.lstg_site_id - ,test_category_groupings.site_id - ,sum(price) as GMV, count(*) as TRANS_CNT - FROM test_kylin_fact - inner JOIN edw.test_cal_dt as test_cal_dt - ON test_kylin_fact.cal_dt = test_cal_dt.cal_dt - inner JOIN test_category_groupings - ON test_kylin_fact.leaf_categ_id = test_category_groupings.leaf_categ_id - AND test_kylin_fact.lstg_site_id = test_category_groupings.site_id - where - test_category_groupings.upd_date='2012-09-11 20:26:04' - group by test_cal_dt.week_beg_dt - ,test_category_groupings.meta_categ_name - ,test_category_groupings.upd_user - ,test_category_groupings.upd_date - ,test_kylin_fact.leaf_categ_id - ,test_category_groupings.leaf_categ_id - ,test_kylin_fact.lstg_site_id - ,test_category_groupings.site_id http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_distinct/query00.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_distinct/query00.sql b/query/src/test/resources/query/sql_distinct/query00.sql deleted file mode 100644 index 03a2ada..0000000 --- a/query/src/test/resources/query/sql_distinct/query00.sql +++ /dev/null @@ -1,24 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -select lstg_format_name, cal_dt, - sum(price) as GMV, - count(1) as TRANS_CNT, - count(distinct seller_id) as DIST_SELLER - from test_kylin_fact - group by lstg_format_name, cal_dt http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_distinct/query01.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_distinct/query01.sql b/query/src/test/resources/query/sql_distinct/query01.sql deleted file mode 100644 index 9f92497..0000000 --- a/query/src/test/resources/query/sql_distinct/query01.sql +++ /dev/null @@ -1,25 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -select lstg_format_name, - sum(price) as GMV, - count(1) as TRANS_CNT, - count(distinct seller_id) as DIST_SELLER - from test_kylin_fact - where lstg_format_name='FP-GTC' - group by lstg_format_name http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_distinct/query02.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_distinct/query02.sql b/query/src/test/resources/query/sql_distinct/query02.sql deleted file mode 100644 index a903bf3..0000000 --- a/query/src/test/resources/query/sql_distinct/query02.sql +++ /dev/null @@ -1,26 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -select lstg_format_name, - sum(price) as GMV, - count(1) as TRANS_CNT, - count(distinct seller_id) as DIST_SELLER - from test_kylin_fact - where lstg_format_name='FP-GTC' - group by lstg_format_name - having count(distinct seller_id) > 50 http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_distinct/query03.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_distinct/query03.sql b/query/src/test/resources/query/sql_distinct/query03.sql deleted file mode 100644 index 61ab376..0000000 --- a/query/src/test/resources/query/sql_distinct/query03.sql +++ /dev/null @@ -1,26 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -select test_cal_dt.week_beg_dt,sum(test_kylin_fact.price) as GMV - , count(1) as TRANS_CNT, count(distinct seller_id) as DIST_SELLER - from test_kylin_fact - inner JOIN edw.test_cal_dt as test_cal_dt - ON test_kylin_fact.cal_dt = test_cal_dt.cal_dt - where test_kylin_fact.lstg_format_name='FP-GTC' - and test_cal_dt.week_beg_dt between DATE '2013-05-01' and DATE '2013-08-01' - group by test_cal_dt.week_beg_dt http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_distinct/query04.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_distinct/query04.sql b/query/src/test/resources/query/sql_distinct/query04.sql deleted file mode 100644 index cb118fa..0000000 --- a/query/src/test/resources/query/sql_distinct/query04.sql +++ /dev/null @@ -1,27 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -select test_cal_dt.week_beg_dt,sum(test_kylin_fact.price) as GMV - , count(1) as TRANS_CNT, count(distinct seller_id) as DIST_SELLER - from test_kylin_fact - inner JOIN edw.test_cal_dt as test_cal_dt - ON test_kylin_fact.cal_dt = test_cal_dt.cal_dt - where test_kylin_fact.lstg_format_name='FP-GTC' - and test_cal_dt.week_beg_dt between DATE '2013-05-01' and DATE '2013-08-01' - group by test_cal_dt.week_beg_dt - having count(distinct seller_id) > 2 http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_distinct/query05.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_distinct/query05.sql b/query/src/test/resources/query/sql_distinct/query05.sql deleted file mode 100644 index cee8ef4..0000000 --- a/query/src/test/resources/query/sql_distinct/query05.sql +++ /dev/null @@ -1,25 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -select lstg_format_name, - sum(price) as GMV, - count(1) as TRANS_CNT, - count(distinct seller_id) as DIST_SELLER - from test_kylin_fact - group by lstg_format_name - order by lstg_format_name http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_distinct/query06.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_distinct/query06.sql b/query/src/test/resources/query/sql_distinct/query06.sql deleted file mode 100644 index 4a46048..0000000 --- a/query/src/test/resources/query/sql_distinct/query06.sql +++ /dev/null @@ -1,26 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -select lstg_format_name, - sum(price) as GMV, - count(1) as TRANS_CNT, - count(distinct seller_id) as DIST_SELLER - from test_kylin_fact - where lstg_format_name='FP-GTC' - group by lstg_format_name - order by lstg_format_name http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_distinct/query07.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_distinct/query07.sql b/query/src/test/resources/query/sql_distinct/query07.sql deleted file mode 100644 index b76cdc8..0000000 --- a/query/src/test/resources/query/sql_distinct/query07.sql +++ /dev/null @@ -1,24 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -select lstg_format_name, - sum(price) as GMV, - count(1) as TRANS_CNT, - count(distinct seller_id) as DIST_SELLER - from test_kylin_fact - group by lstg_format_name http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_dynamic/query01.dat ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_dynamic/query01.dat b/query/src/test/resources/query/sql_dynamic/query01.dat deleted file mode 100644 index a72c741..0000000 --- a/query/src/test/resources/query/sql_dynamic/query01.dat +++ /dev/null @@ -1,2 +0,0 @@ -FP-GTC -Collectibles http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_dynamic/query01.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_dynamic/query01.sql b/query/src/test/resources/query/sql_dynamic/query01.sql deleted file mode 100644 index d777fdf..0000000 --- a/query/src/test/resources/query/sql_dynamic/query01.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -select test_cal_dt.week_beg_dt, test_kylin_fact.lstg_format_name, test_category_groupings.meta_categ_name, sum(test_kylin_fact.price) as gmv, count(*) as trans_cnt - from test_kylin_fact - inner JOIN edw.test_cal_dt as test_cal_dt - ON test_kylin_fact.cal_dt = test_cal_dt.cal_dt - inner JOIN test_category_groupings - ON test_kylin_fact.leaf_categ_id = test_category_groupings.leaf_categ_id AND test_kylin_fact.lstg_site_id = test_category_groupings.site_id - where test_kylin_fact.lstg_format_name = ? - and test_category_groupings.meta_categ_name = ? - and test_cal_dt.week_beg_dt between DATE '2013-05-01' and DATE '2013-10-01' - group by test_cal_dt.week_beg_dt, test_kylin_fact.lstg_format_name, test_category_groupings.meta_categ_name http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_dynamic/query02.dat ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_dynamic/query02.dat b/query/src/test/resources/query/sql_dynamic/query02.dat deleted file mode 100644 index a72c741..0000000 --- a/query/src/test/resources/query/sql_dynamic/query02.dat +++ /dev/null @@ -1,2 +0,0 @@ -FP-GTC -Collectibles http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_dynamic/query02.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_dynamic/query02.sql b/query/src/test/resources/query/sql_dynamic/query02.sql deleted file mode 100644 index eaeccdd..0000000 --- a/query/src/test/resources/query/sql_dynamic/query02.sql +++ /dev/null @@ -1,30 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -select sum(1) as "col" from ( - select test_cal_dt.week_beg_dt, test_kylin_fact.lstg_format_name, test_category_groupings.meta_categ_name, sum(test_kylin_fact.price) as gmv, count(*) as trans_cnt - from test_kylin_fact - inner JOIN edw.test_cal_dt as test_cal_dt - ON test_kylin_fact.cal_dt = test_cal_dt.cal_dt - inner JOIN test_category_groupings - ON test_kylin_fact.leaf_categ_id = test_category_groupings.leaf_categ_id AND test_kylin_fact.lstg_site_id = test_category_groupings.site_id - where test_kylin_fact.lstg_format_name = ? - and test_category_groupings.meta_categ_name = ? - and test_cal_dt.week_beg_dt between DATE '2013-05-01' and DATE '2013-10-01' - group by test_cal_dt.week_beg_dt, test_kylin_fact.lstg_format_name, test_category_groupings.meta_categ_name - ) "tableausql" having count(1)>0 http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_fast_common/query00.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_fast_common/query00.sql b/query/src/test/resources/query/sql_fast_common/query00.sql deleted file mode 100644 index 36249a8..0000000 --- a/query/src/test/resources/query/sql_fast_common/query00.sql +++ /dev/null @@ -1,23 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -select lstg_format_name, cal_dt, - sum(price) as GMV, - count(1) as TRANS_CNT - from test_kylin_fact - group by lstg_format_name, cal_dt http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_hive/query01.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_hive/query01.sql b/query/src/test/resources/query/sql_hive/query01.sql deleted file mode 100644 index 34b81e2..0000000 --- a/query/src/test/resources/query/sql_hive/query01.sql +++ /dev/null @@ -1,20 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -select cal_dt, sum(price)as GMV, count(1) as trans_cnt from test_kylin_fact - group by cal_dt http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_hive/query10.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_hive/query10.sql b/query/src/test/resources/query/sql_hive/query10.sql deleted file mode 100644 index ca77a41..0000000 --- a/query/src/test/resources/query/sql_hive/query10.sql +++ /dev/null @@ -1,26 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -select test_cal_dt.QTR_BEG_DT,sum(test_kylin_fact.price) as gmv - , count(*) as trans_cnt - from test_kylin_fact - inner JOIN edw.test_cal_dt as test_cal_dt - ON test_kylin_fact.cal_dt = test_cal_dt.cal_dt - where test_kylin_fact.lstg_format_name='FP-GTC' - and test_cal_dt.week_beg_dt between '2013-05-01' and '2013-08-01' - group by test_cal_dt.QTR_BEG_DT http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_ii/query01.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_ii/query01.sql b/query/src/test/resources/query/sql_ii/query01.sql deleted file mode 100644 index be187f5..0000000 --- a/query/src/test/resources/query/sql_ii/query01.sql +++ /dev/null @@ -1,19 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -select count(*) as all_count from test_kylin_fact http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_ii/query02.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_ii/query02.sql b/query/src/test/resources/query/sql_ii/query02.sql deleted file mode 100644 index eb52d11..0000000 --- a/query/src/test/resources/query/sql_ii/query02.sql +++ /dev/null @@ -1,19 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -select sum(price) as price_sum, min(price) as price_min, max(price) as price_max from test_kylin_fact http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_ii/query03.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_ii/query03.sql b/query/src/test/resources/query/sql_ii/query03.sql deleted file mode 100644 index d20efec..0000000 --- a/query/src/test/resources/query/sql_ii/query03.sql +++ /dev/null @@ -1,19 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -select sum(price) as price_sum, min(price) as price_min , max(price) as price_max , LSTG_FORMAT_NAME from test_kylin_fact group by LSTG_FORMAT_NAME http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_ii/query04.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_ii/query04.sql b/query/src/test/resources/query/sql_ii/query04.sql deleted file mode 100644 index 4a75fba..0000000 --- a/query/src/test/resources/query/sql_ii/query04.sql +++ /dev/null @@ -1,19 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -select TRANS_ID,CAL_DT,LSTG_FORMAT_NAME,LEAF_CATEG_ID,LSTG_SITE_ID,SLR_SEGMENT_CD,PRICE,SELLER_ID from test_kylin_fact where LSTG_FORMAT_NAME = 'ABIN' http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_ii/query05.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_ii/query05.sql b/query/src/test/resources/query/sql_ii/query05.sql deleted file mode 100644 index 4043a2c..0000000 --- a/query/src/test/resources/query/sql_ii/query05.sql +++ /dev/null @@ -1,19 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -select sum(price) as price_sum, min(price) as price_min , max(price) as price_max , SELLER_ID from test_kylin_fact where SELLER_ID > 10000149 group by SELLER_ID http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_ii/query06.sql.disabled ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_ii/query06.sql.disabled b/query/src/test/resources/query/sql_ii/query06.sql.disabled deleted file mode 100644 index f97f440..0000000 --- a/query/src/test/resources/query/sql_ii/query06.sql.disabled +++ /dev/null @@ -1,19 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -select price from test_kylin_fact where price > 50 http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_ii/query07.sql.disabled ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_ii/query07.sql.disabled b/query/src/test/resources/query/sql_ii/query07.sql.disabled deleted file mode 100644 index 0471a47..0000000 --- a/query/src/test/resources/query/sql_ii/query07.sql.disabled +++ /dev/null @@ -1,19 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -select sum(price) as price_sum, min(price) as price_min , max(price) as price_max , LSTG_FORMAT_NAME from test_kylin_fact where price > 50 group by LSTG_FORMAT_NAME http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_ii/query08.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_ii/query08.sql b/query/src/test/resources/query/sql_ii/query08.sql deleted file mode 100644 index 51a676d..0000000 --- a/query/src/test/resources/query/sql_ii/query08.sql +++ /dev/null @@ -1,19 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -select TRANS_ID,CAL_DT,LSTG_FORMAT_NAME,LEAF_CATEG_ID,LSTG_SITE_ID,SLR_SEGMENT_CD,PRICE,SELLER_ID from test_kylin_fact where LSTG_FORMAT_NAME > 'ABIN' http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_ii/query09.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_ii/query09.sql b/query/src/test/resources/query/sql_ii/query09.sql deleted file mode 100644 index 1562288..0000000 --- a/query/src/test/resources/query/sql_ii/query09.sql +++ /dev/null @@ -1,19 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -select price, SELLER_ID from test_kylin_fact where SELLER_ID > 10000149 http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_invalid/query29_invalid_SQL.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_invalid/query29_invalid_SQL.sql b/query/src/test/resources/query/sql_invalid/query29_invalid_SQL.sql deleted file mode 100644 index 7d2b1b5..0000000 --- a/query/src/test/resources/query/sql_invalid/query29_invalid_SQL.sql +++ /dev/null @@ -1,55 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -SELECT - test_cal_dt.week_beg_dt_test - ,test_cal_dt.retail_year - ,test_cal_dt.rtl_month_of_rtl_year_id - ,test_cal_dt.retail_week - ,test_category_groupings.meta_categ_name - ,test_category_groupings.categ_lvl2_name - ,test_category_groupings.categ_lvl3_name - ,test_kylin_fact.lstg_format_name - ,test_sites.site_name - ,test_seller_type_dim.seller_type_desc - ,sum(test_kylin_fact.price) as gmv - , count(*) as trans_cnt - FROM test_kylin_fact - inner JOIN test_cal_dt - ON test_kylin_fact.cal_dt = test_cal_dt.cal_dt - inner JOIN test_category_groupings - ON test_kylin_fact.leaf_categ_id = test_category_groupings.leaf_categ_id AND test_kylin_fact.lstg_site_id = test_category_groupings.site_id - inner JOIN edw.test_sites as test_sites - ON test_kylin_fact.lstg_site_id = test_sites.site_id - inner JOIN test_seller_type_dim - ON test_kylin_fact.slr_segment_cd = test_seller_type_dim.seller_type_cd - where test_cal_dt.retail_year='2013' - and retail_week in(1,2,3,4,5,6,7,7,7) - and (test_category_groupings.meta_categ_name='Collectibles' or test_category_groupings.categ_lvl3_name='Dresses') - and test_sites.site_name='Ebay' - and test_cal_dt.retail_year not in ('2014') - group by test_cal_dt.week_beg_dt - ,test_cal_dt.retail_year - ,test_cal_dt.rtl_month_of_rtl_year_id - ,test_cal_dt.retail_week - ,test_category_groupings.meta_categ_name - ,test_category_groupings.categ_lvl2_name - ,test_category_groupings.categ_lvl3_name - ,test_kylin_fact.lstg_format_name - ,test_sites.site_name - ,test_seller_type_dim.seller_type_desc http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_invalid/query30_invalid_SQL.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_invalid/query30_invalid_SQL.sql b/query/src/test/resources/query/sql_invalid/query30_invalid_SQL.sql deleted file mode 100644 index 229d198..0000000 --- a/query/src/test/resources/query/sql_invalid/query30_invalid_SQL.sql +++ /dev/null @@ -1,54 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -SELECT - test_cal_dt.week_beg_dt_test - ,test_cal_dt.retail_year - ,test_cal_dt.rtl_month_of_rtl_year_id - ,test_cal_dt.retail_week - ,test_category_groupings.meta_categ_name - ,test_category_groupings.categ_lvl2_name - ,test_category_groupings.categ_lvl3_name - ,test_kylin_fact.lstg_format_name - ,test_sites.site_name - ,test_seller_type_dim.seller_type_desc - ,sum(test_kylin_fact.price) as gmv - , count(*) as trans_cnt - FROM test_kylin_fact - inner JOIN test_cal_dt - ON test_kylin_fact.cal_dt = test_cal_dt.cal_dt - inner JOIN test_category_groupings - ON test_kylin_fact.leaf_categ_id = test_category_groupings.leaf_categ_id AND test_kylin_fact.lstg_site_id = test_category_groupings.site_id - inner JOIN test_sites - ON test_kylin_fact.lstg_site_id = test_sites.site_id - inner JOIN test_seller_type_dim - ON test_kylin_fact.slr_segment_cd = test_seller_type_dim.seller_type_cd - where test_cal_dt.retail_year='2013' - and retail_week in(1,2,3,4,5,6,7,7,7) - and (test_category_groupings.meta_categ_name='Collectibles' or test_category_groupings.categ_lvl3_name='Dresses') - and test_sites.site_name='Ebay' - and test_cal_dt.retail_year not in ('2014') - group by test_cal_dt.week_beg_dt - ,test_cal_dt.retail_year - ,test_cal_dt.rtl_month_of_rtl_year_id - ,test_cal_dt.retail_week - ,test_category_groupings.meta_categ_name - ,test_category_groupings.categ_lvl2_name - ,test_category_groupings.categ_lvl3_name - ,test_kylin_fact.lstg_format_name - ,test_sites.site_name http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_invalid/query31_invalid_SQL.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_invalid/query31_invalid_SQL.sql b/query/src/test/resources/query/sql_invalid/query31_invalid_SQL.sql deleted file mode 100644 index 8fac5a6..0000000 --- a/query/src/test/resources/query/sql_invalid/query31_invalid_SQL.sql +++ /dev/null @@ -1,55 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -SELECT - test_cal_dt.week_beg_dt_test - ,test_cal_dt.retail_year - ,test_cal_dt.rtl_month_of_rtl_year_id - ,test_cal_dt.retail_week - ,test_category_groupings.meta_categ_name - ,test_category_groupings.categ_lvl2_name - ,test_category_groupings.categ_lvl3_name - ,test_kylin_fact.lstg_format_name - ,test_sites.site_name - ,test_seller_type_dim.seller_type_desc - ,sum(test_kylin_fact.price_amt) as gmv - , count(*) as trans_cnt - FROM test_kylin_fact - inner JOIN test_cal_dt - ON test_kylin_fact.cal_dt = test_cal_dt.cal_dt - inner JOIN test_category_groupings - ON test_kylin_fact.leaf_categ_id = test_category_groupings.leaf_categ_id AND test_kylin_fact.lstg_site_id = test_category_groupings.site_id - inner JOIN test_sites - ON test_kylin_fact.lstg_site_id = test_sites.site_id - inner JOIN test_seller_type_dim - ON test_kylin_fact.slr_segment_cd = test_seller_type_dim.seller_type_cd - where test_cal_dt.retail_year='2013' - and retail_week in(1,2,3,4,5,6,7,7,7) - and (test_category_groupings.meta_categ_name='Collectibles' or test_category_groupings.categ_lvl3_name='Dresses') - and test_sites.site_name='Ebay' - and test_cal_dt.retail_year not in ('2014') - group by test_cal_dt.week_beg_dt - ,test_cal_dt.retail_year - ,test_cal_dt.rtl_month_of_rtl_year_id - ,test_cal_dt.retail_week - ,test_category_groupings.meta_categ_name - ,test_category_groupings.categ_lvl2_name - ,test_category_groupings.categ_lvl3_name - ,test_kylin_fact.lstg_format_name - ,test_sites.site_name - ,test_seller_type_dim.seller_type_desc http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_invalid/query32_invalid_SQL.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_invalid/query32_invalid_SQL.sql b/query/src/test/resources/query/sql_invalid/query32_invalid_SQL.sql deleted file mode 100644 index 40b82d8..0000000 --- a/query/src/test/resources/query/sql_invalid/query32_invalid_SQL.sql +++ /dev/null @@ -1,56 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -SELECT - test_cal_dt.week_beg_dt_test - ,test_cal_dt.retail_year - ,test_cal_dt.rtl_month_of_rtl_year_id - ,test_cal_dt.retail_week - ,test_category_groupings.meta_categ_name - ,test_category_groupings.categ_lvl2_name - ,test_category_groupings.categ_lvl3_name - ,test_kylin_fact.lstg_format_name - ,test_sites.site_name - ,test_seller_type_dim.seller_type_desc - ,sum(test_kylin_fact.price) as gmv - , count(*) as trans_cnt - FROM test_kylin_fact - inner JOIN test_cal_dt - ON test_kylin_fact.cal_dt = test_cal_dt.cal_dt - inner JOIN test_category_groupings - ON test_kylin_fact.leaf_categ_id = test_category_groupings.leaf_categ_id AND test_kylin_fact.lstg_site_id = test_category_groupings.site_id - inner JOIN test_sites - ON test_kylin_fact.lstg_site_id = test_sites.site_id - inner JOIN test_seller_type_dim - ON test_kylin_fact.slr_segment_cd = test_seller_type_dim.seller_type_cd - where test_cal_dt.retail_year='2013' - and retail_week in(1,2,3,4,5,6,7,7,7) - and (test_category_groupings.meta_categ_name='Collectibles' or test_category_groupings.categ_lvl3_name='Dresses') - and test_sites.site_name='Ebay' - and test_cal_dt.retail_year not in ('2014') - and test_kylin_fact.price<100 - group by test_cal_dt.week_beg_dt - ,test_cal_dt.retail_year - ,test_cal_dt.rtl_month_of_rtl_year_id - ,test_cal_dt.retail_week - ,test_category_groupings.meta_categ_name - ,test_category_groupings.categ_lvl2_name - ,test_category_groupings.categ_lvl3_name - ,test_kylin_fact.lstg_format_name - ,test_sites.site_name - ,test_seller_type_dim.seller_type_desc http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_invalid/query33_invalid_SQL.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_invalid/query33_invalid_SQL.sql b/query/src/test/resources/query/sql_invalid/query33_invalid_SQL.sql deleted file mode 100644 index d18dbcc..0000000 --- a/query/src/test/resources/query/sql_invalid/query33_invalid_SQL.sql +++ /dev/null @@ -1,56 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -SELECT - test_cal_dt.week_beg_dt_test - ,test_cal_dt.retail_year - ,test_cal_dt.rtl_month_of_rtl_year_id - ,test_cal_dt.retail_week - ,test_category_groupings.meta_categ_name - ,test_category_groupings.categ_lvl2_name - ,test_category_groupings.categ_lvl3_name - ,test_kylin_fact.lstg_format_name - ,test_sites.site_name - ,test_seller_type_dim.seller_type_desc - ,sum(test_kylin_fact.price) as gmv - , count(*) as trans_cnt - FROM test_kylin_fact - inner JOIN test_cal_dt - ON test_kylin_fact.cal_dt = test_cal_dt.cal_dt - inner JOIN test_category_groupings - ON test_kylin_fact.leaf_categ_id = test_category_groupings.leaf_categ_id AND test_kylin_fact.lstg_site_id = test_category_groupings.site_id - inner JOIN test_sites - ON test_kylin_fact.lstg_site_id = test_sites.site_id - inner JOIN test_seller_type_dim - ON test_kylin_fact.slr_segment_cd = test_seller_type_dim.seller_type_cd - where test_cal_dt.retail_year='2013' - and retail_week in(1,2,3,4,5,6,7,7,7) - and (test_category_groupings.meta_categ_name='Collectibles' or test_category_groupings.categ_lvl3_name='Dresses') - and test_sites.site_name='Ebay' - and test_cal_dt.retail_year not in ('2014') - and test_kylin_fact.trans_id=1000000001 - group by test_cal_dt.week_beg_dt - ,test_cal_dt.retail_year - ,test_cal_dt.rtl_month_of_rtl_year_id - ,test_cal_dt.retail_week - ,test_category_groupings.meta_categ_name - ,test_category_groupings.categ_lvl2_name - ,test_category_groupings.categ_lvl3_name - ,test_kylin_fact.lstg_format_name - ,test_sites.site_name - ,test_seller_type_dim.seller_type_desc http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_invalid/query34_invalid_SQL.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_invalid/query34_invalid_SQL.sql b/query/src/test/resources/query/sql_invalid/query34_invalid_SQL.sql deleted file mode 100644 index 4308735..0000000 --- a/query/src/test/resources/query/sql_invalid/query34_invalid_SQL.sql +++ /dev/null @@ -1,24 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -SELECT COUNT(DISTINCT "TableauSQL"."TRANS_CNT") AS "ctd_TRANS_CNT_qk", "TableauSQL"."LSTG_FORMAT_NAME" AS "none_LSTG_FORMAT_NAME_nk" - FROM ( select test_kylin_fact.lstg_format_name, sum(price) as GMV, count(seller_id) as TRANS_CNT - from test_kylin_fact - group by test_kylin_fact.lstg_format_name - ) "TableauSQL" - GROUP BY "TableauSQL"."LSTG_FORMAT_NAME" http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_invalid/query_count_distinct_on_dimension.sql.disabled ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_invalid/query_count_distinct_on_dimension.sql.disabled b/query/src/test/resources/query/sql_invalid/query_count_distinct_on_dimension.sql.disabled deleted file mode 100644 index 63d83b5..0000000 --- a/query/src/test/resources/query/sql_invalid/query_count_distinct_on_dimension.sql.disabled +++ /dev/null @@ -1,20 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -##dd -select count(distinct cal_dt) from test_kylin_fact http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_lookup/query01.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_lookup/query01.sql b/query/src/test/resources/query/sql_lookup/query01.sql deleted file mode 100644 index eb08c01..0000000 --- a/query/src/test/resources/query/sql_lookup/query01.sql +++ /dev/null @@ -1,24 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -select CAL_DT, WEEK_BEG_DT from edw.test_cal_dt - - - - - http://git-wip-us.apache.org/repos/asf/kylin/blob/59943fee/query/src/test/resources/query/sql_lookup/query02.sql ---------------------------------------------------------------------- diff --git a/query/src/test/resources/query/sql_lookup/query02.sql b/query/src/test/resources/query/sql_lookup/query02.sql deleted file mode 100644 index b667519..0000000 --- a/query/src/test/resources/query/sql_lookup/query02.sql +++ /dev/null @@ -1,19 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -select CATEG_LVL3_NAME, CATEG_LVL2_NAME, SITE_ID, META_CATEG_NAME, LEAF_CATEG_ID from test_category_groupings