minor, add license header on some query test cases
Project: http://git-wip-us.apache.org/repos/asf/kylin/repo Commit: http://git-wip-us.apache.org/repos/asf/kylin/commit/3b74cea8 Tree: http://git-wip-us.apache.org/repos/asf/kylin/tree/3b74cea8 Diff: http://git-wip-us.apache.org/repos/asf/kylin/diff/3b74cea8 Branch: refs/heads/master Commit: 3b74cea8e610c021240983d68e2ba3e1326e64f0 Parents: 6dbb840 Author: Li Yang <liy...@apache.org> Authored: Wed Sep 27 15:09:31 2017 +0800 Committer: æ <cheng.w...@kyligence.io> Committed: Thu Sep 28 11:08:38 2017 +0800 ---------------------------------------------------------------------- .../test/resources/query/sql_subquery/query17.sql | 18 ++++++++++++++++++ .../test/resources/query/sql_subquery/query18.sql | 18 ++++++++++++++++++ .../test/resources/query/sql_subquery/query19.sql | 18 ++++++++++++++++++ .../test/resources/query/sql_subquery/query21.sql | 18 ++++++++++++++++++ .../test/resources/query/sql_subquery/query22.sql | 18 ++++++++++++++++++ .../test/resources/query/sql_subquery/query23.sql | 18 ++++++++++++++++++ .../test/resources/query/sql_subquery/query24.sql | 18 ++++++++++++++++++ .../test/resources/query/sql_subquery/query25.sql | 18 ++++++++++++++++++ .../test/resources/query/sql_subquery/query26.sql | 18 ++++++++++++++++++ .../test/resources/query/sql_subquery/query27.sql | 18 ++++++++++++++++++ .../test/resources/query/sql_subquery/query28.sql | 18 ++++++++++++++++++ .../resources/query/sql_subquery/query29.sql.todo | 18 ++++++++++++++++++ .../test/resources/query/sql_subquery/query30.sql | 18 ++++++++++++++++++ .../test/resources/query/sql_subquery/query31.sql | 18 ++++++++++++++++++ .../test/resources/query/sql_subquery/query32.sql | 18 ++++++++++++++++++ .../test/resources/query/sql_subquery/query33.sql | 18 ++++++++++++++++++ .../test/resources/query/sql_subquery/query34.sql | 18 ++++++++++++++++++ 17 files changed, 306 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/kylin/blob/3b74cea8/kylin-it/src/test/resources/query/sql_subquery/query17.sql ---------------------------------------------------------------------- diff --git a/kylin-it/src/test/resources/query/sql_subquery/query17.sql b/kylin-it/src/test/resources/query/sql_subquery/query17.sql index c5833b0..001bfa0 100644 --- a/kylin-it/src/test/resources/query/sql_subquery/query17.sql +++ b/kylin-it/src/test/resources/query/sql_subquery/query17.sql @@ -1,3 +1,21 @@ +-- +-- 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,sum(test_kylin_fact.price) as GMV , count(*) as TRANS_CNT http://git-wip-us.apache.org/repos/asf/kylin/blob/3b74cea8/kylin-it/src/test/resources/query/sql_subquery/query18.sql ---------------------------------------------------------------------- diff --git a/kylin-it/src/test/resources/query/sql_subquery/query18.sql b/kylin-it/src/test/resources/query/sql_subquery/query18.sql index 57bb895..99d5aa9 100644 --- a/kylin-it/src/test/resources/query/sql_subquery/query18.sql +++ b/kylin-it/src/test/resources/query/sql_subquery/query18.sql @@ -1,3 +1,21 @@ +-- +-- 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, sum(test_kylin_fact.price) as GMV http://git-wip-us.apache.org/repos/asf/kylin/blob/3b74cea8/kylin-it/src/test/resources/query/sql_subquery/query19.sql ---------------------------------------------------------------------- diff --git a/kylin-it/src/test/resources/query/sql_subquery/query19.sql b/kylin-it/src/test/resources/query/sql_subquery/query19.sql index 6fee429..55661d4 100644 --- a/kylin-it/src/test/resources/query/sql_subquery/query19.sql +++ b/kylin-it/src/test/resources/query/sql_subquery/query19.sql @@ -1,3 +1,21 @@ +-- +-- 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,sum(test_kylin_fact.price) as GMV http://git-wip-us.apache.org/repos/asf/kylin/blob/3b74cea8/kylin-it/src/test/resources/query/sql_subquery/query21.sql ---------------------------------------------------------------------- diff --git a/kylin-it/src/test/resources/query/sql_subquery/query21.sql b/kylin-it/src/test/resources/query/sql_subquery/query21.sql index 5388d37..6792b9b 100644 --- a/kylin-it/src/test/resources/query/sql_subquery/query21.sql +++ b/kylin-it/src/test/resources/query/sql_subquery/query21.sql @@ -1,3 +1,21 @@ +-- +-- 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,sum(test_kylin_fact.price) as GMV http://git-wip-us.apache.org/repos/asf/kylin/blob/3b74cea8/kylin-it/src/test/resources/query/sql_subquery/query22.sql ---------------------------------------------------------------------- diff --git a/kylin-it/src/test/resources/query/sql_subquery/query22.sql b/kylin-it/src/test/resources/query/sql_subquery/query22.sql index 198a25d..b46424d 100644 --- a/kylin-it/src/test/resources/query/sql_subquery/query22.sql +++ b/kylin-it/src/test/resources/query/sql_subquery/query22.sql @@ -1,3 +1,21 @@ +-- +-- 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,sum(test_kylin_fact.price) as GMV http://git-wip-us.apache.org/repos/asf/kylin/blob/3b74cea8/kylin-it/src/test/resources/query/sql_subquery/query23.sql ---------------------------------------------------------------------- diff --git a/kylin-it/src/test/resources/query/sql_subquery/query23.sql b/kylin-it/src/test/resources/query/sql_subquery/query23.sql index f1a60ed..224c295 100644 --- a/kylin-it/src/test/resources/query/sql_subquery/query23.sql +++ b/kylin-it/src/test/resources/query/sql_subquery/query23.sql @@ -1,3 +1,21 @@ +-- +-- 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,sum(test_kylin_fact.price) as GMV http://git-wip-us.apache.org/repos/asf/kylin/blob/3b74cea8/kylin-it/src/test/resources/query/sql_subquery/query24.sql ---------------------------------------------------------------------- diff --git a/kylin-it/src/test/resources/query/sql_subquery/query24.sql b/kylin-it/src/test/resources/query/sql_subquery/query24.sql index eaf79e4..af3f0d6 100644 --- a/kylin-it/src/test/resources/query/sql_subquery/query24.sql +++ b/kylin-it/src/test/resources/query/sql_subquery/query24.sql @@ -1,3 +1,21 @@ +-- +-- 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,sum(test_kylin_fact.price) as GMV http://git-wip-us.apache.org/repos/asf/kylin/blob/3b74cea8/kylin-it/src/test/resources/query/sql_subquery/query25.sql ---------------------------------------------------------------------- diff --git a/kylin-it/src/test/resources/query/sql_subquery/query25.sql b/kylin-it/src/test/resources/query/sql_subquery/query25.sql index 81ebc37..db1072a 100644 --- a/kylin-it/src/test/resources/query/sql_subquery/query25.sql +++ b/kylin-it/src/test/resources/query/sql_subquery/query25.sql @@ -1,3 +1,21 @@ +-- +-- 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,sum(test_kylin_fact.price) as GMV http://git-wip-us.apache.org/repos/asf/kylin/blob/3b74cea8/kylin-it/src/test/resources/query/sql_subquery/query26.sql ---------------------------------------------------------------------- diff --git a/kylin-it/src/test/resources/query/sql_subquery/query26.sql b/kylin-it/src/test/resources/query/sql_subquery/query26.sql index 925d0a1..e802b19 100644 --- a/kylin-it/src/test/resources/query/sql_subquery/query26.sql +++ b/kylin-it/src/test/resources/query/sql_subquery/query26.sql @@ -1,3 +1,21 @@ +-- +-- 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,sum(test_kylin_fact.price) as GMV , count(*) as TRANS_CNT http://git-wip-us.apache.org/repos/asf/kylin/blob/3b74cea8/kylin-it/src/test/resources/query/sql_subquery/query27.sql ---------------------------------------------------------------------- diff --git a/kylin-it/src/test/resources/query/sql_subquery/query27.sql b/kylin-it/src/test/resources/query/sql_subquery/query27.sql index 78a959d..b437279 100644 --- a/kylin-it/src/test/resources/query/sql_subquery/query27.sql +++ b/kylin-it/src/test/resources/query/sql_subquery/query27.sql @@ -1,3 +1,21 @@ +-- +-- 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, xxx.week_beg_dt , sum(test_kylin_fact.price) as GMV http://git-wip-us.apache.org/repos/asf/kylin/blob/3b74cea8/kylin-it/src/test/resources/query/sql_subquery/query28.sql ---------------------------------------------------------------------- diff --git a/kylin-it/src/test/resources/query/sql_subquery/query28.sql b/kylin-it/src/test/resources/query/sql_subquery/query28.sql index ba31680..c1b20a7 100644 --- a/kylin-it/src/test/resources/query/sql_subquery/query28.sql +++ b/kylin-it/src/test/resources/query/sql_subquery/query28.sql @@ -1,3 +1,21 @@ +-- +-- 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. +-- + http://git-wip-us.apache.org/repos/asf/kylin/blob/3b74cea8/kylin-it/src/test/resources/query/sql_subquery/query29.sql.todo ---------------------------------------------------------------------- diff --git a/kylin-it/src/test/resources/query/sql_subquery/query29.sql.todo b/kylin-it/src/test/resources/query/sql_subquery/query29.sql.todo index 3cd04d3..79453a8 100644 --- a/kylin-it/src/test/resources/query/sql_subquery/query29.sql.todo +++ b/kylin-it/src/test/resources/query/sql_subquery/query29.sql.todo @@ -1,3 +1,21 @@ +-- +-- 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. +-- + -- filter or aggregate on columns from subquery will fail! http://git-wip-us.apache.org/repos/asf/kylin/blob/3b74cea8/kylin-it/src/test/resources/query/sql_subquery/query30.sql ---------------------------------------------------------------------- diff --git a/kylin-it/src/test/resources/query/sql_subquery/query30.sql b/kylin-it/src/test/resources/query/sql_subquery/query30.sql index 3b0dfbf..6018a48 100644 --- a/kylin-it/src/test/resources/query/sql_subquery/query30.sql +++ b/kylin-it/src/test/resources/query/sql_subquery/query30.sql @@ -1,3 +1,21 @@ +-- +-- 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 t1.cal_dt, t1.sum_price,t1.lstg_site_id FROM ( http://git-wip-us.apache.org/repos/asf/kylin/blob/3b74cea8/kylin-it/src/test/resources/query/sql_subquery/query31.sql ---------------------------------------------------------------------- diff --git a/kylin-it/src/test/resources/query/sql_subquery/query31.sql b/kylin-it/src/test/resources/query/sql_subquery/query31.sql index fafc01f..5a1bdb5 100644 --- a/kylin-it/src/test/resources/query/sql_subquery/query31.sql +++ b/kylin-it/src/test/resources/query/sql_subquery/query31.sql @@ -1,3 +1,21 @@ +-- +-- 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 t1.week_beg_dt, t1.sum_price,t1.lstg_site_id FROM ( http://git-wip-us.apache.org/repos/asf/kylin/blob/3b74cea8/kylin-it/src/test/resources/query/sql_subquery/query32.sql ---------------------------------------------------------------------- diff --git a/kylin-it/src/test/resources/query/sql_subquery/query32.sql b/kylin-it/src/test/resources/query/sql_subquery/query32.sql index 6565aa0..cfbf2f0 100644 --- a/kylin-it/src/test/resources/query/sql_subquery/query32.sql +++ b/kylin-it/src/test/resources/query/sql_subquery/query32.sql @@ -1,3 +1,21 @@ +-- +-- 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 '1'='1' then test_cal_dt.week_beg_dt when '1'='2' then test_kylin_fact.lstg_site_id else test_kylin_fact.leaf_categ_id end) as xxx , sum(price) as sum_price from test_kylin_fact http://git-wip-us.apache.org/repos/asf/kylin/blob/3b74cea8/kylin-it/src/test/resources/query/sql_subquery/query33.sql ---------------------------------------------------------------------- diff --git a/kylin-it/src/test/resources/query/sql_subquery/query33.sql b/kylin-it/src/test/resources/query/sql_subquery/query33.sql index 6ed1e37..a9cbb8c 100644 --- a/kylin-it/src/test/resources/query/sql_subquery/query33.sql +++ b/kylin-it/src/test/resources/query/sql_subquery/query33.sql @@ -1,3 +1,21 @@ +-- +-- 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,(case when '2'='1' then test_kylin_fact.lstg_site_id when '2'='2' then test_cal_dt.week_beg_dt else test_kylin_fact.leaf_categ_id end) as xxx ,sum(price) as sum_price from test_kylin_fact http://git-wip-us.apache.org/repos/asf/kylin/blob/3b74cea8/kylin-it/src/test/resources/query/sql_subquery/query34.sql ---------------------------------------------------------------------- diff --git a/kylin-it/src/test/resources/query/sql_subquery/query34.sql b/kylin-it/src/test/resources/query/sql_subquery/query34.sql index 56d04fa..6389121 100644 --- a/kylin-it/src/test/resources/query/sql_subquery/query34.sql +++ b/kylin-it/src/test/resources/query/sql_subquery/query34.sql @@ -1,3 +1,21 @@ +-- +-- 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 '3'='1' then test_cal_dt.week_beg_dt else test_kylin_fact.cal_dt end) as xxx , sum(price) as sum_price from test_kylin_fact