You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@kylin.apache.org by sh...@apache.org on 2015/05/27 06:34:31 UTC
[06/50] [abbrv] incubator-kylin git commit: KYLIN-715
KYLIN-715
Project: http://git-wip-us.apache.org/repos/asf/incubator-kylin/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-kylin/commit/2d57aade
Tree: http://git-wip-us.apache.org/repos/asf/incubator-kylin/tree/2d57aade
Diff: http://git-wip-us.apache.org/repos/asf/incubator-kylin/diff/2d57aade
Branch: refs/heads/0.8.0
Commit: 2d57aade794f2806926c549bd561472431d54767
Parents: 9186304
Author: qianhao.zhou <qi...@ebay.com>
Authored: Fri Apr 24 10:43:57 2015 +0800
Committer: shaofengshi <sh...@apache.org>
Committed: Wed May 27 12:19:28 2015 +0800
----------------------------------------------------------------------
examples/sample_cube/create_sample_tables.sql | 32 +++---
pom.xml | 3 +
query/src/test/resources/query/.gitignore | 1 -
query/src/test/resources/query/h2/query07.sql | 18 ++++
query/src/test/resources/query/h2/query09.sql | 18 ++++
query/src/test/resources/query/h2/query10.sql | 18 ++++
query/src/test/resources/query/sql/.gitignore | 18 ++++
query/src/test/resources/query/sql/query00.sql | 18 ++++
query/src/test/resources/query/sql/query01.sql | 18 ++++
query/src/test/resources/query/sql/query02.sql | 18 ++++
query/src/test/resources/query/sql/query03.sql | 18 ++++
query/src/test/resources/query/sql/query04.sql | 18 ++++
query/src/test/resources/query/sql/query05.sql | 18 ++++
query/src/test/resources/query/sql/query06.sql | 18 ++++
query/src/test/resources/query/sql/query07.sql | 18 ++++
query/src/test/resources/query/sql/query08.sql | 18 ++++
query/src/test/resources/query/sql/query09.sql | 18 ++++
query/src/test/resources/query/sql/query10.sql | 18 ++++
query/src/test/resources/query/sql/query11.sql | 18 ++++
query/src/test/resources/query/sql/query12.sql | 18 ++++
query/src/test/resources/query/sql/query13.sql | 18 ++++
query/src/test/resources/query/sql/query14.sql | 18 ++++
query/src/test/resources/query/sql/query15.sql | 18 ++++
query/src/test/resources/query/sql/query16.sql | 18 ++++
query/src/test/resources/query/sql/query17.sql | 18 ++++
query/src/test/resources/query/sql/query18.sql | 18 ++++
query/src/test/resources/query/sql/query19.sql | 18 ++++
query/src/test/resources/query/sql/query20.sql | 18 ++++
query/src/test/resources/query/sql/query21.sql | 18 ++++
query/src/test/resources/query/sql/query22.sql | 18 ++++
query/src/test/resources/query/sql/query23.sql | 18 ++++
query/src/test/resources/query/sql/query24.sql | 18 ++++
query/src/test/resources/query/sql/query25.sql | 18 ++++
query/src/test/resources/query/sql/query26.sql | 18 ++++
query/src/test/resources/query/sql/query27.sql | 18 ++++
query/src/test/resources/query/sql/query28.sql | 18 ++++
query/src/test/resources/query/sql/query29.sql | 18 ++++
query/src/test/resources/query/sql/query30.sql | 18 ++++
query/src/test/resources/query/sql/query31.sql | 18 ++++
query/src/test/resources/query/sql/query32.sql | 18 ++++
query/src/test/resources/query/sql/query33.sql | 18 ++++
query/src/test/resources/query/sql/query34.sql | 18 ++++
query/src/test/resources/query/sql/query35.sql | 18 ++++
query/src/test/resources/query/sql/query36.sql | 18 ++++
query/src/test/resources/query/sql/query37.sql | 18 ++++
query/src/test/resources/query/sql/query38.sql | 18 ++++
query/src/test/resources/query/sql/query39.sql | 18 ++++
query/src/test/resources/query/sql/query40.sql | 18 ++++
query/src/test/resources/query/sql/query41.sql | 18 ++++
query/src/test/resources/query/sql/query42.sql | 18 ++++
query/src/test/resources/query/sql/query43.sql | 18 ++++
query/src/test/resources/query/sql/query44.sql | 18 ++++
query/src/test/resources/query/sql/query45.sql | 18 ++++
query/src/test/resources/query/sql/query46.sql | 20 +++-
query/src/test/resources/query/sql/query47.sql | 20 +++-
query/src/test/resources/query/sql/query48.sql | 20 +++-
query/src/test/resources/query/sql/query49.sql | 18 ++++
query/src/test/resources/query/sql/query50.sql | 18 ++++
query/src/test/resources/query/sql/query51.sql | 18 ++++
query/src/test/resources/query/sql/query52.sql | 18 ++++
query/src/test/resources/query/sql/query53.sql | 20 +++-
query/src/test/resources/query/sql/query54.sql | 18 ++++
query/src/test/resources/query/sql/query55.sql | 20 +++-
query/src/test/resources/query/sql/query56.sql | 20 +++-
query/src/test/resources/query/sql/query57.sql | 20 +++-
query/src/test/resources/query/sql/query58.sql | 20 +++-
query/src/test/resources/query/sql/query59.sql | 20 +++-
query/src/test/resources/query/sql/query60.sql | 20 +++-
query/src/test/resources/query/sql/query61.sql | 20 +++-
query/src/test/resources/query/sql/query62.sql | 20 +++-
query/src/test/resources/query/sql/query63.sql | 20 +++-
query/src/test/resources/query/sql/query64.sql | 20 +++-
query/src/test/resources/query/sql/query65.sql | 20 +++-
query/src/test/resources/query/sql/query66.sql | 18 ++++
query/src/test/resources/query/sql/query67.sql | 20 +++-
query/src/test/resources/query/sql/query68.sql | 20 +++-
query/src/test/resources/query/sql/query69.sql | 20 +++-
query/src/test/resources/query/sql/query70.sql | 18 ++++
query/src/test/resources/query/sql/query71.sql | 20 +++-
query/src/test/resources/query/sql/query72.sql | 20 +++-
query/src/test/resources/query/sql/query73.sql | 20 +++-
query/src/test/resources/query/sql/query74.sql | 20 +++-
query/src/test/resources/query/sql/query75.sql | 18 ++++
query/src/test/resources/query/sql/query76.sql | 18 ++++
query/src/test/resources/query/sql/query77.sql | 20 +++-
query/src/test/resources/query/sql/query78.sql | 18 ++++
.../resources/query/sql_all_types/query00.sql | 18 ++++
.../resources/query/sql_all_types/query01.sql | 18 ++++
.../resources/query/sql_all_types/query02.sql | 18 ++++
.../resources/query/sql_all_types/query03.sql | 18 ++++
.../resources/query/sql_all_types/query04.sql | 18 ++++
.../resources/query/sql_all_types/query05.sql | 18 ++++
.../resources/query/sql_all_types/query06.sql | 18 ++++
.../resources/query/sql_all_types/query07.sql | 18 ++++
.../resources/query/sql_all_types/query08.sql | 18 ++++
.../resources/query/sql_all_types/query09.sql | 18 ++++
.../resources/query/sql_casewhen/query01.sql | 20 +++-
.../resources/query/sql_casewhen/query02.sql | 20 +++-
.../resources/query/sql_casewhen/query03.sql | 20 +++-
.../query/sql_casewhen/query55.sql.disable | 20 +++-
.../resources/query/sql_casewhen/query56.sql | 20 +++-
.../resources/query/sql_derived/query01.sql | 18 ++++
.../resources/query/sql_derived/query02.sql | 18 ++++
.../resources/query/sql_derived/query03.sql | 18 ++++
.../resources/query/sql_derived/query04.sql | 18 ++++
.../resources/query/sql_derived/query05.sql | 18 ++++
.../resources/query/sql_derived/query06.sql | 18 ++++
.../resources/query/sql_derived/query07.sql | 18 ++++
.../query/sql_derived/query08.sql.disabled | 18 ++++
.../resources/query/sql_derived/query09.sql | 18 ++++
.../resources/query/sql_derived/query10.sql | 18 ++++
.../resources/query/sql_distinct/query00.sql | 18 ++++
.../resources/query/sql_distinct/query01.sql | 18 ++++
.../resources/query/sql_distinct/query02.sql | 18 ++++
.../resources/query/sql_distinct/query03.sql | 18 ++++
.../resources/query/sql_distinct/query04.sql | 18 ++++
.../resources/query/sql_distinct/query05.sql | 18 ++++
.../resources/query/sql_distinct/query06.sql | 18 ++++
.../resources/query/sql_distinct/query07.sql | 18 ++++
.../resources/query/sql_dynamic/query01.dat | 20 +++-
.../resources/query/sql_dynamic/query01.sql | 18 ++++
.../resources/query/sql_dynamic/query02.dat | 20 +++-
.../resources/query/sql_dynamic/query02.sql | 18 ++++
.../resources/query/sql_fast_common/query00.sql | 20 +++-
.../test/resources/query/sql_hive/query01.sql | 18 ++++
.../test/resources/query/sql_hive/query10.sql | 18 ++++
.../src/test/resources/query/sql_ii/query01.sql | 20 +++-
.../src/test/resources/query/sql_ii/query02.sql | 20 +++-
.../src/test/resources/query/sql_ii/query03.sql | 20 +++-
.../src/test/resources/query/sql_ii/query04.sql | 20 +++-
.../src/test/resources/query/sql_ii/query05.sql | 20 +++-
.../resources/query/sql_ii/query06.sql.disabled | 20 +++-
.../resources/query/sql_ii/query07.sql.disabled | 20 +++-
.../src/test/resources/query/sql_ii/query08.sql | 20 +++-
.../src/test/resources/query/sql_ii/query09.sql | 20 +++-
.../query/sql_invalid/query29_invalid_SQL.sql | 18 ++++
.../query/sql_invalid/query30_invalid_SQL.sql | 18 ++++
.../query/sql_invalid/query31_invalid_SQL.sql | 18 ++++
.../query/sql_invalid/query32_invalid_SQL.sql | 18 ++++
.../query/sql_invalid/query33_invalid_SQL.sql | 18 ++++
.../query/sql_invalid/query34_invalid_SQL.sql | 18 ++++
...ery_count_distinct_on_dimension.sql.disabled | 20 +++-
.../test/resources/query/sql_lookup/query01.sql | 18 ++++
.../test/resources/query/sql_lookup/query02.sql | 20 +++-
.../test/resources/query/sql_lookup/query03.sql | 20 +++-
.../test/resources/query/sql_lookup/query04.sql | 20 +++-
.../query/sql_optimize/enable-limit01.sql | 20 +++-
.../resources/query/sql_orderby/query01.sql | 18 ++++
.../resources/query/sql_orderby/query02.sql | 18 ++++
.../resources/query/sql_orderby/query03.sql | 20 +++-
.../resources/query/sql_subquery/query00.sql | 18 ++++
.../resources/query/sql_subquery/query01.sql | 20 +++-
.../query/sql_subquery/query02.sql.disable | 20 +++-
.../resources/query/sql_subquery/query03.sql | 20 +++-
.../resources/query/sql_subquery/query04.sql | 20 +++-
.../resources/query/sql_subquery/query05.sql | 20 +++-
.../resources/query/sql_subquery/query06.sql | 18 ++++
.../resources/query/sql_subquery/query07.sql | 20 +++-
.../resources/query/sql_tableau/query00.sql | 18 ++++
.../resources/query/sql_tableau/query01.sql | 18 ++++
.../resources/query/sql_tableau/query02.sql | 18 ++++
.../resources/query/sql_tableau/query03.sql | 18 ++++
.../resources/query/sql_tableau/query04.sql | 18 ++++
.../resources/query/sql_tableau/query05.sql | 18 ++++
.../resources/query/sql_tableau/query06.sql | 18 ++++
.../resources/query/sql_tableau/query07.sql | 18 ++++
.../query/sql_tableau/query08.sql.disabled | 18 ++++
.../query/sql_tableau/query09.sql.disabled | 18 ++++
.../resources/query/sql_tableau/query10.sql | 18 ++++
.../resources/query/sql_tableau/query11.sql | 18 ++++
.../resources/query/sql_tableau/query12.sql | 18 ++++
.../resources/query/sql_tableau/query13.sql | 18 ++++
.../resources/query/sql_tableau/query14.sql | 18 ++++
.../resources/query/sql_tableau/query15.sql | 18 ++++
.../resources/query/sql_tableau/query16.sql | 18 ++++
.../resources/query/sql_tableau/query17.sql | 18 ++++
.../resources/query/sql_tableau/query18.sql | 18 ++++
.../resources/query/sql_tableau/query19.sql | 18 ++++
.../resources/query/sql_tableau/query20.sql | 18 ++++
.../resources/query/sql_tableau/query21.sql | 18 ++++
.../query/sql_tableau/query22.sql.disabled | 20 +++-
.../resources/query/sql_tableau/query23.sql | 20 +++-
.../resources/query/sql_tableau/query24.sql | 20 +++-
.../resources/query/sql_tableau/query25.sql | 20 +++-
.../resources/query/sql_tableau/query27.sql | 18 ++++
.../resources/query/sql_tableau/query67.sql | 20 +++-
.../resources/query/sql_verifyCount/query04.sql | 18 ++++
.../query/sql_verifyCount/query04.sql.expected | 20 +++-
.../resources/query/sql_verifyCount/query05.sql | 18 ++++
.../query/sql_verifyCount/query05.sql.expected | 20 +++-
.../resources/query/sql_verifyCount/query06.sql | 18 ++++
.../query/sql_verifyCount/query06.sql.expected | 20 +++-
.../resources/query/sql_verifyCount/query07.sql | 18 ++++
.../query/sql_verifyCount/query07.sql.expected | 20 +++-
.../resources/query/tableau_probing/query01.sql | 18 ++++
.../resources/query/tableau_probing/query02.sql | 18 ++++
.../resources/query/tableau_probing/query03.sql | 18 ++++
.../resources/query/tableau_probing/query04.sql | 18 ++++
.../resources/query/tableau_probing/query05.sql | 18 ++++
.../resources/query/tableau_probing/query06.sql | 18 ++++
.../resources/query/tableau_probing/query07.sql | 18 ++++
webapp/app/css/AdminLTE-fonts.css | 7 ++
webapp/template/nginx_default.conf | 95 -----------------
webapp/validate-commit-msg.js | 106 -------------------
204 files changed, 3652 insertions(+), 278 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/examples/sample_cube/create_sample_tables.sql
----------------------------------------------------------------------
diff --git a/examples/sample_cube/create_sample_tables.sql b/examples/sample_cube/create_sample_tables.sql
index 8cd8738..d4ebb6a 100644
--- a/examples/sample_cube/create_sample_tables.sql
+++ b/examples/sample_cube/create_sample_tables.sql
@@ -1,18 +1,20 @@
---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.
+/*
+ * 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.
+*/
DROP TABLE IF EXISTS DEFAULT.KYLIN_CAL_DT;
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/pom.xml
----------------------------------------------------------------------
diff --git a/pom.xml b/pom.xml
index adde019..50c8c9c 100644
--- a/pom.xml
+++ b/pom.xml
@@ -698,6 +698,9 @@
<!-- Temp -->
<exclude>webapp/template/nginx_default.conf</exclude>
<exclude>webapp/validate-commit-msg.js</exclude>
+ <!-- json configuration file-->
+ <exclude>webapp/.bowerrc</exclude>
+ <exclude>webapp/.jshintrc</exclude>
</excludes>
</configuration>
<executions>
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/.gitignore
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/.gitignore b/query/src/test/resources/query/.gitignore
deleted file mode 100644
index cb98934..0000000
--- a/query/src/test/resources/query/.gitignore
+++ /dev/null
@@ -1 +0,0 @@
-/sample.sql
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/h2/query07.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/h2/query07.sql b/query/src/test/resources/query/h2/query07.sql
index 5841f5f..e1403c4 100644
--- a/query/src/test/resources/query/h2/query07.sql
+++ b/query/src/test/resources/query/h2/query07.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 count(*) from ( select test_kylin_fact.lstg_format_name from test_kylin_fact
where test_kylin_fact.lstg_format_name='FP-GTC'
group by test_kylin_fact.lstg_format_name ) t
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/h2/query09.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/h2/query09.sql b/query/src/test/resources/query/h2/query09.sql
index afd186b..9605c8f 100644
--- a/query/src/test/resources/query/h2/query09.sql
+++ b/query/src/test/resources/query/h2/query09.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 count(*) from (select test_cal_dt.week_beg_dt
from test_kylin_fact
inner JOIN edw.test_cal_dt as test_cal_dt
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/h2/query10.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/h2/query10.sql b/query/src/test/resources/query/h2/query10.sql
index 1c642d6..32f319c 100644
--- a/query/src/test/resources/query/h2/query10.sql
+++ b/query/src/test/resources/query/h2/query10.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_cal_dt.week_beg_dt
from test_kylin_fact
inner JOIN edw.test_cal_dt as test_cal_dt
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/.gitignore
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/.gitignore b/query/src/test/resources/query/sql/.gitignore
index 0daace0..d05e0f8 100644
--- a/query/src/test/resources/query/sql/.gitignore
+++ b/query/src/test/resources/query/sql/.gitignore
@@ -1,2 +1,20 @@
+/*
+ * 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.
+*/
+
/sample.txt
/0000.sql
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query00.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query00.sql b/query/src/test/resources/query/sql/query00.sql
index 40c247d..ad07bd0 100644
--- a/query/src/test/resources/query/sql/query00.sql
+++ b/query/src/test/resources/query/sql/query00.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, sum(price) as GMV
from test_kylin_fact
where lstg_format_name='FP-GTC'
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query01.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query01.sql b/query/src/test/resources/query/sql/query01.sql
index 52a2fcf..4b57536 100644
--- a/query/src/test/resources/query/sql/query01.sql
+++ b/query/src/test/resources/query/sql/query01.sql
@@ -1,2 +1,20 @@
+/*
+ * 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 from test_kylin_fact
group by LSTG_FORMAT_NAME
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query02.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query02.sql b/query/src/test/resources/query/sql/query02.sql
index c2baad0..286cb04 100644
--- a/query/src/test/resources/query/sql/query02.sql
+++ b/query/src/test/resources/query/sql/query02.sql
@@ -1 +1,19 @@
+/*
+ * 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 GMV, count(1) as TRANS_CNT from test_kylin_fact
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query03.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query03.sql b/query/src/test/resources/query/sql/query03.sql
index 0db8288..f357cf4 100644
--- a/query/src/test/resources/query/sql/query03.sql
+++ b/query/src/test/resources/query/sql/query03.sql
@@ -1,2 +1,20 @@
+/*
+ * 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(price) as GMV, count(*) as TRANS_CNT from test_kylin_fact
group by test_kylin_fact.lstg_format_name
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query04.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query04.sql b/query/src/test/resources/query/sql/query04.sql
index d7accd9..b515487 100644
--- a/query/src/test/resources/query/sql/query04.sql
+++ b/query/src/test/resources/query/sql/query04.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 from test_kylin_fact
group by test_kylin_fact.lstg_format_name having sum(price)>5000
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query05.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query05.sql b/query/src/test/resources/query/sql/query05.sql
index 711fc5e..283dcd6 100644
--- a/query/src/test/resources/query/sql/query05.sql
+++ b/query/src/test/resources/query/sql/query05.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 from test_kylin_fact
where test_kylin_fact.lstg_format_name is null
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query06.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query06.sql b/query/src/test/resources/query/sql/query06.sql
index 486cd23..76cfb24 100644
--- a/query/src/test/resources/query/sql/query06.sql
+++ b/query/src/test/resources/query/sql/query06.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 from test_kylin_fact
where test_kylin_fact.lstg_format_name is not null
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query07.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query07.sql b/query/src/test/resources/query/sql/query07.sql
index e399a0a..17b90e5 100644
--- a/query/src/test/resources/query/sql/query07.sql
+++ b/query/src/test/resources/query/sql/query07.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 from test_kylin_fact
where test_kylin_fact.lstg_format_name='FP-GTC'
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query08.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query08.sql b/query/src/test/resources/query/sql/query08.sql
index bc4fd53..9be452d 100644
--- a/query/src/test/resources/query/sql/query08.sql
+++ b/query/src/test/resources/query/sql/query08.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 from test_kylin_fact
where test_kylin_fact.lstg_format_name='FP-GTC'
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query09.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query09.sql b/query/src/test/resources/query/sql/query09.sql
index 3dc4ddc..0d4cbd2 100644
--- a/query/src/test/resources/query/sql/query09.sql
+++ b/query/src/test/resources/query/sql/query09.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_cal_dt.week_beg_dt, count(*) as TRANS_CNT
from test_kylin_fact
inner JOIN edw.test_cal_dt as test_cal_dt
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query10.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query10.sql b/query/src/test/resources/query/sql/query10.sql
index ded95e6..8f798ed 100644
--- a/query/src/test/resources/query/sql/query10.sql
+++ b/query/src/test/resources/query/sql/query10.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_cal_dt.week_beg_dt,sum(test_kylin_fact.price) as GMV
, count(*) as TRANS_CNT
from test_kylin_fact
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query11.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query11.sql b/query/src/test/resources/query/sql/query11.sql
index 7713dd0..bac25a3 100644
--- a/query/src/test/resources/query/sql/query11.sql
+++ b/query/src/test/resources/query/sql/query11.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, test_cal_dt.week_beg_dt,sum(test_kylin_fact.price) as GMV
, count(*) as TRANS_CNT
from test_kylin_fact
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query12.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query12.sql b/query/src/test/resources/query/sql/query12.sql
index 659a055..338eb6d 100644
--- a/query/src/test/resources/query/sql/query12.sql
+++ b/query/src/test/resources/query/sql/query12.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, test_cal_dt.week_beg_dt,sum(test_kylin_fact.price) as GMV
, count(*) as TRANS_CNT
from test_kylin_fact
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query13.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query13.sql b/query/src/test/resources/query/sql/query13.sql
index 7e9d477..b05dad7 100644
--- a/query/src/test/resources/query/sql/query13.sql
+++ b/query/src/test/resources/query/sql/query13.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 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
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query14.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query14.sql b/query/src/test/resources/query/sql/query14.sql
index 6627293..f2fda9e 100644
--- a/query/src/test/resources/query/sql/query14.sql
+++ b/query/src/test/resources/query/sql/query14.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_cal_dt.week_beg_dt
,test_category_groupings.meta_categ_name
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query15.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query15.sql b/query/src/test/resources/query/sql/query15.sql
index c21c81d..af68ab0 100644
--- a/query/src/test/resources/query/sql/query15.sql
+++ b/query/src/test/resources/query/sql/query15.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_cal_dt.week_beg_dt
,test_category_groupings.meta_categ_name
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query16.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query16.sql b/query/src/test/resources/query/sql/query16.sql
index 81f6cdb..e810692 100644
--- a/query/src/test/resources/query/sql/query16.sql
+++ b/query/src/test/resources/query/sql/query16.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_cal_dt.week_beg_dt
,test_category_groupings.meta_categ_name
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query17.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query17.sql b/query/src/test/resources/query/sql/query17.sql
index f201687..233424d 100644
--- a/query/src/test/resources/query/sql/query17.sql
+++ b/query/src/test/resources/query/sql/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_cal_dt.week_beg_dt
,test_category_groupings.meta_categ_name
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query18.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query18.sql b/query/src/test/resources/query/sql/query18.sql
index 830f139..6138668 100644
--- a/query/src/test/resources/query/sql/query18.sql
+++ b/query/src/test/resources/query/sql/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_cal_dt.week_beg_dt
,test_category_groupings.meta_categ_name
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query19.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query19.sql b/query/src/test/resources/query/sql/query19.sql
index f201687..233424d 100644
--- a/query/src/test/resources/query/sql/query19.sql
+++ b/query/src/test/resources/query/sql/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_cal_dt.week_beg_dt
,test_category_groupings.meta_categ_name
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query20.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query20.sql b/query/src/test/resources/query/sql/query20.sql
index ca61578..0133b30 100644
--- a/query/src/test/resources/query/sql/query20.sql
+++ b/query/src/test/resources/query/sql/query20.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_cal_dt.week_beg_dt
,test_category_groupings.meta_categ_name
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query21.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query21.sql b/query/src/test/resources/query/sql/query21.sql
index b2e54ba..8b7870f 100644
--- a/query/src/test/resources/query/sql/query21.sql
+++ b/query/src/test/resources/query/sql/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_cal_dt.week_beg_dt
,test_category_groupings.meta_categ_name
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query22.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query22.sql b/query/src/test/resources/query/sql/query22.sql
index 024f9e9..fe8120e 100644
--- a/query/src/test/resources/query/sql/query22.sql
+++ b/query/src/test/resources/query/sql/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_cal_dt.week_beg_dt
,test_category_groupings.meta_categ_name
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query23.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query23.sql b/query/src/test/resources/query/sql/query23.sql
index 25e93d9..6cd09ee 100644
--- a/query/src/test/resources/query/sql/query23.sql
+++ b/query/src/test/resources/query/sql/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_cal_dt.week_beg_dt
,test_category_groupings.meta_categ_name
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query24.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query24.sql b/query/src/test/resources/query/sql/query24.sql
index 5681557..3e730b6 100644
--- a/query/src/test/resources/query/sql/query24.sql
+++ b/query/src/test/resources/query/sql/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_cal_dt.week_beg_dt
,test_category_groupings.meta_categ_name
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query25.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query25.sql b/query/src/test/resources/query/sql/query25.sql
index 0c07a8e..b36fe35 100644
--- a/query/src/test/resources/query/sql/query25.sql
+++ b/query/src/test/resources/query/sql/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_cal_dt.week_beg_dt
,test_category_groupings.meta_categ_name
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query26.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query26.sql b/query/src/test/resources/query/sql/query26.sql
index 3889e77..00bdd99 100644
--- a/query/src/test/resources/query/sql/query26.sql
+++ b/query/src/test/resources/query/sql/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_cal_dt.week_beg_dt
,test_category_groupings.meta_categ_name
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query27.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query27.sql b/query/src/test/resources/query/sql/query27.sql
index 1c0a505..0778a22 100644
--- a/query/src/test/resources/query/sql/query27.sql
+++ b/query/src/test/resources/query/sql/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_cal_dt.week_beg_dt
,test_category_groupings.meta_categ_name
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query28.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query28.sql b/query/src/test/resources/query/sql/query28.sql
index 4b04d35..1720ef0 100644
--- a/query/src/test/resources/query/sql/query28.sql
+++ b/query/src/test/resources/query/sql/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.
+*/
+
SELECT
sum(test_kylin_fact.price) as GMV
, count(*) as TRANS_CNT
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query29.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query29.sql b/query/src/test/resources/query/sql/query29.sql
index c799014..98a7a14 100644
--- a/query/src/test/resources/query/sql/query29.sql
+++ b/query/src/test/resources/query/sql/query29.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_cal_dt.week_beg_dt
,test_category_groupings.meta_categ_name
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query30.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query30.sql b/query/src/test/resources/query/sql/query30.sql
index 57b7f57..92220d6 100644
--- a/query/src/test/resources/query/sql/query30.sql
+++ b/query/src/test/resources/query/sql/query30.sql
@@ -1 +1,19 @@
+/*
+ * 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 GMV, count(1) as TRANS_CNT from test_kylin_fact limit 50
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query31.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query31.sql b/query/src/test/resources/query/sql/query31.sql
index d33f4ba..aea1248 100644
--- a/query/src/test/resources/query/sql/query31.sql
+++ b/query/src/test/resources/query/sql/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
test_cal_dt.week_beg_dt
,test_category_groupings.meta_categ_name
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query32.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query32.sql b/query/src/test/resources/query/sql/query32.sql
index 12fab37..a99892f 100644
--- a/query/src/test/resources/query/sql/query32.sql
+++ b/query/src/test/resources/query/sql/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
test_cal_dt.week_beg_dt
,test_category_groupings.meta_categ_name
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query33.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query33.sql b/query/src/test/resources/query/sql/query33.sql
index 4414533..29e56c4 100644
--- a/query/src/test/resources/query/sql/query33.sql
+++ b/query/src/test/resources/query/sql/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
test_kylin_fact.seller_id
,test_cal_dt.week_beg_dt
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query34.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query34.sql b/query/src/test/resources/query/sql/query34.sql
index 0db088d..54934b0 100644
--- a/query/src/test/resources/query/sql/query34.sql
+++ b/query/src/test/resources/query/sql/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
test_cal_dt.week_beg_dt
,test_category_groupings.meta_categ_name
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query35.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query35.sql b/query/src/test/resources/query/sql/query35.sql
index 3f2beee..ddbf1f8 100644
--- a/query/src/test/resources/query/sql/query35.sql
+++ b/query/src/test/resources/query/sql/query35.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_cal_dt.week_beg_dt
,test_category_groupings.meta_categ_name
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query36.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query36.sql b/query/src/test/resources/query/sql/query36.sql
index 709f00b..d208ac2 100644
--- a/query/src/test/resources/query/sql/query36.sql
+++ b/query/src/test/resources/query/sql/query36.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_category_groupings.meta_categ_name
,sum(test_kylin_fact.price) as GMV_SUM
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query37.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query37.sql b/query/src/test/resources/query/sql/query37.sql
index dfc1845..4de4a29 100644
--- a/query/src/test/resources/query/sql/query37.sql
+++ b/query/src/test/resources/query/sql/query37.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_cal_dt.week_beg_dt, sum(test_kylin_fact.price) as GMV
, count(*) as TRANS_CNT
from test_kylin_fact
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query38.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query38.sql b/query/src/test/resources/query/sql/query38.sql
index 191e12e..7bb77eb 100644
--- a/query/src/test/resources/query/sql/query38.sql
+++ b/query/src/test/resources/query/sql/query38.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, sum(price) as GMV
from test_kylin_fact
where lstg_format_name not in ('FP-GTC', 'ABIN')
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query39.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query39.sql b/query/src/test/resources/query/sql/query39.sql
index aa37afa..5ac5bf6 100644
--- a/query/src/test/resources/query/sql/query39.sql
+++ b/query/src/test/resources/query/sql/query39.sql
@@ -1,2 +1,20 @@
+/*
+ * 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 GMV
from test_kylin_fact
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query40.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query40.sql b/query/src/test/resources/query/sql/query40.sql
index 277e297..cc68d3b 100644
--- a/query/src/test/resources/query/sql/query40.sql
+++ b/query/src/test/resources/query/sql/query40.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 cal_dt, lstg_format_name, sum(price) as GMV
from test_kylin_fact
where cal_dt between date '2013-05-06' and date '2013-07-31'
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query41.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query41.sql b/query/src/test/resources/query/sql/query41.sql
index 1a13939..d6b602a 100644
--- a/query/src/test/resources/query/sql/query41.sql
+++ b/query/src/test/resources/query/sql/query41.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_category_groupings.meta_categ_name
,test_category_groupings.categ_lvl2_name
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query42.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query42.sql b/query/src/test/resources/query/sql/query42.sql
index 5b181a7..ff3c778 100644
--- a/query/src/test/resources/query/sql/query42.sql
+++ b/query/src/test/resources/query/sql/query42.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_cal_dt.cal_dt, count(*) as TRANS_CNT
from test_kylin_fact
inner JOIN edw.test_cal_dt as test_cal_dt
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query43.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query43.sql b/query/src/test/resources/query/sql/query43.sql
index 6112f82..f4c1388 100644
--- a/query/src/test/resources/query/sql/query43.sql
+++ b/query/src/test/resources/query/sql/query43.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_cal_dt.cal_dt, count(*) as CNT
from test_kylin_fact
inner JOIN edw.test_cal_dt as test_cal_dt
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query44.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query44.sql b/query/src/test/resources/query/sql/query44.sql
index 23830c2..73ffa18 100644
--- a/query/src/test/resources/query/sql/query44.sql
+++ b/query/src/test/resources/query/sql/query44.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_category_groupings.meta_categ_name
,sum(test_kylin_fact.price) as GMV
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query45.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query45.sql b/query/src/test/resources/query/sql/query45.sql
index 5a40e25..ee617e5 100644
--- a/query/src/test/resources/query/sql/query45.sql
+++ b/query/src/test/resources/query/sql/query45.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 count(*) as CNT from edw.test_cal_dt
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query46.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query46.sql b/query/src/test/resources/query/sql/query46.sql
index 6dba282..b6fba2d 100644
--- a/query/src/test/resources/query/sql/query46.sql
+++ b/query/src/test/resources/query/sql/query46.sql
@@ -1 +1,19 @@
-select count(*) as CNT from test_category_groupings
\ No newline at end of file
+/*
+ * 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 CNT from test_category_groupings
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query47.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query47.sql b/query/src/test/resources/query/sql/query47.sql
index 7e0f882..f1d78ce 100644
--- a/query/src/test/resources/query/sql/query47.sql
+++ b/query/src/test/resources/query/sql/query47.sql
@@ -1 +1,19 @@
-select count(*) as CNT from edw.test_seller_type_dim
\ No newline at end of file
+/*
+ * 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 CNT from edw.test_seller_type_dim
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/2d57aade/query/src/test/resources/query/sql/query48.sql
----------------------------------------------------------------------
diff --git a/query/src/test/resources/query/sql/query48.sql b/query/src/test/resources/query/sql/query48.sql
index 72e8f73..d67f70c 100644
--- a/query/src/test/resources/query/sql/query48.sql
+++ b/query/src/test/resources/query/sql/query48.sql
@@ -1 +1,19 @@
-select count(*) as CNT from edw.test_sites
\ No newline at end of file
+/*
+ * 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 CNT from edw.test_sites