Repository: lens Updated Branches: refs/heads/current-release-line 6d49513e0 -> dcbe18e6b
LENS-1472: Populate sample metastore on example db is failing Project: http://git-wip-us.apache.org/repos/asf/lens/repo Commit: http://git-wip-us.apache.org/repos/asf/lens/commit/dcbe18e6 Tree: http://git-wip-us.apache.org/repos/asf/lens/tree/dcbe18e6 Diff: http://git-wip-us.apache.org/repos/asf/lens/diff/dcbe18e6 Branch: refs/heads/current-release-line Commit: dcbe18e6bd967cfc5abe14c8fb59bd0bddc2a753 Parents: 6d49513 Author: Rajat Khandelwal <pro...@apache.org> Authored: Tue Sep 5 22:49:00 2017 +0530 Committer: rajub <raju.bairishe...@lazada.com> Committed: Mon Jan 8 09:44:53 2018 +0800 ---------------------------------------------------------------------- lens-dist/src/main/assembly/bin-dist.xml | 8 ++++++++ .../org/apache/lens/examples/PopulateSampleMetastore.java | 5 +++++ .../main/java/org/apache/lens/examples/SampleMetastore.java | 3 +++ .../src/main/resources/sales-aggr-fact2-local4.data | 2 ++ 4 files changed, 18 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/lens/blob/dcbe18e6/lens-dist/src/main/assembly/bin-dist.xml ---------------------------------------------------------------------- diff --git a/lens-dist/src/main/assembly/bin-dist.xml b/lens-dist/src/main/assembly/bin-dist.xml index c3f8f17..36783b1 100644 --- a/lens-dist/src/main/assembly/bin-dist.xml +++ b/lens-dist/src/main/assembly/bin-dist.xml @@ -331,6 +331,14 @@ <fileSet> <directory>../lens-examples/src/main/resources/</directory> + <outputDirectory>/client/examples/data/sales_aggr_fact2_local4</outputDirectory> + <includes> + <include>sales-aggr-fact2-local4*.data</include> + </includes> + </fileSet> + + <fileSet> + <directory>../lens-examples/src/main/resources/</directory> <outputDirectory>/client/examples/data/sales_raw_local1</outputDirectory> <includes> <include>sales-raw-local1*.data</include> http://git-wip-us.apache.org/repos/asf/lens/blob/dcbe18e6/lens-examples/src/main/java/org/apache/lens/examples/PopulateSampleMetastore.java ---------------------------------------------------------------------- diff --git a/lens-examples/src/main/java/org/apache/lens/examples/PopulateSampleMetastore.java b/lens-examples/src/main/java/org/apache/lens/examples/PopulateSampleMetastore.java index 4fc15a6..7c8fd2c 100644 --- a/lens-examples/src/main/java/org/apache/lens/examples/PopulateSampleMetastore.java +++ b/lens-examples/src/main/java/org/apache/lens/examples/PopulateSampleMetastore.java @@ -43,6 +43,10 @@ public class PopulateSampleMetastore { private static final SimpleDateFormat FORMAT = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); private static final String NOW_TIME = FORMAT.format(DATE); + private static final String CREATE_QUERY = "CREATE TABLE if not exists mydb_sales_aggr_continuous_fact " + + "(order_time timestamp, delivery_time timestamp, customer_id integer, product_id integer, promotion_id integer, " + + "customer_city_id integer, production_city_id integer, delivery_city_id integer, unit_sales integer, " + + "store_sales integer, store_cost integer, max_line_item_price integer, max_line_item_discount integer)"; private static final String INSERT_QUERY = "INSERT INTO " + "mydb_sales_aggr_continuous_fact (order_time, delivery_time, customer_id, " + "product_id, promotion_id, customer_city_id, production_city_id, delivery_city_id, unit_sales, " @@ -119,6 +123,7 @@ public class PopulateSampleMetastore { con.setAutoCommit(true); Statement statement = con.createStatement(); try { + statement.execute(CREATE_QUERY); statement.execute(INSERT_QUERY); } finally { http://git-wip-us.apache.org/repos/asf/lens/blob/dcbe18e6/lens-examples/src/main/java/org/apache/lens/examples/SampleMetastore.java ---------------------------------------------------------------------- diff --git a/lens-examples/src/main/java/org/apache/lens/examples/SampleMetastore.java b/lens-examples/src/main/java/org/apache/lens/examples/SampleMetastore.java index e5a397b..1aa993b 100644 --- a/lens-examples/src/main/java/org/apache/lens/examples/SampleMetastore.java +++ b/lens-examples/src/main/java/org/apache/lens/examples/SampleMetastore.java @@ -79,6 +79,9 @@ public class SampleMetastore { public void createCubes() throws JAXBException, IOException { createCube("sample-cube.xml"); createCube("sales-cube.xml"); + createCube("cube11.xml"); + createCube("cube22.xml"); + createCube("cube33.xml"); } private void createDimension(String dimensionSpec) { http://git-wip-us.apache.org/repos/asf/lens/blob/dcbe18e6/lens-examples/src/main/resources/sales-aggr-fact2-local4.data ---------------------------------------------------------------------- diff --git a/lens-examples/src/main/resources/sales-aggr-fact2-local4.data b/lens-examples/src/main/resources/sales-aggr-fact2-local4.data new file mode 100644 index 0000000..407b097 --- /dev/null +++ b/lens-examples/src/main/resources/sales-aggr-fact2-local4.data @@ -0,0 +1,2 @@ +2015-04-13 03:00:00,2015-04-13 04:00:00,1,1,1,1,1,1,5,0 +2015-04-13 03:00:00,2015-04-13 04:00:00,2,1,2,2,2,1,8,2 \ No newline at end of file